Hello.
See: http://dev.mysql.com/doc/mysql/en/moving.html "Andy Hall" <[EMAIL PROTECTED]> wrote: > 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. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
