ib_logfile is different from ibdata1.
Just because i get the database without Ib_logfiles...
I´m sorry, i´m sending now my.cnf and what is in /data directory
Dir:
11/25/2004 04:51 PM <DIR> .
11/25/2004 04:51 PM <DIR> ..
11/15/2004 11:31 AM 5,010,096,128 ibdata1
11/25/2004 04:51 PM 5,242,880 ib_logfile0
11/25/2004 04:50 PM 5,242,880 ib_logfile1
11/25/2004 04:43 PM 3,542 mibhweb01.err
11/25/2004 03:17 PM <DIR> mysql
11/25/2004 04:34 PM 95 mysql.err
11/25/2004 03:17 PM <DIR> test
5 File(s) 5,020,585,525 bytes
---my.ini----
[client]
port=3306
innodb_force_recovery = 2
skip-networking
port=3306
basedir=C:/MySQL/server/
datadir=C:/MySQL/server/Data/
default-character-set=latin1
default-storage-engine=INNODB
max_connections=100
query_cache_size=100M
# section [mysqld_safe]
table_cache=256
tmp_table_size=103M
thread_cache=8
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=205M
key_buffer_size=157M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
#skip-innodb
innodb_additional_mem_pool_size=7M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=4M
innodb_buffer_pool_size=305M
innodb_log_file_size=61M
innodb_thread_concurrency=10
---end my.ini---
On Thu, 25 Nov 2004 20:15:43 +0200, Heikki Tuuri
<[EMAIL PROTECTED]> wrote:
> Carlos,
>
> when filing bug reports for any software, not just MySQL, you should provide
> the full information. You should not try to pick the relevant material
> yourself.
>
> What do you have in your my.cnf file? What does the '/data' directory
> contain?
>
> The errors below look like you would have at least two ibdata files, with
> conflicting lsn stamps in them. InnoDB refuses to init the log files because
> the data files do not match.
>
> Regards,
>
> Heikki
>
> ----- Alkuperäinen viesti -----
> Lähettäjä: "Carlos Augusto" <[EMAIL PROTECTED]>
> Vastaanottaja: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Lähetetty: Thursday, November 25, 2004 8:01 PM
> Aihe: Innodb Corruption with error logs now.
>
>
>
>
> Well, let me begin again..
>
> I´m new in a corporation and my jobs is deal with mysql.
>
> We had, running mysqld 4.1.7 and using Innodb for a database of
> 4.7GB~. But some time inserting data into it, the server crashed.
>
> So i get the server do analyze it.
>
> When i get to the server the mysqld(config-file,errorfile)was ready
> removed and only ibdata1 file was in hd.
> I installed mysqld now and I tryed to put ibdata1 into /data files.
> When i did this i started the daemon and i get some errors( Ill paste
> all errors at the end of the post) . Then i tryed to add into my.ini
> the following parameter:
> innodb_force_recovery =1. And i get new errors. I tryed change the
> value for 2, and 3 respectively.
> The only thing i´ve changed at my.ini was this one above.
>
> Now i´m pasting the FULL content of errorlog.
>
> I aprecciate your help and thanks for attention,
>
> ==========Begin Error log===============
>
> ----> I pasted the ibdata1 at /data directory
> 041125 15:22:18 InnoDB: Log file .\ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file .\ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 041125 15:22:18 InnoDB: Log file .\ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file .\ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Cannot initialize created log files because
> InnoDB: data files are corrupt, or new data files were
> InnoDB: created when the database was started previous
> InnoDB: time but the database was not shut down
> InnoDB: normally after that.
> 041125 15:22:18 [ERROR] Can't init databases
> 041125 15:22:18 [ERROR] Aborting
> 041125 15:22:18 [Note] mysqld: Shutdown complete
>
> ----> the part bellow i tryed to use innodb_force_recovery = 1
> InnoDB: No valid checkpoint found.
> InnoDB: If this error appears when you are creating an InnoDB database,
> InnoDB: the problem may be that during an earlier attempt you managed
> InnoDB: to create the InnoDB data files, but log file creation failed.
> InnoDB: If that is the case, please refer to
> InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
> 041125 15:27:14 [ERROR] Can't init databases
> 041125 15:27:14 [ERROR] Aborting
>
> 041125 15:27:14 [Note] mysqld: Shutdown complete
>
> ----> the part bellow i tryed to use innodb_force_recovery = 2
> InnoDB: No valid checkpoint found.
> InnoDB: If this error appears when you are creating an InnoDB database,
> InnoDB: the problem may be that during an earlier attempt you managed
> InnoDB: to create the InnoDB data files, but log file creation failed.
> InnoDB: If that is the case, please refer to
> InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
> 041125 15:28:54 [ERROR] Can't init databases
> 041125 15:28:54 [ERROR] Aborting
>
> 041125 15:28:54 [Note] mysqld: Shutdown complete
>
> ----> the part bellow i tryed to use innodb_force_recovery = 3
>
> InnoDB: No valid checkpoint found.
> InnoDB: If this error appears when you are creating an InnoDB database,
> InnoDB: the problem may be that during an earlier attempt you managed
> InnoDB: to create the InnoDB data files, but log file creation failed.
> InnoDB: If that is the case, please refer to
> InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html
> 041125 15:41:04 [ERROR] Can't init databases
> 041125 15:41:04 [ERROR] Aborting
>
> 041125 15:41:04 [Note] mysqld: Shutdown complete
>
> ==========End Error log===============
>
> Thanks
> Carlos
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
