FanaticZine

If you are trying to restore a large database backup back to  your MySQL Server, You know that phpMyAdmin is NOT the best solution for the task, beacause of it’s execution limitaion settings it will reject your file being executed. So one way to archive this is to use the mysql command prompt interface. the syntaxt to back up your database unsing command links is.

mysql -u {UserName} -p {TargetDatabase} < {SourceDumpFile}

{UserName} = Your Database username

{TargetDatabase}= Your Target Databse

{SourceDumpFile}=  Your  SQL Dump File

once you run the above line correctly. you should be prompt for a password, Enter your database password and continue. (the restoring time  depends on the size of your database, so be patient and a grab a coffee if it’s so large.)

If you are getting the error ERROR 2006 (HY000) at line 447: MySQL server has gone away when you are trying to restore any MySQL backup on your command prompt. Try following

Open the my.ini in C:\Windows\ or mysql/bin/my.cnf on XAMPP installation and modify the max_allowed_packet to  a higher value. (Probably  higher than your backup file size)