/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

1 vote361 views3 answers
Install atom ubuntu terminal
Shell/Bash
4 votes312 views4 answers
Git squash
Shell/Bash
13 votes330 views2 answers
Find npm version
Shell/Bash
0 vote324 views1 answer
Cmake must be installed to build dlib
Shell/Bash
1 vote319 views1 answer
Dos delete
Shell/Bash
2 votes346 views1 answer
Bash get path from filename
Shell/Bash
8 votes316 views2 answers
Bash script: replace . with :
Shell/Bash
0 vote327 views1 answer
Cache github credentials ubuntu
Shell/Bash
0 vote364 views1 answer
Powershell http request
Shell/Bash
5 votes307 views3 answers
Set git editor
Shell/Bash