Convert MySQL 4 to 5 [Installation Troubleshooting]

XOOPS

Forum

Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk

Convert MySQL 4 to 5

2008/9/19 14:45
jimbofoxman
Quite a regular
Posts: 292
Since: 2005/4/1 1

But what am I converting from? In my hosts little fact file, it says the default tends to be CP1252, but when I go to the PHPAdmin from my particular database it says on the upper right.....ISO-8859-1 for the language.

So how do I determine which it really is......and what should I convert it too?

Thanks

Re: Convert MySQL 4 to 5

2008/9/19 14:53
jdseymour
Friend of XOOPS
Posts: 3782
Since: 2004/11/11

CP1252 is Windows-1252. See http://en.wikipedia.org/wiki/Windows-1252 for more.

You can set the encoding to whatever you want. You do not have to go with the default.

BTW import your data into MySQL5 to fully update your tables.

Proactive Support for Sites and Servers

WebServerMasters.com | XOOPS Tutorials

Re: Convert MySQL 4 to 5

2008/9/19 17:12
jimbofoxman
Quite a regular
Posts: 292
Since: 2005/4/1 1

Nevermind, figured it out.

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Convert MySQL 4 to 5

Re: Convert MySQL 4 to 5

Re: Convert MySQL 4 to 5

Login

Search

Recent Posts

Re: Privacy

Privacy

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}