/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

136 votes207 views4 answers
Install boostrap react
Shell/Bash
0 vote152 views1 answer
Heroku clone database local
Shell/Bash
0 vote147 views1 answer
Remove all files named ubuntu
Shell/Bash
0 vote136 views1 answer
Avoid github credentials
Shell/Bash
0 vote143 views1 answer
How to install prettier globally on mac
Shell/Bash
0 vote143 views1 answer
Ubuntu install opencl
Shell/Bash
0 vote130 views1 answer
Change php version devilbox fish
Shell/Bash
0 vote149 views1 answer
How to see incognito history?
Shell/Bash
3 votes171 views1 answer
How can you identify zombie processes on the Linux system
Shell/Bash
0 vote139 views1 answer
Ubuntu second monitor not working after update
Shell/Bash