/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 vote323 views1 answer
Install gem ubuntu
Shell/Bash
0 vote367 views1 answer
Bash curl forecast
Shell/Bash
9 votes337 views4 answers
How to update visual studio code through ubuntu terninal
Shell/Bash
0 vote309 views1 answer
Inspect changes after git fetch
Shell/Bash
0 vote320 views1 answer
Install bc command mac
Shell/Bash
0 vote315 views1 answer
How to install hashcat
Shell/Bash
0 vote296 views1 answer
Add a picture to readme.md
Shell/Bash
0 vote348 views1 answer
Keep ec2 instance connected on command line
Shell/Bash
0 vote332 views1 answer
How to reslove Jira Software is licensed but not currently installed
Shell/Bash
0 vote343 views1 answer
Git cherry pick chain
Shell/Bash