[DiscordArchive] is there a way to backup the server? make a save of the current entries in all the databases? or at
[DiscordArchive] is there a way to backup the server? make a save of the current entries in all the databases? or at
Archived author: Sanctuary • Posted: 2021-09-23T20:37:49.173000+00:00
Original source
is there a way to backup the server? make a save of the current entries in all the databases? or at least character and world?
Archived author: KingPin • Posted: 2021-09-23T20:41:07.183000+00:00
Original source
mysqldump -u <user> -p <worlddb> > world_20210924.sql
Archived author: KingPin • Posted: 2021-09-23T20:41:20.767000+00:00
Original source
that will dump the world db to an sql file
Archived author: Sanctuary • Posted: 2021-09-23T20:44:15.080000+00:00
Original source
what about the character database? O.o
Archived author: KingPin • Posted: 2021-09-23T20:45:35.595000+00:00
Original source
mysqldump -u <user> -p <chardb> > char_20210924.sql
Archived author: KingPin • Posted: 2021-09-23T20:45:54.643000+00:00
Original source
PS everything inside <> must be changed to your local values
Archived author: Jinnai • Posted: 2021-09-23T20:46:48.901000+00:00
Original source
also this is a console command and not related to your sql client or world/authserver
Archived author: KingPin • Posted: 2021-09-23T20:49:01.683000+00:00
Original source
err yeah if you have a gui client then it may be as easy as clicking backup or dump table on such a client
Archived author: KingPin • Posted: 2021-09-23T20:49:39.550000+00:00
Original source
I haven't used a gui mysql client in sooooo long I don't even recall ... I think last one was navicat..