so i decided that i was gonna go edit the actual pages in the guestbook so it would no longer have "guestbook" "AGB" "advanced" keywords anywhere on the pages anymore but still have a link to the original creators... also i made a new database called commentry hoping that the spammers wouldn't find me anymore
sooooo... i created the new database
now to export the old one
1) what exactly do i need to export? i just want the current comments and pics they have uploaded
2) i tried just a general export (found a link to a faq thread on how to export)
if i just click the checkbox and save as sql with no compression the box comes up to save to a location... i click ok and it doesn't save the file.. the box just dissapears
i chose once to save as zip file and when i tried to import it said
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNodj79Lw0AcxQ/rILcIIro4fIdCHZLr3eUH6W0lhraYpjGpdRJJTdFgTNLESv0LxMHNxX9DZ3Fy
8V/QyV2QDs5enR48Hu/znhMEg0CAzcDm4DqeAA4aWByHQ2nXMLZHoYB6LxZQTdMiKqtJSdJkTIrz
QrkGTjSdcMKAU2o0qdnUKDBTGJZgDNLJZQuceQF13L8JD1wBOqGEG2p1FWVxVMb4MAxgECrQ7jje
UIGRI5lHSQY9B0xCsd9vyz3EJJpapAz7XX8ZUQbhskkjEuEm2WyO3bbXETDJ1KTKVcsyWirD/zx/
v7a6iRBaQ0/Pu3oD9J/3dYRu9xDakm41K8qIspPobJznF0wKkR+/d46rD3Px8rry6HV+7982Hrp3
i089+zKz08b2HwUpVNQ=
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 2 3 82
STR:
CVS: $Id: sqlparser.lib.php,v 2.34.2.1 2005/06/30 16:58:11 lem9 Exp $
MySQL: 4.0.25-standard
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.6.3-pl1
PHP VER,OS: 4.3.11 Linux
LANG: en-iso-8859-1
SQL: PK²³(4' 4ðʇDsupra01_agbook1agb.sqlí]sÛ6ò½¿™NGö?Å”H‰òÜ4nâ6nc'
----END RAW----
SQL query:
PK²³(4' 4ðʇDsupra01_agbook1agb.sqlí]sÛ6ò½¿™NGö?Å”H‰òÜ4nâ6nc'
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1
[ Back ]
so i then tried doing it as uncompressed and the box just dissapears
so then i tried gzipping and it just comes up page cannot be displayed all the time
it's now doing it on just zip
and uncompressed the box dissapears
anyone have any ideas pleaseeeeeeeeeee
thanks