[RCU] mysql data migration

Claudio Kuenzler ck at claudiokuenzler.com
Tue Feb 1 16:50:37 CET 2011


Hello,

You'll find this information in the file UPGRADING and in
SQL/mysql.update.sql, e.g.:

-- Updates from version 0.3-stable

TRUNCATE `messages`;

ALTER TABLE `messages`
    ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`);

ALTER TABLE `session`
    CHANGE `vars` `vars` MEDIUMTEXT NOT NULL;

ALTER TABLE `contacts`
    ADD INDEX `user_contacts_index` (`user_id`,`email`);

-- Updates from version 0.3.1

/* MySQL bug workaround: http://bugs.mysql.com/bug.php?id=46293 */
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

.... and so on

So the best way is to upgrade your existing version.

On Tue, Feb 1, 2011 at 4:12 PM, Frank Bonnet <f.bonnet at esiee.fr> wrote:

> hello
>
> we plan to migrate our mailhub , the actual one runs roundcube 0.3
> and the new on will run 0.5 version.
>
> I would like to import mysql data from the old one to the new one.
> what would be the best way to do so ?
>
> Thanks a lot.
>
> --
> List info: http://lists.roundcube.net/users/
> BT/e21360c6
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/users/attachments/20110201/4a3ca26a/attachment-0001.html>
-------------- next part --------------
-- 
List info: http://lists.roundcube.net/users/
BT/9b404e9e


More information about the users mailing list