1
SillDude
Database copy
  • 2005/3/14 21:39

  • SillDude

  • Just popping in

  • Posts: 9

  • Since: 2005/2/20


I have made a new XOOPS site and now i want to copy my forum to the new site... does some1 know if u can copy your database to a other table ?

2
jdseymour
Re: Database copy

Yes you can without too much trouble.

Assuming that you have PHPmyadmin, select all tables that pertain to the Forum and choose Export.

Now is where some options come into play. If your new forum does not have any existing post that you want to keep choose the option:

Add Drop Table (if exist)

This will drop and recreate the tables with your data entered into the tables. I am assuming that is what you are doing.

Now you may have to edit the SQL file to reflect any change in database name or prefix.

HTH.

3
gestroud
Re: Database copy
  • 2005/8/13 18:02

  • gestroud

  • Home away from home

  • Posts: 1538

  • Since: 2004/12/22


Quote:

jdseymour wrote:
Yes you can without too much trouble.

Assuming that you have PHPmyadmin, select all tables that pertain to the Forum and choose Export.

Now is where some options come into play. If your new forum does not have any existing post that you want to keep choose the option:

Add Drop Table (if exist)

This will drop and recreate the tables with your data entered into the tables. I am assuming that is what you are doing.

Now you may have to edit the SQL file to reflect any change in database name or prefix.

HTH.



I've been trying to figure out how to copy 184 categories from one site to another. You don't know how much time and trouble you just saved me! Resized Image

Login

Who's Online

295 user(s) are online (127 user(s) are browsing Support Forums)


Members: 0


Guests: 295


more...

Donat-O-Meter

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

Latest GitHub Commits