Welcome to Geeklog, Anonymous Saturday, April 01 2023 @ 06:54 pm EDT

Geeklog Forums

copying users to another GL site

Status: offline


Forum User
Registered: 01/31/03
Posts: 38
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

Status: offline


Forum User
Registered: 01/08/03
Posts: 507
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

All times are EDT. The time is now 06:54 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content