{"id":49,"date":"2012-06-25T18:53:41","date_gmt":"2012-06-25T18:53:41","guid":{"rendered":"http:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=49"},"modified":"2023-02-04T10:11:12","modified_gmt":"2023-02-04T10:11:12","slug":"importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/","title":{"rendered":"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server"},"content":{"rendered":"<p>In order to avoid issues with the data that contains non-english characters, exact character set has to be used for <a href=\"https:\/\/www.milesweb.co.uk\/forums\/how-to's\/how-to-import-mysql-database\/\">importing the MySQL database<\/a>.<\/p>\n<p>For instance, if Unicode (UTFB) is the character set of your data, the following command can be used for importing the character set:<\/p>\n<p><strong>mysqldump -uUSERNAME -pPASSWORD &#8211;default-character-set=utf8 USER_DATABASE &gt; backup.sql<\/strong><\/p>\n<p>The attributes &#8211; USERNAME, PASSWORD and USER_DATABASE can be updated with the relevant values pertaining to your database and then a file &#8220;<strong>backup.sql<\/strong>&#8221; will be created that will be encoded in UTF-8.<\/p>\n<p>If any empty MySQL database is used for importing the backup, the exact character set for the data can be inserted manually. You will have to use the following command for doing this:<\/p>\n<p><strong>mysql -uUSERNAME -pPASSWORD &#8211;default-character-set=utf8 USER_DATABASE &lt; backup.sql<\/strong><\/p>\n<p>Replace <strong>&#8211;default-character-set=utf8<\/strong> with the respective character set used for creating the backup.sql file for making sure that the data is inserted correctly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order to avoid issues with the data that contains non-english characters, exact character set has to be used for importing the MySQL database. For instance, if Unicode (UTFB) is the character set of your data, the following command can be used for importing the character set: mysqldump -uUSERNAME -pPASSWORD &#8211;default-character-set=utf8 USER_DATABASE &gt; backup.sql The [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-49","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-dedicated-server-faq"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server<\/title>\n<meta name=\"description\" content=\"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.\" \/>\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.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server\" \/>\n<meta property=\"og:description\" content=\"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-25T18:53:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-04T10:11:12+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/\",\"name\":\"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"datePublished\":\"2012-06-25T18:53:41+00:00\",\"dateModified\":\"2023-02-04T10:11:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69\"},\"description\":\"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g\",\"caption\":\"admin\"},\"description\":\"With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server","description":"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.","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.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/","og_locale":"en_GB","og_type":"article","og_title":"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server","og_description":"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2012-06-25T18:53:41+00:00","article_modified_time":"2023-02-04T10:11:12+00:00","author":"admin","twitter_misc":{"Written by":"admin","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/","name":"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"datePublished":"2012-06-25T18:53:41+00:00","dateModified":"2023-02-04T10:11:12+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69"},"description":"Use the Dedicated Server to import \/ export MySQL databases with the correct character set.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/importing-exporting-mysql-database-with-the-exact-character-set-on-the-dedicated-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Importing \/ Exporting MySQL Database With The Exact Character Set On The Dedicated Server"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/90143c7d8df4b4de36b3dbb0bb272f69","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/42e5b55cc2772cd685c8803f6f7f854b?s=96&d=blank&r=g","caption":"admin"},"description":"With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/admin\/"}]}},"views":1221,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/49","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=49"}],"version-history":[{"count":6,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/49\/revisions"}],"predecessor-version":[{"id":3110,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/49\/revisions\/3110"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=49"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=49"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=49"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}