I have RC installed and working well. Unfortunately I need to move to a new server. I want to keep the folders with their data and contact list including groups for each user. I'm researching with the hosting service how to move the mail folders but I could use a HOWTO on how to restore the MySQL database backup so that the contacts and groups for each user get properly migrated.
I do this all the time, for various testing.
New server
- Create blank database
- Grant permissions to a DB user
Old server
- Dump the current database. On Linux, I do this like so:
- $#mysqldump current_db_name > db_dumpfile.sql
- Transfer the dumpfile to the new server
New server
- Load the database from the dumpfile. Again, on Lunux:
- $#mysql new_db_name < db_dumpfile.sql
As long as you are setting up the exact same version of RC on the new server, you are done.
Thanks so much!