mysql size problem

[tedivm]

I'm running the backup script and I noticed that it was taking a long time, so i checked the file sizes and they're huge.

Apparently one of the accounts has over a gig of databases according to cpanel, when looking at the databases there is less than a couple of megs.

How can I correct this?

 

[chirpy]

Are you saying that the physical size of the database is much larger that the data within the database? If so, then optimizing the database in phpmyadmin should help.

 

[jsilvestre]

Fix mysql quota

Dear tedivm,

try /scripts/updatemysqlquota and /scripts/fixquotas.

 

[chirpy]

You should not run /scripts/updatemysqlquota if you haven't run it previously and understand what it does and its implications or you could end up with corrupt databases and MySQL unable to start.

 

[TSJasonH]

Hi,

To expand a little bit more on what Chirpy is saying. If you begin running /scripts/updatemysqlquota suddenly, there's a very good chance that it can put previously OK accounts over their disk quota limit. When this happens mysql will be restricted from writing to their databases and/or
a) corrupt the database
b) lock-up your mysql server all together (and possibly your whole server depending on the defined mysql limits)

Both are quite bad and it's likely both would occur if you haven't been running the mysqlquotas script on a normal basis and closely monitoring the disk quotas for all your accounts.