/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

2 votes320 views1 answer
Ubuntu cleanup systemd journal
Shell/Bash
0 vote353 views1 answer
Cartesian product file shell
Shell/Bash
0 vote348 views1 answer
Send file from pc to raspberry pi
Shell/Bash
0 vote331 views1 answer
Npm_config_node_gyp
Shell/Bash
24 votes323 views6 answers
Xampp ubuntu
Shell/Bash
0 vote330 views1 answer
Bluetooth headphone not working linux mint
Shell/Bash
3 votes335 views2 answers
Laravel 7 composer install
Shell/Bash
2 votes343 views1 answer
Firebase rules deploy
Shell/Bash
13 votes312 views2 answers
Untar .tar file
Shell/Bash
0 vote323 views1 answer
Assing command to a variable
Shell/Bash