On Monday 16 August 2004 11:05, Duncan Hill might have typed: > Had to rebuild my laptop this weekend. Made sure to make a backup copy > of /var/lib/mysql/*. Loaded on the mysql binary tar (as gentoo doesn't > have 4.1.3 in portage yet), and copied my data back across. > > However, even with the innodb files in place, the mysql engine is saying > things like: > Didn't find any fields in table 'company_addresses' > Didn't find any fields in table 'company_contacts' > > I realise that this is probably because you're not meant to copy innodb > files around :> Is there any way I can recover the structures (ie, create > table statements) - the data is irrelevant and can be recreated easily.
Google eventually turned up http://archives.neohapsis.com/archives/mysql/2004-q1/1056.html which worked like a charm. I've lost all of the foreign key restraints, but I can recreate those easily. bash + hexedit = recovered structures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]