Support » Fixing WordPress » Importing database files MyPHPAdmin

  • 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?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Sorry, wrong answer.


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


    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


    please mark topic as resolved.


    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 )

    MySQL said: Documentation
    #1046 – No database selected

    HELP :S

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Importing database files MyPHPAdmin’ is closed to new replies.