Hi Mikael,
Ok :)
Although I dont know MySQL much...im still experimenting right now.
Mikael Syska wrote:
Hey Kenneth
Could be great if you posted the solution when/if you find it.... Soon I
will also be looking for the same to replicate the mysql db.
Regards
Mikael
-----Oprindelig meddelelse-----
Fra: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] På vegne af Kenneth Oncinian
Sendt: 28. april 2004 10:02
Til: DBMail mailinglist
Emne: Re: [Dbmail] mirroring dbmail mySQL database
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
Dbmail@dbmail.org
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
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
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
