/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 vote213 views2 answers
Adding in ssh agent
Shell/Bash
-1 vote161 views1 answer
How to send email with body and attachment in unix
Shell/Bash
4 votes214 views2 answers
Grep but exclude directory
Shell/Bash
0 vote206 views1 answer
Wait-on yarn
Shell/Bash
0 vote185 views1 answer
Git ignore added folder
Shell/Bash
0 vote185 views1 answer
Information about files linux
Shell/Bash
11 votes265 views2 answers
Github add image to readme.md
Shell/Bash
0 vote227 views1 answer
Git search all commits for string
Shell/Bash
0 vote223 views1 answer
Iris eyesaver
Shell/Bash
0 vote226 views1 answer
Change to drive in batch files
Shell/Bash