Organizational Research By

Surprising Reserch Topic

How to take MYSQL database backup?


To take the database backup use the following syntax:
mysqldump --add-drop-table -u [username] -p[password] [database] > [backup_file]
This command will take the database backup by knowing the username and password for the database connection and dropping any table which is being deleted or not in use. It is always a good practice to take the backup of mysql as it contains all the database information that a user can access. While using the command keep a note that there should not be any space between –p switch and password, if there is then you will get a syntax error.
 
asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
19 views



Related Hot Questions



Government Jobs Opening


...