← Back to team overview

maria-discuss team mailing list archive

Re: Full Replacement of MySQL (innoDB, mysql Workbench, data, etc)


I'm forwarding this to the mailing list since of all the places it was
sent to, lp did not send it to the list...

Please take care of this, nice MariaDB people:


On Mon, Aug 16, 2010 at 7:25 PM, Enrique Daniel <enridp@xxxxxxxxxxxx> wrote:
> Hi !!
> I'm really new with MariaDB, I have discovered it yesterday at really :S
> And I have not tested it yet, but it looks really promising.
> Anyway, there are a few things that are braking me to make the change.
> I hope somebody can help me:
> 1) I'm using mySQL Workbench to design my DB, how can we use it with
> MariaDB? (Aria, XtraDB engine, etc.)
> 2) My tables ar InnoDB, but I was reading about XtraDB and it looks much
> better, how can I make the change from innoDB to XtraDB? if I have a SQL
> file, is enough changing ENGINE=INNODB with ENGINE=XTRADB (or something
> like that).
> I want to preserve my FK, with cascades, and comments.
> 3) What happens if I have my DB with data and working with MySQL and
> InnoDB right now? can I change to MariaDB (and XtraDB) preserving all my
> scheme, tables, data, relations, comments, indexes, etc?
> Thanks !!!
> Enrique.
> --
> This message was sent from Launchpad by the user
> Enrique Daniel (https://launchpad.net/~enridp)
> using the "Contact this team" link on the Maria Discuss
> team page to each member directly.
> For more information see
> https://help.launchpad.net/YourAccount/ContactingPeople

email: henrik.ingo@xxxxxxxxxxxxx
tel:   +358-40-5697354
www:   www.avoinelama.fi/~hingo
book:  www.openlife.cc