Move WordPress Database
My WordPress database was initially installed in a shared database with four other WordPress installations. 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 no changes are made while doing this.
In phpMyAdmin I selected the database, went to the export tab. Then I selected the tables that contained my WordPress installation, then export it to SQL format. I saved the exported database to my local hard drive. After the export, I 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.)
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.
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.
This should be able to be done in about thirty minutes.
After you have tested your installation and everything is working you can delete the old instance in the shared database. This is basically the same steps that you would use to move your WordPress to a new server.
Good luck 🙂
Links
Excellent post. Many thanks for sharing this resource. Thanks so much for everything you’ve put into it this blog has me coming back time and time again.
Thanks for such an excellent post and also the evaluation, I am completely impressed! Maintain stuff like this coming.
Shanta Hardrick Burrell – Hey Melissa,Don’t know if you remember us but Iliya and my dgethaur Morgan were good friends at the CDRC at UA. I was just looking at your site and can’t believe how much Iliya has grown. We will keep you and your family in our prayers and keep us posted about your new addition. Shanta Burrell
Posted on incredible, that was a very good read. In conclusion, someone who actually thinks and understands what they are blogging about. Quite difficult to find of late, especially on the web . I bookmarked your web blog and will make sure to keep coming back here if this is how you always write. thank you, keep it up! .
Writing is not a easy thing to do, it takes creativity and good sense, and you’ve got it!
You’re right!
This is perfect, I am looking to do something similar very soon and this article makes perfect sense.
Dear Krishnaji,Thank you very much for sending brief news about Ghandruk, it ctrnaiely has given us pleasure to know what is going on in Ghandruk.I was born and bred in Ghandruk but due to global migration, currently living in the global village in the UK. As such I am always endeavoring to keep myself up to date with the news and views about Ghandruk. The step you have taken is good for those people living abroad. If you would kindly send us such brief notes at least every six months would be great?Thank you so much.Warmest regards
I think the information on this subject is still very scarce at internet.
cupcake8million Posted on congrats- your living my dream since you won’t see your family/ friends for a long tie you could go cheesy- wish you were here or on the trail again or Where in the world is (your name)? Best of luck!
Your posts are always so explicative, and I like it because I have a problem in understanding such things.
Thanks a lot for sharing this. heard about something like this for the first time.
Nice information, many thanks to the author. It is incomprehensible to me now, but in general, the usefulness and significance is overwhelming. Thanks again and good luck!
The herd instinct among forecasters makes sheep resemble independent thinkers.
Like a small businessperson, you haven’t any greater leverage compared to truth.
Keep, up the good work, looking forward to reading your new material.
Very good most of your articles, many years of quality posts, I admire you in many things and I disagree in others, but still love your posts.
Your blog’s design is simple and clean and i like it. your blog posts are superb. Please keep them coming. greets!!!
Treat others how you want to be treated. It’s one of the best ways of showing respect. If you don’t treat others how you want to be treated, then they will treat you the way you don’t want to be treated or just walk away.
Thanks, I’ll need this information for my homework.
I’m really interested on this subject, gonna see your other posts, hope they are so good like this one.
hello James how i have to install the new site on daewmaerver cs5 cause i dont know what FTP server chose or the name and password and also i want to teach me how to make a free web hosting like the creare.co.uk on matrix linux please tell me i need.. mail me at the gmail : please James or Nick
Anna Posted on Wish I could have gone with you guys. I always want to look back at Hunter and then I almost fall over. Typical me LOVE these pictures of the ride.
Very nice blog.
Thanks sir for this i like it..
Nice this one is really cool!
Excellent article. very interesting to read. i really love to read such a nice article. Thanks! Keep rocking.
Krishna Sir,Namaskar. This is Narayan Singh Gurung from London. Thank you very very much for your detailed infirmatoon about Ghandruk. May we hope to hear from you the same in the days to come as well. Finally please extend my and my family’s regards to Dharma Shila madam and children.Bye for now.
I loved this text from you, helped me a lot. i am really grateful.
Thank you Krishna sir,We really apciaprete for your kind information regarding our beloved village. It has been always fantastic to hear news about our village in such a way,especially, in development sector. I am very much proud of you that you have been serving for our village for such a long prior of time.When I saw your face it remind me of my school age and all those stupid things that i used to do at that time. It just feels like yesterday, I feel young again like a boy. I do hope you also feel the same as me, don’t you sir? I have no doubt you have a huge connection with the school and village both emotionally and physically. I know you love the place same as any other villagers. Only one thing is different with compare to other is that you have been contributing with your highly respected qualification, dedication and honestly almost whole of your life.My heartfelt thanks to you for your hard work and showing such an enthusiasm towards our village and as well as school.We are very lucky to have such a generous teacher and proud of you.Your sincerelyEx student Arjun badmas danda ghar.PS it would be better if you could publish your e mail add so we can contact you personally in future.
e.l Posted on For one thing unless they’re published you mean writers’. Only you can decide when, as it needs to fit round you and your members’ schedules.
Love the site, very nice and meaningful, keep it up.
Very useful content. Thanks.