Wordpress - How do I revert Wordpress page URL edit without FTP & MySQL access?

Question:

Huge mistake, but I cloned my Wordpress site to go debugging and in doing so I changed the page-URL on the actual site. When I opened the clone/wp-admin, it redirected to the actual site where I changed the page-URL into the clone URL. Now both the clone and actual site redirect to the clone domain.

I don't have MySQL and FTP access to the actual site & server. I was sent the files and MySQL.zip to test.

The problem is, is that the site has to go back on a.s.a.p, but our development agency is currently sleeping. Therefor I'm hoping to find a solution in the mean time.

-

I have the official MySQL login, but it's protected behind a cPanel login layer which I cannot access. I can't find a way to sneak past it, so I can't access MySQL..

Who has any idea?

Answer:

Step 1 Change all the urls back to the live site.

Step 2 reinstall wordpress for the clone ( it can just be vanilla wordpress without the live sites DB ).

Step 3 install wp-sync-db plugin on both sites. https://github.com/wp-sync-db/wp-sync-db

Step 4 use wp-sync-db to push the database from the "live site" instance to the "development/testing site instance" you will have to collect the private key from wp-sync-db on the test site and use that to push the DB from the live environment to testing.

-- Very important that you push From live to your Clone/testing/dev enviroment.

You should now a easy path for migrating database back and forth via wp-sync-db. Ofcourse to maintain file synchronization use your favorite ftp solution.

WP-Sync-Db will handle all of the sql queries necessary to for you.