Split it up.
after each statement is a semicolon eg.
[sql]CREATE TABLE `faq` (
`faqname` varchar(250) binary NOT NULL default '',
`faqparent` varchar(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`faqname`),
KEY `faqparent` (`faqparent`)
) TYPE=MyISAM;[/sql]
[sql]INSERT INTO `faq` VALUES (0x76625f666171, 'faqroot', 100, 1);[/sql]
Open your sql file in an edior (use wordpard instead of notepad because wordpad seperates the lines better or use an editor your like.)
cut about 600 lines and place it into another file named vb_1.sql then go cut another 600 lines and paste it into a file named vb_2.sql and so on... (make sure you end on a semiolon.)
Now upload the sql files in order.
I hope that helps.
|