/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

3 votes180 views1 answer
Delete floder linux
Shell/Bash
0 vote159 views1 answer
Slack is not opening ubuntu 22
Shell/Bash
-1 vote178 views1 answer
Installing Docker Engine in Linux/Ubuntu
Shell/Bash
0 vote199 views1 answer
Git raname file
Shell/Bash
0 vote195 views1 answer
Powershell scape quotes
Shell/Bash
0 vote201 views1 answer
Bash start two processes at the same time
Shell/Bash
1 vote209 views2 answers
Create github repo with curl
Shell/Bash
0 vote193 views1 answer
How to check the installed version of React-Native
Shell/Bash
0 vote188 views1 answer
Ubuntu 20.04 install google cloud sdk
Shell/Bash
0 vote150 views1 answer
Output text after specific character powershell
Shell/Bash