Backing up Server

[kennxonline]

How would one back up there server information so people don't lose there levels and stats. I just bought a server PC and moving everything over to it. I have never done this before please bare with me. Any information or links on now to do this will really help thank you!

[kjLotus]

look up how to back up a mySQL database (all the information is in the database)

[kennxonline]

look up how to back up a mySQL database (all the information is in the database)

thanks, I think I understand it.

using information off of http://webcheatsheet.com/SQL/mysql_backup_restore.php

[kennxonline]

wow this is beyond me I have no clue what im doing.

[kjLotus]

you can use mysqldump to dump the contents of a table to a file that you can run later - all the tables that start with "char" or "account" are the ones you would need

[kennxonline]

you can use mysqldump to dump the contents of a table to a file that you can run later - all the tables that start with "char" or "account" are the ones you would need

I download mysqldump but my computer doesn't know how to start it or something I'm confused on what I do after I download it.

[kjLotus]

you should have it already with your mysql install. It's a command line utility, so you run it through the command prompt

[fnx]

While probably not the best way... This is my easy way to do backups once a week when I do updates.

I have all my data in one directory

FFXI
---- MYSQLdata <<< Need to set this in MySQL or else it goes to default in MySQL directory
---- Server
---- Tools
---- Error Log

When I do updates I do the following
1) Stop all three parts of Darkstar
2) Stop MySQL
3) 7zip the entire directory and date it (FFXI-Server-2015-11-12.7z)
4) Check Git to see if any of the config files have changed in the last week.
(everything in the conf directory & /scripts/globals/settings.lua)
5) Git-Sync my Darkstar directory
6) Restart MySQL
7) Check sql directory for any updates to the files that are deleted by my "Save_Char_Data_SQL.bat"
8) Run "Save_Char_Data_SQL.bat" that imports all sql files and any execute any changed char data files.
9) Build all three servers
10) Restart servers

In all takes about 20 minutes unless there I miss a sql file or setting .lua
Best part is that if the new server build or database takes a dump I stop servers and MySQL, delete directory and then unzip back to that mornings working version which takes at most 5 minutes.

[whasf]

you can use mysqldump to dump the contents of a table to a file that you can run later - all the tables that start with "char" or "account" are the ones you would need

delivery_box and auction_house too!

[TeoTwawki]

And linkshell table if you want people those preserved.