backup mysql hanya schema

spring boot inisialisasi aplikasi menggunakan file schema.sql

Bismillah

q> Bagaimana caranya backup database hanya schema saja ?

mysqldump -u root -p --no-data dbname > schema.sql

q> Ayo test, misalnya pada mysql terdapat database db_primary, maka

mysqldump -uroot -p --no-data db_primary > schema_primary.sql

Alhamdulillah

Published by

saifiahmada

Begin a big Process with a bit trying

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s