Sunday, June 30, 2013
mysql dump big tables with no load
mysqldump -u USER -p --single-transaction --quick --lock-tables=false DATABASE | gzip > OUTPUT.gz
Dump everything except table
mysqldump -u username -p database --ignore-table=database.table1 --ignore-table=database.table2 > database.sql
Permissions .ssh/id_dsa are too open. It is required that your private key files are NOT accessible by others.
bash-3.2$ ssh 4r@4r.lt @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: UNPROTECTED PRIVATE KEY FILE! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Permissions 0755 for '/Users/jj/.ssh/id_dsa' are too open. It is required that your private key files are NOT accessible by others. This private key will be ignored. bad permissions: ignore key: /Users/jj/.ssh/id_dsa Password: # SOLUTION bash-3.2$ sudo chmod -R 700 ~/.ssh Password: bash-3.2$ ssh 4r@4r.lt Last login: Sun Jun 30 21:55:50 2013 from 68.84.191.165 Copyright (c) 1980, 1983, 1986, 1988, 1990, 1991, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD 8.2-RELEASE (GENERIC) #0: Fri Feb 18 02:24:46 UTC 2011 Welcome to FreeBSD!
Subscribe to:
Posts (Atom)