mysqldump -u %UserName% -p %DbName% %TableName% > %FileName.sql%

mysql -u %UserName% -p %DbName%  < %FileName.sql%

gunzip < [backupfile.sql.gz] | mysql -u[username] -p[password] [database]

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'insert_password';