introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.
-->

Convert 2.0 to 3.0



Posted by: chris_s
June 17, 2009 08:11PM
I installed version 3.0 but I need to know how to get from my 2.0 Applications and database to the 3.0 version.

Can I change the database password for the root user back to a null value? I don't want to have to change the dataabase password in a whole lot of applications.

What is the correct procedure to convert MySQL databases from version 2 to version 3? It looks as if I can't just copy the data directory. Do I have to dump my database tables to SQL and re-load them?

________________________

I did some reasearch and found the mysql_upgrade utility that will check for consistency and try to fix any problems (NOT included with EasyPHP). I ran it and after that I was able to use one of the databases I copied from 2.0 but not the other one.



Edited 2 time(s). Last edit at 06/17/2009 11:04PM by chris_s.
Posted by: Amour
June 19, 2009 08:08AM
>>Do I have to dump my database tables to SQL and re-load them?

Yes

And to change root password, you can do it with phpMyAdmin ;)