Jonathan I'm looking for enduser who may not having knowledge on external tolls. If we have a simple button in the pos app to take backup and to restore the db that will be useful.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I use Auto-Mysql-Backup-win-15 on windows, only problem it ruines umlauts in german.
One must give "--default-character-set=latin1" as parameter to the mysqldump command.
Then your backup will have it's umlauts too.
There is a similar but better script for linux too.
Run it with the scheduler of your OS.
The backup-directory is synchronised with an owncloud-instance especially for my customers,
https and with an encrypted filesystem.
Regards,
Jan
Last edit: Janvl 2015-12-11
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Its all perfect done with a script which starts a batchfile i found i think in the unicenta forum, but maybe it is also here now..
It makes a "mysqldump" ... is packing the sql file over the comandline with "7z" automatically to the dropbox folder. And all integrated with a button in the pos...
Easier it is not possible and i think there are more important and more dificult problems to solve for the developer team...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Loading financial Data onto Dropbox is not exactly compliant with the most basic security-rules. Olly describes Automysql.bat, starting it with the windows scheduler makes it invisible for the user, install and forget. Just check once in a while. And do not use Dropbox.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for the security advice, but using dropbox with viivo... there is no problem.
Only the plain passwords in the batch-file is maybe a problem but if you cannot trust your employers, better you close your store....
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Can be done with HeidiSQL (Free software) easily.
Jonathan I'm looking for enduser who may not having knowledge on external tolls. If we have a simple button in the pos app to take backup and to restore the db that will be useful.
Hi
I use Auto-Mysql-Backup-win-15 on windows, only problem it ruines umlauts in german.
One must give "--default-character-set=latin1" as parameter to the mysqldump command.
Then your backup will have it's umlauts too.
There is a similar but better script for linux too.
Run it with the scheduler of your OS.
The backup-directory is synchronised with an owncloud-instance especially for my customers,
https and with an encrypted filesystem.
Regards,
Jan
Last edit: Janvl 2015-12-11
Like the idea. Especially if chromis asks to do backup (maybe even to dropbox) and full system shutdown on exit.
Its all perfect done with a script which starts a batchfile i found i think in the unicenta forum, but maybe it is also here now..
It makes a "mysqldump" ... is packing the sql file over the comandline with "7z" automatically to the dropbox folder. And all integrated with a button in the pos...
Easier it is not possible and i think there are more important and more dificult problems to solve for the developer team...
Loading financial Data onto Dropbox is not exactly compliant with the most basic security-rules. Olly describes Automysql.bat, starting it with the windows scheduler makes it invisible for the user, install and forget. Just check once in a while. And do not use Dropbox.
Thanks for the security advice, but using dropbox with viivo... there is no problem.
Only the plain passwords in the batch-file is maybe a problem but if you cannot trust your employers, better you close your store....