Try the following: mysqlhotcopy -u root -p <password> <dbname> /path/to/copy/the/data/to
so, if you want to copy the db "foobar", you do the following: mysqlhotcopy -u root -p <password> foobar /backup/data and a new dir will be created called /backup/data/foobar with all the tables there -dan On Wednesday 13 March 2002 11:45, you wrote: > Can anyone give me an example of how to run mysqlhotcopy from the command > line? What can I expect as the output and where is the file created/ > stored? > > Thanks > Mark > -----Original Message----- > From: Michael Grassman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tuesday, March 12, 2002 11:59 PM > Subject: xp and mysql 3.23.49-win > > >I am trying to install mysql for use with iis4 and when I click > >on the setup.exe file an error message pops up but closes > >right away so I can't see the problem. has anyone had this > >frustrating experiance. If so please help. > > > >Thank Mike > > > >--------------------------------------------------------------------- > >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 > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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