SHARE
TWEET

Untitled

a guest Jun 15th, 2019 628 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top