2010/8/18 Daniel P. Brown :
> On Tue, Aug 17, 2010 at 15:19, tedd wrote:
>>
>> Bingo -- that worked.
>>
>> It's interesting that a space is optional between -u and user, but required
>> to be absent between -p and password. Seems not symmetrical to me.
>
> The command I sent was because - as I
On Tue, Aug 17, 2010 at 15:19, tedd wrote:
>
> Bingo -- that worked.
>
> It's interesting that a space is optional between -u and user, but required
> to be absent between -p and password. Seems not symmetrical to me.
The command I sent was because - as I said in the original thread
- passing
On Aug 17, 2010, at 3:19 PM, tedd wrote:
> At 11:45 AM -0700 8/17/10, Mari Masuda wrote:
>> Actually,
>>
>>mysqldump -u user -p password database_name > outfile.sql
>>
>> is also the incorrect command. When providing the password in the command,
>> there should not be a space between th
At 11:45 AM -0700 8/17/10, Mari Masuda wrote:
Actually,
mysqldump -u user -p password database_name > outfile.sql
is also the incorrect command. When providing the password in the
command, there should not be a space between the "-p" and the actual
password. Try
mysqldump
On Tue, Aug 17, 2010 at 3:04 PM, Robert Cummings wrote:
> On 10-08-17 03:00 PM, David Hutto wrote:
>>
>> On Tue, Aug 17, 2010 at 2:55 PM, Robert Cummings
>> wrote:
>>>
>>> On 10-08-17 02:45 PM, Mari Masuda wrote:
On Aug 17, 2010, at 11:40 AM, tedd wrote:
> At 2:17 PM -0400 8/17
On 10-08-17 03:00 PM, David Hutto wrote:
On Tue, Aug 17, 2010 at 2:55 PM, Robert Cummings wrote:
On 10-08-17 02:45 PM, Mari Masuda wrote:
On Aug 17, 2010, at 11:40 AM, tedd wrote:
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 -0
On Tue, Aug 17, 2010 at 3:00 PM, David Hutto wrote:
> On Tue, Aug 17, 2010 at 2:55 PM, Robert Cummings wrote:
>> On 10-08-17 02:45 PM, Mari Masuda wrote:
>>>
>>> On Aug 17, 2010, at 11:40 AM, tedd wrote:
>>>
At 2:17 PM -0400 8/17/10, Robert Cummings wrote:
>
> On 10-08-17 02:08 PM, t
On Tue, Aug 17, 2010 at 2:55 PM, Robert Cummings wrote:
> On 10-08-17 02:45 PM, Mari Masuda wrote:
>>
>> On Aug 17, 2010, at 11:40 AM, tedd wrote:
>>
>>> 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
On 10-08-17 02:45 PM, Mari Masuda wrote:
On Aug 17, 2010, at 11:40 AM, tedd wrote:
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 whic
On Aug 17, 2010, at 11:40 AM, tedd wrote:
> 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 t
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
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:
mysql
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
That might be the easiest, but all I get is an empty file.
I've tried many dif
# [EMAIL PROTECTED] / 2006-10-24 17:58:45 +1000:
> Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100:
> >>It looks to me as if you are trying to use web scripting (PHP) to do the
> >>sysadmin on your server, for which other methods are more suitable.
> >
> >Those would b
Roman Neuhauser wrote:
# [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100:
It appears that it could be because the user that runs the scripts is
not allowed to. When I run them on the commandline, I run them as the
root user.
that's very simple to check (man su)
yes I know of CRONtabs but w
# [EMAIL PROTECTED] / 2006-10-23 16:34:16 +0100:
> > >>It appears that it could be because the user that runs the scripts is
> > >>not allowed to. When I run them on the commandline, I run them as the
> > >>root user.
that's very simple to check (man su)
> > yes I know of CRONtabs but wont th
Angelo, as Brad says, you can pass user and password args to mysqldump from
an include file.
I run a php backup script via cron every night, then tar and compress and
store in various dirs out of the web tree.
I have the script if you'd like. It came from someone on the php-db list
years ago, an
Edward Kay wrote:
Angelo Zanetti wrote:
hi all,
Im doing the following dump through PHP:
$output = shell_exec('mysqldump '. $db_database .' > '.
$backup_path.$filename);
It doesnt seem to work but when I run the exact same command (with
appropriate values) in the command line it crea
Edward Kay wrote:
hi all,
Im doing the following dump through PHP:
$output = shell_exec('mysqldump '. $db_database .' > '.
$backup_path.$filename);
It doesnt seem to work but when I run the exact same command (with
appropriate values) in the command line it creates the dump file. What
could be
> >>>hi all,
> >>>
> >>>Im doing the following dump through PHP:
> >>>
> >>>$output = shell_exec('mysqldump '. $db_database .' > '.
> >>>$backup_path.$filename);
> >>>
> >>>It doesnt seem to work but when I run the exact same command (with
> >>>appropriate values) in the command line it creates the
Angelo Zanetti wrote:
hi all,
Im doing the following dump through PHP:
$output = shell_exec('mysqldump '. $db_database .' > '.
$backup_path.$filename);
It doesnt seem to work but when I run the exact same command (with
appropriate values) in the command line it creates the dump file. Wha
write rights for apache/php user to the $backup_path?
also is apache/php user allowed to run mysqldump?
hi all,
Im doing the following dump through PHP:
$output = shell_exec('mysqldump '. $db_database .' > '.
$backup_path.$filename);
It doesnt seem to work but when I run the exact same comm
hi all,
Im doing the following dump through PHP:
$output = shell_exec('mysqldump '. $db_database .' > '.
$backup_path.$filename);
It doesnt seem to work but when I run the exact same command (with
appropriate values) in the command line it creates the dump file. What
could be the reason for
Thank you Jon, Joe, and Richard.
I guess I'll leave things as they are and continue to monitor daily.
Fortunately, only up to 3 years worth of data needs to be kept "live" in the
master-slave db's, so there is a limit to how much data I will have to cope
with.
David
On Tue, October 3, 2006 9:29 am, David Giragosian wrote:
> So, Question 1 is: does mysqldump's connection to the slave db exist
> for the
> entire script execution time, or just for the length of time of its
> own
> execution?
exec() runs its own little mini-not-quite-shell, so as soon as it
ends,
1. mysqldump will only keep the connection open for as long as it
needs it. Once your calling script is allowed to continue mysqldump
has either exited successfully or with an error, but either way the
connection should no longer be active.
2. I don't think that would be a good idea. 30 min
David Giragosian wrote:
So, Question 1 is: does mysqldump's connection to the slave db exist
for the
entire script execution time, or just for the length of time of its own
execution? I imagine if I used mysql_connect() in the script that it
would
be for the entire length of the script executi
Howdy Guys,
I have a PHP backup script running as a cronjob that has an exec(mysqldump)
line followed a bit later by an exec(tar -cjf) line. The backup script runs
against a slave db in the wee hours, and the master gets a continuous stream
of inputs at the rate of about 18,720 per day. Obviously
Sorry to be a stickler... but _technically_ the backtick is shorthand
for shell_exec(). exec and passthru are a little different.
Mike Migurski wrote, On 2003/Jul/25 11:12 AM:
Thanks for the replies guys but the main reason I'm doing this is
because most times I don't have access to the servers,
>Thanks for the replies guys but the main reason I'm doing this is
>because most times I don't have access to the servers, or not enough
>preveleges to install myadmin or any other tools. I wish we had our own
>server but I'm trying for a solution where you can't upload any tools and
>cannot access
t or leave
it.
David
-Original Message-
From: Curt Zirzow [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 10:33 AM
To: '[EMAIL PROTECTED]'
Subject: Re: [PHP] mysqldump
* Thus wrote Marios Adamantopoulos ([EMAIL PROTECTED]):
> This is an attempt to create an backup scri
ECTED]'
Subject: Re: [PHP] mysqldump
* Thus wrote Marios Adamantopoulos ([EMAIL PROTECTED]):
> This is an attempt to create an backup script for my online databases.
There
> are few things to sort out and the coding is not the most effiecient out
> there yet!!!
>
> I just wanted
* Thus wrote Marios Adamantopoulos ([EMAIL PROTECTED]):
> This is an attempt to create an backup script for my online databases. There
> are few things to sort out and the coding is not the most effiecient out
> there yet!!!
>
> I just wanted to check on what you guys think, am I going the right w
This is an attempt to create an backup script for my online databases. There
are few things to sort out and the coding is not the most effiecient out
there yet!!!
I just wanted to check on what you guys think, am I going the right way, is
there anything I should keep in mind?
Mario
Code below
--
just make a php file with system calls in it to do mysqldump
how secure that is is a different question
- Original Message -
From: "John Taylor-Johnston" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 10:43 PM
Subject: [PHP] m
Anyone do MySQLDump using PHP ?
http://www.mysql.com/doc/en/mysqldump.html
My code is:
mysqldump -u ** -p ** -A > /home/mybackups/dump_all.sql
I would like to pull it off using PHP, remotely.
$date = date ("Ymd");
$to_path = "/home/MyBackups/$date/dump_all.sql";
mysqldump -u ** -p
mysqldump --opt -u username -p password databasename > filename.sql
Try mysqldump --help for additional options, or the MySQL manual.
Robert Zwink
-Original Message-
From: TopFive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 5:06 PM
To: [EMAIL PROTECTED]
Subject: [
you should be supplying a password...what's the error?
-jack
-Original Message-
From: TopFive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 08, 2001 5:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MYSQLDUMP
When I attempt to backup my database using MYSQLDUMP, I get repeated
s
When I attempt to backup my database using MYSQLDUMP, I get repeated
syntax error messages from MySQL. This is driving me nuts. I've
even attempted the simplest form of the command I can muster:
mysqldump mydatabasename > dump.sql;
Am I overlooking something dreadfully obvious here?
39 matches
Mail list logo
