1
ALineberger
Transferring tables from one schema to another
  • 2005/8/2 18:14

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


May be more of a mySQL question than XOOPs.

I am currently migrating from a 2.0.11 site to 2.2 site. Instead of following the update path, I decided to create a new site and am now trying to move the smartFAQ data from one site to the other. Besides having to rename the tables from xoops_smartfaq_faq/answers/categories to xxxxx_smartfaq_faq/answers/categories is there anything else of which I need to be aware?

I am using the mySQL Administrator for W2k3 so I thought I would just backup the old schema, and import those tables into the new schema, renaming the Table Names to match. SmartFAQ is already installed and running in the new installation.

Running v4.1.12 of MySQL / PHP v5

The overall goal is to eventually down the old site and switch the new site into it's place.

Abel

2
ALineberger
Re: Transferring tables from one schema to another
  • 2005/8/2 18:22

  • ALineberger

  • Just popping in

  • Posts: 7

  • Since: 2005/6/27


Well, it appears to have worked. No errors yet.

Abel

Login

Who's Online

209 user(s) are online (125 user(s) are browsing Support Forums)


Members: 0


Guests: 209


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