Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: MySQL database move

From: Alex Arul Lurthu <alex.lurthu(at)gmail.com>
Date: Mon Jul 09 2007 - 01:59:45 EDT


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  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 <rajan.halade@gmail.com> 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
> >
>
Received on Mon Jul 9 02:00:36 2007

This archive was generated by hypermail 2.1.8 : Tue Jul 10 2007 - 21:34:34 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library