{"id":849,"date":"2013-09-15T20:43:13","date_gmt":"2013-09-15T17:43:13","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=849"},"modified":"2013-09-15T20:43:13","modified_gmt":"2013-09-15T17:43:13","slug":"mysql-database-import-and-export-operations","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/mysql-database-import-and-export-operations\/","title":{"rendered":"MySQL Database Import And Export Operations"},"content":{"rendered":"<p><strong>Take Backup With Data<\/strong><\/p>\n<blockquote><p>Open Command Prompt (cmd)<br \/>\n# mysqldump -u dbusername -p db_name > \/tmp\/db_fullbackup.sql<\/p><\/blockquote>\n<p><strong>Take Only Metadata Backup<\/strong><\/p>\n<blockquote><p>\n# mysqldump -u dbusername -p &#8211;no-data db_name > \/tmp\/db_backupmetadata.sql<br \/>\nor<br \/>\n# mysqldump -u dbusername -p -d db_name > \/tmp\/db_backupmetadata.sql\n<\/p><\/blockquote>\n<p><strong>Restore Database Metadata From Backup<\/strong><\/p>\n<blockquote><p>\n# mysql -u dbusername -p db_name < \/tmp\/db_backupmetadata.sql\n<\/p><\/blockquote>\n<p><strong>Restore Database From Backup<\/strong><\/p>\n<blockquote><p>\n# mysql -u dbusername -p db_name < \/tmp\/db_fullbackup.sql\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Take Backup With Data Open Command Prompt (cmd) # mysqldump -u dbusername -p db_name > \/tmp\/db_fullbackup.sql Take Only Metadata Backup # mysqldump -u dbusername -p &#8211;no-data db_name > \/tmp\/db_backupmetadata.sql or # mysqldump -u dbusername -p -d db_name > \/tmp\/db_backupmetadata.sql Restore Database Metadata From Backup # mysql -u dbusername -p db_name < \/tmp\/db_backupmetadata.sql Restore Database From...\n<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[43,45],"tags":[23,100,44],"class_list":["post-849","post","type-post","status-publish","format-standard","hentry","category-administration-mysql","category-mysql-backup-and-recovery","tag-backup-and-recovery-2","tag-mysql","tag-mysql-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-dH","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=849"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/849\/revisions"}],"predecessor-version":[{"id":850,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/849\/revisions\/850"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=849"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}