How to import big mysql dump file

big dumb

How to import a big dump v file to your database? Phpmyadmin is the common tools to import database on mysql, but dumping a big file it need a loot of effor to do on it.

Actually we can do it without using any tools and believe me it is easy to do.

 

 

 

 

 

1. You need to open mysql using command prompt
2. Connect to the mysql using the user name and password
3. Connect to the database

   USE`database` 

   where ‘database’ is name of your database

4. the next thing to do is import the dump file, the fastest way is using ‘source’ command and point it to your physical path of sql file

   source D:\data\source.sql 

5. Taraaa… that ‘s  it..

The other knowledge command that you might need is information about mysql variable setting  and you can use this command to view and set the mysql variable setting

show variables; 

# With this command can help you to check values of mysql setting

set @@GLOBAL.max_allowed_packet = 1048576000; 

#With this command, you can set the variable values

Advertisement