/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 vote299 views1 answer
GIT starting an Interactive Rebase session
Shell/Bash
0 vote314 views1 answer
No module named 'numpy'
Shell/Bash
4 votes301 views1 answer
Install spectral tensorflow pip
Shell/Bash
7 votes329 views1 answer
Current location bash
Shell/Bash
6 votes337 views3 answers
How to completely remove apps ubuntu package
Shell/Bash
0 vote322 views1 answer
Sed script "etc/psswd"
Shell/Bash
22 votes309 views1 answer
Xcode-selec not working
Shell/Bash
0 vote301 views1 answer
Ubuntu add entry to /etc/apt/sources.list
Shell/Bash
0 vote345 views1 answer
Height not divisible by 2 (3308x1975) Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height
Shell/Bash
0 vote337 views1 answer
Mac update path permanently
Shell/Bash