Using_mysqldump_Backup_&_Restore_MySQL_Database

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: 85%;"><b><span style="font-size: large;"> Backup and Restore MYSQL Databases</span></b></span><br /> <br /> <span style="font-size: 85%;">Using <span style="font-weight: bold;">mysqldump</span>, you can backup a local database and restore it on a remote database at the same time, using a single command.<br />An examples on how to use mysqldump to backup and restore</span><br /> <br /> <pre><b style="color: #006600;">To backup:</b> # <span style="color: black;">mysqldump -u root -p(root_password) (database_name) > filename.sql</span> <b><span style="color: #000099;">To restore</span>: </b># <span style="color: black;">mysql -u root -p (root_password) (database_name) <></span></pre> <br /> <span style="font-size: 85%;">from the desk of <a href="http://www.amitmaheshwari.in/" target="_blank"><span style="color: #660000;">Amit Maheshwari</span></a></span></div>

Using_mysqldump_Backup_&_Restore_MySQL_Database

 Backup and Restore MYSQL Databases Using mysqldump , you can backup a local database and restore it on a remote database at the same tim...

Read more »