Linux/Mysql

From Wiki
< Linux
Revision as of 06:20, 13 March 2019 by Marcluer (talk | contribs)

List Databases

mysql -u root -p
show databases;
 
or

mysql -u root -p -e 'show databases;'

Dump Database

mysqldump -u root -p databasename > databasename.sql

mysqldump -u root -p --quick --add-drop-table --complete-insert --allow-keywords databasename > databasename.sql