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