Jump to content

How to restore innoDB tables without ibdata1


giba

Recommended Posts

Hi there guys!

 

 

I have a serious problem and can't find a solution.

 

I recently had problems with my system and had to backup de tables by copying then from the folder mysql/data

but I forget to copy the file ibdata1 and now after putting it again in the new instalation of my mysql

I can just acess the MyISAM tables and the InnoDB tables aren't listed.

 

Any idea of how to solve it?

 

 

I have these lines in my my.ini file, but if I uncomment any of these lines,

mysql doesn't start up!

 

# Uncomment the following if you are using InnoDB tables

#innodb_data_home_dir = C:\mysql\data/

#innodb_data_file_path = ibdata1:10M:autoextend

#innodb_log_group_home_dir = C:\mysql\data/

#innodb_log_arch_dir = C:\mysql\data/

# You can set .._buffer_pool_size up to 50 - 80 %

# of RAM but beware of setting memory usage too high

#innodb_buffer_pool_size = 16M

#innodb_additional_mem_pool_size = 2M

# Set .._log_file_size to 25 % of buffer pool size

#innodb_log_file_size = 5M

#innodb_log_buffer_size = 8M

#innodb_flush_log_at_trx_commit = 1

#innodb_lock_wait_timeout = 50

Well the log file :

 

 

090114 14:05:28  InnoDB: Starting shutdown...

090114 14:05:31  InnoDB: Shutdown completed; log sequence number 0 3457404

 

090114 14:05:32  InnoDB: Operating system error number 3 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: If you are installing InnoDB, remember that you must create

InnoDB: directories yourself, InnoDB does not create them.

InnoDB: File name C:\mysql\data\ibdata1

InnoDB: File operation call: 'create'.

InnoDB: Cannot continue operation.

090114 14:07:52  InnoDB: Operating system error number 3 in a file operation.

InnoDB: The error means the system cannot find the path specified.

InnoDB: If you are installing InnoDB, remember that you must create

InnoDB: directories yourself, InnoDB does not create them.

InnoDB: File name C:\mysql\data\ibdata1

InnoDB: File operation call: 'create'.

InnoDB: Cannot continue operation.

090114 14:08:06  InnoDB: Started; log sequence number 0 3457404

Yes, the directories exist.

The problem is that the ibdata1 file had to be overriden

to get a list of the innoDB tables but I forgot to copy it when backing up the database, so I would like to know if there is a way to recreate this listing information.

 

Yes, the directories exist.

The problem is that the ibdata1 file had to be overriden

to get a list of the innoDB tables but I forgot to copy it when backing up the database, so I would like to know if there is a way to recreate this listing information.

 

Huh?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.