Restorey MySQL db, size limit


#1

Hi. I am trying to restore a MySQL database backup that exceeds the size limit indicated on the Import page of phpMyAdmin, which says the max is 10,240 KiB.

I’ve looked in the MySQL and phpMyAdmin help, but to be honest, most of what it says is pretty over my head.

I’m hoping there’s some easy way to do this. What good is an exported backup that can be imported back?

Thanks!


#2

When you have a database backup that is too big for phpMyAdmin you can handle the import using the command line from the Linux shell.

Once again, the DreamHost wiki is your friend, and these two articles discuss how to do this:

http://wiki.dreamhost.com/Restore_SQL_backup
http://wiki.dreamhost.com/Migrate_MySQL

Before using the methods described on either of these pages, you will need to make sure you have a shell enabled user, and have a basic understanding of how to get around using the shell.

It really isn’t hard to learn, and this is exactly the kind of task that is often a new user’s first introduction to the shell, so don’t be afraid to jump in and give it a try. :slight_smile:

–rlparker
–DreamHost Tech Support


#3

Belated thanks for this reply!

And a Happy New Year to you and all!