Thanks Dan - Quick question -
I have a db named content with user "admin" and pass "mypass" Do I still use -u root p maypass ? or would I use mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to Thanks again for your help. Mark -----Original Message----- From: Dan Patnaude <[EMAIL PROTECTED]> To: Mark Stringham <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, March 13, 2002 10:41 AM Subject: Re: mysql hotcopy >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 > --------------------------------------------------------------------- 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