RE: Increasing the InnoDB log file size

2004-12-10 Thread Anil Doppalapudi
Hi, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Thanks Anil NOC -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:08 PM To: [EMAIL

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Do you know if is there a risk of loosing any data? Thanks, Ronan -- MySQL General Mailing List For list archives:

RE: Increasing the InnoDB log file size

2004-12-10 Thread Anil Doppalapudi
the InnoDB log file size Anil, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Do you know if is there a risk of loosing any data? Thanks, Ronan -- MySQL General Mailing List For list archives: http

RE: Increasing the InnoDB log file size

2004-12-10 Thread Oropeza Querejeta, Alejandro
Hello, I had the same issue myself, i read the manual and there says that you have to stop mysql, then change the parameter in my.cnf, then i moved to another directory the log file just to be cautious, and then restarted mysql. Everything went right. Best regards Alejandro -Mensaje

Re: Increasing the InnoDB log file size

2004-12-10 Thread Ronan Lucio
Anil and Oropeza, if mysql shutdowns cleanly. then there is no chance of loosing data. for safe side take compleate database backup. Ok, thank you very much for your help. Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: