Let me explain this better and add a bit of history so as not to confuse.
Originally...I was going to use phpmyadmin to execute a database dump from my old server and ftp the .sql file to my new server and then use phpmyadmin to import that file.
I was able to dump successfully with phpmyadmin. But I cannot import the file with phpmyadmin because the browser times out. Probably due to the file size about 15 meg.
So I followed the advice here by using mysql to do a dump and import from the mysql prompt. Well the syntax looks plenty easy enough but I keep getting syntax errors. I swear Im following it verbatim so I have no idea what Im doing wrong. Once again Im using terminal services to logon to my windows 2000 server not ssh or telnet but that shouldnt make any difference. I just fire up ms dos and change directory to c:\mysql\bin and type mysql to get a mysql prompt.
From the mysql> I type in:
mysqldump -u myusername -p mydatabasename > mydatabasename.sql
and get this arrow:
[:"red"]-->[/] So then I figure its waiting for a semi colon and I add that and get an sql syntax error.
I never get to the point where it asks for a password because of the syntax error.
I must be typing something wrong.
