/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

6 votes140 views2 answers
Install jenkins on ubuntu 20.04
Shell/Bash
0 vote173 views1 answer
Wget multiple urls from file
Shell/Bash
10 votes146 views1 answer
Install brave browser download
Shell/Bash
5 votes141 views1 answer
How to view all the history of all your commands in linux
Shell/Bash
0 vote189 views1 answer
Awk uppercase first character
Shell/Bash
5 votes179 views4 answers
Windows cmd remove a not empty directory
Shell/Bash
25 votes140 views2 answers
Untar xz
Shell/Bash
1 vote150 views1 answer
Cat create file
Shell/Bash
1 vote211 views1 answer
Check go is installed mac
Shell/Bash
73 votes142 views4 answers
Git pull hard
Shell/Bash