Skip to main content

Dumping MySQL tables schema's out to file


  • The mysqldump command line program does this for you - although the docs are very unclear about this.
  • One thing to note is that ~/output/dir has to be writable by the user that owns mysqld. On Mac OS X:
  • sudo chown -R _mysqld:_mysqld ~/output/dir
mysqldump --user=dbuser --password --tab=~/output/dir dbname
  • After running the above, you will have one tablename.sql file containing each table's schema create table statement) and tablename.txt file containing the data.
  • If you want a dump with schema only, add the --no-data flag:
  • mysqldump --user=dbuser --password --no-data --tab=~/output/dir dbname

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more