Project

General

Profile

Backup Help

Added by Vikram Prasad over 12 years ago

Hi

I am used backup command : mysqldump -u root -p asterisk > /mnt/asterisk-21nov11.sql
the above command dump the sql file successfully.
but when i am using restore command : mysql -u root -p asterisk < /mnt/asterisk-21nov11.sql
it did not work or did not restoring it. can any one help me.what is the issue with database.

Thanks


Replies (2)

RE: Backup Help - Added by Wilper Necesario over 12 years ago

Hi,

Did you received any errors while restoring the database?

RE: Backup Help - Added by striker 247 over 12 years ago

it looks like ur using wrong command
"mysql -u root -p asterisk < /mnt/asterisk-21nov11.sql"

try
"mysqldump -u root -p asterisk < /mnt/asterisk-21nov11.sql

or try the below
mysql -u root -p

mysql> use asterisk
mysql > \. /mnt/asterisk-21nov11.sql

br
striker
http://striker24x7.co.cc/

    (1-2/2)
    Go to top