You should probably read the MySQL manual on this. There's a chapter on replication there, which might have some info on mixing InnoDB and MyISAM tables.
Ilja On Wed, 2004-04-28 at 03:02, Kenneth Oncinian wrote: > Hi list, > ALthough this sounds like more of an MySQL question, my knowledge in > MySQL is very limited as of now so please bear with me :). > > In one of my server, I used the command: > mysql -u root -p < sql/mysql/create_tables.mysql > to create the mysql database. > > I would like to mirror that in one of my server as live backup because I > would be doing some maintenance on the other server. > > But instead, I used the InndDB command to create the database using > mysql -u root -p < sql/mysql/create_tables_innoDB.mysql in the backup > server. > > My question is, can I still use the old MySQL database from the main > server to the backup server? Could I just rsync the original > /var/lib/mysql/dbmail to the backup server? > > > thanks and best regards, > Kenneth Oncinian > >
