[rt-users] migration from rt2 to rt3

[venkata.kurra at thomson.com]

Hi, 

We are trying to migrate rt2 to rt3 using mysql. The size of the
database is 100 Mb with 3500 tickets. It took 45 min to migrate to rt3
(mysql 5). Anybody has similar experience of the time it took.
Ultimately we would like to migrate the main database of size 6 GB. At
this ratio it might take more than 24 hours to migrate.

We have 4GB memory in the import server. Any clues to speed up the
process! Do I have to modify the database parameters before migrate!

My-huge.conf:
key_buffer = 384M
max_allowed_packet = 128M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M