How to upload a database larger than 10mb on Media Temple

I recently had the task of uploading a database to my hosting account with Media Temple. Media Temple has a 10mb limit for uploading from phpMyAdmin, so in order to use a larger database, a tiny bit of code is required. This is how you do it…

1. Export your database from phpMyAdmin
2. Upload the exported database.sql file to the html directory of the site you are working on in your Media Temple account.
3. Open PuTTy and enter the IP address from your Media Temple account.
4. Enter username (e.g. serveradmin@yourdomain.com)
5. Enter password (you won’t see the password as you type it due to a security feature)
6. Go to the folder where you uploaded the database.sql file earlier in step 2 by typing cd /home/#####/domains/yourdomain.com/html/ (##### is the number assigned to your database account)
7. Enter the command that will populate the new database by typing mysql –u db##### –p db#####_newdatabasenameonlynosqlextension –h internal-db.s#####.gridserver.com < databaseimportingfrom.sql

And that’s it. Log-in to your account and open the phpMyAdmin to view your populated database.

About the Author

Michael is owner/operator of The Graphic Design Shop, which he started after graduating from the Savannah College of Art and Design in 2000. Michael is a fan of all things creative and lives by the motto "We Don't Just Talk About It!".

Visit Michael Krapf's Website♦Visit Michael Krapf on Twitter♦Subscribe