/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

21 votes155 views2 answers
What is ssh
Shell/Bash
0 vote155 views1 answer
What to do with unstaged changes after reset
Shell/Bash
1 vote156 views1 answer
How to search all subfolders in linux for file
Shell/Bash
3 votes148 views2 answers
Adonis version
Shell/Bash
1 vote137 views1 answer
Git graphic log
Shell/Bash
0 vote146 views1 answer
Cartesian product file shell
Shell/Bash
1 vote134 views1 answer
Bash store string in variable
Shell/Bash
0 vote150 views1 answer
Ubuntu start sublime 3
Shell/Bash
0 vote148 views2 answers
The framework needs the following extension(s) installed and loaded: intl. at SYSTEMPATH\CodeIgniter.php:219
Shell/Bash
0 vote134 views1 answer
Install virtualmin
Shell/Bash