{"id":14,"date":"2016-01-12T15:52:14","date_gmt":"2016-01-12T20:52:14","guid":{"rendered":"http:\/\/wp-p3d2tsa2xh.pairsite.com\/?p=14"},"modified":"2025-05-29T14:58:33","modified_gmt":"2025-05-29T18:58:33","slug":"moving-your-mysql-database-to-pair-networks","status":"publish","type":"ht_kb","link":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/","title":{"rendered":"Moving Your MySQL Database to Pair Networks"},"content":{"rendered":"\n<p>There are a few steps you should follow to move one or more of your MySQL databases from an existing web hosting company over to Pair Networks.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">1. Create an Empty Database at Pair Networks<\/h2>\n\n\n\n<p>You will need to create an empty database on your Pair Networks web hosting account before you can import your MySQL Database. Here are the simple steps to create a database on your Pair Networks web hosting account:<\/p>\n\n\n\n<p>Choose the tutorial that reflects your ACC interface type:&nbsp;<\/p>\n\n\n\n<ul>\n<li><a href=\"#if-you-are-using-the-legacy-interface\" data-type=\"internal\" data-id=\"#if-you-are-using-the-legacy-interface\">Legacy Interface<\/a><\/li>\n\n\n\n<li><a href=\"#if-you-are-using-the-new-acc-interface\">New ACC Interface<\/a><\/li>\n<\/ul>\n\n\n\n<p>Not sure what the difference is? See<a href=\"http:\/\/pair.com\/support\/kb\/which-acc-interface-am-i-using\/\"> Which ACC Interface Am I Using?\u00a0<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>If you are using the Legacy Interface:<\/strong><\/h3>\n\n\n\n<ol>\n<li>Log into the&nbsp;<a href=\"http:\/\/my.pair.com\">Account Control Center<\/a><\/li>\n\n\n\n<li>Select&nbsp;<strong>Database<\/strong><\/li>\n\n\n\n<li>Select&nbsp;<strong>Create New Database<\/strong><\/li>\n\n\n\n<li>Enter a database name into the&nbsp;<strong>Database Name<\/strong>&nbsp;field<\/li>\n\n\n\n<li>Select the access level using the&nbsp;<strong>Access Level<\/strong>&nbsp;drop-down menu<\/li>\n\n\n\n<li>Select the optimization period using the&nbsp;<strong>Optimization Period<\/strong>&nbsp;drop-down menu<\/li>\n\n\n\n<li>Click&nbsp;<strong>Add Database<\/strong><\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>If you are using the New ACC Interface:<\/strong><\/h3>\n\n\n\n<ol>\n<li>Log into the Account Control Center at <a href=\"https:\/\/my.pair.com\/\">my.pair.com<\/a><\/li>\n\n\n\n<li>In the top navigation bar, click <strong>Databases<\/strong><\/li>\n\n\n\n<li>Click the <strong>Create New Database<\/strong> button<\/li>\n\n\n\n<li>Enter a database name into the <strong>Database Name<\/strong> field<\/li>\n\n\n\n<li>Select the access level using the <strong>Access Level<\/strong> drop-down menu<\/li>\n\n\n\n<li>Select the optimization period using the <strong>Optimization Period<\/strong> drop-down menu<\/li>\n\n\n\n<li>Click <strong>Add Database<\/strong><\/li>\n<\/ol>\n\n\n\n<p>Take note of the information on the database creation success page. It is recommended that you save the page for future reference.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">2. Create a MySQL \"Dump File\" of Your Database<\/h2>\n\n\n\n<p>To move your database from your old web hosting company to Pair Networks, you will have to create what is called a \"dump file\" of your database. This is basically a copy of your database. Check with your old host on how this would work with their system. Generally, if you log into your hosting you run the following command in a terminal window, you will have created a \"dump file.\"<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqldump -Qq -hDBSERVER -uUSERNAME -p DATABASE_NAME &gt; backup.sql<\/code><\/pre>\n\n\n\n<p>Replace \"DBSERVER\" with the server name where the database currently resides. Replace \"USERNAME\" with your MySQL username, and replace \"DATABASE_NAME\" with the full name of the database. With most other web hosting companies, you can leave off the \"-hDBSERVER\" part, which will make the command default to what is known as the \"local host.\" Many other web hosting companies have databases running on the same server as the web hosting files.<\/p>\n\n\n\n<p>Please also note that when you run this command, you will be prompted for a password. Enter your MySQL database password at this point. Depending on the size of the database, the command may take up to several minutes to run.<\/p>\n\n\n\n<p>The command above will create a file named backup.sql in the current directory where the command was run. Run this command on your old Web hosting or database server. You will then need to upload this backup.sql file to your Pair Networks web hosting account (in your home directory).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">3. Upload the Dump File to Your New Web Hosting Account<\/h2>\n\n\n\n<p>Use FTP or SFTP to upload the backup.sql file to your Pair Networks web hosting server. After uploading the file, connect to the hosting server using SSH. After you are connected, you can transfer the contents of the backup.sql file into your new empty Pair Networks database by entering the following command in a terminal window:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -hDBSERVER -uUSERNAME -p DATABASE_NAME &lt; backup.sql<\/code><\/pre>\n\n\n\n<p>Replace \"DBSERVER\" with your Pair Networks database server name. Replace \"USERNAME\" with your Pair Networks MySQL username, and replace \"DATABASE_NAME\" with your new Pair Networks database name. Refer back to the Pair Networks database information page for this information.<\/p>\n\n\n\n<p>Please also note that when you run this command, you will be prompted for a password. Enter your MySQL database password at this point. Depending on the size of the database, the command may take up to several minutes to run.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>There are a few steps you should follow to move one or more of your MySQL databases from an existing web hosting company over to Pair Networks. 1. Create an Empty Database at Pair Networks You will need to create an empty database on your Pair Networks web hosting account&#8230;<\/p>\n","protected":false},"author":12,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[2],"ht-kb-tag":[186],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks<\/title>\n<meta name=\"description\" content=\"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.\" \/>\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.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks\" \/>\n<meta property=\"og:description\" content=\"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - Pair Networks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/pairnetworks\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-29T18:58:33+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@pairNetworks\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/\",\"name\":\"Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks\",\"isPartOf\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\"},\"datePublished\":\"2016-01-12T20:52:14+00:00\",\"dateModified\":\"2025-05-29T18:58:33+00:00\",\"description\":\"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pair.com\/support\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Moving Your MySQL Database to Pair Networks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#website\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"name\":\"Knowledge Base - Pair Networks\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#organization\",\"name\":\"Pair Networks\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"contentUrl\":\"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg\",\"width\":360,\"height\":360,\"caption\":\"Pair Networks\"},\"image\":{\"@id\":\"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/pairnetworks\/\",\"https:\/\/twitter.com\/pairNetworks\",\"https:\/\/www.instagram.com\/pairnetworks\/\",\"https:\/\/www.linkedin.com\/company\/2269676\/\",\"https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/\",\"https:\/\/www.youtube.com\/user\/pairnetworks\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks","description":"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.","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.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/","og_locale":"en_US","og_type":"article","og_title":"Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks","og_description":"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.","og_url":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/","og_site_name":"Knowledge Base - Pair Networks","article_publisher":"https:\/\/www.facebook.com\/pairnetworks\/","article_modified_time":"2025-05-29T18:58:33+00:00","twitter_card":"summary_large_image","twitter_site":"@pairNetworks","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/","url":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/","name":"Moving Your MySQL Database to Pair Networks - Knowledge Base - Pair Networks","isPartOf":{"@id":"https:\/\/www.pair.com\/support\/kb\/#website"},"datePublished":"2016-01-12T20:52:14+00:00","dateModified":"2025-05-29T18:58:33+00:00","description":"There are a few simple steps you should follow to move one or more of your MySQL databases from an existing Web hosting company over to pair Networks.","breadcrumb":{"@id":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pair.com\/support\/kb\/moving-your-mysql-database-to-pair-networks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pair.com\/support\/kb\/"},{"@type":"ListItem","position":2,"name":"Moving Your MySQL Database to Pair Networks"}]},{"@type":"WebSite","@id":"https:\/\/www.pair.com\/support\/kb\/#website","url":"https:\/\/www.pair.com\/support\/kb\/","name":"Knowledge Base - Pair Networks","description":"","publisher":{"@id":"https:\/\/www.pair.com\/support\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pair.com\/support\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.pair.com\/support\/kb\/#organization","name":"Pair Networks","url":"https:\/\/www.pair.com\/support\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","contentUrl":"https:\/\/www.pair.com\/support\/kb\/wp-content\/uploads\/2022\/02\/Gb_TUkUE_400x400.jpeg","width":360,"height":360,"caption":"Pair Networks"},"image":{"@id":"https:\/\/www.pair.com\/support\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/pairnetworks\/","https:\/\/twitter.com\/pairNetworks","https:\/\/www.instagram.com\/pairnetworks\/","https:\/\/www.linkedin.com\/company\/2269676\/","https:\/\/www.pinterest.com\/pairnetworksinc\/pins\/","https:\/\/www.youtube.com\/user\/pairnetworks"]}]}},"_links":{"self":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/14"}],"collection":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/comments?post=14"}],"version-history":[{"count":8,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/14\/revisions"}],"predecessor-version":[{"id":9821,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb\/14\/revisions\/9821"}],"wp:attachment":[{"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/media?parent=14"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=14"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.pair.com\/support\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=14"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}