Re: [PHP] mysqldump

At 2:17 PM -0400 8/17/10, Robert Cummings wrote:
>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


I did catch that, but did not correct it in my post (considering it 
was a direct quote).

-------

>>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.


No, I didn't -- however, I just did this (using the correct user, 
password, and database name):

   exec('mysqldump  -u user -p password databaseName > outfile.txt',$a,$b);

And received back an empty array for $a and '2' for $b. I don't know 
what that means.


-------
>>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

I'm neither on Windozes nor the host. I am on a hosted account and 
that may be the problem. However, I've been told that I *can* access 
the command line, I am just clueless as to how to do it.

In the past I have been reluctant to try because I don't want to 
screw things up. You see, it's Okay if I screw up my own system, but 
someone else's, I would rather not. However, I would like to know how 
to do it safely.

Thanks for your time.

Cheers,

tedd

-- 
-------
http://sperling.com/