/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 vote272 views1 answer
List threads in process ubuntu
Shell/Bash
1 vote277 views1 answer
How to delete images older than x days from docker hub
Shell/Bash
10 votes264 views6 answers
Lf will be replaced by crlf
Shell/Bash
0 vote276 views1 answer
1 exception(s): Exception #0 (Magento\Framework\Exception\RuntimeException): Type Error occurred when creating object: Signature\LockersCarrier\Model\Carrier\LockersCarrier
Shell/Bash
-1 vote267 views2 answers
Migrate fresh
Shell/Bash
0 vote297 views1 answer
Git get all branches and code
Shell/Bash
0 vote256 views1 answer
How to get data from pc to cluster
Shell/Bash
5 votes273 views1 answer
Install dependencies react project material ui
Shell/Bash
8 votes259 views3 answers
Untar ubuntu
Shell/Bash
1 vote269 views1 answer
Install rematch
Shell/Bash