Hi, I have tried the following process in order to try and replicate a database with InnoDB files:
1. created a new database in PHPMyAdmin 2. via command line, copied all the .frm files from the old database directory into the new database directory 3. changed all the ownership and permissions 4. restarted mysql The database is now recognised in PHPMyAdmin, but when I click on any of the tables I get the message "cannot find [table].InnoDB". Originally, the tables in the source database were MyISAM and then converted to InnoDB. I tried renaming one of the [table].frm files to [table].InnoDB, but now this does not show up on the table list. I tried the described method as I have done this before with MyISAM tables successfully. What am I missing? Or is a completely invalid way to move the database? Would a server restart fix it? Thanks Andy Hall. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
