backupen van mysql

<?php
function copyMySQL($user, $pass, $server, $database, $table) {
			
				$conn = mysql_connect($server, $user, $pass) OR DIE("De ingevoerde mysql gegevens kloppen niet");
				mysql_select_db($database, $conn);
				$res = mysql_query("SHOW CREATE TABLE ".$table."") OR DIE(mysql_error());
				$row = mysql_fetch_array($res);
				$sql .= $row[1];
				$res2 = mysql_query("SELECT * FROM ".$row[0]) or die(mysql_error());
				while($row2 = mysql_fetch_array($res2)) {
					$sql .= "INSERT INTO ".$row[0]." (";
					foreach($row2 as $name=>$value) {
						$sql .= $name.",";
					}
					$sql = substr($sql, 0, -1);
					$sql.= ") VALUES (";
					foreach($row2 as $name=>$value) {
						$sql .= "'".$value."',";
					}
					$sql = substr($sql, 0, -1);
					$sql = ");";
					
					
				}
				echo $sql;
			
		}
?>

<?php
function copyMySQL($user, $pass, $server, $database, $table) {
 
				$conn = mysql_connect($server, $user, $pass) OR DIE("De ingevoerde mysql gegevens kloppen niet");
				mysql_select_db($database, $conn);
				$res = mysql_query("SHOW CREATE TABLE ".$table."") OR DIE(mysql_error());
				$row = mysql_fetch_array($res);
				$sql .= $row[1];
				$res2 = mysql_query("SELECT * FROM ".$row[0]) or die(mysql_error());
				while($row2 = mysql_fetch_array($res2)) {
					$sql .= "INSERT INTO ".$row[0]." (";
					foreach($row2 as $name=>$value) {
						$sql .= $name.",";
					}
					$sql = substr($sql, 0, -1);
					$sql.= ") VALUES (";
					foreach($row2 as $name=>$value) {
						$sql .= "'".$value."',";
					}
					$sql = substr($sql, 0, -1);
					$sql = ");";
 
 
				}
				echo $sql;
 
		}
?>

CREATE TABLE `wikis` ( `id` int(10) NOT NULL auto_increment, `cat_id` int(10) NOT NULL default '1', `title` varchar(255) collate latin1_general_ci NOT NULL, `placer_id` varchar(255) collate latin1_general_ci NOT NULL, `votes` int(10) NOT NULL, `rating` int(10) NOT NULL, `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `visits` int(10) NOT NULL, `content` text collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='De Wiki''s'INSERT INTO wikis (0,id,1,cat_id,2,title,3,placer_id,4,votes,5,rating,6,addtime,7,visits,8,content) VALUES ('1','1','1','1','UBB Test','UBB Test','1','1','3','3','10','10','2008-02-23 19:34:58','2008-02-23 19:34:58','1','1','Dit is een test voor de ubb! [b]Dikgedrukt[/b] [i]Schuingedrukt[/i] [u]Onderstreept[/u] http://urlzondertags.nl/sj.jd?s=ff [url]halve tag[/url] [url=1]hele tag[/url] Smilies :):|:(;);p:$:o:D;D:H:K:p:'(:#O)^):Z:@:.@0) Afbeelding: [img]http://localhost/v2.1/header.gif[/img]','Dit is een test voor de ubb! [b]Dikgedrukt[/b] [i]Schuingedrukt[/i] [u]Onderstreept[/u] http://urlzondertags.nl/sj.jd?s=ff [url]halve tag[/url] [url=1]hele tag[/url] Smilies :):|:(;);p:$:o:D;D:H:K:p:'(:#O)^):Z:@:.@0) Afbeelding: [img]http://localhost/v2.1/header.gif[/img]');

CREATE TABLE `wikis` ( `id` INT(10) NOT NULL AUTO_INCREMENT, `cat_id` INT(10) NOT NULL DEFAULT '1', `title` VARCHAR(255) COLLATE latin1_general_ci NOT NULL, `placer_id` VARCHAR(255) COLLATE latin1_general_ci NOT NULL, `votes` INT(10) NOT NULL, `rating` INT(10) NOT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `visits` INT(10) NOT NULL, `content` TEXT COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='De Wiki''s'INSERT INTO wikis (0,id,1,cat_id,2,title,3,placer_id,4,votes,5,rating,6,ADDTIME,7,visits,8,content) VALUES ('1','1','1','1','UBB Test','UBB Test','1','1','3','3','10','10','2008-02-23 19:34:58','2008-02-23 19:34:58','1','1','Dit is een test voor de ubb! [b]Dikgedrukt[/b] [i]Schuingedrukt[/i] [u]Onderstreept[/u] http://urlzondertags.nl/sj.jd?s=ff [url]halve tag[/url] [url=1]hele tag[/url] Smilies :):|:(;);p:$:o:D;D:H:K:p:'(:#O)^):Z:@:.@0) Afbeelding: [img]http://localhost/v2.1/header.gif[/img]','Dit is een test voor de ubb! [b]Dikgedrukt[/b] [i]Schuingedrukt[/i] [u]Onderstreept[/u] http://urlzondertags.nl/sj.jd?s=ff [url]halve tag[/url] [url=1]hele tag[/url] Smilies :):|:(;);p:$:o:D;D:H:K:p:'(:#O)^):Z:@:.@0) Afbeelding: [img]http://localhost/v2.1/header.gif[/img]');