Re: mysqldump of huge innodb database

2007-09-24 Thread Benjamin Schmidt
not possible cause of the huge size of the database. Hard-core copy of db-files causes a downtime of up to 8 hours so it would be possible. Or does somebody has another (hope better) solution? With best regards, Benjamin Schmidt Hartleigh Burton wrote: Hiya, I was backing up a 95GB

mysqldump of huge innodb database

2007-09-04 Thread Benjamin Schmidt
_stack = 128K query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 set-variable = max_connections=1000 max_allowed_packet = 64M ... As I wrote above, it worked this way a very long time. And it should work again ;) Does anyone know this problem or has an idea? Many thanks in adva