/Shell/Bash/Upload sql database in devilbox

Upload sql database in devilbox

# Navigate to the Devilbox directory
host> cd path/to/devilbox

# Enter the PHP container
host> ./shell.sh

# Create new database if not present
mysql -u root -h 127.0.0.1 -p -e 'CREATE DATABASE my_wp;'
# OR START MYSQL THEN CREATE DATABASE
mysql -u root -h mysql
CREATE DATABASE my_database

# Start the import
mysql -h mysql -u root -p my_db_name < /shared/backups/mysql/my_db_name.sql

Source: devilbox.readthedocs.io

Similar codes

-2 votes376 views3 answers
Docker-compose centos 7
Shell/Bash
0 vote345 views1 answer
K8s rollout
Shell/Bash
0 vote358 views1 answer
Bash check if string ends with slash
Shell/Bash
8 votes375 views2 answers
Jest install
Shell/Bash
0 vote357 views1 answer
Zsh history by tab
Shell/Bash
0 vote336 views1 answer
Bash send email from script
Shell/Bash
0 vote351 views1 answer
Push empty git commit
Shell/Bash
3 votes351 views1 answer
Cmake: not found
Shell/Bash
2 votes372 views1 answer
How to scp or ssh to gcp instance
Shell/Bash
0 vote337 views1 answer
How to pass a user defined argument in scrapy spider
Shell/Bash