PDA

View Full Version : Side effects of exporting part of SQL database.


James Birkett
07-24-2009, 05:11 PM
Q1: What database table stores thread titles/content/user etc?
Q2: Can this corrupt my database if I export just threads?
Q3: I imported 1 user into the database earlier with no trouble, is there anything stored in the 'user' table that can affect my forum if I export and import?

Dismounted
07-25-2009, 04:40 AM
Always backup the entire database. You an always selectively import things with ImpEx with needed.

PS. There is more than one table that stores thread info, etc.

James Birkett
07-25-2009, 06:05 PM
I've resolved this issue :) Thanks for the reply Dismounted.

Marco van Herwaarden
07-27-2009, 08:25 AM
Just to emphasize: You should not try to import/restore partial data. It will for sure break things.