WordPress.org

1. aelfa
   Member
   Posted 5 years ago #

   Hostmysite.com has a one-click WordPress installation, but the database it generates is not accessible through myphpadmin. I can, using hostmysite's web interface, create a new database that I can manage w/ myphpadmin. (They keep their blog databases more locked down.) I'd like my blog to point to the new, more accessible, database. I have more than 400 posts.

   Do you think this will work?

   1)Backup existing database
   2)Create new database
   3)Import all fields from the backup file to the new database
   4)Change wp-config.php to reflect the new database and password

   I want to keep the same WP installation, just point it to a new database. The host, domain, etc. will all stay the same.

   I'm pretty new w/ WordPress. Should this work, or am I missing something?

   Any thoughts?

   Thanks!

   Jessica

2. moshu
   Member
   Posted 5 years ago #

   My only question is: if you cannot access your original DB via phpMyadmin - how will you do a backup?

3. aelfa
   Member
   Posted 5 years ago #

   I can back it up through that wonderful WordPress plug-in.

4. moshu
   Member
   Posted 5 years ago #

   Oh, I never use, so I always forget about it :)
   Well, try it, keep a backup copy... and proceed as per the instructions:
   http://codex.wordpress.org/Backing_Up_Your_Database
   (there is also a section about the restore process)

5. aelfa
   Member
   Posted 5 years ago #

   Thanks! I'll give it a shot and let folks know if it works.

6. aelfa
   Member
   Posted 5 years ago #

   It does work to export from the old database and import to the new. You just need to change is the wp-config.php settings to point to the new database. I'm running into issues in two areas, however. Somewhere along the way, the collation is changed on the database tables, so some characters aren't represented correctly in the new database. It also broke some plug-ins, such as the tag cloud widget for Ultimate Tag Warrior. I'll work on these issues, but the process I outlined above works.

7. moshu
   Member
   Posted 5 years ago #

   the collation is changed on the database tables
   You should make sure the collation/encoding is the same on the old and new DB.

   (no idea about the other issue - I don't use it)

Topic Closed

This topic has been closed to new replies.