Dump MySQL Database without Drop Table Syntax

       

Output .sql file for MySQL but without the drop table syntax before table name use the --skip-add-drop-table flag


mysqldump -u root -p database_name --skip-add-drop-table --skip-lock-tables > database_name.sql

Tagged w/ #databases #flags #mysql #mysqldump #syntaxdatabases

Apps I've Built

PhotoLocationChanger
Easily change the location on your photos and videos
Click here for more info about the app
PhotoDateChanger
Easily change the dates and times on your photos and videos
Click here for more info about the app
VocabReminder
English dictionary with notifications so you won't forget what you're studying!
Click here for more info about the app
VocabQuiz
The app that quizzes and scores you on your vocabulary!
Click here for more info about the app