Trouble restoring a mysql database
-
Dear friends, For days now, I have been trying to restore a backup of the database (with command prompt) I had made with mysqldump. This is my line of code. "C:\Program Files\MySQL\MySQL Server 5.5\mysql --user=root --password=mypassword --host= localhost --port= 3306 --database=dbname < C:/Backup/dbname.sql" I get "The filename, directory name, or volume lable syntax is incorrect" error messsage. I have googled for this error to no avail as to do with mysql. - My mysql server is up and running with no problem. (Even the mysqldump command works) -Problem is the same even if I open the command prompt from C:\Program Files\MySQL\MySQL Server 5.5\mysql -I have tried to remove "", did not help. - I tried to change / with \ but no success. For this one, I will really appreciate any help.
-
Dear friends, For days now, I have been trying to restore a backup of the database (with command prompt) I had made with mysqldump. This is my line of code. "C:\Program Files\MySQL\MySQL Server 5.5\mysql --user=root --password=mypassword --host= localhost --port= 3306 --database=dbname < C:/Backup/dbname.sql" I get "The filename, directory name, or volume lable syntax is incorrect" error messsage. I have googled for this error to no avail as to do with mysql. - My mysql server is up and running with no problem. (Even the mysqldump command works) -Problem is the same even if I open the command prompt from C:\Program Files\MySQL\MySQL Server 5.5\mysql -I have tried to remove "", did not help. - I tried to change / with \ but no success. For this one, I will really appreciate any help.
Get the MySQL GUI Tools and try with them. That's the easiest way. My impression is that you do something wrong with spaces and quotation marks. What about
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" --user=root --password=mypassword --host=localhost --port=3306 --database=dbname < "C:\Backup\dbname.sql"
In case of the GUI tools, you need not worry about that.
-
Get the MySQL GUI Tools and try with them. That's the easiest way. My impression is that you do something wrong with spaces and quotation marks. What about
"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe" --user=root --password=mypassword --host=localhost --port=3306 --database=dbname < "C:\Backup\dbname.sql"
In case of the GUI tools, you need not worry about that.