Exporting mySQL database

leetcrew

how to export all tables and data from mySQL without using shell access? just like phpBB, if you clicked on back up database, the script will send you .sql file

thanks in advance! 🙂


if ( ($HTTP_USER_DATA['admin']) && ($HTTP_GET_VARS['action'] == backup) )
$db->backup();

pyfsapple

Simply write it yourself!

mysql_list_dbs
mysql_list_tables
mysql_list_fields
...

LordShryku

Fill in the blanks

<?
$host           = "";
$user           = "";
$pass           = "";

$backupDir      = "/home/user/";
$backupFileName = "backup.sql";

$back           = $backupDir.$backupFileName
system(sprintf("mysqldump --all-databases -h %s -u %s -p%s > %s",$host,$user,$pass,$back));
?>

This will dump all databases. Look at the manual to change the options

HalfaBee

If you can use mysqldump with an EXEC() or SYSTEM() function, if they are enabled.

HalfaBee

leetcrew

thanks for quick reply 🙂


function export()
{
	$backupDir      = $GLOBALS['root_path'] . '"backup"; 
	$backupFileName = "backup.sql"; 
	$back           = $backupDir.$backupFileName 
	system(sprintf("mysqldump --all-databases -h %s -u %s -p%s > %s",$GLOBALS['dbHost'],$GLOBALS['dbUser'],$GLOBALS['dbPassword'],$back)); 
}

what if system() and exec() functions has been disabled by an admin?

LordShryku

Then you'll have to create a custom script to do it. Something to list the DB's, show create table on each table in the DB, select all, write the script.

I've been working on something like this for a little while. Kinda quit and haven't gotten back to it yet (no real need for it). Maybe it's time to finish it up....

HalfaBee

I think it is safer to use -r $backupfailename than using redirected stdout.

HalfaBee

leetcrew

okay, thanks
it works 🙂