Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
Hi,
We have crisis. Disk with MySQL database is full. Now we want to move
database to another disk. How can we do it?
--
Thanks,
Rajan
backup and restore would be what i would do.
using either mysql administrator or mysqldump.
On 09/07/2007, at 3:45 PM, Ace wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to
move
database to another disk. How can we do it?
--
Thanks,
Rajan
Regards,
Hi Ace,
Can't you zip or move old bin-logs to a different disk and release some free
space on the current drive.
regards
anandkl
On 7/9/07, Ace [EMAIL PROTECTED] wrote:
Hi,
We have crisis. Disk with MySQL database is full. Now we want to move
database to another disk. How can we do it?
Will try with dump and moving logs.
Can I just move my datadir=/usr/local/mysql/data to some other location and
change it in my.cnf? Will there be any complications to this?
Thanks,
Rajan
On 7/8/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Ace,
Can't you zip or move old bin-logs to a
