Dum mysql db with cli

# export mysql
mysqldump -h localhost -u username -p dbname > filename.sql


# restore / import mysql
mysqldump -h localhost -u username -p dbname < filename.sql

Source: grepper.com

Similar codes

1 vote135 views1 answer
Required Windows feature(s) not enabled : Hyper-V and Containers
Shell/Bash
0 vote130 views1 answer
How to get server ip address centos
Shell/Bash
0 vote142 views1 answer
Ubuntu not showing video thumbnails
Shell/Bash
35 votes134 views4 answers
Brew in mac
Shell/Bash
0 vote153 views1 answer
Install any desc ubunto
Shell/Bash
0 vote143 views1 answer
Embed a youtube video in github readme
Shell/Bash
0 vote133 views1 answer
How to compress all branches on branch into one branch back to the master
Shell/Bash
-1 vote164 views1 answer
Debian restart service
Shell/Bash
3 votes125 views1 answer
Bash delete env variable
Shell/Bash
0 vote140 views1 answer
Not found 91.189.88.142 ubuntu
Shell/Bash