Skip to content

Instantly share code, notes, and snippets.

@mberizzo
Last active July 18, 2020 19:20
Show Gist options
  • Save mberizzo/0898b075a120e7d33ce4 to your computer and use it in GitHub Desktop.
Save mberizzo/0898b075a120e7d33ce4 to your computer and use it in GitHub Desktop.
Ubuntu install LAMP - commands
You can import "file.sql" file using the standard input like this:
* mysql -u <user> -p <dbname> < file.sql
Import mysql database in laradock. Note: database "my-database-name" should be exists (empty)
docker-compose exec -T mysql mysql -uroot -proot my-database-name < /home/matias/Downloads/my-database-name.sql
Import all mysql databases
mysql -u root -p < all_databases.sql
You can export all mysql databases to "all_databases.sql"
* mysqldump -h localhost -u root -p --all-databases > all_databases.sql
You can export specific database to "dbname.sql"
* mysqldump -h localhost -u root -p dbname > dbname.sql
Install mcrypt:
* sudo apt-get install php5-mcrypt
* sudo php5enmod mcrypt
* sudo service apache2 restart
Copy from local to docker container:
* docker cp /home/matias/Downloads/app-routenavi-spatial.sql.tar.gz "$(docker-compose ps -q mysql)":/app-routenavi-spatial.sql.tar.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment