Hi, 1 - backup with mysqldump on the old machine 2 - rsync or ftp the dump file to the new machine 3 - stop mysql on the new machine 4 - delete the innodb file on the new machine to start with a clean Innodb file 5 - start mysql on the new machine 6 - restore the dump file
I don't know if this is "graceful" but that's what I do. Cordialement Jacques Beaudoin Agent d'administration Les services des technologies de l'information et des communications Commission scolaire de la Pointe de l'Île Montréal, Québec, Canada Courriel/Email: [EMAIL PROTECTED] Cel: 514 918-3350 Selon Curtis Maurand <[EMAIL PROTECTED]>: > Hello, > I need to migrate all users and messages from one dbmail database to > another. Is there a graceful way of doing this? I have a machine that > needs to be decommissioned and have another existing machine that has > lots of horsepower and room to have these few users (about 40) moved to > it. I had meant for the machine its currently on (Celeron 1GHz) to be a > testing and development platform. Its become a workhorse and is just > not up to it. > > Thanks in advance, > > Curtis Maurand > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
