/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 vote159 views1 answer
Trying to bind fd 26 to <0.0.0.0:443>: errno=13
Shell/Bash
0 vote152 views2 answers
Rvm
Shell/Bash
89 votes167 views6 answers
Npm cache clean force
Shell/Bash
0 vote152 views1 answer
Ip route delete linux
Shell/Bash
1 vote155 views1 answer
K8 svc url
Shell/Bash
0 vote114 views1 answer
Install ansible
Shell/Bash
0 vote153 views1 answer
How to install vim through powershell
Shell/Bash
0 vote147 views1 answer
Bash regex match
Shell/Bash
0 vote154 views1 answer
Minify json python
Shell/Bash
1 vote219 views1 answer
Wc bash
Shell/Bash