Linux/Mysql: Difference between revisions

Revision as of 07:07, 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

Import Database

mysql -u root -p databasename < databasename.sql

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