Author Topic: Move to new server  (Read 3288 times)

Offline stevenospam

  • Newbie
  • *
  • Posts: 8
Move to new server
« on: February 15, 2014, 03:09:53 PM »
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.
« Last Edit: February 15, 2014, 03:18:38 PM by stevenospam »

Offline ABerglund

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 673
Re: Move to new server
« Reply #1 on: February 15, 2014, 04:14:49 PM »
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.
Arne Berglund
SysAdmin, Internet Services
Lane Education Service District
Eugene, OR, USA

Offline stevenospam

  • Newbie
  • *
  • Posts: 8
Re: Move to new server
« Reply #2 on: February 17, 2014, 11:49:07 AM »
Thanks so much!