Mysql Db Import - Times Out

[Rednarb]

I'm trying to import a database backup in to a test database using MySQLAdmin however the import times out because it is too big.

 

Regardless, is there any way to import, or essentially copy a live database to a test one?

[TCH-Andy]

for large files the best is to upload the file to the server, and ask us to put it into the database for you via a ticket a the help desk.

[Rednarb]

I guess I'll have to try that however I was hoping to not have to rely on support. You see I want to set up a test database and will have to refresh it with live data on occasion.

 

I found in phpMyAdmin where you can copy a database to another but I always get access denied when phpMyAdmin tries to create a DB. Looks like the only way to create a DB is to use the mysql tool that's in Control Panel. However phpmyadmin won't copy a database to an existing one, it always tries to make a new one which fails of course.

[TCH-Andy]

You can update it yourself - and you should be able to import into phpMyAdmin, but it will start to fail when the database is a few MB (I've forgotten the exact limit - possibly a 4MB limit). If it's below that, you should be fine.

[Rednarb]

You can update it yourself - and you should be able to import into phpMyAdmin, but it will start to fail when the database is a few MB (I've forgotten the exact limit - possibly a 4MB limit). If it's below that, you should be fine.

 

The SQL export is about 60 MB so I guess I'm out of luck without support doing the upload for me.