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.
Advertising
$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