Make homepage|Add to favorites

reviews, articles, tips & snippets

Buy SQL » Tag Cloud » backup

MySQL cheat sheet

Author: Dicentis on 1-11-2011, 18:15

MySQL cheat sheet notepadWhen developing an internet site, you may often see developers making recurring mistakes when designing databases.

Today I decided to publish own FAQ answers for working with MySQL.




Working with MySQL backups

Creating a backup:

mysqldump -u USER -pPASSWORD DATABASE > /path/to/file/dump.sql

Creating a database structure without data:
mysqldump --no-data - u USER -pPASSWORD DATABASE > /path/to/file/schema.sql