Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: How to add Data file in mysql ?
Thread ID: 345106 Message ID: 345166 # Views: 31 # Ratings: 0
Version: Unknown Category: Databases, Tables and SQL Server
Date: Saturday, May 19, 2012 11:07:29 AM         
   


> >
> > 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

Thanks Pete :) ,
This means it is regarding about physical hdd Option . I was in wrong impression that this option will create extra space for my Mysql data :-P . Where i was working before 31 march as Edp Inchage we have banking software which have d2k as front end and oracle as back end and Linux server the some time increase oracle table space . So i thought that its related with that .

So still my query is , Can i increase the data table space of mysql ?


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 !!!

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