/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 vote206 views1 answer
Npm port already in use
Shell/Bash
-1 vote240 views1 answer
Odoo 14 install ubuntu 20.04
Shell/Bash
0 vote209 views1 answer
How to uninstall ngrok
Shell/Bash
0 vote198 views1 answer
Kubectl get taints
Shell/Bash
0 vote219 views1 answer
Parquet tools install mac
Shell/Bash
12 votes208 views1 answer
Dir in file txt
Shell/Bash
0 vote164 views1 answer
Scrollmagic npm
Shell/Bash
0 vote190 views1 answer
How to save history of commands in linux
Shell/Bash
0 vote197 views1 answer
Install parallel in ubuntu
Shell/Bash
1 vote219 views1 answer
Bily-101 github
Shell/Bash