/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

1 vote183 views1 answer
Find files created in last 20 days
Shell/Bash
0 vote177 views3 answers
Linux find partial name
Shell/Bash
7 votes158 views2 answers
Kubectl cleanup pods
Shell/Bash
2 votes233 views1 answer
Git orphan branch
Shell/Bash
0 vote197 views1 answer
Apt install jack audio
Shell/Bash
0 vote159 views1 answer
AttributeError: module 'tensorflow.python.training.training' has no attribute 'list_variables'
Shell/Bash
8 votes170 views3 answers
How to undo a commit sent that was pushed
Shell/Bash
0 vote190 views1 answer
Shell nohup
Shell/Bash
0 vote178 views1 answer
Install razer synapse ubuntu
Shell/Bash
21 votes175 views5 answers
Homebrew linux
Shell/Bash