Mysql BackUp

[onlyican]

Hey guys

I am looking at creating an option to back up the databases, creating a wicked .sql file

Currently I would back up using Mysql-front
Which will give me a result such as

CREATE TABLE IF NOT EXISTS mytable (
id_num INT(12) auto_increment,
name VARCHAR(150) DEFAULT NULL,
PRIMARY KEY (id_num),
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1

Which I can do using the Mysql Function SHOW CREATE TABLE mytable

BUT

How would I get the data

Would I do something like
[code]
<?php
$query = "SELECT * FROM mytable";

$result = mysql_query($query);

while($row = mysql_fetch_assoc($result)){
$update[] = "INSERT INTO mytable (id_num, myname) VALUES ('".$row["id_num"]."', '".$row["myname"]."')";
}
?>
[/code]
Yes I know it will need a little bit more coding than that, but the principle is there

Or is there another wicked function in mysql which will show the results like I want

[ataria]

<?php
$result = mysql_query("SELECT * FROM `mytable`");
while($row = mysql_fetch_assoc($result)){
$update = "INSERT INTO `mytable` (`id_num`, `myname`) VALUES ('{$row["id_num"]}', '{$row["myname"]}')";
}
?>

[onlyican]

Pretty much what i said, but I want to know is there a function which will auto create them like
SHOW CREATE TABLE tbl_name for creating the tables
I could do SHOW FIELDS but that builds it for me