Hi,
I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was reintroduced
the limit of 500 chars max in Innodb primary keys (limit that would break my
application). Is it still present ?
Is it present in Mysql 4 ?
I also need to know if Innodb is reliable in replication mode. I remember that with
past versions, if the master broke the slave would lose synchrony, or something of
this kind that would make a self-recovery impractical.
I need to implement a read-only fall-back DB, and I'm planning to use a combination
of cron script to dump the live db to the slave after having renamed the good (old)
versions, and after having verified that all the data in
the new dump is fine, renaming the new db to the right name.
The problem is that I can't find in the manual a command to rename a database.
I will appreciate any suggestion,
Thanks,
Nico
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
