rieh25 wrote:
I'm working on a script to create back-up's of a database. It's not complete
because it only generates the "insert into" commands, it doesn't generate
the "create database" or "create table" ones, but I wondered if there is
another way to create a back-up's of a database that can only be accessed
through the web.

$qry = "SHOW CREATE TABLE " . $tablename;
$result = mysql_query($qry);
$create_table = mysql_result($result, 0, 1) . ";\n";

No idea about create database but something similar should work.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to