I created a script that outputs the following code into a PHP file for EACH table in the database. I am using this as a “ready to run” backup script that i can just include and it will drop all tables, recreate the tables and then reinsert each value.
For some reason i can only get the code to drop the tables, any help is much appreciated. ?
[code=php]mysql_query(“DROP TABLE IF EXISTS usr”);
$sql=”CREATE TABLE page (pge string(1) not_null primary_key, mt string(10000) not_null, mim string(50) not_null, imh string(3) not_null, imw string(3) not_null, tile string(100) not_null, mh string(100) not_null, cue string(1) not_null, su string(1) not_null, PRIMARY KEY (page)) TYPE=MyISAM”;
mysql_query($sql);
mysql_query(“INSERT INTO usr VALUES (‘1’, ‘Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, <span style=”font-weight: bold;”>sed diam voluptua</span>. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, <span style=”font-style: italic;”>consetetur sadipscing elitr</span>, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. <br><ul><li><span style=”font-weight: bold;”>ro eos et accusam eAt vet justo duo dolores et ea rebum</span>.</li><li> Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. <br></li><li style=”font-weight: bold;”>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.</li><li> At vero eos et accusam et justo duo dolores et ea rebum. <br></li><li style=”font-weight: bold;”>Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</li></ul>Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. <br>’, ‘StandingHandInPocket.JPG’, ‘350’, ‘233’, ‘Home’, ‘Welcome!’, ‘n’, ‘n’,)”);
mysql_query(“INSERT INTO page VALUES (‘2’, ‘asd<span style=”font-weight: bold;”>fgafgadfg</span><br>’, NULL,NULL,NULL,’page 2′, ‘header2’, NULL,NULL)”);
mysql_query(“INSERT INTO page VALUES (‘5’, ‘<br>’, NULL,NULL,NULL,NULL,NULL,’y’, NULL)”);
mysql_query(“INSERT INTO page VALUES (‘3’, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)”);
mysql_query(“INSERT INTO page VALUES (‘4’, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)”);
Thanks,
Jeremy