My phpBB version is 2.0.19. Can I do MySQL 4.1 -> 5.1 update just like this:
1.. Export phpbb -table with phpMyAdmin

(SQL-options

[x] Structure:
[x] Add AUTO_INCTRMENT value
[x] Enclose table and field names with backquates
[x] Data:
[x] Use hexadecimal for binary fileds
Export type: INSERT)


2.. Uninstall MySQL 4.1 and delete folder

3.. Install MySQL 5.1

4.. Import phpbb.sql with phpMyAdmin


I use same dbusername and dbpasswd, but is somekind mysql_fix_privilege_tables needed?

Hi,

with your strategy, you don't take care of the mysql database which stores
the current privileges. So you will have the default user root without
password after this kind of update.

If you know exactly what you do, you can of course update straight from 4.1
to 5.1, but unless you're absolutely familar with what goes on behind the
scenes, I would recommand you to do it the way that's described in the
manual:

http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html

http://dev.mysql.com/doc/refman/5.1/...-from-5-0.html

and upgrade from one version to another.

You should also know that MySQL 5.1 is still alpha and not recommanded for
production use (you should rather use 5.0.18 for a production server) and
also that MySQL 5.1 is not yet supported by phpBB. So if you have a problem
with phpBB and MySQL 5.1, none of the phpBB guys will care about it! I'm not
even sure if they have already solved all the MySQL 5.0 related problems
that might arise when you use a strict mode option.

So if you need your database server primarily for phpBB, you would probably
do best with MySQL 5.0.18 and not using strict mode (although you could try
it and eventually switch back if you find any problems).

Markus

"Markus Popp" <mfp@gmx.li> wrote in message

> with your strategy, you don't take care of the mysql database which stores
> the current privileges. So you will have the default user root without
> password after this kind of update.

I use same username (root) with same password what it was with 4.1.

> If you know exactly what you do, you can of course update straight from 4.1
> to 5.1, but unless you're absolutely familar with what goes on behind the
> scenes, I would recommand you to do it the way that's described in the
> manual:
> http://dev.mysql.com/doc/refman/5.0/...-from-4-1.html
> http://dev.mysql.com/doc/refman/5.1/...-from-5-0.html
> and upgrade from one version to another.

I am just a newbie with this issue. I try to read that 'upgrading-from-4-1.html'
but I dont find clear path to upgrade MySQL on Windows. Especially how I
handle the database backup and restore.

> So if you need your database server primarily for phpBB, you would probably
> do best with MySQL 5.0.18 and not using strict mode (although you could try
> it and eventually switch back if you find any problems).

Thanks for a tip. I stick in 5.0.18 without strict mode. I have 1.75Ghz Sempron
and 786Mb memory. Only use to computer is MySQL -server (with apache & phpbb).
What is a fastes config to MySQL on my case? I choose those like this:

[ ] Developer Machine
[ ] Server Machine
[x] Dedicated MySQL server machine

[ ] Multifunctional Database
[x] Transactional Database Only
[ ] Non-Transactional Database Only

[ ] Decision Support
[x] Online Transaction Processing
[ ] Manual Setting

Is there any benefit to convert Standard Character Set (Latin1) to Multilingualism (UTF8)?

Everything seem to work ok, but is what is that mysql_fix_privilege_tables?