Wordpress Transfer to new server issue

Hi,

I have read WP.org info on this and I still cannot get my site moved to my new server. I purchased a wp site and recieved the back up of it and the database. I installed WP and upload back and I either get cant install backup correctly (sql errors) or when i just upload all the files to the main DIR it says wordpress cannot connect to wp-config.php or database. I tried editing these to my new info and nada. I can get the wp to work but not the database. Any one know how to fix?

Thanks

 

A few questions:

1. Have you created the new database to hold your blog?
2. If you have created the database, are the details for username and password to it correctly specified in wp-config.php?
3. If the above are correct and have been done, have you restored the database from the backup of your old one using something like "phpmyadmin"?

 

Hi,

I created a DB for the for WP and tried to upload the old db and I had some issues, user names differ in wp-config then on the sever db.
I went to phpmyadmin and tried deleting the old db's and adding in the backup tags. Some of these worked i.e. the categories showup but not the post.

Thanks for you help and reply.

 

I am still not exactly sure of your process but here's how I'd do it.

1. Within my hosting account, use their facilities to create a new database. Taking note of special prefixes that most hosting companies would add to databases created this way.
2. Create the database user and assign it to the new database.
3. Go into the phpmyadmin interface, and click on "Import".
4. Select your saved backup file (usually with extension of ".sql.gz") and click "Go".
5. Make sure that all tables have been restored.
6. Modify the relevant sections in your "wp-config.php" file.

Hope this helps.

 

since I am new to WP, what part of wp-config should I change and what to, I bought this site from a DP member and Now its unusable to me. the domain name is the same but my login info is different then theres was on their server. I will start from scratch.

Thanks for you help.

 

If you are installing WP from scratch then you wouldn't need to touch the config file at all. In fact I would advise against it especially when you are new to WP.

But for future use, the parts of the "wp-config.php" file that you'd usually change if you doing server migration etc. are the following:

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

Code (markup):

 

Thanks for all the help, I figured it out lastnight somehow. Every time i would import the DB it would say already exsist and or user not allowed. I created the DB in phpmyadmin but removed all WP dbs and files before doing so. I then edited the DB file to not included create db 'db_name' so that it would only import the tags, if that makes sense. After a refresh all the old content showed up.Maybe not the correct way but I tried new install of WP, i tried jsut uplaod the files of the old site ( wp-config errors on this). Oh well its fixed now. sorry for long reply, but I appreciate your help!

Thanks alot
Jay

 

No worries mate! Glad it all worked out.

 

Thanks for the help though, =)