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