{"id":861,"date":"2018-03-03T22:59:32","date_gmt":"2018-03-03T22:59:32","guid":{"rendered":"https:\/\/webhostingplus.uk\/hosting\/?p=861"},"modified":"2018-03-03T22:59:32","modified_gmt":"2018-03-03T22:59:32","slug":"how-do-i-upload-mysql-database","status":"publish","type":"post","link":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/","title":{"rendered":"How do I upload my MySQL database?"},"content":{"rendered":"

There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2 and 3. <\/p>\n

Method 1<\/strong> \u2013 phpMyAdmin <\/p>\n

You may use phpMyAdmin to load your database by using the Import link to upload a .sql file or by pasting the SQL script into a query window and executing it. For the latter method – <\/p>\n

1. Login to phpMyAdmin with a MySQL user that has been given DBA rights to the MySQL database you wish to load.
\n2. Then click on the SQL tab.
\n3. Paste the SQL script content into the text area, and click Go. <\/p>\n

If the SQL script contains a lot of data, you might still get away with this by pasting it bit by bit. If the data is simply too large, see the other sections. <\/p>\n

Method 2<\/strong> – Web Hosting Plus control panel restore <\/p>\n

In the Web Hosting Plus control panel go to the MySQL Databases page.
\nOn this page is the text “To restore a database which you’ve previously backed up, click here.”
\nIf you follow the link, you can upload a larger SQL file than would be possible in phpMyAdmin. <\/p>\n

If the SQL file is very large, please consider one of the other methods below <\/p>\n

Method 3<\/strong> – MySQL Administrator <\/p>\n

MySQL offer free software to manage, backup and restore MySQL databases. The software can restore very large files, and also comes packaged with MySQL Query Browser, which can be used a faster alternative to phpMyAdmin
\nYou can download the software at https:\/\/dev.mysql.com\/downloads\/workbench\/<\/a><\/p>\n

Method 4<\/strong> – MySQL command line client <\/p>\n

This requires you to have SSH Access, which may or may not be available on your particular package.
\nDue to the limitations imposed by PHP, phpMyAdmin is unable to load a large MySQL dump data. <\/p>\n

You can upload the MySQL dump file created by mysqldump –opt -Q dbname to your home directory, and then execute the MySQL client to load it. <\/p>\n

To load your sql dump using MySQL, you can use the following command: <\/p>\n

mysql -h mysqlhost -u mysqlusername -p databasename < dumpfile.sql \n\nor \n\ncat dumpfile | mysql -h mysqlhost -u mysqlusername -p databasename \n\nWhere: \n\nmysqlhost<\/strong> – The name of the server where your MySQL database is located. You can find this out from the Control Panel in the MySQL Database area.
\nmysqlusername<\/strong> – Your MySQL User name as created through the Control Panel.
\ndatabasename<\/strong> – This is the name of your database
\ndumpfile.sql<\/strong> – The file created by mysqldump <\/p>\n","protected":false},"excerpt":{"rendered":"

There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2 and 3. Method 1 \u2013 phpMyAdmin You may use phpMyAdmin to load your database by using the Import link to upload a .sql file or by pasting the SQL script into a query window and executing it. For the … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-861","post","type-post","status-publish","format-standard","hentry","category-mysql-databases"],"yoast_head":"\nHow do I upload my MySQL database? - Web Hosting Plus<\/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:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I upload my MySQL database? - Web Hosting Plus\" \/>\n<meta property=\"og:description\" content=\"There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2 and 3. Method 1 \u2013 phpMyAdmin You may use phpMyAdmin to load your database by using the Import link to upload a .sql file or by pasting the SQL script into a query window and executing it. For the ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting Plus\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-03T22:59:32+00:00\" \/>\n<meta name=\"author\" content=\"webhostingplus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"webhostingplus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/\"},\"author\":{\"name\":\"webhostingplus\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/person\\\/ac818f1a9ee343e82657049f7c97c9dc\"},\"headline\":\"How do I upload my MySQL database?\",\"datePublished\":\"2018-03-03T22:59:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/\"},\"wordCount\":412,\"publisher\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\"},\"articleSection\":[\"MySQL Databases\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/\",\"name\":\"How do I upload my MySQL database? - Web Hosting Plus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#website\"},\"datePublished\":\"2018-03-03T22:59:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/how-do-i-upload-mysql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I upload my MySQL database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#website\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\",\"name\":\"Web Hosting Plus\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#organization\",\"name\":\"Web Hosting Plus\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/wp-content\\\/uploads\\\/Web-Hosting-Plus-Logo.png\",\"contentUrl\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/wp-content\\\/uploads\\\/Web-Hosting-Plus-Logo.png\",\"width\":339,\"height\":78,\"caption\":\"Web Hosting Plus\"},\"image\":{\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/webhostingplus.uk\\\/hosting\\\/#\\\/schema\\\/person\\\/ac818f1a9ee343e82657049f7c97c9dc\",\"name\":\"webhostingplus\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do I upload my MySQL database? - Web Hosting Plus","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:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"How do I upload my MySQL database? - Web Hosting Plus","og_description":"There are numerous ways to upload a MySQL database, we would strongly recommend trying methods 2 and 3. Method 1 \u2013 phpMyAdmin You may use phpMyAdmin to load your database by using the Import link to upload a .sql file or by pasting the SQL script into a query window and executing it. For the ... Read more","og_url":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/","og_site_name":"Web Hosting Plus","article_published_time":"2018-03-03T22:59:32+00:00","author":"webhostingplus","twitter_card":"summary_large_image","twitter_misc":{"Written by":"webhostingplus","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/#article","isPartOf":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/"},"author":{"name":"webhostingplus","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/person\/ac818f1a9ee343e82657049f7c97c9dc"},"headline":"How do I upload my MySQL database?","datePublished":"2018-03-03T22:59:32+00:00","mainEntityOfPage":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/"},"wordCount":412,"publisher":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#organization"},"articleSection":["MySQL Databases"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/","url":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/","name":"How do I upload my MySQL database? - Web Hosting Plus","isPartOf":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#website"},"datePublished":"2018-03-03T22:59:32+00:00","breadcrumb":{"@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webhostingplus.uk\/hosting\/how-do-i-upload-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webhostingplus.uk\/hosting\/"},{"@type":"ListItem","position":2,"name":"How do I upload my MySQL database?"}]},{"@type":"WebSite","@id":"https:\/\/webhostingplus.uk\/hosting\/#website","url":"https:\/\/webhostingplus.uk\/hosting\/","name":"Web Hosting Plus","description":"","publisher":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webhostingplus.uk\/hosting\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/webhostingplus.uk\/hosting\/#organization","name":"Web Hosting Plus","url":"https:\/\/webhostingplus.uk\/hosting\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/logo\/image\/","url":"https:\/\/webhostingplus.uk\/hosting\/wp-content\/uploads\/Web-Hosting-Plus-Logo.png","contentUrl":"https:\/\/webhostingplus.uk\/hosting\/wp-content\/uploads\/Web-Hosting-Plus-Logo.png","width":339,"height":78,"caption":"Web Hosting Plus"},"image":{"@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/webhostingplus.uk\/hosting\/#\/schema\/person\/ac818f1a9ee343e82657049f7c97c9dc","name":"webhostingplus"}]}},"_links":{"self":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts\/861","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/comments?post=861"}],"version-history":[{"count":0,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/posts\/861\/revisions"}],"wp:attachment":[{"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/media?parent=861"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/categories?post=861"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostingplus.uk\/hosting\/wp-json\/wp\/v2\/tags?post=861"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}