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 L
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:http://lists.m
original-
De: Ronan Lucio [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 10 de Diciembre de 2004 11:38 a.m.
Para: [EMAIL PROTECTED]
Asunto: Increasing the InnoDB log file size
Hi,
I need to increase the innodeb_log_file_size parameter, but when I set it
higher, mysql don´t starts and give the
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://lists.mysql
]
Subject: Increasing the InnoDB log file size
Hi,
I need to increase the innodeb_log_file_size parameter,
but when I set it higher, mysql don´t starts and give the
follow erro:
041210 13:27:40 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0
Hi,
I need to increase the innodeb_log_file_size parameter,
but when I set it higher, mysql don´t starts and give the
follow erro:
041210 13:27:40 mysqld started
InnoDB: Error: log file ./ib_logfile0 is of different size 0 100663296 bytes
InnoDB: than specified in the .cnf f
