mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql
mysqldump -u USER -pPASSWORD DATABASE TABLE1 TABLE2 TABLE3 > /path/to/file/dump_table.sql
mysqldump -u USER -pPASSWORD DATABASE | gzip > /path/to/outputfile.sql.gz
mysqldump -u USER -pPASSWORD DATABASE | gzip > `date +/path/to/outputfile.sql.%Y%m%d.%H%M%S.gz`
mysql -u USER -pPASSWORD DATABASE < /path/to/dump.sql
gunzip < /path/to/outputfile.sql.gz | mysql -u USER -pPASSWORD DATABASE
zcat /path/to/outputfile.sql.gz | mysql -u USER -pPASSWORD DATABASE
mysqladmin -u USER -pPASSWORD create NEWDATABASE
-Q -c -e
, т.е. mysqldump -Q -c -e -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql
, где:mysqlshow -u USER -pPASSWORD
mysqlshow -u USER -pPASSWORD DATABASE
ssh -fNL LOCAL_PORT:localhost:3306 REMOTE_USER@REMOTE_HOST
SELECT * FROM table WHERE `datetime` = DATE(`timestamp`)