How to import big MYSQL dump in WAMP Server

Hi all

When importing big SQL dump in WAMP, phpmyadmin shows an error that it cannot upload such big dump. The easiest solution I found is, just type in the following in your command prompt.. and it’s done.

C:\wamp64\bin\mysql\mysql5.7.19\bin\mysql.exe -u root -p {dbName} < {file location}
  • {dbName}: should be replaced with your database name where this dump shall be imported.
  • {file location}: should be the location of your sql dump file.
  • Also, check your correct path for mysql.exe file.

 

Leave a Reply

Your email address will not be published. Required fields are marked *