/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

9 votes312 views5 answers
Check react version
Shell/Bash
0 vote261 views1 answer
Bash source in lxc
Shell/Bash
0 vote296 views1 answer
Npm TypeError [ERR_INVALID_ARG_TYPE]:
Shell/Bash
0 vote249 views1 answer
Node-gyp rebuild
Shell/Bash
148 votes330 views10 answers
Grepper
Shell/Bash
1 vote267 views1 answer
Stop minikube
Shell/Bash
1 vote253 views5 answers
Install adb
Shell/Bash
8 votes272 views1 answer
Git forget local commits to branch
Shell/Bash
0 vote266 views1 answer
Yarn equivalent of npm ci
Shell/Bash
0 vote257 views1 answer
Ubuntu open with software install not working
Shell/Bash