Importing & Exporting large scaled Databases using MySQL dumper
For your information, there are different kinds of Database structures over the internet such as Oracle, Microsoft SQL Server, MySQL.. etc. Now we’re discussing here; about MySQL which can be run through phpMyAdmin. It is actually an open-source tool written on PHP intended to handle the administration of MySQL with a use of a web-browser.
In this post, We’re discussing about a common issue, where most of the users come across while importing large scaled Databases. When importing database on phpMyAdmin, limitation plays the major role. Also, phpMyAdmin does not have a proper import procedure. But currently, user can import a database by pasting the SQL statements in a form and clicking submit, or by uploading an SQL file through the web-browser. Now that’s all well and good, but there are some problems which can occur such as follows;
- First is timeouts. Of these there are two kinds, which can be browser timeouts and server timeouts.
- The second problem is the file size. File limit, which you don’t often read about, is the phpMyAdmin configuration limit.
phpMyAdmin has a limit in their configuration file that limits the actual number of SQL commands which can be executed. Simply, if your database goes beyond this, then you’re out of luck.
Or else, you could install your own version of phpMyAdmin on the server and configure it as you like. If this works for you, that’s great. But if your problem is also one of those mentioned above, then again, you’re out of luck.
What else can I do;
Well, you can simply hire a better server by spending more money. A better server which gives you access to shell commands where you can perform “MySQL” queries on the command prompt.
Oh! wait, there’s another problem which raise-up & say; “how am I going to import a GZipped file or any other unsupported formats using this method.. Gosh! that would be another hectic one where you need to contact your host-providers support, then e-mail them to import & request them to upload on to the host or else; you upload it on the host root/directory and informing them the location where you actually uploaded.. blah! blah!..? Really, that’s insane & annoying, isn’t it?
As I previously said; host your own server, where you can control everything… Pretty simple..
Enough said! So what do the rest of us do?
Here’s the solution;
You can simply use a Database dumping tool to solve the problem. It actually works without any hesitation. I found this amazing tool called “MySQLDumper“, which is a PHP and Perl based tool for backing up, restoring MySQL databases. Check below video log to get more knowledge on how to use this dumper;
[box] More Tools: MySQLDumper, BigDump [/box]