Heya thar: Take the file that you have as autoextend right now, round it down to the nearest meg, and enter this value as the size (without autoextend).
Then make the new file autoextend. Peter <^_^> -----Original Message----- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:18 PM To: '[EMAIL PROTECTED]' Subject: Changing InnoDB files As the person who's asking a question and just had it rejected twice, here it is again ... sql, query, blah, blah. I have three InnoDB data files that I've created as time has gone on; 100M, 250M and 1G (autoextend). I would like to create a new data file on a new raid partition and make it autoextend instead of the current one. How do I properly set the size on the current file so that it has no problems if I remove the autoextend keyword, or is this not. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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