Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Help! Hosting transfer makes database problems
I transferred to another host this week. In moving my database, a few problems have ensued. If anyone can offer advice, it would be much appreciated. I’m thinking I might need to transfer the database again; I have access to the old host until mid November, so it’s no problem if I can find out how to go about it.
1. I had some Korean text in several articles which was converted into gibberish characters on the new host.
2. My links have been appended with junk. Originally http://theturninggate.com/galleries/TTGSelectionGallery/index.html, is now http://theturninggate.com/galleries/TTGSelectionGallery/index.html?phpMyAdmin=6aovv97hJ3cdgPdGnzoa%2C9LMl32. Every link in every article has this. They still seem to work, but I’d like to get rid of the excess garbage. Dynamic links, like categories and article permlinks don’t have this problem; only links that are hard coded into articles and pages.
3. All of my pre-existing comment invitations have received junk characters. “Comment »” is not “Comment »” on all of my articles. New articles don’t have this problem.
4. Some random gibberish shows up in the TXP interface. For example, “Reset time to now…” from the write tab.
If anyone can offer advice on the proper way to export or import the database, I’d love to get this fixed.
Thanks,
theturninggate
Offline
Re: Help! Hosting transfer makes database problems
Compare the TXP full diagnostics on the old and new webhost. 1, 3 and 4 are a character set problems.
Offline
Re: Help! Hosting transfer makes database problems
Of special importance: In config.php, both sites have to employ identical settings for $txpcfg['dbcharset'].
Offline
Re: Help! Hosting transfer makes database problems
Robert,
$txpcfg[‘dbcharset’] is set to utf8 for both config.php files.
Ruud,
What’s the best solution for character set problems?
Offline
Re: Help! Hosting transfer makes database problems
What were the MySQL versions on the old and the new host… and how did you export (UTF8 or latin1) and how did you import (UTF8 or latin1)?
Offline
Re: Help! Hosting transfer makes database problems
Old host was running MySQL 4.1.12.
New host is running MySQL 4.1.10.
Now sure about the export and import settings. They new host handled the transfer for me. If I make the transfer again, which settings would you recommend?
Offline
Re: Help! Hosting transfer makes database problems
Both export and import in UTF8. Because the MySQL versions are identical (both 4.1.x) that should work fine.
Do make sure you have spare copies of the new articles you’ve added, because they will be gone when you restore a new backup.
Offline
#8 2007-09-07 17:58:08
- Rei
- Member
- From: MY / SG (GMT +08)
- Registered: 2007-08-31
- Posts: 14
Re: Help! Hosting transfer makes database problems
theturninggate, i faced the same problem 2 days ago, the Chinese and French became junk characters after imported. That was due to the different collation on the old (default set at latin1) and new (default set at utf8-unicode-ci) MySQL system.
After reading up all those complicated methods of converting and transferring of the MySQL database, i went for an easy method, by exporting and importing with MovableType format in text (old blog was using Wordpress 1.5).
However, the ID would be reassigned according to the data sequence in the text file, if that is important to you.
Offline