go to the folder where mysql.exe exists and execute the command there Read More
take a look at http://adityangoyal.blogspot.in/2013/04/importexport-mysql-database.html .I have explained how to import and export mysql database.
* As what i can see,the error you are getting is because you have to set the path of mysql.exe in your system environment variable.
Go to System properties->Environment variable.In system varaiable->path.At end add semicolon … Read More
> mysqldump -u username -p databasename < C:\Backup\databaseNameToBeRestored.sql
We always change from < to > because
when we use "**<**" we are importing a file to our database.
And on the other hand when we use "**>**" we are exporting.
Happy coding. Read More
instead of backward slash(\), try forward slash(/) in your location.
mysql --u root --pMyPassword databasename < C:/Backup/databasename.sql
Note:-I hope that you are also following the steps i told in my first comment,otherwise you will get mysql is not recognised as internal command error Read More
Check if your mysql service is running.Check if it's status is Started.Try by restarting the mysql service.
If it is still not working also check if firewall is not blocking the service to connect. Read More
Do note that that there is a difference when specifying option with `-` versus `--`
mysql -u root -h localhost
mysql --user=root --host=localhost
Use one or the other. [Read more](http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html). Read More
Use back slashes on windows, not forward slashes
`C:\Backup\dbname.sql` Read More
Hmm, you should be running it from bin. Try this with two different steps:
1) `cd C:\Program Files\MySQL\MySQL Server 5.5\bin`
2) `mysql –uroot -ppassword -hlocalhost dbname < C:\Backup\dbname.sql` Read More
Have you thought about using a GUI - e.g toad or workbench ?
and just run the script from within. Read More
**savedlema** .. it did not work beacause we just imported .. It did not update the database you have ..
if you are using phpmyadin just upload your backup .. in that case you will not have a prblem in your data.. Read More