We decided to build a new test site for development of our production site, lifering.org. We chose to do this on a new hosting company, using a new domain, lsrtesting.com. Lifering.org is hosted on a virtual host at GoDaddy; lsrtesting.com is on shared hosting at Siteground.
Lifering.org uses the Chapelco theme from RocketThemes.com.
I've copied this site before, about 3 years ago. I moved the files, took a database copy, created a new mySQL database and user on the new site, and did a search-and-replace on the URLs in the database, which is 64MB (it's a big, old site; the blog probably goes back 10 years). I very carefully changed everything but the domains in email addresses. When I tried to bring up the site, it wouldn't display properly and I couldn't log in.
On Siteground's advice I then uploaded a new database that hadn't had the URLs changed and added these 2 lines to the theme's function.php; but it hasn't helped:
update_option( 'siteurl', 'http://lsrtesting.com' );
update_option( 'home', 'http://lsrtesting.com' );
Home page now displays correctly but I still can't log in, http://lsrtesting.com/wp-admin redirects to http://lsrtesting.com/rcp/rcp-login/ and produces a 404. http://lsrtesting.com/wp-login also redirects and 404s.
I created a copy of this site about 3 years ago and didn't have these problems (I had a different set!), but at that time we were using a basic WordPress theme, not the very complex RocketTheme theme. I'll open a ticket with RocketPress, too, but if someone can suggest what I'm doing wrong I'd be very grateful. I've reviewed the codex instructions on updating the database for a URL change, but frankly the instructions for that script that it recommends scare me.
Do I need to edit the database and change all the URLs for this move, or not? The base path changed radically from the old site (/var/www/vhosts/lifering.org) to the new site (/home/lsrtesti/lsrtesting.com), and I specifically changed that the first time, but it didn't seem to help.
I have access to the cPanel, and to the database via phpMyAdmin, but I can't log into WordPress.
would I be better off doing a clean WordPress install and then loading the site copy over it??