Documentation

MySQL Reference

We have put together some easy to use notes for using MySQL with Sequel Pro.

The official documentation for MySQL is at dev.mysql.com and you can get specific information about the MySQL server version you are running:

Run the following query in the Custom Query tab:

 SET PASSWORD = PASSWORD('parrot');

Type Password at a Prompt

mysql -h 127.0.0.1 -u db_user -p db_name < import_file.sql

Include Password in Command

mysql -h 127.0.0.1 -u db_user -psecretpassword db_name < import_file.sql

mysqldump -h 127.0.0.1 -u db_user -p db_name > import_file.sql

mysqldump -h 127.0.0.1 -u db_user -psecretpassword db_name > import_file.sql

You can run the following command to get a list of the databases on your server and the size in MB they are consuming:

SELECT table_schema "My databases", sum( data_length + index_length ) / 1024 / 1024 "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;