Re: mysqldump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 10-08-17 02:08 PM, tedd wrote:
Hi gang:

At 6:11 PM -0400 8/13/10, Daniel P. Brown wrote:
     Easiest method, from the command line on the server from which you
want to dump the database:

         mysqldump -u user -p database_name>  outfile.sql

Command is wrong... should be:

    mysqldump -u user -p password database_name > outfile.sql

That might be the easiest, but all I get is an empty file.

I've tried many different variations of the syntax using exec(), but
nothing produces any subsistent output. What am I doing wrong?

Have you checked the return code of running exec? It may be the mysqldump program isn't in your path.

As for accessing a command line, I am still in the dark as to how to do that.

In windows you can do Start -> Run -> cmd.exe to load the command prompt terminal. You could probably put the above mysqldump command directly into the run prompt, but I don't know what it's default path is... but a small tweak might be:

    C:\PATH\TO\mysqlump -u user -p password database_name > C:\outfile.sql

Cheers,
Rob.
--
E-Mail Disclaimer: Information contained in this message and any
attached documents is considered confidential and legally protected.
This message is intended solely for the addressee(s). Disclosure,
copying, and distribution are prohibited unless authorized.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux