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 > > [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 > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
