How to import a large database in Wamp

If you try to import a large MySQL database in your server, then a Maximum execution time of 300 seconds exceeded may occur. To override this do the following:

Left click wampmanager icon in the system tray -> MySQL -> MySQL Console

Enter the ‘root’ password which is nothing ( just press enter key ) unless you changed it.

Select the database you want to reload like this

USE Database_name;

Then load the dump file like this

SOURCE C:\folder\where\you_saved\your\dumpfile.sql

You can alternatively use bigdump as explained here.

Post A Comment

Anti-Spam Quiz: