Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
1,190
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. mysqldump --user=username --password=password db_name table_name --where=date_pulled > '2014-07-21 16:25:00' > backup.sql
  2.  
  3. SELECT * FROM table_name
  4. WHERE date_pulled > '2014-07-21 16:25:00'
  5. INTO OUTFILE 'table_name.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n';
  6.  
  7. [mysqld]
  8. log-bin=/path/to/binlogs/mysql-bin
  9. expire-logs-days=14
  10.  
  11. MYSQL_USER=root
  12. MYSQL_PASS=rootpassword
  13. MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
  14. MYSQLDUMP_OPTIONS="--routines --triggers --flush-logs"
  15. MYSQLDUMP_OPTIONS="${MYSQLDUMP_OPTIONS} --master-data=2 --all-databases"
  16. mysqldump ${MYSQL_CONN} ${MYSQLDUMP_OPTIONS} > FullBackup.sql
  17.  
  18. 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