Backup Help
Added by Vikram Prasad over 13 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 13 years ago
Hi,
Did you received any errors while restoring the database?
RE: Backup Help
-
Added by striker 247 over 13 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/