Using PHP to Database Tables via Email

Hello all.

I use 1and1 as my webhost.

Using their configuration, the web server and mysql server are 2
different machines.

I have a web application that uses 2 database tables. I am looking
for a convenient way to get backup's of the database tables at a click
of a button on an admin section of my website. So far, I have had no
luck.

My latest attempt involved the following steps:

1) Running a system command to put the database tables in a file:
system("mysqldump -h $dbhost -u $dbuser -p $dbpass $dbname >
$backupfile");

2) Composing an email using php's Mail library and adding the
aforementioned backup file as an attachment.

Anyone have any experience with this? Offer any insight?

Thanks,
AJ

aj wrote:
> Hello all.
>
> I use 1and1 as my webhost.
>
> Using their configuration, the web server and mysql server are 2
> different machines.
>
> I have a web application that uses 2 database tables. I am looking
> for a convenient way to get backup's of the database tables at a click
> of a button on an admin section of my website. So far, I have had no
> luck.
>
> My latest attempt involved the following steps:
>
> 1) Running a system command to put the database tables in a file:
> system("mysqldump -h $dbhost -u $dbuser -p $dbpass $dbname >
> $backupfile");
>
> 2) Composing an email using php's Mail library and adding the
> aforementioned backup file as an attachment.
>
> Anyone have any experience with this? Offer any insight?
>
> Thanks,
> AJ

I too used 1and1 until recently. Their customer service has gone so far
downhill, I have moved all my hosting to QiQ
http://www.myqiq.info/uk/aff.php?aff=023

BTW, you haven' told us in which ways these attempts have failed?

Can't you use phpMyAdmin?