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]