SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:47 AM
| |||
| |||
 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 <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 >      |
|
02-28-2008, 06:47 AM
| |||
| |||
| 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! |
|
02-28-2008, 06:47 AM
| |||
| |||
| 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 <anandkl@gmail.com> 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 > > > > |
|
02-28-2008, 06:47 AM
| ||||
| ||||
| 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 <anandkl@gmail.com> 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 > > > |
Linear Mode
