/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

23 votes286 views4 answers
Remove a non empty directory
Shell/Bash
0 vote284 views1 answer
Linux find filetype
Shell/Bash
1 vote302 views4 answers
Remove git tag
Shell/Bash
-1 vote319 views1 answer
Change date and time in kali linux 2021
Shell/Bash
3 votes269 views1 answer
Run docker image ubuntu
Shell/Bash
6 votes303 views4 answers
Kill process in win by pid
Shell/Bash
0 vote289 views1 answer
Xrandr non cambia la luminosità
Shell/Bash
0 vote288 views1 answer
Powershell elevate to admin within a function
Shell/Bash
17 votes303 views3 answers
Check if port is running in ubuntu
Shell/Bash
3 votes320 views1 answer
Delete files with a certain extension recursively
Shell/Bash