common linux commands.md

rsync - copy / synchronization

copy file: copy file 'backup.18-11-2017_09:40:15.fbsale.sql' from remote server to local file 'www/backup.18-11-2017_09:40:15.fbsale.sql'

rsync -avzP root@{server-ip}:/data/backup/backup.18-11-2017_09:40:15.fbsale.sql /var/www/backup.18-11-2017_09:40:15.fbsale.sql

copy folder: copy all files from remote server's folder 'backup', to local folder 'backup'

rsync -avzP root@{server-ip}:/data/backup/* /var/www/backup/

copy large MySQL database

reference https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html

mkdir DUMPDIR
mysqldump --tab=DUMPDIR db_name --username='root' --password='yourpassword'

mysqladmin create db_name           # create database
cat DUMPDIR/*.sql | mysql db_name   # create tables in database
mysqlimport --username='root' --password='yourpassword' db_name DUMPDIR/*.txt   # load data into tables

export MySQL and excude some tables

mysqldump --user='username' --password='password' database --ignore-table=database.table1 --ignore-table=database.table2 --ignore-table=database.table3 > database_backup.sql

fast clone a local database

create a new database: new_database

 mysqldump -u root old_database | mysql -u root new_database