Mysql backup restore shell

mysql databasename -ukullanici_adi -psifre < restore_dosyasi.sql

mysqldump -ukullanici_adi -psifre databasename > backup_dosyasi.sql

vim ~/.my.cnf
[mysqldump]
column-statistics=0

mysqldump -u user_name -p -h ip_address --databases database_name --where="1 limit 30">output.sql