Linux/Mysql: Difference between revisions

Revision as of 06:20, 13 March 2019

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

@@ Line 14: / Line 14: @@
 == Dump Database ==
+<pre>
+mysqldump -u root -p databasename > databasename.sql
+mysqldump -u root -p --quick --add-drop-table --complete-insert --allow-keywords databasename > databasename.sql
+</pre>
 [[Category:Linux]]
 [[Category:Linux/Services]]