{"id":419,"date":"2013-05-10T06:07:19","date_gmt":"2013-05-10T06:07:19","guid":{"rendered":"http:\/\/a1webdesignteam.com\/blog\/?p=419"},"modified":"2013-05-10T06:07:19","modified_gmt":"2013-05-10T06:07:19","slug":"backup-restore-mysql-database-mysqldump-command","status":"publish","type":"post","link":"https:\/\/a1webdesignteam.com\/blog\/backup-restore-mysql-database-mysqldump-command\/","title":{"rendered":"Backup and Restore Mysql database with mysqldump command"},"content":{"rendered":"

For fast database backup, use command line tool. Here are basic scripts for backing up and restoring a mysql database from the command line<\/p>\n

Backup<\/strong><\/p>\n

\n
\n
mysqldump -u user -p database_name > dump.sql<\/pre>\n<\/div>\n<\/div>\n
Fast Restore<\/strong><\/p>\n
\n
\n
mysql - u user -p database_name < dump.sql<\/pre>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
For fast database backup, use command line tool. Here are basic scripts for backing up and restoring a mysql database from the command line Backup mysqldump -u user -p database_name > dump.sql Fast Restore mysql – u user -p database_name < dump.sql<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/419"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=419"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/419\/revisions"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}