jetshack

(btw http://www.docfell.net)

inserted as is and got the error for the
DEFAULT CHARSET=latin1

so i took out the
DEFAULT CHARSET=latin1

but still ended with the error
#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 ” at line 1

so what you’re saying for me to do is:
1. switch nameservers back over to old host
2. reexport database as mentioned above.
3. switch nameservers back to new host
4. reimport database…

That host is so flakey (the reason for teh move) that that could take a few days (which I’m allright with)…. just as an fyi their servers are down right now.

I can get access to it, but I’ll have to wait on nameservers to move over…

Is there no way to just get the wp_posts table inserted? The other tables are already in and working

should be on the way

edit

should be on the way again… i screwed up the addie the first time

I already did away with all of the
DEFAULT CHARSET=latin1
entries….

doing so was one of the things I had to do to get all the other tables inserted…

BTW: thanks to you for that podz… i found your mentioning that in another thread

also as an example… here’s the data from the sql… through the first post…

code
DROP TABLE IF EXISTS wp_posts;
CREATE TABLE wp_posts (
ID bigint(20) unsigned NOT NULL auto_increment,
post_author int(4) NOT NULL default ‘0’,
post_date datetime NOT NULL default ‘0000-00-00 00:00:00’,
post_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
post_content longtext NOT NULL,
post_title text NOT NULL,
post_category int(4) NOT NULL default ‘0’,
post_excerpt text NOT NULL,
post_status enum(‘publish’,’draft’,’private’,’static’,’object’) NOT NULL default ‘publish’,
comment_status enum(‘open’,’closed’,’registered_only’) NOT NULL default ‘open’,
ping_status enum(‘open’,’closed’) NOT NULL default ‘open’,
post_password varchar(20) NOT NULL default ”,
post_name varchar(200) NOT NULL default ”,
to_ping text NOT NULL,
pinged text NOT NULL,
post_modified datetime NOT NULL default ‘0000-00-00 00:00:00’,
post_modified_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’,
post_content_filtered text NOT NULL,
post_parent int(11) NOT NULL default ‘0’,
guid varchar(255) NOT NULL default ”,
menu_order int(11) NOT NULL default ‘0’,
post_excerpt_filtered text NOT NULL,
PRIMARY KEY (ID),
KEY post_name (post_name),
KEY post_status (post_status)
);
/*!40000 ALTER TABLE wp_posts DISABLE KEYS */;
LOCK TABLES wp_posts WRITE;
INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_category, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_content_filtered, post_parent, guid, menu_order, post_excerpt_filtered) VALUES (21,1,’2000-05-05 02:12:25′,’2000-05-04 20:42:25′,'<font size=\”1\”>An unidentified transvestite protests Rockers return to New York</font><img title=\”05.05.00.jpg\” style=\”width: 260px; height: 200px\” height=\”200\” alt=\”05.05.00.jpg\” hspace=\”5\” src=\”http://docfell.net/images/05.05.00.jpg\” width=\”260\” align=\”left\” border=\”0\” /><font size=\”1\”>By Charles Shaft
Associated Press</font> Returning to New York for the first time since making prejudice remarks during last years playoffs, John Rocker of the Atlanta Braves was greeted by a lone protester outside Yankee stadium. The person, an unidentified transvestite, set fire to a stack of Barry Manilow albums and danced around the flames chanting "let your freak flag fly baby!", while the Braves arrived for their pre-game workout. "I just want him(Rocker) to know that the voice of freedom can not be suppressed," claimed the person. "As far as I\’m concerned he and Jerry Falwell can kiss my hairy butt." After ten minutes NY police grew weary of the spectacle and beat the protestor into a coma with their night sticks. "We really wanted to kill the queer little punk but then he wouldn\’t learn his lesson," said officer Bryan O\’Peltzer. Later Rocker was questioned about the incident, "She looked pretty hot to me," he said. "Maybe we had a one night stand and she was pissed or something. I don\’t know what her problem was the silly bitch." ‘,’code