Sql Questions
Sql Questions
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.
-
- Developer
- Posts: 707
- Joined: Sun Jul 22, 2012 12:11 am
Re: Sql Questions
Your best bet is to learn how to add columns to existing tables. Still recommend backing up first though.
Re: Sql Questions
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.
Then just schedule it in a cron job to run nightly or what not.