Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
the user with the necessary 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

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 somewh

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 SQ