1
Xetox
DB Issue
  • 2005/12/1 21:01

  • Xetox

  • Just popping in

  • Posts: 71

  • Since: 2005/10/28


After fighting getting my site moved to my new host after old on crashed, I have decided to just start over.

This is my question. I am wanting to just exract my users our of the database and import them into my newone is this possible? If so how?

2
bb2120
Re: DB Issue
  • 2005/12/1 21:32

  • bb2120

  • Not too shy to talk

  • Posts: 179

  • Since: 2005/7/6 1


Import the users table from the MySQL databse using phpmyadmin or similar - there are loads of manuals of how to do this, just google it

3
highlander
Re: DB Issue
  • 2005/12/1 21:36

  • highlander

  • Not too shy to talk

  • Posts: 151

  • Since: 2004/12/5


Hi Xetox,

As long as your XOOPS version are the same (to keep things simple) it should not be too hard.

Use PhpMyAdmin (or an other database administration tool) to export the table(s) with users form the old DB and use the same tool to import the table(s) into the new DB.

for XOOPS 2.0.13.2 (my version) you will need to export the following table : "<prefix>_users" and for the permissions you'll need to do the same for "<prefix>_groups_users_link" and "<prefix>_groups".

Use the export function to make a full backup (all tables) first just incase you press the wrong buttons !!

Hope this helps, Highlander
So, I'm in the park wondering why frisbees get larger as they get closer when suddenly, it hits me...
www.AnimalPedigree.com

Login

Who's Online

163 user(s) are online (134 user(s) are browsing Support Forums)


Members: 0


Guests: 163


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits