8:36
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Using PHP to copy tables
>
>
> > Is there an easy way to create an HTML page that will copy
> selected tables
> > to backup copies on the same server? I want to create an administration
> > page for my cl
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access to the MySQL server and don
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access to the MySQL server and don
Try using such command from PHP...
system("$MYSQLDUMP --opt --user=$USER --password=$PASSWORD $DATABASE_NAME
$GZIP - > $BKDIR/$newfile.gz",$status);
where
$MYSQLDUMP is the mysqldump path
$GZIP is the path to gzip
$BKDIR is the path to the backup folder
Sound like a great idea!
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access
