{"id":210,"date":"2012-01-19T17:40:21","date_gmt":"2012-01-20T00:40:21","guid":{"rendered":"http:\/\/www.wei-tek.com\/myblog\/?p=210"},"modified":"2015-12-21T22:30:42","modified_gmt":"2015-12-22T05:30:42","slug":"move-wordpress-database","status":"publish","type":"post","link":"https:\/\/blog.wei-tek.com\/?p=210","title":{"rendered":"Move WordPress Database"},"content":{"rendered":"

Move WordPress Database<\/h2>\n

\"Move<\/p>\n

My WordPress database was initially installed in a shared database with four other WordPress installations.\u00a0 I wanted to move my blog to its own database so that it would be easier to backup and restore.<\/p>\n

To Move WordPress Database, you need to place your WordPress into maintenance mode so\u00a0 no changes are made while doing this.<\/p>\n

In phpMyAdmin I selected the database, went to the export tab.\u00a0 Then I selected the tables that contained my WordPress installation, then export it to SQL\u00a0 format.\u00a0 I saved the exported database to my local hard drive. After the export,\u00a0I opened the exported file with Notepad++ I edited the database name and any paths, and save it as a new file. (Note – always keep plenty of backups.)<\/p>\n

After editing the file and verifying the changes. then open phpMyAdmin and create a new empty database. After creating the empty database, select the database and go to the import tab. Select the edited file and complete the import.<\/p>\n

In your WordPress installation rename the wp-config.php, then open your blog. The installation page will appear, complete the database connection information and save, this is all that is required to connect to the new database. Login as admin and turn off maintenance mode. Your blog should be up and running in the same state it was in before the migration, (except in it”s own database). If it does not work go back and check everything and repeat the steps.<\/p>\n

This should be able to be done in about thirty minutes.<\/p>\n

After you have tested your installation and everything is working you can delete the old instance in the shared database. \u00a0 This is basically the same steps that you would use to move your WordPress to\u00a0 a new server.<\/p>\n

 <\/p>\n

Good luck \ud83d\ude42<\/p>\n

Links<\/p>\n

Myphpadmin Home Page<\/a><\/p>\n

Mysql Home Page<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Move WordPress Database My WordPress database was initially installed in a shared database with four other WordPress installations.\u00a0 I wanted to move my blog to its own database so that it would be easier to backup and restore. To Move WordPress Database, you need to place your WordPress into maintenance mode so\u00a0 no changes are […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[49],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-sql-databases","tag-wordpress"],"yoast_head":"\nMove Wordpress from shared database - WEI-Tek Consulting Company Blog<\/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:\/\/blog.wei-tek.com\/?p=210\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Move Wordpress from shared database - WEI-Tek Consulting Company Blog\" \/>\n<meta property=\"og:description\" content=\"Move WordPress Database My WordPress database was initially installed in a shared database with four other WordPress installations.\u00a0 I wanted to move my blog to its own database so that it would be easier to backup and restore. To Move WordPress Database, you need to place your WordPress into maintenance mode so\u00a0 no changes are […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.wei-tek.com\/?p=210\" \/>\n<meta property=\"og:site_name\" content=\"WEI-Tek Consulting Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-01-20T00:40:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-12-22T05:30:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt\" \/>\n<meta name=\"author\" content=\"rainewalker\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rainewalker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\\\/\\\/blog.wei-tek.com\\\/?p=210#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210\"},\"author\":{\"name\":\"rainewalker\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\"},\"headline\":\"Move WordPress Database\",\"datePublished\":\"2012-01-20T00:40:21+00:00\",\"dateModified\":\"2015-12-22T05:30:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210\"},\"wordCount\":311,\"commentCount\":32,\"image\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/encrypted-tbn3.gstatic.com\\\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt\",\"keywords\":[\"WordPress\"],\"articleSection\":[\"SQL Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210\",\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210\",\"name\":\"Move Wordpress from shared database - WEI-Tek Consulting Company Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/encrypted-tbn3.gstatic.com\\\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt\",\"datePublished\":\"2012-01-20T00:40:21+00:00\",\"dateModified\":\"2015-12-22T05:30:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#primaryimage\",\"url\":\"https:\\\/\\\/encrypted-tbn3.gstatic.com\\\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt\",\"contentUrl\":\"https:\\\/\\\/encrypted-tbn3.gstatic.com\\\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/?p=210#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/blog.wei-tek.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Move WordPress Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#website\",\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/\",\"name\":\"WEI-Tek Consulting Blog\",\"description\":\"Tip, Tricks and Letting off steam\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.wei-tek.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.wei-tek.com\\\/#\\\/schema\\\/person\\\/57843d667045c1d2e92f6709b31826cc\",\"name\":\"rainewalker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g\",\"caption\":\"rainewalker\"},\"sameAs\":[\"http:\\\/\\\/www.my-businessmail.com\"],\"url\":\"https:\\\/\\\/blog.wei-tek.com\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Move Wordpress from shared database - WEI-Tek Consulting Company Blog","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:\/\/blog.wei-tek.com\/?p=210","og_locale":"en_US","og_type":"article","og_title":"Move Wordpress from shared database - WEI-Tek Consulting Company Blog","og_description":"Move WordPress Database My WordPress database was initially installed in a shared database with four other WordPress installations.\u00a0 I wanted to move my blog to its own database so that it would be easier to backup and restore. To Move WordPress Database, you need to place your WordPress into maintenance mode so\u00a0 no changes are […]","og_url":"https:\/\/blog.wei-tek.com\/?p=210","og_site_name":"WEI-Tek Consulting Blog","article_published_time":"2012-01-20T00:40:21+00:00","article_modified_time":"2015-12-22T05:30:42+00:00","og_image":[{"url":"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt","type":"","width":"","height":""}],"author":"rainewalker","twitter_misc":{"Written by":"rainewalker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.wei-tek.com\/?p=210#article","isPartOf":{"@id":"https:\/\/blog.wei-tek.com\/?p=210"},"author":{"name":"rainewalker","@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc"},"headline":"Move WordPress Database","datePublished":"2012-01-20T00:40:21+00:00","dateModified":"2015-12-22T05:30:42+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.wei-tek.com\/?p=210"},"wordCount":311,"commentCount":32,"image":{"@id":"https:\/\/blog.wei-tek.com\/?p=210#primaryimage"},"thumbnailUrl":"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt","keywords":["WordPress"],"articleSection":["SQL Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.wei-tek.com\/?p=210#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.wei-tek.com\/?p=210","url":"https:\/\/blog.wei-tek.com\/?p=210","name":"Move Wordpress from shared database - WEI-Tek Consulting Company Blog","isPartOf":{"@id":"https:\/\/blog.wei-tek.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.wei-tek.com\/?p=210#primaryimage"},"image":{"@id":"https:\/\/blog.wei-tek.com\/?p=210#primaryimage"},"thumbnailUrl":"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt","datePublished":"2012-01-20T00:40:21+00:00","dateModified":"2015-12-22T05:30:42+00:00","author":{"@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc"},"breadcrumb":{"@id":"https:\/\/blog.wei-tek.com\/?p=210#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.wei-tek.com\/?p=210"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.wei-tek.com\/?p=210#primaryimage","url":"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt","contentUrl":"https:\/\/encrypted-tbn3.gstatic.com\/images?q=tbn:ANd9GcT-wNBedyKzMdStN4YcUuyAgS2S_5S-J3YU2XzBxps-qlLIW_Mt"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.wei-tek.com\/?p=210#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.wei-tek.com\/"},{"@type":"ListItem","position":2,"name":"Move WordPress Database"}]},{"@type":"WebSite","@id":"https:\/\/blog.wei-tek.com\/#website","url":"https:\/\/blog.wei-tek.com\/","name":"WEI-Tek Consulting Blog","description":"Tip, Tricks and Letting off steam","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.wei-tek.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.wei-tek.com\/#\/schema\/person\/57843d667045c1d2e92f6709b31826cc","name":"rainewalker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4d680e5f042d634a22d17592d61565cd82ae4b89c745ba619c1d8e796fb79b89?s=96&d=identicon&r=g","caption":"rainewalker"},"sameAs":["http:\/\/www.my-businessmail.com"],"url":"https:\/\/blog.wei-tek.com\/?author=2"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2SXof-3o","_links":{"self":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=210"}],"version-history":[{"count":0,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=\/wp\/v2\/posts\/210\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.wei-tek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}