yes mysqldump database name >filename.sql where database name is the name of the database to dump and filename.sql is the file to dump it into including a valid pathname..
it will dump everything into the text file as valid mysql statements that will let you run the script again.. actually when you mysqldump the db into a file it creates a script that can be ran to restore the db back to the original state of the db right before the dump.. ----- Original Message ----- From: "Octavian Rasnita" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 3:09 PM Subject: Dumping a database > Hi all, > > I've seen that it is very easy to export an entire database using mysqldump. > > Can I export any database using this program? > > Will it export the sql statements for creating indexes, and the binary > fields? > > Can I restore any database exported with this method without any problem? > > Thank you. > > Teddy, > Teddy's Center: http://teddy.fcc.ro/ > Email: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php