Dev Site:
– export database using phpMyAdmin or whatever db tool you use
– ZIP up the contents of the site folder
Client Site:
– create new, empty db and import into it the .sql file you exported from the dev site
– edit the siteurl and home fields of the wp_options table with the client site URL (http://www.elliswealthmanagement.net)
– upload the ZIP file created above to the root of the hosting account if this is the main (only) site on the account, and unZIP it there
– edit the wp-config.php file which is now on the Client Site with the Client Site db credentials
– log into the client site WP dashboard and install and run this plugin:
http://wordpress.org/plugins/velvet-blues-update-urls/
— select all options EXCEPT the last one (GUID)
– upload and run this script:
https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
– go to Setting > Permalinks and just re-save
– done 🙂 … takes about 5 minutes if you have done it “once or twice” 🙂
…or …
Use this plugin:
http://wordpress.org/plugins/duplicator/
But then you really don’t know what’s going on behind the scenes (it basically “automates” the described process).
The duplicator plugin, will this work though if I am midway through the process.
The problem is now if you go to my client site
elliswealthmanagement.net
it look like the theme got imported but none of my images or media did. It took FOREVER for me to transfer the 9000 something files and I believe the process got interrupted when I was using my FTP.
I don’t know if I should delete all the files from my client site and start over.
Also, not sure what to do once I zip the .sql file. Do I go into phpMyAdmin on my clients database? This is where I get lost with the backups.
This is the error I get when I try to upload the backup of the site that I created on my domain.
“#1044 – Access denied for user ‘920081_ellisw’ to database ‘883535_elliswealth’ ”
‘I was having the same problem. that’s why I shifted one of my website( http://www.happynewyear2015wishes.com ) to another platform.But one of my friend helped me to get that problem resolved. now I am satisfied with the wordpress platform. will get back to you after asking my friend about the same problem’.
@crfrankenbery – looks as though you got it sorted 🙂
Nice looking site.
Please mark this topic as resolved.
yes!
Finally figured it out!
So initially when I backed up my old site for whatever reason I couldn’t import it into my new database. Did the good old troubleshooting step of starting over and BOOM — got it imported.
However somehow (and I still am unsure why) I misspelled my site (…) so whenever I clicked to another link, it gave me an error.
I ended up searching for my misspelling in phpMyAdmin and found it in wp_options and now it’s live.
Woohoo! (I screamed out loud when I got it fixed)
Good luck to any other beginners! I consider myself pretty experienced with HTML/css and troubleshooting (I’m a mobile technician) but could not figure this out for the life of me!
After I backup up my initial site I renamed it to my clients database name (XXXXX_client format) and then I used the online search and replace tool to get it working btw.
