• Resolved 1995ad

    (@1995ad)


    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter 1995ad

    (@1995ad)

    As you would have noticed, I am using WP-Popularity plugin. Is there any way which I can remove it?

    Thread Starter 1995ad

    (@1995ad)

    I resolved the problem. I had forgotten to select the database before importing. Foolish of me ??

    Thanks for nothing!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Restoring Database after moving to another server – problem’ is closed to new replies.