Magento – Import 1.2 GB database to phptheadmin xampp and having error

databaseimportPHP

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

  1. Remove (or reduce) your log files that will really make your backup file smaller, as @brentwpeterson said. You can do so by typing below command in your magento root

php -f shell/log.php clean --days 30 to keep 30 days log, keep it whatever you like

  1. Backup the database now mysqldump -u[username] -p [database_name] > db.sql

  2. 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.

Related Topic