Title: Importing database files MyPHPAdmin
Last modified: August 19, 2016

---

# Importing database files MyPHPAdmin

 *  [vested1](https://wordpress.org/support/users/vested1/)
 * (@vested1)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/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)

 *  [henkholland](https://wordpress.org/support/users/henkholland/)
 * (@henkholland)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1331662)
 * Sorry, wrong answer.
 *  [Robert S](https://wordpress.org/support/users/rschilt/)
 * (@rschilt)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1331672)
 * [@vested1](https://wordpress.org/support/users/vested1/),
 * What errors do you get/see and we might be able to help.
 * R
 *  Thread Starter [vested1](https://wordpress.org/support/users/vested1/)
 * (@vested1)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1331791)
 * 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
 *  [Robert S](https://wordpress.org/support/users/rschilt/)
 * (@rschilt)
 * [16 years, 4 months ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1331818)
 * [@vested1](https://wordpress.org/support/users/vested1/),
 * please mark topic as resolved.
 * R
 *  [abinesh](https://wordpress.org/support/users/abinesh/)
 * (@abinesh)
 * [16 years, 1 month ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1332024)
 * 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

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Importing database files MyPHPAdmin’ is closed to new replies.

## Tags

 * [?s=](https://wordpress.org/support/topic-tag/s/)
 * [myphpadmin](https://wordpress.org/support/topic-tag/myphpadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 4 participants
 * Last reply from: [abinesh](https://wordpress.org/support/users/abinesh/)
 * Last activity: [16 years, 1 month ago](https://wordpress.org/support/topic/importing-database-files-myphpadmin/#post-1332024)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics