/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

2 votes239 views2 answers
Ffmpeg scale but keep aspect ratio
Shell/Bash
0 vote209 views1 answer
Ubuntu permission all file in folder
Shell/Bash
6 votes228 views2 answers
Extract rar linux
Shell/Bash
28 votes239 views5 answers
Git stash save untracked
Shell/Bash
0 vote217 views1 answer
How to install image app in linux using terminal
Shell/Bash
8 votes260 views3 answers
Install cocoapods
Shell/Bash
12 votes237 views5 answers
Restart postgres ubuntu
Shell/Bash
0 vote211 views1 answer
Hadoop hive get time from timestamp
Shell/Bash
2 votes247 views1 answer
Debian show installed packages
Shell/Bash
124 votes235 views6 answers
Git change remote origin
Shell/Bash