Your work is vital. We are raising funds to support it.
I am not strong with the command line. As such, I rely on PHPMyAdmin to get things done in MySQL quickly. One of the big problems with PHPMyAdmin are the import limitations and timeout issues. In my case, my host's implementation of PHPMyAdmin doesn't even include the import function. In my last post, on upgrading to D6, I described a situation where I really needed to import a database, that I had performed the update on my laptop.
I used PHPMyAdmin to export the database on my live site and plopped it on my desktop. I fired up MAMP and went to MySQL. I created a new database and granted all to a new user on the blank database. I *tried* to import my database--which currently is about 56--and had no joy. I increased the file size and timeout length, but that didn't help me out--I could only get two out of 88 tables to import.
I needed a different solution. In comes BigDump.
BigDump is a script that will take your MySQL database and stagger the import, handling very large MySQL files.
NonProfit Technology Consulting
Hi there!I also find PHPMyAdmin to be a convenient tool for getting things done in MySQL. It does have issues with import limitations and timeouts but I believe this can be solved using some type of partitioning or sharding that suits your needs. This is especially important, I think, when dealing with large and rapidly-growing databases. By implementing sharding or partitioning on your database, you can still use PHPMyAdmin - you just need multiple instances, each open on a specific shard.This way you can use your regular tools to run export/import commands, etc, but they will be handling smaller MySQL files that are easier to manage. I read up a bit about the BigDump solution you suggested, this seems useful when you are forced to handle such large files and have no other MySQL management options.In short - with partitioning, parallelism is used to partition your database by tables and even the tables themselves are partitioned, thus improving MySQL performance. Sharding is a form of partitioning in which you can assign dedicated network, memory and processing resources, creating independent database shards. to be sure which option is more suitable for you, here is an interesting comparison between MySQL sharding and partitioning, I found it insightful.Micky :)
I can enjoy society in a room; but out of doors, nature is company enough for me. ~William Hazlitt
Greetings my dearMy name is Basilia Jackson a lady from U.S, i saw your profile and become interested in knowing you please contact me in my email address as a friend firstname.lastname@example.org
Close this window