I have been trying to import my magento website database which size is 1.2 gb in phpmyadmin xampp and having error
''You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.''
I did below things to solve my problem but nothing work.
In php.ini
max_execution_time = 300
max_input_time = 60
memory_limit = 1200M
upload_max_filesize = 1100M
post_max_size = 1100M
Used bigdump and having this error "access denied for user localhost using password yes"
Is any one has solution of my problem?
Best Answer
php -f shell/log.php clean --days 30
to keep 30 days log, keep it whatever you likeBackup the database now
mysqldump -u[username] -p [database_name] > db.sql
Import it. Make sure your mysql username has all the grant privileges to new database
mysql -u[username] -p [new_database_name] < db.sql
I don't think you can do import easily via PHPmyAdmin as Magento DBs are usually huge. Doing from mysql console/terminal is the best and fastest way to do.