Jump to content



Photo

Importing MySQL data from the 2.1 to the 3!


  • Please log in to reply
6 replies to this topic

#1   Mitchell69

Mitchell69
  • Members
  • 77 posts
  • Real Name:Mitchell

Posted 20 April 2008 - 12:59

Hi,

Any idea if or how I can import old database before 2003 (2.1) to the latest one without loosing all data?

Many thanks in advance
Mitchell

#2   geoffreywalton

geoffreywalton

    Professional Developer

  • Community Sponsor
  • 8,243 posts
  • Real Name:Geoffrey Walton
  • Gender:Male
  • Location:Norfolk, UK (close to the centre of the universe)

Posted 20 April 2008 - 13:01

Shouldnt be a problem.

The upgrade path is in each package, usually in the extras directory.

You might have to do it in a few stps depending on how old your orig package is.

Edited by geoffreywalton, 20 April 2008 - 13:07.

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.

For links mentioned in old answers that are no longer here follow this link Useful Threads.

If this post was useful, click the Like This button over there ======>>>>>.

#3   Mitchell69

Mitchell69
  • Members
  • 77 posts
  • Real Name:Mitchell

Posted 20 April 2008 - 13:20

Shouldnt be a problem.

The upgrade path is in each package, usually in the extras directory.

You might have to do it in a few stps depending on how old your orig package is.



Thanks for the quick reply, I will start the website fresh, so I do not need to upgrade the actual script but as I have a huge database only want to upgrade the database.
It seem to be very hard to manualy do it, is there any easy way to just uograde the MYSQL?

Many thanks in advance
Mitchell

#4   geoffreywalton

geoffreywalton

    Professional Developer

  • Community Sponsor
  • 8,243 posts
  • Real Name:Geoffrey Walton
  • Gender:Male
  • Location:Norfolk, UK (close to the centre of the universe)

Posted 20 April 2008 - 13:27

Did you look in the extras directory?

2.2 has \extras\pr21_to_pr22
Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.

For links mentioned in old answers that are no longer here follow this link Useful Threads.

If this post was useful, click the Like This button over there ======>>>>>.

#5   Mitchell69

Mitchell69
  • Members
  • 77 posts
  • Real Name:Mitchell

Posted 21 April 2008 - 11:42

Did you look in the extras directory?

2.2 has \extras\pr21_to_pr22


Yes I did but I couldn't find any help how to upgrade the database!
Are you sure it is there?
Cheers
Mitchell

#6   autoxtreme

autoxtreme
  • Members
  • 114 posts
  • Real Name:wayne

Posted 21 April 2008 - 19:23

Yes I did but I couldn't find any help how to upgrade the database!
Are you sure it is there?
Cheers
Mitchell


I was just wondering about this. I have just downloaded OSC 3.0a4 and I want to upgrade my database to work with it. I checked the download and I dont have an extras folder or anything I can see that will upgrade the database.

What has everyone else done that has used version 3.0 a4

Thanks

#7   jalal

jalal
  • Members
  • 26 posts
  • Real Name:jalal

Posted 23 April 2008 - 20:04

What has everyone else done that has used version 3.0 a4


I've knocked up a quick script that works for me, it's available here:
http://codeworks.gno...e_from_2.2.phps

But this is really rough and ready, you're welcome to try it and let me know if it works for you. And if it doesn't, what the problems are.

In particular, the images and the languages need some work...

cheers
jalal

Edited by jalal, 23 April 2008 - 20:06.