{"id":3862,"date":"2016-05-05T17:08:40","date_gmt":"2016-05-05T21:08:40","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2016\/05\/05\/how-to-migrate-databases-into-your-reseller-server\/"},"modified":"2023-06-12T10:32:24","modified_gmt":"2023-06-12T14:32:24","slug":"how-to-migrate-databases-into-your-reseller-server","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/","title":{"rendered":"How to Migrate Databases into your Reseller Server"},"content":{"rendered":"

In this article, we will show you how to migrate your customers\u2019 databases into your reseller hosting account. At this point, you should have already created a cPanel account<\/a>. These steps will also work on the VPS reseller program<\/a> as well as the shared option.<\/p>\n\n\n\n

How Do I Know if my Customers are using a Database?<\/h2>\n\n\n\n

If your customer is using a Content Management System like WordPress or Joomla, or they have a shopping cart, then they are most likely using a database to store the content of their website.<\/p>\n\n\n\n

Repairing the Database<\/h2>\n\n\n\n

It is important to always \u201crepair\u201d the database before exporting. Often, exporting a database without using \u201crepair\u201d can cause data loss due to caching and various server-side functions.<\/p>\n\n\n\n

How to Repair a Database in phpMyAdmin<\/h2>\n\n\n\n

phpMyAdmin<\/strong> is a popular open-source database management system. It is widely used, so your customers may have an available installation in their hosting environment. Here we\u2019ll show you how to access phpMyAdmin from the cPanel interface.<\/p>\n\n\n\n

    \n
  1. Log into your cPanel<\/a>.<\/li>\n\n\n\n
  2. \"phpMyAdmin<\/a>Click on phpMyAdmin<\/b> located under the Databases<\/em> category.\n
    \u00a0<\/div>\n<\/li>\n\n\n\n
  3. \"Select<\/a>Select the database you want to repair from the menu on the left side.\n
    \u00a0<\/div>\n<\/li>\n\n\n\n
  4. \"check<\/a>Under the Table<\/em> section choose Check All<\/strong>.\n
    \u00a0<\/div>\n<\/li>\n\n\n\n
  5. \"Click<\/a>In the dropdown menu, select Repair table<\/strong>.\n
    \u00a0<\/div>\n<\/li>\n<\/ol>\n\n\n\n

    How to Repair a Database from the Command Line<\/h3>\n\n\n\n

    If your customer does not have either cPanel or phpMyAdmin, you can also repair the database on the command line using the below command:<\/p>\n\n\n\n

    mysqlcheck --repair -u [USERNAME] -p [DATABASE]<\/code><\/p>\n\n\n\n

    Make sure to replace [USERNAME] with the actual database username and [DATABASE] with the name of the database.<\/p>\n\n\n\n

    Exporting the Database<\/h2>\n\n\n\n

    You will need a copy of the database in .sql format. Your customer should be able to provide this to you. If not, there are a few different ways they can export their database.<\/p>\n\n\n\n

    You can export a database using phpMyAdmin<\/a> if available. You can also export the database on the command line<\/a>.<\/p>\n\n\n\n

    Import the Database into Your Reseller Server<\/h2>\n\n\n\n

    Once you have recovered the .sql file from the old host you can easily import the database into your customer\u2019s phpMyAdmin installation (available through cPanel).<\/p>\n\n\n\n

    How to Import the Database into phpMyAdmin<\/h3>\n\n\n\n

    The steps below are meant to be followed after you have created a new database<\/a> to import the original database into.<\/p>\n\n\n\n

      \n
    1. Log into cPanel.<\/li>\n\n\n\n
    2. Go to the Databases section.<\/li>\n<\/ol>\n\n\n\n
      \"phpMyAdmin<\/a><\/figure>\n\n\n\n
      \u00a0<\/div>\n\n\n\n
      \u00a0<\/div>\n\n\n\n
        \n
      1. Choose phpMyAdmin<\/strong>.\n
        \u00a0<\/div>\n<\/li>\n<\/ol>\n\n\n\n
        \"choose<\/a><\/figure>\n\n\n\n
        \u00a0<\/div>\n\n\n\n
          \n
        1. Select the database you created to import into.\n
          \u00a0<\/div>\n<\/li>\n<\/ol>\n\n\n\n
          \"import<\/a><\/figure>\n\n\n\n
          \u00a0<\/div>\n\n\n\n
            \n
          1. Click Import<\/strong> from the top menu.\n
            \u00a0<\/div>\n<\/li>\n<\/ol>\n\n\n\n
            \"browse<\/a><\/figure>\n\n\n\n
            \u00a0<\/div>\n\n\n\n
              \n
            1. Under File to Import<\/em> click Browse<\/strong>.\n
              \u00a0<\/div>\n<\/li>\n\n\n\n
            2. Locate the database file you are importing.<\/li>\n\n\n\n
            3. \"Gray<\/a>\n
              \u00a0<\/div>\n

              Click Go<\/strong> at the bottom.<\/p>\n

              \u00a0<\/div>\n<\/li>\n<\/ol>\n\n\n\n

              Now that you have imported the database, make sure that any applications that use this database can connect successfully. Remember, you can test the site with a hosts file modification<\/a> before switching DNS to your reseller server.<\/p>\n\n\n\n

              If you are working on migrating an account from a non-cPanel host, you can continue to our next article on transferring emails to your reseller account<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

              In this article, we will show you how to migrate your customers’ databases into your reseller hosting account. At this point, you should have already created a cPanel account. These steps will also work on the VPS reseller program as well as the shared option. How Do I Know if my Customers are using a Read More ><\/a><\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4463,4305],"tags":[],"class_list":["post-3862","post","type-post","status-publish","format-standard","hentry","category-reseller-hosting","category-databases"],"acf":[],"yoast_head":"\nHow to Migrate Databases into your Reseller Server | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this article, we will be covering different methods for migrating databases into your reseller hosting server.\" \/>\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.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Migrate Databases into your Reseller Server | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this article, we will be covering different methods for migrating databases into your reseller hosting server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-05T21:08:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-12T14:32:24+00:00\" \/>\n<meta name=\"author\" content=\"Christopher Maiorana\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Maiorana\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\"},\"author\":{\"name\":\"Christopher Maiorana\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f\"},\"headline\":\"How to Migrate Databases into your Reseller Server\",\"datePublished\":\"2016-05-05T21:08:40+00:00\",\"dateModified\":\"2023-06-12T14:32:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\"},\"wordCount\":501,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"Reseller Hosting\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\",\"name\":\"How to Migrate Databases into your Reseller Server | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2016-05-05T21:08:40+00:00\",\"dateModified\":\"2023-06-12T14:32:24+00:00\",\"description\":\"In this article, we will be covering different methods for migrating databases into your reseller hosting server.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Migrate Databases into your Reseller Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f\",\"name\":\"Christopher Maiorana\",\"description\":\"Christopher Maiorana joined the InMotion community team in 2015 and regularly dispenses tips and tricks in the Support Center, Community Q&A, and the InMotion Hosting Blog.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/chris-m-4623144b\/\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/christopherm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Migrate Databases into your Reseller Server | InMotion Hosting","description":"In this article, we will be covering different methods for migrating databases into your reseller hosting server.","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.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/","og_locale":"en_US","og_type":"article","og_title":"How to Migrate Databases into your Reseller Server | InMotion Hosting","og_description":"In this article, we will be covering different methods for migrating databases into your reseller hosting server.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2016-05-05T21:08:40+00:00","article_modified_time":"2023-06-12T14:32:24+00:00","author":"Christopher Maiorana","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Christopher Maiorana","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/"},"author":{"name":"Christopher Maiorana","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f"},"headline":"How to Migrate Databases into your Reseller Server","datePublished":"2016-05-05T21:08:40+00:00","dateModified":"2023-06-12T14:32:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/"},"wordCount":501,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["Reseller Hosting","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/","name":"How to Migrate Databases into your Reseller Server | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2016-05-05T21:08:40+00:00","dateModified":"2023-06-12T14:32:24+00:00","description":"In this article, we will be covering different methods for migrating databases into your reseller hosting server.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/how-to-migrate-databases-into-your-reseller-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Migrate Databases into your Reseller Server"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/c6922c56c84e17079fd558e07b7ef72f","name":"Christopher Maiorana","description":"Christopher Maiorana joined the InMotion community team in 2015 and regularly dispenses tips and tricks in the Support Center, Community Q&A, and the InMotion Hosting Blog.","sameAs":["https:\/\/www.linkedin.com\/in\/chris-m-4623144b\/"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/christopherm\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3862","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=3862"}],"version-history":[{"count":7,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3862\/revisions"}],"predecessor-version":[{"id":105111,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3862\/revisions\/105111"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=3862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=3862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=3862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}