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

I wrote an app a while back that does this. I didn't do much with it and 
it isn't thoroughly tested, but you're welcome to it:

http://www.pragmapooldev.com/download/mysqlbackup.zip

I had intended it for use from the desktop (via Serlient) to backup 
remote hosts, but the fact that most hosts also block remote access made 
that use less viable and it's been sitting ever since.

Brandon Carlson wrote:

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


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