Access mysql remote server using command line

mysql.sh

# if you dont have the tool
#   apt-get install mysql-client

mysql -u [USER] -p[PASS] -h [REMOTE_HOST] [DATABASE_NAME]

# after this commmand, the prompt will be
#   mysql> 

# and will accept SQL commands
#   mysql> Select * from yourtable;

# type exit when you are finished
#   mysql> exit

# database dump
mysqldump -u [USER] -p[PASS] -h [REMOTE_HOST] [DATABASE_NAME] > database_dump.sql

# dump all databases
mysqldump -u [USER] -p[PASS] -h [REMOTE_HOST] --all-databases > all_databases_dump.sql

#local file to remote server
mysql -u [USER] -p[PASS] -h [REMOTE_HOST] [DATABASE_NAME] < file.sql


#from terminal, display the size of all databases
SELECT table_schema "database", sum(data_length + index_length)/1024/1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema;