Import and Export Database via terminal

IMPORT

• mysql -u root -pasdf dbname < db.sql (import .sql ke database bisa berupa per-table atau)
• gunzip < db.sql.gz | mysql -u root -pasdf dbname (import .gz file ke database. ukuran lebih kecil)

EXPORT

• mysqldump -u root -pasdf --extended-insert --add-drop-table dbname > dbname.sql (export ke .sql)
• mysqldump -u root -pasdf --extended-insert --add-drop-table dbname | gzip > dbname.sql.gz (export ke .gz)
• mysqldump -u root -pasdf --extended-insert --add-drop-table dbname tablename | gzip > tablename.sql.gz (export tabel ke .gz)

Posted in: MYSQL