Anonymous

Changes

From NixNet
m
remove dir path for compressed mysql dump
*Delete a row: <code>DELETE FROM table WHERE column=value;</code>
*Dumping databases for backups: <code>mysqldump dbname > dbname_$(date -u -Iseconds).sql</code> (run as shell command)
**Dumps with compression: <code>mysqldump dbname | gzip -c - > /root/dumps/dbname_$(date -u -Iseconds).sql.gz</code>
*Restore database from backup: <code>mysql dbname < backup.sql</code>
**With compression: <code>gunzip backup.sql.gz</code> then run command above