Duane, yes, you can change the last data file as auto-extending.
Shut down mysqld, edit the my.cnf file, and start mysqld again. Another solution is just to add another file ibdata2: innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend Best regards, Heikki Innobase Oy Copied message: .......... Subject: InnoDB autoextend question From: Duane Winner Date: Mon, 9 Sep 2002 10:30:21 -0700 Hello all, I'm hoping someone can confirm this for me. We're using InnoDB, but when I set it up originally, I just specified the size of the data file: innodb_data_file_path = ibdata1:1000M Being new to it and all at the time, I wasn't aware of the autoextend capability. But now I'm being asked by the boss, did I configure it with autoextend capability. Uhhh, no, but I see that you can by adding ':autoextend' at the end: innodb_data_file_path = ibdata1:1000M:autoextend My question is, can I add this after the db has already been created? Can I just add the :autoextend option and restart MySQL? Or do I have to drop everything and start over? Thanks. sql query --------------------------------------------------------------------- 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