Linux/Mysql: Difference between revisions
< Linux
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
show databases; | show databases; | ||
mysql -u root -p -e 'show databases;' | mysql -u root -p -e 'show databases;' | ||
</pre> | </pre> | ||
<pre> | <pre> | ||
echo "show databases;" | mysql | |||
</pre> | </pre> | ||
Revision as of 06:24, 13 March 2019
List Databases
mysql -u root -p show databases; mysql -u root -p -e 'show databases;'
echo "show databases;" | mysql
Dump Database
mysqldump -u root -p databasename > databasename.sql mysqldump -u root -p --quick --add-drop-table --complete-insert --allow-keywords databasename > databasename.sql