alright guys,
here is the mistake i was making - sorry i'm a total fresher... i need to be in the same directory where the test-dump-Sat.sql file is located. so i simply copied the dump file to the root from where i was executing my commands and it was working. However now i need it to be restored in a proper database folder (reporter) and not in the test database... but when i try to run : % mysql -u root reporter < reporter-dump-Sat.sql it says : ERROR 1044: Access denied for user: '@localhost' to database 'reporter'. Can someone guide how to go abt creating 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-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] > __________________________________ 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]