Welcome, Guest
Please Login or Register.    Lost Password?

Have upgraded MySQL 4.0 to 5.0
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Have upgraded MySQL 4.0 to 5.0
#3971
Have upgraded MySQL 4.0 to 5.0 2 Years, 1 Month ago Karma: 0
Have upgraded MySQL 4.0 to 5.0. Now what do I need to do to swap it over? I have not changed the database login details in Joomla admin or anything yet because I don't want to mess up. Can you please tell me what I need to do so that I don't lose any data?

Thanks

Cammy Girl
The Cammy Girl
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
The Camelia Grove Hotel Location: Alexandria, NSW Australia
The administrator has disabled public write access.
 
#3972
Re:Have upgraded MySQL 4.0 to 5.0 2 Years, 1 Month ago Karma: 0
Hi Cammy Girl,
Here is some documentation on migrating data after you've upgraded to MySQL 5.0
mysql-upgrading

Do you have your database backed up from the previous version?
Little Bear
Admin
Posts: 38
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#3973
Re:Have upgraded MySQL 4.0 to 5.0 2 Years, 1 Month ago Karma: 0
no, not sure how to do this as it is new. Have never required to do this before
The Cammy Girl
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
The Camelia Grove Hotel Location: Alexandria, NSW Australia
The administrator has disabled public write access.
 
#3975
Re:Have upgraded MySQL 4.0 to 5.0 2 Years, 1 Month ago Karma: 19
Hi Cammy Girl,

have you Consoles-Access in your hosting pack? Or you have a access with phpmyadmin?

You must create a backup from your old database, then create a new with the version 5 and inport your backup.

In your root-folder from your site, you must edit the configuration.php file. Please make a backup from the configuration.php before you change anything. ;-)

Edie the lines:

var $user = 'DATABASE USER';
var $db = 'DATABASE NAME';
var $password = 'DATABASE PASSWORT';

Please make a backup from the configuration.php before you change anything. ;-)

Regards,

GermanBear
GermanBear
Moderator
Posts: 441
graphgraph
User Offline Click here to see the profile of this user
ICQ#: 178412056 Gender: Male hofmar123 Carnevale di Venezia Bonn Location: Bonn Birthday: 05/08
The administrator has disabled public write access.
 
#3990
Re:Have upgraded MySQL 4.0 to 5.0 2 Years, 1 Month ago Karma: 0
Thanks Germanbear. I do have phpmyadmin access. I think I understand your message so I'll give it a shot. Much to my dismay, my office package has stopped working...so much for computers.

I'll let you know how I go. Have a great weekend!
The Cammy Girl
Junior Boarder
Posts: 29
graphgraph
User Offline Click here to see the profile of this user
The Camelia Grove Hotel Location: Alexandria, NSW Australia
The administrator has disabled public write access.
 
Go to topPage: 1
Moderators: Support
 
JOOMLA TEMPLATES Joomla Templates By JoomlaBear