On linux terminal by using native mysql client tools:

$mysqldump -u yourUsername -h 127.0.0.1 -p yourPassword > interac.20191023.sql ==> step 1 = backup

$cp -i yourPrivateKey.pem interac.20191023.sql yourUsername@EC2_instance_name.us-east-2.compute.amazonaws.com:/file_path_to_destiantion_folder/ ==> step 2 = copy

$pv 20191008-interac.sql | mysql -u admin -p -h db_Name.czesu1azy0cv.us-east-2 .rds.amazonaws.com databaseName ==> step 3 = restore

(pv stands for progress view)

default mysql username and password for maintenance is at /etc/mysql/debian.cnf

Other SQL commands:

>SELECT @@version = Check SQL version and edition

>DBCC CHECKDB (database_name) = Run a database consistency check

>SELECT * FROM information_schema.user_privileges; = display all users and their privileges

>SELECT COUNT(*) FROM Database.TableName WHERE ColumnName='nameOfColumn'

>SELECT column1,column2 FROM Database.TableName LIMIT 10