Importing database files MyPHPAdmin

Sorry, wrong answer.

@vested1,

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

R

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

@vested1,

please mark topic as resolved.

R

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