Re: backing up mysql via pure php (no external commands)

I'm not sure if there's anything already outthere, but the concept
should be fairly easy in php. Probably something like:

connect to database
list tables
foreach table
        list fields (desc table)
        make create table statement
        write create table to file
        query data
        create insert statement
        write insert to file
close database

I'm sure that's oversimplified, but you get the idea.

Brandon

On Thu, 2005-06-30 at 00:12, Kyle Sloan wrote:
> I'm looking for a way to basically do a mysqldump without using 
> mysqldump.  My new company has assinged me with making an hourly backup 
> of a mysql db, and it turns out the host does not allow mysqldump to 
> us.  I've dug around but cannot find a simple script that will generate 
> the file via queries through php or anything like that not requering 
> shell_execs or being overly bloated.  I have found several forum posts 
> around the net about this question, but never found an answer.
> 
> I was hoping someone knew of a stripped down phpmyadmin export tool 
> before I go to gutting away at phpmyadmin to fit my needs of being able 
> to run the export on a cron job.  Blast not having root access to the 
> server...
> 
> Thanks,
> -Kyle
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: 
> talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx
> 
> Please read and follow the list guidelines:
>   http://www.tcphp.org/mailing_list/guidelines
> 
> The tcphp.org mailing list is sponsored by pajunas interactive, inc.
-- 
Brandon Carlson
CEO - Aphion Inc
www.aphion.com
brandon-+k24AcDEvnDQT0dZR+AlfA@xxxxxxxxxxxxxxxx
651-429-9888
AIM: bcarl314pi
Yahoo: bcarl314


---------------------------------------------------------------------
To unsubscribe, e-mail: talk-unsubscribe-4zcLI8jJc/rYtjvyW6yDsg@xxxxxxxxxxxxxxxx

Please read and follow the list guidelines:
  http://www.tcphp.org/mailing_list/guidelines

The tcphp.org mailing list is sponsored by pajunas interactive, inc.