Thanks Ilja,
Yes, I'm reading the MySQL manual at this very moment.
Thanks again.
regards,
Kenneth
Ilja Booij wrote:
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
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
"Even if you're on the right track, you'll get run over if you just sit
there."
-- Will Rogers
