/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 vote165 views1 answer
Scp two remote devices
Shell/Bash
1 vote169 views1 answer
Stackoverflow most popular question
Shell/Bash
2 votes160 views1 answer
Restart a pod kubernetes
Shell/Bash
0 vote162 views1 answer
Installing qt ubuntu
Shell/Bash
0 vote158 views1 answer
Find pid of a port and kill the process in linux
Shell/Bash
2 votes170 views3 answers
Download folder github
Shell/Bash
0 vote180 views1 answer
Ubuntu show current path
Shell/Bash
3 votes211 views3 answers
Uninstall vscode linux
Shell/Bash
1 vote188 views1 answer
Powershell execute command only if previous successful
Shell/Bash
4 votes168 views4 answers
Vscode install-extension command line
Shell/Bash