Re: mysql dump not working
At 16:27 -0700 1/17/03, Zak Greant wrote: On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? Hi Mark, To rephrase: If you run the command mysqldump -u uipcontent -p test on the command line, what happens? It'll probably say that the database "" does not exist. :-) Don't put a space between -p and the password . Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Houston, February 17-21, 2003 Visit http://mysql.com/training for more information Open Source Initiative (http://www.opensource.org) - 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
Re: mysql dump not working
On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > sql, query > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > advanced server. I'm running a BAT file with the following syntax > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > c:\testdump.sql > > the file testdump.sql gets created in the appropriate place but the > file itself has nothing in it. > > I'm obviously missing something. Do you see any output when you run mysqldump without redirecting stdout? -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information Support Global Human Rights - Amnesty International (http://amnesty.org) - 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
Re: mysql dump not working
On Fri, Jan 17, 2003 at 04:24:37PM -0700, Mark Stringham wrote: > I'm not sure what you mean but the file gets created and when I open > it - there is nothing in it. > > Do I need the path to mysql at the beginning ? IE > c:\apache\mysql\bin>mysqldump ? Hi Mark, To rephrase: If you run the command mysqldump -u uipcontent -p test on the command line, what happens? Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Houston, February 17-21, 2003 Visit http://mysql.com/training for more information Open Source Initiative (http://www.opensource.org) - 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
Re: mysql dump not working
I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? thanks MS > On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > > sql, query > > > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > > advanced server. I'm running a BAT file with the following syntax > > > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > > c:\testdump.sql > > > > the file testdump.sql gets created in the appropriate place but the > > file itself has nothing in it. > > > > I'm obviously missing something. > > Do you see any output when you run mysqldump without redirecting > stdout? > > -- > Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com > > Managing MySQL > MySQL Training: Washington DC, March 19-21, 2003 > Visit http://mysql.com/training for more information > > Support Global Human Rights - Amnesty International (http://amnesty.org) > > Mark Stringham edea solutions 801.808.8791 - 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
Re: mysql dump not working
I'm not sure what you mean but the file gets created and when I open it - there is nothing in it. Do I need the path to mysql at the beginning ? IE c:\apache\mysql\bin>mysqldump ? thanks MS > On Fri, Jan 17, 2003 at 04:12:58PM -0700, Mark Stringham wrote: > > sql, query > > > > I'm trying to utilize the mysqldump utility to backup my db on a WIN2k > > advanced server. I'm running a BAT file with the following syntax > > > > c:\apache\mysql\bin>mysqldump -u uipcontent -p test > > > c:\testdump.sql > > > > the file testdump.sql gets created in the appropriate place but the > > file itself has nothing in it. > > > > I'm obviously missing something. > > Do you see any output when you run mysqldump without redirecting > stdout? > > -- > Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com > > Managing MySQL > MySQL Training: Washington DC, March 19-21, 2003 > Visit http://mysql.com/training for more information > > Support Global Human Rights - Amnesty International (http://amnesty.org) > > Mark Stringham edea solutions 801.808.8791 - 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
mysql dump not working
sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\bin>mysqldump -u uipcontent -p test > c:\testdump.sql the file testdump.sql gets created in the appropriate place but the file itself has nothing in it. I'm obviously missing something. Any help is appreciated Mark - 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
mysql dump not working
sql, query I'm trying to utilize the mysqldump utility to backup my db on a WIN2k advanced server. I'm running a BAT file with the following syntax c:\apache\mysql\bin>mysqldump -u uipcontent -p test > c:\testdump.sql the file testdump.sql gets created in the appropriate place but the file itself has nothing in it. I'm obviously missing something. Any help is appreciated Mark - 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