Re: Estimate mysqldump size

2018-11-28 Thread Olivier
Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have found: >> >> mysql -s -u root -e "SELECT SUM(data

Re: Estimate mysqldump size

2018-11-28 Thread Olivier
Ronan McGlue writes: > Hi Olivier, > > On 28/11/2018 8:00 pm, Olivier wrote: >> Hello, >> >> Is there a way that gives an estimate of the size of a mysqldump such a >> way that it would always be larger than the real size? >> >> So far, I have found: >> >> mysql -s -u root -e "SELECT SUM(data

Re: Estimate mysqldump size

2018-11-28 Thread Reindl Harald
Am 28.11.18 um 10:00 schrieb Olivier: > Is there a way that gives an estimate of the size of a mysqldump such a > way that it would always be larger than the real size? keep in mind that a dump has tons of sql statements not existing that way in the data -- MySQL General Mailing List For list

Re: Estimate mysqldump size

2018-11-28 Thread Ronan McGlue
Hi Olivier, On 28/11/2018 8:00 pm, Olivier wrote: Hello, Is there a way that gives an estimate of the size of a mysqldump such a way that it would always be larger than the real size? So far, I have found: mysql -s -u root -e "SELECT SUM(data_length) Data_BB FROM information_schema