{"id":2661,"date":"2019-06-30T15:00:25","date_gmt":"2019-06-30T09:30:25","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=2661"},"modified":"2019-06-30T15:00:26","modified_gmt":"2019-06-30T09:30:26","slug":"how-to-export-import-mysql-database-with-correct-character-set-on-linux","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/","title":{"rendered":"How to export\/import MySQL database with correct character set on Linux?"},"content":{"rendered":"\n<p>To Export\/Import MySQL database with correct character set on Linux export your database with the correct character set is important to avoid any kind of problems with data that has non English characters within the table. <\/p>\n\n\n\n<p>For example, if the character set of the database is Unicode (UTF8) you can use the following command to export it using this character set: <\/p>\n\n\n\n<p>Command would be as below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># mysqldump -u User -p Password \u2013default-character-set=utf8 Database > backup.sql<\/pre>\n\n\n\n<p>Replace User, Password and Database with values for your database and you will have a file named \u201cbackup.sql\u201d encoded in UTF-8. <\/p>\n\n\n\n<p>When you import a database backup into an empty MySQL database tables then you can set the exact character set for the data. For that use the following syntax for the command as follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># mysql -uUser -pPassword \u2013default-character-set=utf8 Database &lt; backup.sql<\/pre>\n\n\n\n<p>Replace \u2013default-character-set=utf8 with the charset used for the creation of the backup.sql file.\u00a0 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>To Export\/Import MySQL database with correct character set on Linux export your database with the correct character set is important to avoid any kind of problems with data that has non English characters within the table. For example, if the character set of the database is Unicode (UTF8) you can use the following command to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[30,34,174],"tags":[177,178,179,25,176],"class_list":["post-2661","post","type-post","status-publish","format-standard","hentry","category-centos","category-linux","category-mysql","tag-backup","tag-character-set","tag-charset","tag-mysql","tag-mysqldump"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog<\/title>\n<meta name=\"description\" content=\"How to export\/import MySQL database with correct character set on Linux?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"How to export\/import MySQL database with correct character set on Linux?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-30T09:30:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-30T09:30:26+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/\",\"name\":\"How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2019-06-30T09:30:25+00:00\",\"dateModified\":\"2019-06-30T09:30:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"description\":\"How to export\/import MySQL database with correct character set on Linux?\",\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to export\/import MySQL database with correct character set on Linux?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog","description":"How to export\/import MySQL database with correct character set on Linux?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/","og_locale":"en_US","og_type":"article","og_title":"How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog","og_description":"How to export\/import MySQL database with correct character set on Linux?","og_url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/","og_site_name":"24x7serversupport Blog","article_published_time":"2019-06-30T09:30:25+00:00","article_modified_time":"2019-06-30T09:30:26+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/","url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/","name":"How to export\/import MySQL database with correct character set on Linux? | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2019-06-30T09:30:25+00:00","dateModified":"2019-06-30T09:30:26+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"description":"How to export\/import MySQL database with correct character set on Linux?","breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-export-import-mysql-database-with-correct-character-set-on-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to export\/import MySQL database with correct character set on Linux?"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=2661"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2661\/revisions"}],"predecessor-version":[{"id":2662,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/2661\/revisions\/2662"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=2661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=2661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=2661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}