Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: How to add Data file in mysql ?
Thread ID: 345106 Message ID: 345127 # Views: 55 # Ratings: 2
Version: Unknown Category: Databases, Tables and SQL Server
Date: Friday, May 18, 2012 5:15:55 PM         
   


> >
> >
> > Hi,
> > Maybe you can explain a bit more on what you are doing. Adding more tables to mySQL does not relate to freeing up space unless you are adding tables to remove data redundancy issues.
> > Please provide more details.
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> Thanks for the Replay Pete ,
> Please See the Jpg Below i am uploading jpg.
>
>
>
> regards
> Anand S. Kulkarni
>
> When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!


Hi Anand,

OK now I think I know what you are after. In mySQL server you can have your data split into more that one data file. Generally speaking let say you are running out of room in a hard drive partition and your mySQL Server database data file resides in this partition. You have three possible options to make more room if you are running out of hard drive disk space:

1. You use a partition manager such as "EASEUS Partition Master 8" or another partition manager and re-size the partition where your mySQL data file resides and make the partition bigger, shrinking another partition that has more free space.

2. You install a secondary hard drive in your server, format it and then go into the InnoDB Manager and create a second data file and target the new hard drive you just installed in the server. Set this new data file so it grows automatically. For full instructions on how to setup and configure this please review in full the following link: http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html

3. You do have one other option if you are installing a second hard drive. Install the new hard drive and format it. Then shutddown mySQL and copy the database files into a folder on your new hard drive with lots of drive space. Now in the InnoDB Manager target the new drive and folder location for your mySQL server database files upon startup. In this scenario you still have only 1 mySQL server data file, but now relocated into a hard drive partition with lost of growth space.

In looking at all the options above I would probably go with option 3 as hard drives are cheap.

Note: Always perform a full database backup prior to performing these kinds of administrative tasks and of course perform these kinds of things off-line in non-working hours.

Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

How to add Data file in mysql ? Posted by anand kulkarni @ 5/18/2012 11:02:53 AM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/18/2012 3:25:31 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/18/2012 3:59:15 PM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/18/2012 5:15:55 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/19/2012 11:07:29 AM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/19/2012 7:50:45 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/20/2012 5:22:56 AM