restoring mysqldump ???

2003-11-22 Thread Nilesh Avalani
i have a backup copy created using mysqldump called test-dump-Sat.sql. i need to restore it into the test database on my remote Solaris server. after getting into mysql i gave command: use test; mysql test test-dump-Sat.sql; i got the following error: ERROR 1064: You have an error in your SQL

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
Hi Mikael, I've tried that but it says : test-dump-Sat.sql: No such file or directory. tell me something... when i type in this command where should my test-dump-Sat.sql file be located? as of now i've placed it in the test folder under mysql-2.23.58/var... is this right? or should it be

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
rights... --- Nilesh Avalani [EMAIL PROTECTED] wrote: Hi Mikael, I've tried that but it says : test-dump-Sat.sql: No such file or directory. tell me something... when i type in this command where should my test-dump-Sat.sql file be located? as of now i've placed it in the test folder