WordPress.org

1. moisie
   Member
   Posted 8 years ago #
   

   The easiest solution is to set them up using the same database.

2. shirasade
   Member
   Posted 8 years ago #
   

   Is there a way to copy the data from one database to another? Maybe using phpMyAdmin? I really don't know anything about mysql...

3. davidchait
   Member
   Posted 8 years ago #
   

   You certainly should be able to export tables and re-import them into the other db.
   However, you should be able to use multiple DBs, so long as all the WP code, and the third party code, make proper calls to the mysql interfaces passing the database handle to be accessed. If the handle isn't provided, mysql calls default to the last-opened db (I think), thus the sql error you are seeing would lead me to believe you have uncovered something in WP (or a plugin) that isn't doing db calls 'correctly'.
   -d

4. shirasade
   Member
   Posted 8 years ago #
   

   It definitely looks as if it's just calling on the last-opened db... Strange that no one noticed that before me! Being the amateur that I am, I guess I'll have to do the db switch - it probably won't be easy to fix the error otherwise.
   Thanks a lot for the help, though!

Topic Closed

This topic has been closed to new replies.