/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 vote350 views1 answer
Connection failed blueman.bluez.errors.dbusfailederror protocol not available
Shell/Bash
0 vote313 views10 answers
How install hub
Shell/Bash
1 vote336 views1 answer
How to prevent ubuntu from sleeping when lid is closed
Shell/Bash
0 vote304 views1 answer
Termux comandos hack
Shell/Bash
0 vote324 views2 answers
Nano linenumber
Shell/Bash
0 vote322 views1 answer
How to erase folder that match characters in linux
Shell/Bash
0 vote294 views1 answer
REMOTE HOST IDENTIFICATION HAS CHANGED! how to fix in ubuntu
Shell/Bash
3 votes393 views3 answers
Github how to clone private repo
Shell/Bash
2 votes327 views1 answer
Linux search for previous commands
Shell/Bash
3 votes325 views3 answers
Firebase environment variables
Shell/Bash