how to copy accounts/chars to new server

[Rodion]

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

[Nigel728]

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?

[Psytrac]

there is an update database command.. somewhere

[Nigel728]

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.