Tips & Trick Backup Data Pada MYSQL

• Backup Hanya Data : shell>mysqldump -u root -p -h localhost --tables --no-create-db --no-create-info dbName table1 table2>fileName.sql.

• Backup Hanya Struktur : shell>mysqldump -d -u root -p -h localhost dbName>fileName.sql