Database Migration [Installation Troubleshooting]

Database Migration

2005/11/13 16:41
abbey
Just popping in
Posts: 50
Since: 2005/3/17

Hi guys,,,

I have one question... I have created a new database fpr XOOPS 2.3.3 and i want to move the registered users from the old database to the new databse.

I have over 5,500 registered users ans i dont want to loose them.

Which key tables in the old database should I move the new database so that i cab i have my registered users log into the new site?

Thanks.

Visit GhanaMusic.com: The Largest electronic news source of information on the Ghanaian music industry.

Re: Database Migration

2005/11/13 18:41
Herko
XOOPS is my life!
Posts: 4238
Since: 2002/2/4 1

Abbey, the best way is to move your whole 2.0.x db to the new db, and then run the 2.2.3 installer/updater. This will transform the old tables into the new structure (this has changed, so you can't just copy them).

Herko

Re: Database Migration

2005/11/13 19:46
abbey
Just popping in
Posts: 50
Since: 2005/3/17

i tried that but by moving the whole old database to the new database. Then i tried to install XOOPS 2.3.3 to that new database but when you get to stage where it creates tables it gives you an error ... that the tables already exist in the database.

what shd i do?

Visit GhanaMusic.com: The Largest electronic news source of information on the Ghanaian music industry.

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

Database Migration

Re: Database Migration

Re: Database Migration

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

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