CODEWITHSUNDEEP
phpmysqlwordpress
cloe
cloe

Reputation: 51

Connect WordPress website to remote MySQL database?

I have a WordPress website hosted on GoDaddy and obviously the website content is stored on WordPress's MySQL. Now I want to change this database to my remote MySQL database. Is it possible to get the whole script of WordPress database (all tables with stored content) and run it on my remote database? Then I change the connection string from wp-config.php by providing my remote database details.

Would this procedure work and will my work done remain available?

Upvotes: 2

Views: 8910

Answers (3)

Lajos Arpad
Lajos Arpad

Reputation: 76434

By exporting the database and importing into the other location you cannot possibly ruin anything, so don't be afraid, just export the data, import it where it is needed and change your configuration. Do not be afraid to try out things when you cannot ruin anything.

Upvotes: 0

Greg L
Greg L

Reputation: 468

This is built into wordpress.
Just login to wordpress, go to tools > export. Select all content, and save the file.
Then locally, click tools > Import.

Upvotes: 0

Nathan Dawson
Nathan Dawson

Reputation: 19308

Yes, this wouldn't be a problem. Go into phpMyAdmin in your control panel and export the database. Import it into your remote DB. Then update wp-config.php with your remote DB details.

Upvotes: 1

Related Questions