Hi! A couple of days ago I stopped a MySQL server to change a couple of parameters in the my.cnf file and to add 2 data files (InnoDB).
When restarting it, MySQL exited because I'd resized the log file size but forgot to delete/move the old ones. Secondly, I had another error because I allocated more memory than ulimit allowed. I fixed both, restarted, but then it exited because it had created the first datafile with a size of 0. I deleted the ibdata file and restarted, and now it created both data files and started correctly. However, the two new datafiles are not used, and the data they were supposed to add doesn't show up in a "show table status". I've later created another data file, and this one works. ...so the question is : How to fix those two ? Can I just shutdown MySQL, rename them and then re-start MySQL and have the files re-created, or is there another solution ? /Jesper --------------------------------------------------------------------- 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