Restoring Database after moving to another server – problem
-
Hello guys. I am stuck with a problem and would love it if any of you guys could help me out with it.
Here’s the problem:
I wanted to develop (or modify) my theme to make it look better. So, I decided to back up the database (by exporting it) and did the same with my wordpress files.
After reading through numerous articles all across the internet, I learnt how to export it (and am pleased with myself for it )
On my Ubuntu Linux computer, I installed XAMPP (or LAMPP) and copied all the wordpress files to htdocs. Everything works till now.
But when I wanted to restore the database in phpmyAdmin, I get an error.
I am sure I followed all the right steps, but after I do that, I get an error.
It reads as follows:Error SQL query: -- -- Database: <code>b8_7529199_wordpress</code> -- -- -------------------------------------------------------- -- -- Table structure for table <code>wp_ak_popularity</code> -- CREATE TABLE IF NOT EXISTS <code>wp_ak_popularity</code> ( <code>post_id</code> int( 11 ) NOT NULL , <code>total</code> int( 11 ) NOT NULL , <code>feed_views</code> int( 11 ) NOT NULL , <code>home_views</code> int( 11 ) NOT NULL , <code>archive_views</code> int( 11 ) NOT NULL , <code>category_views</code> int( 11 ) NOT NULL , <code>single_views</code> int( 11 ) NOT NULL , <code>comments</code> int( 11 ) NOT NULL , <code>pingbacks</code> int( 11 ) NOT NULL , <code>trackbacks</code> int( 11 ) NOT NULL , <code>last_modified</code> datetime NOT NULL , KEY <code>post_id</code> ( <code>post_id</code> ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: #1046 - No database selected
This is the problem and I am unable to move any further with this. Will you please help me out?
Thanks a lot.
- The topic ‘Restoring Database after moving to another server – problem’ is closed to new replies.