MySQL Forums
Forum List  »  Backup

MYSQL backup
Posted by: karthi R
Date: April 27, 2011 10:50PM

HI all

I m using Mysql 5.5 and i want to take single database backup.
i used that following commands in Mysql query browser to run the Query

mysqldump -u root -p password mysql(database name)>archive_data_mh.sql(backup database name);

but this query is not working and send the error report as

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p sachin mysql>archive_data_mh' at line 1

Please Help to run the command ....

Thanks in Advance friends ....

Options: ReplyQuote


Subject
Views
Written By
Posted
MYSQL backup
3403
April 27, 2011 10:50PM
1537
April 27, 2011 11:00PM
1185
April 27, 2011 11:08PM
1184
April 27, 2011 11:29PM
1174
April 28, 2011 03:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.