Linux and UNIX Systems Configuration Help, How To, Tutorial and Basic Information

  • Decrease font size
  • Default font size
  • Increase font size
  • default color
  • red color
  • green color
Home How To Database How to Export A MySQL Database Structures
How to Export A MySQL Database Structures PDF Print E-mail
Thursday, 03 December 2009 12:59
AddThis Social Bookmark Button
If You need to export only the MySQL database's tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql
 

Comments  

 
0 #1 David 2009-12-07 09:45
mysqldump -u username -ppassword –no-data database_name > dump.sql

You can provide this command as

mysqldump -u {server_usernam e} -p{server_passwo rd} –no-data {database_name} > dump.sql

Where password argument entering without space -p{server_passwo rd}
Quote
 

Add comment


Security code
Refresh

Latest News

Tags

by Zaragoza Online

Friends

Thanks David Ayvazyan for provided useful information and discussions.
www.gnu.am (Armenian Translation)