How to change table collation in phpMyAdmin?

Question by Laila2009: How to change table collation in phpMyAdmin?
Hello @ all, please help me, I am a Newbe, I have created an account at my US web host and then I installed WordPress through Fantastico. Then I have installed and activated the plug-in Language Switcher. I cannot publish posts in Russian or Korean language, they are all displayed as ????. It’s because of the table collation that is set. It currently is set to latin1_swedish_ci. If I login to phpmyadmin of the cpanel account, then look at the wordpress database and specifically the collation of the tables, I see this. Solution shall be this answer: “If select all the tables then do operations you can change this to the character set you need which is probably a UTF 8 one of some kind. ” I don’t know what exactly I have to do and what I have to change and where. Do I have to change
latin1_swedish_ci
into
utf8_general_ci
if I want to publish Russian and Korean text on my WordPress website? What exactly do I need to do? Please answer like you do to a complete dumb person with all steps. Thank you so much! I need you guys!

Best answer:

Answer by Inggo
It’s a bit tedious, but if you’re using phpMyAdmin, follow these steps:

1. Locate your database on the left frame, and click it. Your database information should now appear on the main (right) frame, and the left frame should change to a list of all the tables.
2. Click on a table on the left frame. This time, the table’s information should appear in the main frame with a list of the fields/columns. If not, click the “Structure” tab on the main frame.
3. Click the “Check All” below the list of fields, and all the fields on the table should now be marked.
4. Click the “Change” icon, the one that looks like a pencil at the right of `With Selected`.
5. You will now be presented with a form which allows you to modify the selected fields. What you’re interested in is the “Collation” row. Change each collation to utf_general_ci (only for those with an existing collation already). Press save once done.
6. Repeat steps 2-5 for each of your tables.

This is using phpMyAdmin 3.1.1, by the way.

Give your answer to this question below!

Change web URL help! Ok i need help here i signed up to a web host?

Question by Crackster J: Change web URL help! Ok i need help here i signed up to a web host?
Ok i need help here i signed up to a web host and i did not have a URL so i used a sub domain

like crackster.WEBHOSTLINK.com and in cpanel i made my word-press blog now its up and doing good i bought a domain like NAME.com

Now i no i can forward the URL from crackster.WEBHOSTLINK.com to NAME.com but if i click on a link are any thing i will come up crackster.WEBHOSTLINK.com

is there any way on my hosting to get rid of that sub domain and change it to NAME.com cos my wordpress blog still be pointing to crackster.WEBHOSTLINK.com but will i lose my wordpress if i do change it?

thanks

Best answer:

Answer by nosmirc flen
Did you get hosting space for the name.com site? If so, install wordpress there, import your wordpress database on name.com When everything is correct there, use an .htaccess file for a 301 redirect from crackster.WEBHOSTLINK.com to the name.com site. Then after a month or so delete the subdomain.

This is what I would do.

What do you think? Answer below!

how to change my host?

Question by Nady Gold: how to change my host?
i have a site. i am not happy with my current host provider co. now i want to change my hosting service provider. so what should i do for that. can we do something in cpanel ?

Best answer:

Answer by Danijel
i’m guessing you created an account on some “website provider” on internet and you created your website there.

so maybe find another “website provider” and create account there?
and don’t even think that you can transfer your website from one to another, you have to start all over

Give your answer to this question below!

How can I change file permissions chmod 777?

Question by miah: How can I change file permissions chmod 777?
i am using yahoo web host, the cpanel diffrence than others
anyone using yahoo web host?

Best answer:

Answer by danuitti
Get an FTP tool that supports chmod commands. Try the evaluation version of ws_ftp

http://www.ipswitch.com/downloads/index.asp

Good luck and Happy Computing!

Know better? Leave your own answer in the comments!

how do I change a domain from one host to another?

Question by Damien: how do I change a domain from one host to another?
I have a domain hosted on a CPanel server. On this server I have yet 7 “addon” domains I can use. I have another domain hosted on another, different, CPanel server. What I want to do is host the second domain on the same server as the first’s. How, where and what DNS changes and the such do I have to do?

Best answer:

Answer by toecee
Contact the server you want to change your domain too and they will provide you with all the details and should at least help you if not do it all for you.

Give your answer to this question below!

I just purchased “web hosting” How do I change NAMEservers? This is needed to before I can login into cPanel

Question by Will W: I just purchased “web hosting” How do I change NAMEservers? This is needed to before I can login into cPanel

Best answer:

Answer by Rusty Nails
You shouldn’t need to change name server to log in to the control panel..

You will need to log in to domain name control panel and update the name server to your webhosts specs.

The webhost should send the numbers and you update them in domain name control panel..

Add your own answer in the comments!