Linux/Mysql: Difference between revisions
< Linux
Line 31: | Line 31: | ||
<pre> | <pre> | ||
docker exec -i mysql-container mysql -uuser -ppassword name_db < data.sql | docker exec -i mysql-container mysql -uuser -ppassword name_db < data.sql | ||
</pre> | |||
docker-compose: | |||
<pre> | |||
volumes: | |||
- ./dump.sql:/docker-entrypoint-initdb.d/dump.sql | |||
</pre> | </pre> | ||
[[Category:Linux]] | [[Category:Linux]] | ||
[[Category:Linux/Services]] | [[Category:Linux/Services]] |
Revision as of 07:17, 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
docker-compose:
volumes: - ./dump.sql:/docker-entrypoint-initdb.d/dump.sql