Re: database has run out of space

[Phil Hildebrand]

That's not really the kind of partitioning this forum is for, but most likely you have logs getting too big if it's /var and you have a typical 'nix system.

could be a couple things:

If your mysql home is in /var, you can shutdown mysql, copy everything to some other directory/partition, and create a soft link to the new location

If your query joins are too big and your are sorting to disk, it could be that your sort area is in /var, ( mysql> show variables like '%tmpdir%' ) you can just set the tmpdir variable to a larger partition