Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 04:37 am EDT

Geeklog Forums

copying users to another GL site


Status: offline

doopisdotnet

Forum User
Chatty
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
 Quote

Status: offline

DTrumbower

Forum User
Moderator
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
 Quote

All times are EDT. The time is now 04:37 am.

  • 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