/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 vote221 views3 answers
Where does pgadmin save backups in ubuntu
Shell/Bash
0 vote213 views1 answer
Sum of array elements bash
Shell/Bash
15 votes221 views2 answers
Linux change username
Shell/Bash
1 vote178 views1 answer
Install fzf linux
Shell/Bash
2 votes226 views1 answer
Ubuntu top bar hide
Shell/Bash
35 votes231 views4 answers
Npm uninstall eslint
Shell/Bash
1 vote212 views1 answer
Install typescript in gatsby
Shell/Bash
1 vote221 views1 answer
Powershell connect to serial port
Shell/Bash
0 vote212 views1 answer
Linux waitptid function
Shell/Bash
3 votes204 views3 answers
Install next-auth
Shell/Bash