There are 2 ways to restore your MySQL database from sql dump file. 1st way to restore mysql database from sql dump file is using mysql web control panel – phpMyAdmin – Log into phpMyAdmin. – Select your preference database on the left database navigation drop down list. – Click on Import tab on the [...]
Making mysqldump compatible with older versions
If you receive some errors such as the following when trying to import your mysql database dump you are most likely attempting to dump a database from a newer version of MySQL and import it into an older version: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL [...]