Re: MySQL database move
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 http://blog.360.yahoo.com/alex.lurthu On 7/9/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: 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? > > -- > Thanks, > Rajan >
Re: MySQL database move
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 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? > > -- > Thanks, > Rajan >
Re: MySQL database move
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? -- Thanks, Rajan
Re: MySQL database move
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, Hartleigh Burton Resident Geek MRA Entertainment Pty Ltd 5 Dividend St | Mansfield | QLD 4122 | Australia Phone: (07) 3457 5041 Fax: (07) 3349 8806 Mobile: 0421 646 978 www.mraentertainment.com Internal Virus Database was built: Never Checked by MAC OSX... we don't get viruses!
MySQL database move
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