Need cron-job for backup of database

[yesco]

The database is currently stored on a virtual machine. The data should be backed up somewhere "else".

[lionello]

How about we use SQLITE instead? Backup would be simply copying the file.

[lionello]

http://php.net/manual/en/book.sqlite.php

[lionello]

And we'd need http://php.net/manual/en/function.sha1.php to make up for lack of SHA1 in SQLITE.

[nihaopaul]

If there is processing power pear has a software implementation

On Mon, 3 Aug 2015 11:36 Lio李欧 notifications@github.com wrote:

And we'd need http://php.net/manual/en/function.sha1.php to make up for
lack of SHA1 in SQLITE.

—
Reply to this email directly or view it on GitHub
#12 (comment).

[mermetbt]

It's really easy to backup a MySQL database, just do in a daily cron (localy or remotely) something like the command:

mysqldump -h HOSTNAME -u USERNAME --password=PASSWORD --opt MYDB > backup_date '+%Y-%m-%d'.sql

This will make a file for each day.

[lionello]

That part is easy, but where do we keep the files? I guess we can keep them on the server, but that hardly helps us: when the server crashes, both the VM and the backups crash. We need to keep the backups somewhere else. Perhaps on the XCJ NAS http://burty/ ?

[nihaopaul]

Yeah. NFS Mount. Or. Github like we did with partkeepr..

Paul

On Sat, 12 Sep 2015 23:47 Lio李欧 notifications@github.com wrote:

That part is easy, but where do we keep the files? I guess we can keep
them on the server, but that hardly helps us: when the server crashes, both
the VM and the backups crash. We need to keep the backups somewhere else.
Perhaps on the XCJ NAS http://burty/ ?

—
Reply to this email directly or view it on GitHub
#12 (comment).

[lionello]

I'm changing to SQLite for use in Dimsumlabs.

[lionello]

WIP https://github.com/dimsumlabs/bouncer/tree/sqlite

Need a migration script for moving MySQL data into SQLite DB.

[lionello]

#49

[lionello]

I created a new issue for SQLite: #50

This issue will be used for the backup cronjob. Who will take this? @nihaopaul @mermetbt ?