Re: [RCU] mysql data migration

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@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