Backup/Restore db with multilingual characters? [Resolved]

Posted: Mon Jan 22, 2007 7:05 am

Hi all ,

after copying my online phpnuke site locally importing the database e.t.c. and bypassing some problems to do that info about these problems and solutions here i can now run my online site locally as well.

Yet another problem arised.
When i try to view my site locally it shows ????????????? everywhere except the menus which work well both in english and greek.
In sort words it is as all the greek content of the site is imported with ???????

The online site is multilingual.It uses greek and english and works fine.

So the wuestion (and probably the error) is :
How should backup/restore a database which includes english and non english characters?

I think this is gonna be tough someone to tell me what is the problem or what i should do because most of the guys here use english and not greek in their phpnuke sites.
But since i dont know how to resolve this you are my last chance.

Regards,
nikits72.
__________

Sells PC To Pay For Divorce Joined: Posts: 5661

it depends on how your database is saved....
that can be done in a few ways...
is it in ANSII , utf-8, etc...
not my thing...... Sad

but there are people here that know everything about that...
keep an eye on next replies..... Wink

Posted: Mon Jan 22, 2007 9:55 am

If i judge from my previews post (you know which) you bet i will.

I guess this is the question then,
how i should back up the database.I used phpadmin with its default values to export it.

Thx.

Posted: Mon Jan 22, 2007 9:58 am

yes, i use default to but it might need a different approach since you use englisch and greek.

just wait for other replies...
the other guys know much more... Wink

Posted: Mon Jan 22, 2007 6:52 pm

I have to admit this is something I have not tried or come across before but I would assume that you would need to export the database using the character encoding applicable to your servers language settings.

phpmyadmin for example normally has the encoding set to a default language which might not be correct for where you want to use it but luckily, you can usually change that from a drop down list.
It would be worth checking what the default setting is on your hosted environment and that of your local server.

Posted: Tue Jan 23, 2007 3:52 am

Ok ,

i will try the database checking the encoding in both backup/restore procedures and i will inform since this is a rare issue.

Thx for your reply.
Regards N.

Posted: Tue Jan 23, 2007 4:39 am

It seems that Mysql of webhoster exports the database with encoding : en-iso-8859-1 while when i try to import i dont have this option. The option i have is utf-8 (among others like latin1 e.t.c.)

Trying to export as utf-8 and import as utf-8 doesnt solve the problem.

So now i have to see how i can have the option of en-iso-8859-1 in my local Mysql installation too....

Posted: Tue Jan 23, 2007 5:59 am

well i even called a friend and he says you should be able to do it by exporting it by different characters setting and change it back locally when importing it...
its a bit hard to explain.....
maybe next reply of a member can explain it better.....

Posted: Tue Jan 23, 2007 7:36 am

Quote:

When i try to view my site locally it shows ????????????? everywhere except the menus which work well both in english and greek.
In sort words it is as all the greek content of the site is imported with ???????

Just curious, when you say this, are you referring to what are typically just the PHP-nuke labels or is the text of say your news articles messed up? I just want to make sure the database is the issue and not a corrupt set of greek language files.

Posted: Tue Jan 23, 2007 8:14 am

Menus are very ok.
The problem is the with the texts which i have entered.
Lets say it the greek content of the site .

The online version it is ok.
So the problem definitelly arises from the backup and restore in my local web which i do in different coding untill now as i posted in my previews posts.

Hitwalker' friend says it can be done and up to now from my search around various forums ,yes it is possible.

But havent figured out how yet.
I hope i will with your aid .

Thx.

Posted: Tue Jan 23, 2007 9:05 am

what charater encodings do you have on your website / phpmyadmin and locally ?

Posted: Tue Jan 23, 2007 9:13 am

I am afraid i dont understand the question.

The html of the phpnuke site is the same.
Locally is a copy of the online phpnuke site.

As for phpmyadmin i use the one of my webhoster to make the back up and another one which i have installed locally to make the restore.The problem seems to be that in the local phpmyadmin there is no option to restore with the en-iso-8859-1 which my webhoster's phpmyadmin uses as default.

In case i use utf-8 to export and utf-8 to import which both phpmyadmins have the problem persists.

pls excuse my ignorance for not understanding your question...

Posted: Tue Jan 23, 2007 9:56 am

Quote:

there is no option to restore with the en-iso-8859-1

thats the problem you have to solve locally....

Posted: Wed Jan 24, 2007 6:29 pm

Unfortunately, I may not be much help. What I have personally done, when I was trying to test my current site as UTF-8 in preparation for using G2 (Gallery 2.x), I took the backup of my production site to file, remove ALL the "default charset" statements in that file. Then, I picked a default character set of UTF-8 Unicode on a new database and then imported it in.

Bottom line, you may need to remove the specific default charset information that gets exported too, and see if you can get it imported properly. Don't know if it will help, but as hitwalker says, it is definitely something locally you are going to have to solve.

Posted: Thu Jan 25, 2007 5:29 am

Well,

my webhoster says that i should backup not through phpmyadmin.
And he probably means by directly using command line to the server through ssh.

That is awful news cause i dont know how i will do that.

But thank you very much for your answers.

Posted: Thu Jan 25, 2007 5:32 am

well you can try both ways...
you can also ask your host to help,let them make the back up and put it on your server or something for you to download.

Posted: Thu Jan 25, 2007 6:40 am

Well everything is fixed, here is how in case someone has similar problem.Although i have not quite understand why it worked but anyway i ll write what i did :

Up to now i was trying to backup the online database using my webhoster's phpmyadmin which was giving me the option to backit up with encoding en-iso-8859-1 which my local phpmyadmin didnt had as an option for the restore.

So i executed a direct comand to the online Mysql server to make the backup,
The command was /usr/local/mysql/bin/mysqldump --add-drop-table -u whatevre.user.name -p whatever.database.name > nikbackup

Then i downloaded the backup.
Afterwards i made a local database and changed the collation to utf8_general_ci
Then i imported the backup with this tool here because the backup was bigger than 2,084 Mb and my localphpmyadmin couldnt handle it.

Finally now works like a charm Smile

Thx to everyone who answered me,
N.

Posted: Thu Jan 25, 2007 6:46 am

mmmm,something like this...?

συγχαρητήρια για το επίτευγμά σου!. Δείτε επίσης: accomplishment

Posted: Thu Jan 25, 2007 6:47 am

lol
i bet you are using a translator Wink

Posted: Thu Jan 25, 2007 6:48 am

yeah i do..... Laughing

i paid 400 euro for greek lessons but im not that good.....
im just starting but have little time left...

Posted: Thu Jan 25, 2007 7:21 am

well ,
greek language is a little bit difficult and i recon you ll need much more money to pay than the ones you pay for the divorce .

But i could do teach you the basics Smile

Posted: Thu Jan 25, 2007 7:32 am

well the lessons are serious and it gives me the right for 5 years to learn it all...
but problem i have / or think im gonna have... is that we cannot simply translate A word into greek cause the greek have a different vocabulaire than we have (as dutch)...
that doesnt make it easier... Sad

Posted: Thu Jan 25, 2007 7:39 am

well ,
persist and i bet you ll be doing great.

Posted: Thu Jan 25, 2007 12:46 pm

If you could check this question mates which now arised
Its here

<edited by admin>i just wanted to copy my site locally for tests.
I thought it would be simpler...
(Crowd's voice---> How optimistic?! Specially since you are not a very clever lad nikits Twisted Evil

)
Thx...