I've tried to play with db backup and restore but I am dealing with difficulties. This what I've done:
I backed up database using cPanel option and got 8MB large SQL file. Afterwards I installed new Wordpress in it's own new home. I accessed database associated with new installation of Wordpress through phpMyAdmin and dropped all the tables. Then I clicked on Import and choose to upload file from my Computer. After some time process reported it's success with over 200 queries executed. I checked the database and tables were really there with content as well.
Now when I tried to start my new WP instance with hope to get it populated with DB data I get a broken link error, like URL that I've entered doesn't even exist.
I tried to keep it simple so I changed new WP wp-config.php
to direct to an actual database(not backup) but then I get the old site run with page not found error.
Let me point that I installed new WP instance in existing WP installation folder. I placed it in a new folder of course called development
. That makes it:
example.com (being my live version) example.com/development (testing version)
So testing version works fine with default install but once I change it's config file to overwritten database it gets broken, or when I change it to use main database(example.com) I get Page not found error generated by Wordpress.
Hope all this makes sense. Any help appreciated.