Linux/Mysql: Difference between revisions

From Wiki
No edit summary
Line 16: Line 16:


mysqldump -u root -p --quick --add-drop-table --complete-insert --allow-keywords databasename > databasename.sql
mysqldump -u root -p --quick --add-drop-table --complete-insert --allow-keywords databasename > databasename.sql
</pre>
== Dump Database from Docker ==
<pre>
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
</pre>
</pre>



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

Dump Database from Docker

docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

Import Database

mysql -u root -p databasename < databasename.sql

Import Database in Docker

docker exec -i mysql-container mysql -uuser -ppassword name_db < data.sql