Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqldump --user=username --password=password db_name table_name --where=date_pulled > '2014-07-21 16:25:00' > backup.sql
- SELECT * FROM table_name
- WHERE date_pulled > '2014-07-21 16:25:00'
- INTO OUTFILE 'table_name.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n';
- [mysqld]
- log-bin=/path/to/binlogs/mysql-bin
- expire-logs-days=14
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- MYSQLDUMP_OPTIONS="--routines --triggers --flush-logs"
- MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=2 --all-databases"
- mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} > FullBackup.sql
- mysqlbinlog --start-datetime="2016-11-21 00:00:00" --stop-datetime="2016-11-21 23:59:59" mysql-bin.[0-9]* > Incremental_20161121.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement