Rednarb Posted March 6, 2007 Posted March 6, 2007 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? Quote
TCH-Andy Posted March 6, 2007 Posted March 6, 2007 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. Quote
Rednarb Posted March 6, 2007 Author Posted March 6, 2007 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. Quote
TCH-Andy Posted March 6, 2007 Posted March 6, 2007 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. Quote
Rednarb Posted March 6, 2007 Author Posted March 6, 2007 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. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.