Hi REposting as the 'spam' filter didn't like my mail.
Question, If I need to add a data file to the InnoDB setup can I just tack another 'data file' to the innodb_date_file_path setting, restart server and it will be used? Or, is there more involved like dumping data, re-creating ALL the data_files and importing the data again? Thanks. Also I can't figure out if it's better to just create 2G data files or make a 500M one with gro up to max of 2GIG. I am unsure of my OS limit so i'm maxing them out at 2G 'just in case'. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 2:26 PM > To: John Bateman > Subject: Re: Innodb 'devices' / data files > > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of > it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, > for example. > > You have written the following: > > Hi > > Question, If I need to add a data file to the InnoDB setup can I just tack > another 'data file' to the innodb_date_file_path setting, restart > server and > it will be used? Or, is there more involved like dumping data, re-creating > ALL the data_files and importing the data again? > > Thanks. > > Also I can't figure out if it's better to just create 2G data > files or make > a 500M one with gro up to max of 2GIG. I am unsure of my OS limit so i'm > maxing them out at 2G 'just in case'. > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php