Make homepage|Add to favorites
 

MYSQL TOOLS
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