Restore Wordpress from backup to new host?

[seedubya]

I'm doing a gratis job for a local health charity. Their web designer refused to give them admin access to the Wordpress site that he designed for them as they are leaving his VERY overpriced hosting (€600 per year just for hosting!) and I'm providing it FOC for them. The designer is being very difficult and refused to allow me access to install WPBackup which I use to backup and transfer sites with no re-config afterwards. All he'll give me is a SQL dump and the WP directory contents.

Can anyone point me to a method to restore from this without too much hassle? I'll need to test that it works so I'll restore it to a sub-directory on our dev hosting first and then transfer to their new account and then change the DNS.

 

[Mainstay]

http://codex.wordpress.org/Restoring_Your_Database_From_Backup

and then run some find / replace commands

Here are from my own notes:


Migrating Databases

1. On original host, load PHPmyAdmin and Export Database


On new host

1. Add WP install and create your username and password

2. On new server access phpMyAdmin

a. With the new database selected >> Import >> location of exported database >> type SQL >> Go

b. Copy wp-content from original host to new host (plugins, theme, and uploads)

c. Log into the new WordPress site >> Settings >> Permalinks >> Default >> Save Changes >> and then back to Custom Structure >> /%category%/%postname%/

>> Save Changes

RUN:


UPDATE wp_options SET option_value = replace(option_value, 'old site url and subdirectory', 'new site url and subdirectory') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'old site url and subdirectory','new site url and subdirectory');

UPDATE wp_posts SET post_content = replace(post_content, 'old site url and subdirectory', 'new site url and subdirectory');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://olddomain.com','http://newdomain.com');

 

[TenYardFight]

Sql dump and wp directory is all you need! Mainstays instructions are perfect.

 

[seedubya]

Mainstay, thank you very much for the assistance. I will try this tonight.

 

[Markverhyden]

Not sure of the contractual arrangements but most likely the website is their property so that could be considered theft. Have they been told that a police report will be filed? At any rate, if it's as easy as @Mainstay says, I'd just do that but still, at least, file the complaint.

 

[TenYardFight]

This has been brought up before. It is possible that the site is not owned by the end user. It's possible that the end user paid close to nothing up front, and the large annual costs are meant to pay for the initial development of the site. Say, over 3 years. This is a valid business model, if that's what is going on.

So many people here marvel at the huge hosting costs associated with a site they are taking over, when they don't know the initial contract. They also don't know what "HOSTING" includes. Godaddy will host your site for $5, but if I am going to answer the phone 24/7, back it up every day, store those backups, update plugins, update wordpress. Troubleshoot spam, troubleshoot DDOS attacks, help administer the firewall, etc, etc, etc...I want 50 to 100 bucks a month. By the way...tell your insurance company you host websites. Rate just went up. (Rant over)

...and when the new guy wants to move the site, he gets cpanel creds. If he can't do what he needs to do using cpanel creds, my assistance in training him is billable...

At any rate, the developer offered the SQLDUMP and WP content, so I doubt he sees it as theft.