Most of the mysql-admins out there will know phpmyadmin as a very helpful and reliable database administration tool. It’s available in most linux distros, can easily be installed and is for sure a very nice tool. Today I stumbled upon an alternative mysql administration-tool driven by php called chive.
From the project-website you can quickly see, that it already has a vast feature list and doesn’t need to hide after phpmyadmin.
My first impression is absolutely great and i think this tool can drain off phpmyadmin one day, but that’s of course a very subjective opinion.
More screenshots can be found here: http://www.chive-project.com/Screenshots
Today i tried to insert data to a mysql-database from a sql-dump with phpmyadmin. Although the dumpfile was not so big (1,8M) i got a timeout after about 30 secondes each time I tried it. This timeout is often by webhosters in their PHP installation.
The problem is that the customer (me in this case) is not able to increase this value 🙁 So what to do?
After googling a bit I found the solution: It’s called Bigdump! Wow!!! 🙂
A simple php-script which does all the work for you. Upload this script and the dump via FTP to the webspace and modify all the needed and well documented parameters in bigdump.php (databaseuser, pw, hostname,..)Fire up your browser and go to the location where you put the file and start the import of the data. As the script doesn’t try to insert all data with one single request and instead does more smaller requests by refreshing itself after some time, the PHP timeout will not be reached!