Transfer Database Issue
Permalink
I am transferring my clients' sites to a new server. I have followed the instructions on how to do this exactly, but I am getting a "Unable to connect to database" error.
I have tried editing the config/site.php file, but this has not worked.
I should mention also that the domain is NOT currently set to point to the new server (I wish to do this after the transfer is successful).
When I imported the database, everything went smoothly with no errors.
Any ideas what is happening?
I have tried editing the config/site.php file, but this has not worked.
I should mention also that the domain is NOT currently set to point to the new server (I wish to do this after the transfer is successful).
When I imported the database, everything went smoothly with no errors.
Any ideas what is happening?
You shouldn't import the data by exporting all tables through phpMyAdmin. In the process you will overwrite the tables that were created for the new wordpress installation, with its own values for options such as siteurl, bloginfo etc.
So re-install Wordpress on the new server, to start again clean. Don't overwrite the tables it auto-generates.
Login to your development wordpress dashboard, go to Tools > Export and select all content, including all linked files. Go to new Wordpress, go to tools > Import, select Wordpress, install the plugin, choose the file you exported and you should be all set.
You will need to update some URL's that might not get updated within your posts/pages. You might also need to update catid's in your code, as the imported categories will get assigned new values.
So re-install Wordpress on the new server, to start again clean. Don't overwrite the tables it auto-generates.
Login to your development wordpress dashboard, go to Tools > Export and select all content, including all linked files. Go to new Wordpress, go to tools > Import, select Wordpress, install the plugin, choose the file you exported and you should be all set.
You will need to update some URL's that might not get updated within your posts/pages. You might also need to update catid's in your code, as the imported categories will get assigned new values.
Just curious Growthcurve,
I'm assuming that you are using a different site name then and will change it to the legacy site's name once tested?
And: @ LeeLondon: IMHO it isn't appropriate to join a Concrete5 forum to troll for your WordPress business.
Bad form.
I'm assuming that you are using a different site name then and will change it to the legacy site's name once tested?
And: @ LeeLondon: IMHO it isn't appropriate to join a Concrete5 forum to troll for your WordPress business.
Bad form.
OMG I'm such an idiot! I was using the OLD password for the site.php file, not the new one. Everything works perfect now! Transfer successful! Yaay!
lol :)
congratulations... (its nice to see I'm not the only one that's done that)
congratulations... (its nice to see I'm not the only one that's done that)
So re-install Wordpress on the new server, to start again clean. Don't overwrite the tables it auto-generates.
Login to your development wordpress dashboard, go to Tools > Export and select all content, including all linked files. Go to new Wordpress, go to tools > Import, select Wordpress, install the plugin, choose the file you exported and you should be all set.
You will need to update some URL's that might not get updated within your posts/pages. You might also need to update catid's in your code, as the imported categories will get assigned new values.