tedivm

Member
Aug 30, 2006
10
0
151
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

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,465
30
473
Go on, have a guess
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

Member
Jul 7, 2005
24
0
151
Fix mysql quota

Dear tedivm,

try /scripts/updatemysqlquota and /scripts/fixquotas.
 

chirpy

Well-Known Member
Verifed Vendor
Jun 15, 2002
13,465
30
473
Go on, have a guess
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

Active Member
PartnerNOC
Nov 25, 2003
34
0
156
Chicago, IL
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.
 
Thread starter Similar threads Forum Replies Date
L Databases 3
psytanium Databases 7
T Databases 3
K Databases 1
S Databases 0