Replicating InnoDB tables in new database

2005-03-18 Thread Andy Hall
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

Re: Replicating InnoDB tables in new database

2005-03-18 Thread Alec . Cawley
Andy Hall [EMAIL PROTECTED] wrote on 18/03/2005 12:06:30: 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

Re: Replicating InnoDB tables in new database

2005-03-18 Thread Ware Adams
On Mar 18, 2005, at 7:06 AM, Andy Hall 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

Re: Replicating InnoDB tables in new database

2005-03-18 Thread Gleb Paharenko
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