MySQL

SQL

List databases

show databases;

Open db

use dbname;

or

connect dbname;

List tables

show tables;

add .sql to MySQL database

TODO: REVISAR backup:

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

backup .sql.gz

mysql -uroot -ppassword mydb > myfile.sql.gz

restore:

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

restore .sql.gz

zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database