Using mysqldump
Using ‘mysqldump’ command you can take the mysql database backup. This command all the datas to a text file.
The syntax is
shell> mysqldump [options] db_name [tables]
shell> mysqldump [options] –databases db_name1 [db_name2 db_name3…]
shell> mysqldump [options] –all-databases
Backuping Examples:
shell> mysqldump -u root -p dbaseName > file.sql;
shell> Enter the password
Restoring Example:
Suppose, we have the database as file.sql, and we […]

Continue reading " Backuping & Restoring using mysqldump & mysqlhotcopy "