WordPress.org

Ready to get started?Download WordPress

Forums

Importing database files MyPHPAdmin (6 posts)

  1. vested1
    Member
    Posted 4 years ago #

    I am having problems pulling the terms_taxonomy and terms_relations tables back into a database using myphpadmin --- the options table doesn't want to cooperate either.. the comments, posts postmeta tables came back in ok.. is there a trick to this?

  2. henkholland
    Member
    Posted 4 years ago #

    Sorry, wrong answer.

  3. Robert S
    Member
    Posted 4 years ago #

    @vested1,

    What errors do you get/see and we might be able to help.

    R

  4. vested1
    Member
    Posted 4 years ago #

    I got it, I went into the original installation, turned off all the plugins, emptied the 24 megs of data marked spam (no idea why the person did/had not deleted the spam when it was marked) and then, instead of pasting it into the SQL editor, I used the upload/import tool (which I could because the size of the above were greatly reduced)

    Believe it or not, the first time I migrated this server for this person, this one blog had a database close to 189 megs (mostly saved spam) and at that time the original server was no longer available, I had to edit and run SQL statements chunks at a time to get it installed, I just cleaned it up again and that same database today, 2 and 1/2 years later is only 5.87 megs...

    I just thought I recalled Andrea mentioning this before as a "work-a-round"

    Instead of worry about adjusting the php.ini to handle whooping huge files via MyPHPAdmin (I normally use MySQL tools) I just brought the database in table at a time...

    Issue resolved... thanks

  5. Robert S
    Member
    Posted 4 years ago #

    @vested1,

    please mark topic as resolved.

    R

  6. abinesh
    Member
    Posted 4 years ago #

    Im having some trouble uploading a .sql file to myphpadmin. Im moving the wp site to a new server and the error message i get is below.

    --
    -- Database: localag1_wrd02
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table wp_ak_twitter
    --
    CREATE TABLE IF NOT EXISTS wp_ak_twitter (
    id int( 11 ) NOT NULL AUTO_INCREMENT ,
    tw_id varchar( 255 ) NOT NULL ,
    tw_text varchar( 255 ) NOT NULL ,
    tw_reply_username varchar( 255 ) DEFAULT NULL ,
    tw_reply_tweet varchar( 255 ) DEFAULT NULL ,
    tw_created_at datetime NOT NULL ,
    modified datetime NOT NULL ,
    PRIMARY KEY ( id ) ,
    UNIQUE KEY tw_id_unique ( tw_id )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =13;

    MySQL said: Documentation
    #1046 - No database selected

    HELP :S

Topic Closed

This topic has been closed to new replies.

About this Topic