Adding -D to dump only data structure
Example :
$ mysqldump -h 127.0.0.1 -u root -p"something" -D database1 > db.sql#TIL : Mysql dumping only table structure
You may also like (related posts)
#TIL : Export MySQL data by specified query to CSV file
#TIL : Export MySQL data by specified query to CSV file
I learned on 2019-03-12 about cli, mysql
Build Sequel Pro from source in XCode 10
Sequel Pro is great GUI MySQL tool in macOS (it's open source and of course totally free)
#TIL : The safest way to reset root password of MySQL Server
#TIL : The safest way to reset root password of MySQL Server
I learned on 2018-08-25 about database, mysql, security, sysadmin
#TIL : Sleeping connections in MySQL
#TIL : Sleeping connections in MySQL
I learned on 2018-01-04 about db, mysql, web
Latest posts
Weighted Round Robin : Scheduling Algorithm
#TIL : Becareful on using port mapping of Docker in Development
#TIL : Becareful on using port mapping of Docker in Development
I learned on 2022-03-17 about docker, security
#TIL : Using extra hosts to add custom ip of hostnames to Docker container
#TIL : Using extra hosts to add custom ip of hostnames to Docker container
I learned on 2022-03-16 about docker, networking
#TIL : Laravel run scheduled command within parent environment
#TIL : Laravel run scheduled command within parent environment
I learned on 2022-03-15 about cronjob, laravel, php