giba Posted January 13, 2009 Share Posted January 13, 2009 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? Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/ Share on other sites More sharing options...
fenway Posted January 13, 2009 Share Posted January 13, 2009 Check the config files.... Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-736123 Share on other sites More sharing options...
giba Posted January 13, 2009 Author Share Posted January 13, 2009 Check the config file for what? Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-736165 Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 To make sure innodb in enabled, that your directories are configured correctly, etc. Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-736880 Share on other sites More sharing options...
giba Posted January 14, 2009 Author Share Posted January 14, 2009 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 Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-737042 Share on other sites More sharing options...
fenway Posted January 14, 2009 Share Posted January 14, 2009 Well, that might be a problem... what errors are in the log? Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-737167 Share on other sites More sharing options...
giba Posted January 14, 2009 Author Share Posted January 14, 2009 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 Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-737287 Share on other sites More sharing options...
corbin Posted January 15, 2009 Share Posted January 15, 2009 Do those directories exist? Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-737492 Share on other sites More sharing options...
giba Posted January 15, 2009 Author Share Posted January 15, 2009 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. Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-737576 Share on other sites More sharing options...
fenway Posted January 18, 2009 Share Posted January 18, 2009 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? Link to comment https://forums.phpfreaks.com/topic/140653-how-to-restore-innodb-tables-without-ibdata1/#findComment-739716 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.