Wordpress SQL help

[AHarvey]

Hi all,

Our work webserver can only host 3 SQL databases.

We created TEAM1 as a forum for team 1, then we created TEAM1WP for use for a wordpress systems for team 1. Team 2 got jealous so I figured out I could create a TEAM2 database and host both the forum and wordpress files on it.

So, all my databases are used up and team 3 have decided they want the same thing. My only solution is to take TEAM1 and TEAM1WP and merge them. I have exported the tables from TEAM1WP, zipped them, and imported into TEAM1.

Now, this is the problem, I am not moving that actual wordpress files, just the tables. Anyone know how to point the original wordpress files towards another database?

 

[Dolph]

You should just be able to edit in in the wordpress config file,

Look for the following (won't look exactly like this because it will have values in it already)

define('DB_NAME', 'putyourdbnamehere');    // The name of the database
define('DB_USER', 'usernamehere');     // Your MySQL username
define('DB_PASSWORD', 'yourpasswordhere'); // ...and password
define('DB_HOST', 'localhost');    // 99% chance you won't need to change this value

You'll be looking to change the first one, and the username and password as appropriate (it's unlikely you'll need to change the last)

If you've just imported the tables fully, the tableprefix should remain the same.

 

[AHarvey]

Thanks

I'd already tried it but it hadn't worked, but after you saying that's the way I went back and retried. Realised that I was missing one uppercase letter :S

always the way

thanks again