Linux/Mysql: Difference between revisions

From Wiki
No edit summary
No edit summary
Line 4: Line 4:
show databases;
show databases;
   
   
or
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