how to copy accounts/chars to new server

Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Valued Member Rodion is offline
    MemberRank
    Feb 2011 Join Date
    FranceLocation
    146Posts

    Re: how to copy accounts/chars to new server

    Quote Originally Posted by 343 View Post
    Well if you had to re-register, something was majorly wrong since accounts are in dbo... Though if you don't really have a problem with it as of now, there's no point in talking about it.

    You also actually do NOT have to 'copy/backup/transfer' (whatever you wanna call it) uniquenamed, the ONLY one that is REQUIRED (to save characters) is DBDATA/GAMEDBD... Some people can disagree with me all they want, but uniquenamed will re-populate itself automatically once you run your restored game DB... This has never caused issues in the probably THOUSANDS (1,000's) of times I have done it this way (NOT copying or 'backing up' uniquenamed')...

    Now, with that out of the way, make or take your backup of the game DB data and delete clsconfig from the 'backup'. You will want to go from an 'empty' server installation (with no DB files at all) and start the daemons so that it creates all of the game DB files as it automatically does. Next step STOP all daemons. Following step, COPY your backup (WITH NO CLSCONFIG) to your 'running' DB directory (over-writing) the empty ones that running the daemon created... Presto your problem will be solved
    I tryed your solution from 1.5.1 to 1.5.3 and that doesn't work... =(
    All daemon running well but went i'm connect to the game, i don't have my Characters and the "create new one" button is disabled...


    --------------

    Problem solved
    Last edited by Rodion; 11-12-17 at 08:13 PM. Reason: Solved

  2. #17
    Apprentice Nigel728 is offline
    MemberRank
    Mar 2021 Join Date
    20Posts
    Quote Originally Posted by 343 View Post
    make or take your backup of the game DB data and delete clsconfig from the 'backup'. You will want to go from an 'empty' server installation (with no DB files at all) and start the daemons so that it creates all of the game DB files as it automatically does. Next step STOP all daemons. Following step, COPY your backup (WITH NO CLSCONFIG) to your 'running' DB directory (over-writing) the empty ones that running the daemon created... Presto your problem will be solved
    So had done a dummy run a while back of copying data from 1.4.6 to 1.5.5, I thought all was working fine because I hadn't tried creating new chars. Now I've got problems with that, so re-copied the MySQL DB, wiped gamedbd and uniquenamed and let it autocreate the files, then copied in the 1.4.6 gamedbd files (minus clsconfig) as per above, and still got problems...

    If I try to add a char onto an account that existed on the 1.4.6 server, I get "There is already a character by this name" (even if I type random gibberish name). If I try to create a new account (which works fine) then create a char on that, I get "Failed to create character". I can log in existing chars no problem. uniquenamed is running fine.

    Anyone have any suggestions please?

  3. #18
    Psy Sins Psytrac is online now
    MemberRank
    Jul 2011 Join Date
    Hammond, INLocation
    1,986Posts
    there is an update database command.. somewhere

  4. #19
    Apprentice Nigel728 is offline
    MemberRank
    Mar 2021 Join Date
    20Posts
    Ok got it to work. Am migrating 1.4.6 to 1.5.5... don't know if those version numbers affect what's necessary here, but what I had to do was:
    * Wipe gamedbd/dbdata and /dblogs, and uniquenamed/dbdata and /dblogs
    * Start 1.5.5 server + end it again (just to get default files created)
    * Copy 1.4.6 gamedbd/dbdata over the top of 1.5.5 folder with exception of clsconfig (as per 343's instructions above)
    * Copy 1.4.6 uniquenamed/dbdata over the top of 1.5.5 folder
    * Now for some reason I don't get, nothing was necessary to "fix" gamedbd, it just worked. But uniquenamed had to loosely follow https://forum.ragezone.com/f754/tuto...tabase-895462/ and do:
    * Wipe uniquename/dblogs (again)
    * cd uniquenamed
    * mv dbdata olddata
    * mkdir dbdata
    * ../gamedbd/dbtool -r -s olddata/unamerole -d dbata/unamerole (and so on, for each of the files in uniquenamed/olddata); each time this would output how many record it migrated

    Started it all back up and worked, could create new accounts and new chars on those accounts.



Page 2 of 2 FirstFirst 12

Advertisement