{"id":185,"date":"2009-10-05T17:28:48","date_gmt":"2009-10-05T21:28:48","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=185"},"modified":"2013-03-20T08:40:08","modified_gmt":"2013-03-20T12:40:08","slug":"howto-backup-and-restore-a-database","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/howto-backup-and-restore-a-database","title":{"rendered":"Howto: Backup and Restore a database"},"content":{"rendered":"<p>You need to use the <strong>&#8220;mysqldump&#8221; command to backup a Mysql database<\/strong>.<\/p>\n<p><strong>Backup\/Dump a Mysql database on a Linux Or Linux\/cPanel server:<\/strong><\/p>\n<blockquote><p><span style=\"color: #0000ff;\"><strong>root@host [~]# mysqldump \/var\/lib\/mysql\/dbname &gt; dbname.sql<\/strong><\/span><\/p><\/blockquote>\n<p><strong>Restore the .sql file in a database:<\/strong><\/p>\n<blockquote><p><span style=\"color: #0000ff;\"><strong>root@host [~]# mysql \/var\/lib\/mysql\/dbname &lt; \/path\/to\/filename.sql<\/strong><\/span><\/p><\/blockquote>\n<p><strong>Backup\/Dump a Mysql database on a Linux\/Plesk server:<\/strong><\/p>\n<blockquote><p><span style=\"color: #0000ff;\"><strong>root@host [~]# mysqldump -uadmin -p`cat \/etc\/psa\/.psa.shadow` \/var\/lib\/mysql\/dbname &gt; dbname.sql<\/strong><\/span><\/p><\/blockquote>\n<p><strong>Restore the .sql file on a Plesk server :<\/strong><\/p>\n<blockquote><p><span style=\"color: #0000ff;\"><strong>root@host [~]# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` \/var\/lib\/mysql\/dbname &lt; \/path\/to\/filename.sql<\/strong><\/span><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>You need to use the &#8220;mysqldump&#8221; command to backup a Mysql database.<br \/>\nBackup\/Dump a Mysql database on a Linux Or Linux\/cPanel server:<br \/>\nroot@host [~]# mysqldump \/var\/lib\/mysql\/dbname &gt; dbname.sql<br \/>\nRestore the .sql file in a database:<br \/>\nroot@host [~]# mysql \/var\/lib\/mysql\/dbname &lt; \/path\/to\/filename.sql<br \/>\nBackup\/Dump a Mysql database on a Linux\/Plesk server:<br \/>\nroot@host [~]# mysqldump -uadmin -p`cat \/etc\/psa\/.psa.shadow` \/var\/lib\/mysql\/dbname &gt; dbname.sql<br \/>\nRestore the .sql file on a Plesk server :<br \/>\nroot@host [~]# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` \/var\/lib\/mysql\/dbname &lt; \/path\/to\/filename.sql<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[111],"tags":[201,202,203,200],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/185"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":7,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"predecessor-version":[{"id":2126,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions\/2126"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}