RE: [PHP] mysqldump

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

-----Original Message-----
From: David Smith [mailto:dsmith@sebc.edu]
Sent: 25 July 2003 16:54
To: php-general@lists.php.net

I agree with Curt, why reinvent the wheel. I mean even if you are like me
and cannot access the command-line on your web server (which really really
sucks) then there are still other tools that can do this very same thing. If
you just want to click on a link and backup the db why not use the load data
infile (of course this does not backup the database structure just the data)
http://www.mysql.com/doc/en/LOAD_DATA.html. Or why not just get phpMyAdmin
and upload it to your server. It already has these features plus many
others, and of course the best part is it is open source
http://sourceforge.net/projects/phpmyadmin/. So why take the time of
reinventing the wheel?
Of course this is just my dumb opinion...so you can always take it or leave
it.
David



-----Original Message-----
From: Curt Zirzow [mailto:curt@zirzow.dyndns.org]
Sent: Friday, July 25, 2003 10:33 AM
To: 'php-general@lists.php.net'
Subject: Re: [php] mysqldump


* Thus wrote Marios Adamantopoulos (mario@tonic.co.uk):
> 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?

perhaps something like would be a whole lot easier:
`mysqldump [options] db tables`;

My general policy is don't revent the wheel unless it isn't round.

Curt
--
"I used to think I was indecisive, but now I'm not so sure."

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




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

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, 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 system commands.
>
>
> Curt's suggestion does not require command-line access - the backtick
> operator is a shorthand for exec() or passthru(), and is a language
> construct of PHP. So yeah, don't reinvent the wheel.
>
> http://php.net/manual/en/language.op....execution.php
>
> ---------------------------------------------------------------------
> michal migurski- contact info and pgp key:
> sf/ca http://mike.teczno.com/contact.html
>
>