PDA

View Full Version : Category Dump Issues


sfod_d223
06-24-2007, 02:52 AM
I backed up all my links and did first part of "drop" files under SQL..but this is the error that I receive:

Ver. 3.06

Error

SQL query:
--
-- Recreate category sequence number table and data
--
CREATE TABLE `PLD_CATEGORY_SEQ` ( `id` int( 11 ) NOT NULL default '0'
) ENGINE = MYISAM DEFAULT CHARSET = latin1;


MySQL said: Content visible to registered users only. (http://dev.mysql.com/doc/refman/4.1/en/error-returns.html)
#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 'DEFAULT CHARSET=latin1' at line 3


Any idea what I ned to do?

David
06-24-2007, 03:01 AM
Is there a difference in the mysql version of your old server and your new server?
(I think there are some export options that should solve this problem)

PL_90
06-24-2007, 09:12 AM
Try with this:
http://www.ozerov.de/bigdump.php

David
06-24-2007, 03:15 PM
Let us know if you still haven't solved it.