How to take database backup and restore that in mysql

Question

0.00/5 (No votes)

See more:

Hi
Please tell me how to take database backup in mysql using command line.and where it will be stored..i am using MySql 5.5

Thank you

Posted 19-Dec-12 20:09pm

Code-Hunt

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Abhishek Pant* · Answer 1 · 2012-12-19T20:24:00

Solution 1

this is your solution
MySQL Database Backup using mysqldump command[^]

Backup and Restore MySQL Database Using mysqldump[^]
Backing Up and Restoring A MySQL Database[^]
also have reference with the
MySQL 5.5 Reference Manual-mysqldump — A Database Backup Program[^]

also write your syntax correctly

Posted 19-Dec-12 20:24pm

Abhishek Pant

Updated 19-Dec-12 20:47pm

v3

Comments

[no name] 20-Dec-12 2:33am

i tried this but its giving error..

mysql> mysqldump -uroot -p1234 demo > demo.sql
-> ;
ERROR 1064 (42000): 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 'mysql
dump -uroot -p1234 demo>demo.sql' at line 1
mysql> mysqldump --user root --password=1234 demo > demo.sql;
ERROR 1064 (42000): 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 'mysql
dump --user root --password=1234 demo > demo.sql' at line 1

How to take database backup and restore that in mysql

1 solution

Solution 1

Add your solution here

Preview 0

How to take database backup and restore that in mysql

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us