Home : Products : Gossamer Forum : Discussion :

Products: Gossamer Forum: Discussion: Re: [warc1] moving to a new server: Edit Log

Here is the list of edits for this post
Re: [warc1] moving to a new server
Some information that might be of use to any other novices, like myself, that want to move their forum to a new server. I discovered the following by trial and error. Therefore, I may not have stubled across the easiest way of doing a transfer and more experienced users can jump in to correct me. In fact, the following may have caused the error I am now experiencing. However, this is what got me to the point that at least my database is installed on the new server.

To use a mysql dump to move the contents of the database, I had to first set up the Gossamer installation on the new server including setting up the new database. In my case, I called the new database "forumd". This created a blank database with the table structure in place. A straight import using the command line listed in a previous post would not work since it errored out in trying to create tables that already exist. Therefore, the tables had to be cleared in the new database. I found I could do this using MySQLman in Gossamer Forum by clicking "drop" beside each table in the database until it was empty.

I used FTP to upload the text file dump (I called it mysqldmp.txt) of my old database to the new server. I uploaded it to the root directory of my web taking note of the path name displayed in my FTP client. In my case, the path name was /home/lansingheritage/www. I then used the freeware program PuTTY to intiate an SSH connection to import the data from the text file. I did this instead of using a command line in MySQLman because I couldn't find one in v1.9 that is included with Gossamer V1.8. After logging into the server, the command line to import the MySQL dump became:

mysql -uusername -ppassword forumd </home/lansingheritage/www/mysqldump.txt; echo "Done"

This worked with the exception of the error reported above that I hope can be addressed shortly.

Regards

Don McRitchie
Webmaster
Lansing Heritage Website

Last edited by:

warc1: Jul 10, 2003, 9:18 AM

Edit Log: