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 somewhere on my local system? just in case i didnt say this before... I've trying to run this command on a remote solaris server...
Thanks, Nilesh --- Mikael Fridh <[EMAIL PROTECTED]> wrote: > > 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; > > try the same command from shell. > shell> mysql -uUser -p test < test-dump-Sat.sql > > Mike > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]