This section explains how to transfer your member database from one web server to another. You may need to do this, for example, if you're transferring to another web host. If you are unable to complete the transfer yourself, customer support will for an additional fee. To transfer your database to another server, complete the following steps:

1. Do a clean install of xFlow on the new server. Do not run First Time Setup on the new server.
   
   
2. Login to the old server via Telnet / SSH
   
   
3. Change to the /xflow_data/tools/ directory of your old server, and run the general.pl script, by typing the following at the SSH prompt:
   

   ./general.pl

   
   
4. Backup your member database by typing 'BACKUP' without the quotation marks at the general.pl prompt. A success message will be displayed, giving the exact filename of the backup file. Exit the general.pl script by typing '0' at the prompt.
   
   
5. Transfer the backup file to the new server, into the same directory as the /xflow_data/ directory is located. When you view the contents of the directory, you should see both, the backup file and the /xflow_data/ directory.
   
   
6. Login to the new server via SSH, and rename the current /xflow_data/ directory, by typing the following at the SSH prompt:
   

   mv xflow_data xflow_data_old

   
   
7. Unpack the backup file you transferred over from the old server, by typing the following at the SSH prompt:
   

   tar -xzf FILENAME.tar.gz

   
   
8. Open the /xflow_data_old/wsr.conf file in a text editor, and copy lines 3 - 14 (@cmds - $in{'gif_url'}).
   
   
9. Open up the /xflow_data/wsr.conf file, and replace the lines you previously copied as needed. Delete lines 3 - 14 in the xflow.conf file, and paste in the copied lines.
   
   
10. Delete the /xflow_data_old/ directory from your server, by typing the following at the SSH prompt:
    

    rm -rf xflow_data_old

    
    
11. Open up your web browser, and view the dbinfo.cgi script, which should be located at a URL such as:
    

    http://www.domain.com/cgi-bin/xflow/dbinfo.cgi

    
    
12. Enter the database information for the new server, and submit the form. The next screen should ask you to install the database. Do not do this, and instead, close the web browser.
    
    
13. There will be a SQL dump file located on your server at /xflow_data/dump.sql. Change to the /xflow_data/ directory, and load the dump file into your database by typing something such as:
    

    mysql -uDBUSER -pDBPASS DBNAME < dump.sql

That's it! If you have successfully completed all above steps, your member database will have been successfully transferred from one web server, to another. You can now continue running your business as normal.