Easy database backup

64 Posts

culd | steffan Reply #1, 14 years, 7 months ago

Hi there,

I'm writing a .csv import script but before inserting/updating the database I'd like to take a backup in case things go wrong.

I've written this piece of code to do this but I was wondering if there is an easy way to do this using xpdo etc.

//backup nemen van de tabellen
	$dblijst=array("modx_catalogus","modx_catalogus_hoofdcategorie","modx_catalogus_subcategorie","modx_catalogus_subsubcategorie");
	
	foreach($dblijst as $db)
		{
		$backuptabel=$db."_backup";
		$deletequery="DELETE FROM $backuptabel";
		mysql_query($deletequery);
		$backupquery="INSERT INTO $backuptabel SELECT * FROM $db";
		mysql_query($backupquery);
		$content.="<br/>Backup van tabel $db: OK";
		}//foreach($dblijst as $db)

64 Posts

culd | steffan Reply #2, 14 years, 7 months ago

For anyone who might be wondering:

	//backup nemen van de tabellen
	$dblijst=array("modx_catalogus","modx_catalogus_hoofdcategorie","modx_catalogus_subcategorie","modx_catalogus_subsubcategorie");
	
	
	
	foreach($dblijst as $db)
		{
		$backuptabel=$db."_backup";
		$deletequery="DELETE FROM $backuptabel";
		$delete = $modx->query($deletequery);
		$backupquery="INSERT INTO $backuptabel SELECT * FROM $db";
		$insert = $modx->query($backupquery);
		if($insert) $content.="<br/>Backup van tabel $db: OK";
		}//foreach($dblijst as $db)