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
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
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
but when i try to run :
% mysql -u root reporter reporter-dump-Sat.sql
mysql -uroot -p reporter dumpfile
it says :
ERROR 1044: Access denied for user: '@localhost' to
database 'reporter'.
think it's because of that extra space between the '-u' and 'root'
you also need the -p parameter so
]
Verzonden: zondag 23 november 2003 13:48
Aan: [EMAIL PROTECTED]; Nilesh Avalani
Onderwerp: Re: restoring mysqldump ???
but when i try to run :
% mysql -u root reporter reporter-dump-Sat.sql
mysql -uroot -p reporter dumpfile
it says :
ERROR 1044: Access denied for user: '@localhost
PROTECTED]
Verzonden: zondag 23 november 2003 14:11
Aan: 'Mikael Fridh'; [EMAIL PROTECTED]; 'Nilesh Avalani'
Onderwerp: RE: restoring mysqldump ???
mysql -u user_name -p reporter dumpfile
Leaving a space between -u (=user) and the user_name should
not be a problem it is if you supply