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: jacques-beaudoin@xxxxxxxxxx
Cel: 514 918-3350
Selon Curtis Maurand <curtis@xxxxxxxxxxx>:
> 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
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
|
