Sql Questions

Post Reply
Vargas
Posts: 54
Joined: Fri Jul 27, 2012 10:25 pm

Sql Questions

Post by Vargas » Tue Jun 18, 2013 3:22 pm

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.

bluekirby0
Developer
Posts: 707
Joined: Sun Jul 22, 2012 12:11 am

Re: Sql Questions

Post by bluekirby0 » Wed Jun 19, 2013 8:20 am

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

aizenmyou
Posts: 13
Joined: Fri May 10, 2013 4:16 pm

Re: Sql Questions

Post by aizenmyou » Fri Jun 21, 2013 10:11 pm

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.

Post Reply