New Server Questions

dad7732 · Posted: Fri Aug 13, 2010 5:14 pm

Just starting to configure a new VPS for my support domain. The site is so resource intensive that it will be the only domain on the server.

I installed PHP5 and MySQL 5 ..

What is the best type of DB to create for RN 2.4 and beyond, the defaults are:

Collation
uft8_general_ci

Using the latest PHPMyAdmin - lots of new stuff to learn.

Thanks

Also got this at the bottom of MyAdmin:

Your PHP MySQL library version 5.1.45 differs from your MySQL server version 5.0.90. This may cause unpredictable behavior.

Any ideas here?

nuken · Posted: Fri Aug 13, 2010 7:59 pm

I personally use collation latin1_swedish_ci

Palbin · Posted: Fri Aug 13, 2010 8:16 pm

RN 3.0 will use uft8_general_ci , but current version use latin1_swedish_ci.

dad7732 · Posted: Fri Aug 13, 2010 8:52 pm

Can it be changed w/o problems when 3.0 is out?

montego · Posted: Fri Aug 20, 2010 5:28 am

dad7732, if you site(s) are strictly in English, using utf8_general_ci even now won't hurt you. At least I have a terrible mix of charsets being used on individual tables even. Not even 100% sure how they got that way, but they are all compatible with the standard English characters et.

dad7732 · Posted: Fri Aug 20, 2010 6:10 am

Yes, learning that as I go along. Getting too old to "learn", just wanna be in the "it works" stage. Cool

Cheers

Palbin · Posted: Fri Aug 20, 2010 6:43 am

dad7732 wrote:

Yes, learning that as I go along. Getting too old to "learn", just wanna be in the "it works" stage. Cool

Cheers

Don't we all Laughing