mysqldump - Base 64

Useful commands to setup MySQL in Docker

mysql mysqldump docker import export

Create a MySQL Docker container docker run --name my-container-name -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql Login to Docker container bash / terminal docker exec -it mysql bash Create MySQL database in Docker In order to create the database you'll first need to login to

Export single table MySQL

mysql mysqldump error 2020 max_allowed_packet export table

If you receive the following error: Error 2020: Got packet bigger than max_allowed_packet bytes when dumping table This normally occurs as a result of a particular table exceeding the max_allowed_packet size. This can be solved by exporting a single table