Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well… arises for medium and large size databases – for databases below 100GB in size compression performance is usually not the problem (though backup impact on server…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…large data things in MySQL is patience and careful planning. Both of which relate two single property of large…Backup and restore will be faster but it can still take hours especially if database is already loaded. So operating wit such large databases…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… by people with traditional database background. Things are different with MySQL. There are many … for few seconds rather than giant 100GB table for few hours so can…It is also much easier to do backup and restore if you need only… more in my Why MySQL Could be slow with Large Tables article. 5. The…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… locks small table for few seconds rather than giant 100GB table > for few hours so can be done… queries. It is also much easier to do backup > and restore if you need only portion of… > Why MySQL Could be slow with Large Tables article. Deciding whether or not to let the database maintain referential…
Post: Wishes for mysqldump
May 22, 2007 By 19 Comments
… and recovery of large and partially corrupted database I’ve got couple of feature ideas for …backup needs. Dump each table in its own file This is much more convenient compared to single say 100GB…such table was not dumped successfully, wait for MySQL to complete restart and continue going with other…
