Hello Mike, I hope the weather is nice where you are currently located. Take a deep breath and we'll get you sorted out :)
Okay, let's start by getting some details.
1) Before downloading the site from your back end, did you go to Settings > General and change the URLs to the live server? If so, good.
2) As indicated, your client has a mySQL database set up. However, did you export the tables from your database and import them into theirs?
Mike, you sound like you know what you're doing, but at the risk of telling you something you may already know, this is the step by step process I follow when moving WordPress.
Step 1: Log into the backend of the demo site. Go to Settings > General and change the URLs to where your site is going to be located.
(Note: be sure that the URLs are correct as once you press Save Changes, the site will be out of action.)
Step 2: Via FTP, download your entire WordPress site to your computer.
Step 3: Log into your hosting cPanel. Depending on your host, you're either going to find your mySQL database and then click something to the extent of, "Edit in phpMyAdmin", or you're going to log into phpMyAdmin and select your database from the left hand pane.
With your database selected, click the export tab. Make sure these are the defaults.
- All tables selected
- radial SQL button selected
Options > Structure section:
- Structure selected
- Add AUTO_INCREMENT value selected
- Enclose table and field names with backquotes selected
Options > Data section:
- Data selected
- Use hexadecimal for BLOB selected
At the bottom, select Save as File, name the file name template whatever you'd like, and use no compression.
Step 4: Time to set up a database on your clients server. Once it's set up, get into their phpMyAdmin for the database and go to the import tab.
Select the sql file from your hard drive and press Go.
Step 5: In the downloaded copy of their site, edit the wp-config file. Edit the DB_NAME, DB_USER, DB_PASSWORD, and DB_HOST to match the clients database.
Step 6: Upload the site to your clients' server via FTP.
Also upload this file: http://interconnectit.com/products/search-and-replace-for-wordpress-databases/ You need it do update all the URLs in the database pointing at your old server.
Once uploaded, go to example.com/search-and-replace.php (or whatever you name the file) and go through the steps. It will read the wp-config file and automatically know what database you're trying to deal with. Go through the steps, have all the tables selected, and when it asks what you want it to search, put your demo server's url (reshwatercreative.com/backerauto). Do not add any unnecessary characters like the slash at the end or the http. Replace it with the new url (backerauto.com).
Once done, delete the search and replace file and you should be done!
(Note the search and replace won't find any direct references in your theme files. So if you direct linked something in your header.php file, you'll need to update that manually.)
Common issues I come across:
All pages other than home in the nav lead to a 404.
- Go to Settings > permalinks and put it back to default, press save, then put it to your preferred setting.
Still some references back to the old server.
- Remember the search and replace was only for the database. If you've edited theme files with full urls, you'll need to update those. I recommend using some kind of text editor that has a "find", and "replace all" option.
Site has elements from the old site.
-Empty your browsers cache, cookies, and history.
Good luck Mike, I hope this helps! :)