"Dan Soendergaard" <dan1990@gmail.com> wrote:
> On Mar 16, 11:33 am, Axel Schwenke <axel.schwe...@gmx.de> wrote:
>>
>> Seems the tables are InnoDB tables and you did not copy the InnoDB
>> tablespace files (and logs) as well.
>
> The tables are InnoDB, yes. I located a directory called "InnoDB" in
> the MySQL directory. It contained one file which I copied to the new
> MySQL installation. I then copied the whole "Data" directory to the
> new installation too, but I get the same result. Are the InnoDB
> tablespace files and logs located somewhere else? Should I copy
> anything else to get it to work?

This is all configurable. Get the my.ini file from the old installation
and check the innodb_data_home_dir, innodb_data_file_path and
innodb_log_group_home_dir variables for where to find the data files
and logs. If there are nonstandard settings in my.ini, you have to copy
them to the new my.ini.

Default is to have none of those settings in my.ini. Then everything is
located in datadir = $INSTALLDIR/Data. There should be files ibdata1,
ib_logfile0 and ib_logfile1.

Oh - and use the *exact* same version of MySQL.


XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/