Last active
July 18, 2020 19:20
-
-
Save mberizzo/0898b075a120e7d33ce4 to your computer and use it in GitHub Desktop.
Ubuntu install LAMP - commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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