Simple mysql database backup
https://github.com/openSUSE/mysql-backupscript
This package contains a simple mysql database backup script
running daily.
To restore, simply 'cd' into the backup directory of your
choise (configured in %{_sysconfdir}/sysconfig/mysql-backupscript),
bunzip2 the database file you want to restore and run:
mysql < $dbfile
That's it. The script also copies your %{_sysconfdir}/my.cnf away, so
you have something at hand if you played too much with the
settings there ;-)
More information can be found in
%{_docdir}/%{name}/README.SUSE
-
1
derived packages
- Download package
-
Checkout Package
osc -A https://api.opensuse.org checkout home:lrupp/mysql-backupscript && cd $_ - Create Badge
Refresh
Refresh
Source Files
| Filename | Size | Changed |
|---|---|---|
| LICENSE | 0000001511 1.48 KB | |
| README.SUSE | 0000001383 1.35 KB | |
| mysql-backup.logrotate | 0000000146 146 Bytes | |
| mysql-backup.sysconfig | 0000006372 6.22 KB | |
| mysql-backupscript | 0000011165 10.9 KB | |
| mysql-backupscript.changes | 0000008486 8.29 KB | |
| mysql-backupscript.service | 0000000133 133 Bytes | |
| mysql-backupscript.spec | 0000004643 4.53 KB | |
| mysql-backupscript.timer | 0000000146 146 Bytes | |
| mysql_start_galera_sync_after_dump.sh | 0000000406 406 Bytes | |
| mysql_start_slave_after_dump.sh | 0000000395 395 Bytes | |
| mysql_stop_galera_sync_before_dump.sh | 0000000428 428 Bytes | |
| mysql_stop_slave_before_dump.sh | 0000000419 419 Bytes |
Revision 47 (latest revision is 51)
Lars Vogdt (lrupp)
committed
(revision 47)
- update to 2.0.8: + enhanced default dump options and make them configurable. Added options: * --add-drop-database and --add-drop-table (replace the former manual entries) * --add-drop-trigger * --apply-slave-statements * --dump-date * --extended-insert * --flush-logs * --flush-privileges * --include-master-host-port * --master-data This should allow to use the dump also to setup a slave server directly.
Comments 0