backup of db table using php

I’m trying to could backup one of tables from database using php only. I’d like to save result in some directory at my server or (the best) send it via e-mail.

My problem is that:
– [B]exec()[/B] is disabled
– [B]system()[/B] is disabled

I’m tried to use “[B]SELECT * INTO OUTFILE[/B]” and “[B]LOAD DATA INFILE[/B]” but I got blank page each time (no error raport). “[B]Backup[/B]” directory have [B]chmod 777[/B] so that’s not problem.

My files looks this way:

[code=php]
<?php

$host = “localhost”; // Host name
$username = “username”; // Mysql username
$password = “password”; // Mysql password
$db_name = “MyDbName”; // Database name
$tableName = “MyTestTable”; // Table name

// Connect to server and select database.
mysql_connect($host, $username, $password)or die(“cannot connect”);
mysql_select_db($db_name)or die(“cannot select DB”);

$backupFile = “/home/myusername/domains/mydomain.com/public_html/admin/backup/mybackup.sql”;
$query = “SELECT * INTO OUTFILE ‘$backupFile’ FROM $tableName”;
$result = mysql_query($query);

if($result){

echo “success”;

} else {

echo “error”;
}

// close connection
mysql_close();

?>
[/code]

[code=php]
<?php

$host = “localhost”; // Host name
$username = “username”; // Mysql username
$password = “password”; // Mysql password
$db_name = “MyDbName”; // Database name
$tableName = “MyTestTable”; // Table name

// Connect to server and select database.
mysql_connect($host, $username, $password)or die(“cannot connect”);
mysql_select_db($db_name)or die(“cannot select DB”);

$backupFile = “/home/myusername/domains/mydomain.com/public_html/admin/backup/mybackup.sql”;
$query = “LOAD DATA INFILE ‘backupFile’ INTO TABLE $tableName”;
$result = mysql_query($query);

if($result){

echo “success”;

} else {

echo “error”;
}

// close connection
mysql_close();

?>
[/code]

Also in #PHP _↴