/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 vote171 views1 answer
Bash how to define a path
Shell/Bash
0 vote197 views1 answer
Mover archivos linux ssh
Shell/Bash
0 vote204 views1 answer
Conda install libsndfile
Shell/Bash
7 votes172 views4 answers
Git delete local commit
Shell/Bash
3 votes177 views1 answer
Magento 2 file permission
Shell/Bash
0 vote206 views1 answer
Platform CLI
Shell/Bash
0 vote192 views1 answer
Error: Unable to find a match: centos-release-openstack-queens
Shell/Bash
0 vote186 views1 answer
How to run back and front simultaneously linux
Shell/Bash
1 vote166 views1 answer
Address already in use flask ubuntu
Shell/Bash
9 votes329 views4 answers
Revert to a particular commit git
Shell/Bash