Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Switching Host and Moving, SQL PHPMyAdmin Dump/Export Character Issues
I am having trouble with my TXP database when I move it to a new server. I continue to get very strange characters no matter what language settings I use for PHPMyAdmin export (both hosts are using the same version of MySql).
I keep seeing quotes and apostrophes like this user’s, “designâ€, ifâ€
In the diagnostic tab of TXP on both host I have the following information.
OLD HOST: http://www.codylindley.com
Charset (default/config): latin1/
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
19 Tables: OK
NEW HOST: http://s5725.gridserver.com/
Charset (default/config): latin1/latin1
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/share/mysql/charsets/
19 Tables: OK
Does anyone have any insight for me. I feel like I have tried everything. Sencer HELP!
Last edited by codylindley (2006-12-11 21:14:13)
codylindley.com
Offline
#2 2006-12-11 21:38:08
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Switching Host and Moving, SQL PHPMyAdmin Dump/Export Character Issues
Read this thread, I think it’s similar.
Offline
Re: Switching Host and Moving, SQL PHPMyAdmin Dump/Export Character Issues
I did mine by hand .. only 59+ articles .. shrug all i had to do was ask.. i thought mine was a mysql 5 issue…
these links are now BOOKMARKED .. thanks
nuff-respec ::: dannyb
Offline
Re: Switching Host and Moving, SQL PHPMyAdmin Dump/Export Character Issues
Just dug this up from when I moved from MySQL 3.23 to 4.1.x:
- Install rss_admin_db to backup your site. My phpmyadmin backups were corrupted somehow, but the rss_admin ones were fine.
- Back your site up multiple times (databases twice from rss_admin, and twice from phpmyadmin (just to be safe).
- On your new server/host, create a new database
- in phpmyadmin, choose “Import”. Import the file as latin1.
- Upload your old, or new TXP install, but make sure the line in config.php says
$txpcfg['dbcharset'] = 'latin1';
Offline
Re: Switching Host and Moving, SQL PHPMyAdmin Dump/Export Character Issues
Yeah, I tried all the things mention. I finally just decided to make the changes by hand. :-(
Last edited by codylindley (2006-12-13 21:29:08)
codylindley.com
Offline