Moving ListMail to a new Host

[gluntz]

We have to switch hosting companies this week. I cannto find any doc on exactly what to do to move our system over with all the data.  Pleasxe could you lay out the steps needed, especially those rleated to exporting all data (including custom HTML, existing emails/autoresponders, list details and list members?).

Thanks,

George

[DW]

It is recommended that you use the program PhpMyAdmin, often available from your web control panel.  From here you can Export all of your ListMail database tables, and data, into a zipped text file file.

On the new host, set up a new database and, again through PhpMyAdmin, import / upload the data file to set up the tables and data in the new database.  

Next, upload the ListMail files to your desired directory on the new host, ie public_html/mail, and modify config.php to contain the new server's MySQL access info.

You should then be able to access ListMail on the new host with all of your old data.  If necessary, update the path to ListMail, the domain name, and re-setup the cron task and bounce scripts.

http://listmailpro.com/help

[steve]

Step One: Back up your data before the move!   ListMail Pro does have an export function and a back up utility built in.

You'll need to ensure that there is a database setup and ready to use at the new site. I would try to ensure the db was the same name as I'm using now.

I would then install ListMail Pro as new at the new site.

Then I would import the data from the back up.

Of course, you'll also have to ensure that the sign-up pages and such are created and available too.

Not sure if I was able to help - but it's a try...

[DW]

Please note that you could be missing data if you use ListMail v1.77(b) to export the database data.  The process is being redone.  If you can access PhpMyAdmin it is safer.  Otherwise, if you use ListMail's backup process please make sure you verify that there are 12 "create table" statements in your backup file.

[gluntz]

Dean, Steve:

Thanks very much for the input; I will try that approach and see if it works for me.  Please pray hard  :?

Regards,

George

[gluntz]

I followed all steps, did an Export using these options:

* SQL (as opposed to CSV for Excel etc)
* gzipped (my server does not seem to understand zipped)

I set up the database with the same name, user, logins etc.  I then ran the phpMyAdmin.  The only thing I saw to do to import was to run a SQL query, using the Browse function to find the file.  It uploaded the file and seemed to run for quite a while (20 minutes or so), then returned to phpMyAdmin with no errors, but did not refresh the screen ... just had the dbname there.

I then clicked on the dbname and found to to still be empty ... any ideas?

Thanks!

[gluntz]

Well, I figured he best way was to get to the shell command line and use mysql at the command level. So I "gunzipped" the text file, ran the file using the "source" command and BINGO - all 12 tables, all records!Logged into the new Listmail install, tested bounce.cgi and SMTP .. all works.  Thanks for the pointers!
 

[DW]

Web hosts are being analyzed and reviewed - please post your recent experience if your host is not listed already!

Here's the post:
Email Web Hosting Review

Regards