General mysqldump create table if not exists January 2, 2019 Pramod T P Leave a comment Issue the following command mysqldump -p --no-data -e DATABASE_NAME | sed 's/^CREATE TABLE /CREATE TABLE IF NOT EXISTS /' > DATABASE_NAME.sql