From: Reindl Harald
Date: September 29 2011 5:01pm
Subject: Re: replication between two tables in same database
List-Archive: http://lists.mysql.com/mysql/225857
Message-Id: <4E84A45A.5030409@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig110EE392C71C7BB16B152146"

--------------enig110EE392C71C7BB16B152146
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 29.09.2011 18:56, schrieb Tompkins Neil:
> Hi
>=20
> I've a Innodb and MyISAM table in the SAME database that I wish to repl=
icate
> the data between the two because I need to use FULLTEXT searching on
> the MyISAM table.  Is this possible ? If so how do I do it.

in short: no

in longer:
why in the world are you using the wrong engine if you need fulltext-sear=
ch?
mysql 5.6 semmes to start support this in innodb, but currently not

replication is based on binlogs and contains database/table so there is
no dirty trick do this on one server except let run a script and copy
the table-contents per cronjob


--------------enig110EE392C71C7BB16B152146
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk6EpFsACgkQhmBjz394Ank7sQCfXnas9NcgAZBInhdMB878JAJ1
quAAn3SWV6FIWP9ofZftZPV3ZkelcxNz
=P2Bg
-----END PGP SIGNATURE-----

--------------enig110EE392C71C7BB16B152146--