OK, I know I should be searching through google, or looking at webmonkey, but I haven't found an answer yet...

I've just moved hosts and I need to upload my database to an empty database.

So I'm in phpmyadmin and i choose to browse file and go. But the thing always times out on me (it's a relatively large file...8mb?)

So, I'm forced to open up the file and copy and paste bits at a time...at this rate, it's gonna take about 10-20 hours =)

does anybody have any suggestions as to how I can improve this?

any time i try to copy and paste the whole database over... the phpmyadmin just times out (and pisses me off cuz it takes about 1/2 hour for me to find out)...and for the times that it doesn't, it takes about 1/2 hour just to comlete about 5-10% of my whole database, which is not too efficient.

thanks for the help and assistance ...

Do you have shell access on your new host?

if so you can just load the database with the following command:

mysql -u DB-USER -p DATABASE < DUMP-FILE

where:

DB-USER = database user name
DATABAE = database name
DUMP-FILE = the backup you're going to load

Frank

Unfortunately, no, I don't have shell access.

But, Dan @Serve-You has offered to help me set it up because it's just a big too big ...

Thanks!

Raine,

I just duplicated what you are trying without any problems.

What I did:

To extract-

1. Go to phpMyAdmin
2. Click on the db name so as to bring up the table listing
3. Scroll down to where it shows 'View dump (scheme) of database'
4. Select all the tables required by shift-clicking
5. Click on the 'Structure and Data' radio button
6. Tick the 'Send' box
7. Click the 'Go' button
...and save the results as 'whatever.sql' to your local hdd.

To load up new db-

1. Same as above
2. Same as above
3. Scroll down to where it shows 'Or Location of the textfile:'
4. Browse to where you save 'whatever.sql'
5. Click on the 'Go' button

Worked perfectly.

Help this helps.


Lats...