Deprecated Darkstar fourms

For Backing up sql files such as the character storage and chars, do i just export them and manually add the info into the new ones? Ive done this but get sql errors not sure what im doing wrong.

Your best bet is to learn how to add columns to existing tables. Still recommend backing up first though.

If your mysql/mariadb is in Linux you can just create a script to use mysqldump to dump specific table into a file then bzip2, or what ever, the file.
Then just schedule it in a cron job to run nightly or what not.