{"id":1217,"date":"2018-12-17T14:12:38","date_gmt":"2018-12-17T13:12:38","guid":{"rendered":"https:\/\/www.websupport.sk\/podpora\/?post_type=ht_kb&#038;p=1217"},"modified":"2019-01-13T20:34:22","modified_gmt":"2019-01-13T19:34:22","slug":"en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/","title":{"rendered":"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7"},"content":{"rendered":"\n<p><strong>This migration can be done via Webadmin. Steps are the same for different database versions, although only migrating to a newer version is typically supported.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Log in to Webadmin<\/strong><\/li><li><strong>Choose your domain and open the Databases section<\/strong><\/li><li><strong>Find the database you with to migrate, and select Manage -&gt; Duplicate<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1477\" height=\"634\" src=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png\" alt=\"\" class=\"wp-image-1219\" srcset=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png 1477w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-300x129.png 300w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-768x330.png 768w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-783x336.png 783w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-50x21.png 50w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-60x26.png 60w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1-100x43.png 100w\" sizes=\"auto, (max-width: 1477px) 100vw, 1477px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>A dialog informing you that a backup will have to be created is shown, this is OK. Click continue<\/strong><\/li><li><strong>On the next screen, pick the target database type, choose a name and password (or accept \/ generate random ones) and click on Create.&nbsp;<\/strong><\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1467\" height=\"956\" src=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00.png\" alt=\"\" class=\"wp-image-1221\" srcset=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00.png 1467w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-300x196.png 300w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-768x500.png 768w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-783x510.png 783w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-50x33.png 50w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-60x39.png 60w, https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-27-09-35-00-100x65.png 100w\" sizes=\"auto, (max-width: 1467px) 100vw, 1467px\" \/><\/figure>\n\n\n\n<p><strong>You\u2019ve just created a new database. To check whether everything is OK with your new database, try logging into PhpMyAdmin at db57.websupport.sk (if you picked MySQL 5.7).<\/strong><\/p>\n\n\n\n<p><strong>Now the only remaining step is updating the configuration of your website to connect to the newly created database &#8211; you may use our how-to to check out the necessary steps.<\/strong><\/p>\n\n\n\n<p><strong>If your website is running fine on your new database, you may delete the original database at any time &#8211; by following the first two steps of the above guide, and selecting \u201cManage -&gt; Delete\u201d.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>HAVING ISSUES?<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>ACCENTED CHARACTERS AREN\u2019T BEING DISPLAYED CORRECTLY<\/strong><\/h4>\n\n\n\n<p><strong>One of possible, though uncommon, issues may be that the website shows incorrect characters in place of accented characters (broken diacritics). Sometimes the only thing that\u2019s necessary is manually specifying the encoding when the app connects to the database. For example:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$connection&nbsp;=&nbsp;new&nbsp;PDO(\"mysql:host=mysql57.websupport.sk;port=3311;dbname=db_name; charset=utf8\", \"db_name\", \"password\", array(PDO::MYSQL_ATTR_INIT_COMMAND =&gt; \"SET NAMES 'utf8'\"));<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">$connection = 'mysql:unix_socket=\/tmp\/mysql57.sock;dbname='nazov_db';charset=utf8';<\/pre>\n\n\n\n<p><strong>If none of these work, you may try issuing the SET NAMES command manually by adding the following after the connection string:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql_query(\"SET NAMES 'utf8'\");<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\">$db = mysql_pconnect('localhost:\/tmp\/mysql57.sock','nazov_db','heslo');\n\nmysql_query(\"SET NAMES 'utf8'\");\n\nmysql_select_db('nazov_db');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>This migration can be done via Webadmin. Steps are the same for different database versions, although only migrating to a newer version is typically supported. Log in to Webadmin Choose your domain and open the Databases section Find the database you with to migrate, and select Manage -&gt; Duplicate A&#8230;<\/p>\n","protected":false},"author":30,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[41],"ht-kb-tag":[],"class_list":["post-1217","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databazy"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory<\/title>\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.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory\" \/>\n<meta property=\"og:description\" content=\"This migration can be done via Webadmin. Steps are the same for different database versions, although only migrating to a newer version is typically supported. Log in to Webadmin Choose your domain and open the Databases section Find the database you with to migrate, and select Manage -&gt; Duplicate A...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport centrum podpory\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-13T19:34:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min\u00faty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/\",\"url\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/\",\"name\":\"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.sk\/podpora\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png\",\"datePublished\":\"2018-12-17T13:12:38+00:00\",\"dateModified\":\"2019-01-13T19:34:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage\",\"url\":\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png\",\"contentUrl\":\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png\",\"width\":1477,\"height\":634},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.websupport.sk\/podpora\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.websupport.sk\/podpora\/#website\",\"url\":\"https:\/\/www.websupport.sk\/podpora\/\",\"name\":\"Websupport centrum podpory\",\"description\":\"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory","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.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/","og_locale":"sk_SK","og_type":"article","og_title":"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory","og_description":"This migration can be done via Webadmin. Steps are the same for different database versions, although only migrating to a newer version is typically supported. Log in to Webadmin Choose your domain and open the Databases section Find the database you with to migrate, and select Manage -&gt; Duplicate A...","og_url":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/","og_site_name":"Websupport centrum podpory","article_modified_time":"2019-01-13T19:34:22+00:00","og_image":[{"url":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"2 min\u00faty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/","url":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/","name":"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7 - Websupport centrum podpory","isPartOf":{"@id":"https:\/\/www.websupport.sk\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png","datePublished":"2018-12-17T13:12:38+00:00","dateModified":"2019-01-13T19:34:22+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/"]}]},{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#primaryimage","url":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png","contentUrl":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/Screenshot-from-2018-06-04-10-08-13_shadow-1.png","width":1477,"height":634},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/en-migrating-a-database-from-mysql-5-0-5-1-to-mysql-5-7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/podpora\/"},{"@type":"ListItem","position":2,"name":"[EN] Migrating a database from MySQL 5.0\/5.1 to MySQL 5.7"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/podpora\/#website","url":"https:\/\/www.websupport.sk\/podpora\/","name":"Websupport centrum podpory","description":"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/users\/30"}],"version-history":[{"count":1,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1217\/revisions"}],"predecessor-version":[{"id":1225,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1217\/revisions\/1225"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/media?parent=1217"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1217"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}