LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 05-24-2007, 09:25 AM   #1
streamkid
LQ Newbie
 
Registered: Nov 2006
Distribution: gentoo
Posts: 7

Rep: Reputation: 0
Unicode support broken on Gentoo/MySQL server


Hello,
I moved my server stuff from my old RHEL4 server to a new Gentoo.

I am facing some problems with MySQL (and php?) though.

I backed up using cPanels feature. It gave me a .sql file.
I restored the backup using phpMyAdmin.

On the old server, connection collation was utf8_unicode_ci, and default charset was utf8 (all this according to phpmyadmin).

I configured the new server with the same settings. Here is also my config file:

Quote:
streamkid[dot]de/~alex/my[dot]cnf
(no paste because its big)
The problem is that greek characters don't show up properly. You can have a look here about what i mean:
streamkid[dot]de/~alex/blog/

Using a test.html, i verified that apache is correctly configures. Or at least the greeks chars on the file were properly displayed.

What have i misconfigured
Any help appreciated
 
Old 05-25-2007, 02:47 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,158
Blog Entries: 1

Rep: Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021
Recently I came up a similar post at Hellenic Linux Users Group. Take a look there and perhaps ask them to help you.

Regards
 
Old 05-26-2007, 07:13 AM   #3
streamkid
LQ Newbie
 
Registered: Nov 2006
Distribution: gentoo
Posts: 7

Original Poster
Rep: Reputation: 0
This made me realize that the backup file i get is already corrupted. Any idea on how to get a proper backup?
 
Old 05-26-2007, 08:55 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 13,158
Blog Entries: 1

Rep: Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021Reputation: 2021
According to the post I gave you above, you should use "mysqldump --default-character-set=xxx" to export your database and then use iconv to transform the resulting .sql file to a new .sql with the correct encoding.
Possibly another solution could be to copy all of your tables from the old installation to the new one (overriding the existing tables). You should make a backup first, before trying to do this.
 
Old 05-27-2007, 02:32 AM   #5
streamkid
LQ Newbie
 
Registered: Nov 2006
Distribution: gentoo
Posts: 7

Original Poster
Rep: Reputation: 0
It's propably my mistake I forgot to mention it:
I have only cPanel access (reseller account, they don't give out ssh).
So I guess I forget this until I get a shell..
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Server won't start in Gentoo mclinkor Linux - General 6 09-20-2006 01:05 PM
Full Unicode support quiescere Slackware 4 02-24-2006 10:10 AM
Unicode(UTF8) support in linux shell uiqbal Linux - General 0 10-20-2005 03:21 AM
Hard to install unicode support? newlinuxnewbie Linux - General 5 10-12-2005 11:12 PM
unicode support, slackware 9 anadyr Slackware 4 03-28-2003 08:52 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 04:09 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration