Re: [PHP] mysqldump

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.