I have some trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command prompt (Windows)
This is my code:
mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql
With this, I get the message that "mysql" is not recognized as internal or external or external command, operable program or batch file.
I added "" to get "mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql" But to this I get error message "The filename, directory name, or volume lable syntax is incorrect"
This man here said the code I tried worked for him.
Any help please? (and if you don't mind, I would appreciate if somebody could told me why changing > to < in the mysqldump command does not work 100% in restoring the backed database)