Posted on: 09/22/03 09:26am
By: doopisdotnet
how can I copy my gl_users, gl_usersettings and so on from one server/DB to another server / DB (to replace the existing one). also, what tables are needed to copy users and user settings from one site to another (with little/no errors)
if it matters, im trying to replace data in 1.3.8-1 with data from 1.3.7sr1.
thank you,
-Christian
Re:copying users to another GL site
Posted on: 09/22/03 10:23am
By: DTrumbower
If the new site is empty, just dump the old data into the new. You can create sql commands that can do the inserts or use phpmyadmin to dump the tables.
If the new site is not empty, than you have to create new ids for the new users. The easiest way is find you max id in the new db. Then add that number to all of the imported ids.
Look at the tables that start with \"user\" in them. That should do the trick.
Database image[*1]