Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's
Author Message
nikits72
Regular
Regular


Joined: Jan 06, 2005
Posts: 80
Location: Athens/Greece

PostPosted: Mon Jan 22, 2007 7:05 am Reply with quote

Hi all ,

after copying my online phpnuke site locally importing the database e.t.c. and bypassing some problems to do that Only registered users can see links on this board! Get registered or login! 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.
__________

_________________
nikits72 with the unexploding grenade...

Last edited by nikits72 on Sun Jan 28, 2007 10:59 am; edited 1 time in total 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Mon Jan 22, 2007 9:48 am Reply with quote

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
 
View user's profile Send private message
nikits72
PostPosted: Mon Jan 22, 2007 9:55 am Reply with quote

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.
 
hitwalker
PostPosted: Mon Jan 22, 2007 9:58 am Reply with quote

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


Last edited by hitwalker on Tue Jan 23, 2007 5:51 am; edited 1 time in total 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Mon Jan 22, 2007 6:52 pm Reply with quote

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.
 
View user's profile Send private message Send e-mail
nikits72
PostPosted: Tue Jan 23, 2007 3:52 am Reply with quote

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.
 
nikits72
PostPosted: Tue Jan 23, 2007 4:39 am Reply with quote

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....
 
hitwalker
PostPosted: Tue Jan 23, 2007 5:59 am Reply with quote

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.....
 
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Tue Jan 23, 2007 7:36 am Reply with quote

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.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
nikits72
PostPosted: Tue Jan 23, 2007 8:14 am Reply with quote

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.
 
hitwalker
PostPosted: Tue Jan 23, 2007 9:05 am Reply with quote

what charater encodings do you have on your website / phpmyadmin and locally ?
 
nikits72
PostPosted: Tue Jan 23, 2007 9:13 am Reply with quote

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...
 
hitwalker
PostPosted: Tue Jan 23, 2007 9:56 am Reply with quote

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


thats the problem you have to solve locally....
 
montego
PostPosted: Wed Jan 24, 2007 6:29 pm Reply with quote

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.
 
nikits72
PostPosted: Thu Jan 25, 2007 5:29 am Reply with quote

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.
 
hitwalker
PostPosted: Thu Jan 25, 2007 5:32 am Reply with quote

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.
 
nikits72
PostPosted: Thu Jan 25, 2007 6:40 am Reply with quote

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 Only registered users can see links on this board! Get registered or login! 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.
 
hitwalker
PostPosted: Thu Jan 25, 2007 6:46 am Reply with quote

mmmm,something like this...?

συγχαρητήρια για το επίτευγμά σου!. Δείτε επίσης: accomplishment
 
nikits72
PostPosted: Thu Jan 25, 2007 6:47 am Reply with quote

lol
i bet you are using a translator Wink
 
hitwalker
PostPosted: Thu Jan 25, 2007 6:48 am Reply with quote

yeah i do..... Laughing
i paid 400 euro for greek lessons but im not that good.....
im just starting but have little time left...
 
nikits72
PostPosted: Thu Jan 25, 2007 7:21 am Reply with quote

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
 
hitwalker
PostPosted: Thu Jan 25, 2007 7:32 am Reply with quote

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
 
nikits72
PostPosted: Thu Jan 25, 2007 7:39 am Reply with quote

well ,
persist and i bet you ll be doing great.
 
nikits72
PostPosted: Thu Jan 25, 2007 12:46 pm Reply with quote

If you could check this question mates which now arised
Only registered users can see links on this board! Get registered or login!

<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...
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> How To's

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©