error with loading table structure and data from a script file

Hi, I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error. mysql -u root -p databasename scriptfile.sql What is the right syntax for this. I managed to unpack my table structure from the same script into another machine on Win2000 Server. However, I remember

Re: error with loading table structure and data from a script file

Thursday, April 08, 2004, 1:07:27 PM, b wrote: hi, Error 1064: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL for the right syntax to use near 'mysql -u root -p databasename scriptfile.sql' at line 1 however, I tried this. \u database name; \.