Jump to content

Mysql Db Import - Times Out


Rednarb
 Share

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...