Big Dump Review : How To Import Big Databases
I am by no means any expert on databases, MYSQL, or PHPMYADMIN. What I like is simplicity when it comes to moving my blogs and forums though, and I’ve never liked PHPMYADMIN way of doing things. I don’t like the way it exports or imports databases. Today was the first time I had a database so big it couldn’t be imported by my hosting company’s limitations in PHPMYADMIN. The hosting company in question is not the most supportive, but I won’t name any names. (It’s not the one this blog is hosted on!) I was really kinda ticked about that when I saw it wasn’t going to be the normal way of importing, but to PHPMYADMIN’s benefit, they listed a link to a free script that makes things much FASTER and EASIER. BigDump: Staggered MySQL Dump Importer It perfectly defines a common problem by stating that the script is for people who want to restore a very large backup of a mySQL database (or at least part of it) into a new or same mySQL database. Like most webmasters, you don’t have access to the server shell and phpMyAdmin won’t work due to the hard memory resp. runtime limit of the web server. I downloaded the script, edited it with my database info, chose the file and run it. Total time to import a large database : 5 minutes. When I import databases with PHPMYADMIN sometimes it can take 30 mintes. This script is a lifesaver and I’ll probably use it from now on for ALL database imports of reasonable size because it was so much faster than trying to use PHPMYADMIN. Two thumbs up BigDump! 
|
Subscribe to this blog's feed! |
One Customer Review of “Big Dump Review : How To Import Big Databases”
dan wrote on August 5, 2009
thanks I’ll have to check that out. I love PHPMyAdmin, but try anything written by someone who named one of their scripts “Big Dump”. Awesome, so funny..
Write a Review