{"id":181,"date":"2011-01-16T18:57:22","date_gmt":"2011-01-16T23:57:22","guid":{"rendered":"http:\/\/mtecheasy.wordpress.com\/?p=181"},"modified":"2011-01-16T18:57:22","modified_gmt":"2011-01-16T23:57:22","slug":"backing-up-and-restoring-your-mysql-database","status":"publish","type":"post","link":"https:\/\/bourbonnaisservices.com\/blog\/2011\/01\/backing-up-and-restoring-your-mysql-database\/","title":{"rendered":"Backing Up and Restoring Your MySQL Database"},"content":{"rendered":"

The easiest way to backup and restore your mysql database is the following:<\/p>\n

Backing up your database:
\nmysqldump -u username -p password database > backupfile.sql<\/p>\n

– username – this is your database username
\n– password – this is the password for your database
\n– database – the name of your database
\n– backupfile.sql – the file to which the backup should be written.<\/p>\n

Restoring your database:
\nmysql -u username -p password database < backupfile<\/p>\n","protected":false},"excerpt":{"rendered":"

The easiest way to backup and restore your mysql database is the following: Backing up your database: mysqldump -u username -p password database > backupfile.sql – username – this is your database username – password – this is the password for your database – database – the name of your database – backupfile.sql – the […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/181"}],"collection":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/comments?post=181"}],"version-history":[{"count":0,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/181\/revisions"}],"wp:attachment":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/media?parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/categories?post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/tags?post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}