How to restore mysql dump file?

All we need is an easy explanation of the problem, so here it is.

We have created a dump file (.sql) using the command mysqldump in mysql5.5.
Now we want to restore the same. We are using the command :-

-u[username] -p[pwd] [dbname] < [.sql file]

But we are not able to restore.
We are using Win7 SP1 32 bit OS.

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Looks like you left part of your command off. To be clear, you’ll need to use the mysql client for the import. But, in general that should work. Another option is to just connect to the client (same command as before, but with out the the

Once in you can run

mysql> source /path/to/outfile.sql

Method 2

The problem got solved by using command prompt of Windows OS. Following are the steps:

  1. Change the directory to the one where your dump file is residing.

    cd /d [pathname]
    
  2. Execute the restore command

    mysql -u[username] -p[password] [dbname] < [filename]
    

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply