/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

0 vote180 views1 answer
Diff from last commit
Shell/Bash
68 votes187 views6 answers
Kill port 3000 ubuntu
Shell/Bash
0 vote198 views8 answers
Create swapfile ubuntu
Shell/Bash
1 vote229 views1 answer
Nginx: [alert] could not open error log file: open() "/var/log/nginx/error.log" failed (13: Permission denied)
Shell/Bash
1 vote178 views1 answer
Appcenter codepush remove release
Shell/Bash
1 vote253 views3 answers
Bash: /bin/rm: Argument list too long
Shell/Bash
1 vote221 views1 answer
How to install golang on manjaro
Shell/Bash
0 vote184 views1 answer
Bash sum
Shell/Bash
3 votes212 views3 answers
Tensorflow docker hub
Shell/Bash
0 vote181 views1 answer
Date fns install
Shell/Bash