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? Quote 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.... Quote 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? Quote 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. Quote 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 Quote 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? Quote 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 Quote 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? Quote 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. Quote 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? Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.