Import Large mysql dump

  • run mysql command

>mysql -u [user] -p

Enter password  :  [password]

  • drop your database or create the new one

mysql>drop database [your old database to be droped];

or

mysql>create database [your new database];

  • impor your big dump sql file

mysq>source [path to your dump file +  your dump file name];

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: