I'm currently using MySQL version 5.0.16, on my local computer (which runs a 32-bit OS), for easier access while developing my program.
Now that I'm ready to deploy my program, I'd like to test the connection over a network, and use a 64-bit server to hold the database.
Up til now, I've only used the 32-bit version, and my backup 'process' would be to copy the database folder from C:\Program Files\MySQL\MySQL Server 5.0\data and paste it onto the same directory of another computer.
I'm not sure if that would work.
I tried using both MySQL Query Browser and Command Line Client to do the following:
mysqldump -u root -proot Isys-TMS(EEI1) > isystms.sql;
But both simply return this error:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -proot Isys-TMS(EEI1) > isystms.sql' at line 1"
Which is not at all helpful. (Though I'm not sure if I did it right on the command line client, as opposed to Windows' own CMD)
I'm also assuming I can simply use this .sql output on the new 64-bit MySQL, so if that's not the case, what else can I do to solve this problem?
- I'm using Windows 7 32-bit Pro, with MySQL Server 5.0 installed in it.
- I'm planning to move the database to a Windows Server 2008 64-bit, with MySQL Community Server 5.6
EDIT: I actually used mysqldump, not mysqldumb. Quick, someone make a dumb/dump joke.