Author Topic: Old Mails lost after Server-Migration  (Read 3874 times)

uwe.stache

  • Posts: 7
    • View Profile
Old Mails lost after Server-Migration
« on: September 08, 2016, 07:31:10 am »
I succesfully migrated LM from one server to another, everythings fine, but: the contents of my old mails are lost. I can see them in the database, but i cannot see them in ListMail. I can see the list with the old mails, i can load the mails, i can see the subjects, but no content.
What is my mistake?
Best wishes from Germany
Uwe

BGSWebDesign

  • Posts: 625
    • View Profile
    • http://www.bgswebdesign.com
Re: Old Mails lost after Server-Migration
« Reply #1 on: September 12, 2016, 07:38:33 am »
Hi Uwe,

I would think you did not move the content field properly in the lm_sent table (lm_sent->content) which is defined as Medium Text.  Check the collation type as well, make sure it is: utf8_general_ci , or the same you are coming from.

How did you do the migration?  I usually do this with MySQLDump on the command line, and then import via MySQL on the command line, NOT trying to do it through PHPMyAdmin or any similar type of program.  It's best to work with the raw data using dumped data from MySQL on the command line, and to import it on the command line.  It's also much faster to do it this way.

I can help you do this if you like, I can also tune your application to make it more efficient, and faster sending, and do much more.  Just contact me at my Contact page indicated (in my signature below).  My minimum charge is $40.

Let me know if you have any other questions?

Thanks,
-Brett
http://www.bgswebdesign.com/Contact-Us.php

*** I do custom List Mail Pro installations ***
Contact me through my website (above)