SQL problem

[kakarotto]

Well, I have been everywhere with this problem but no one's answers work. perhaps you guys' will .

I need to upload a db for PHPNuke. Most of the tables are already created, but some of the content inside them isn't, which creates errors at my site. What I need to figure out is a way that would let me insert the new SQL content to the old ones, without having the problem of the error saying:

#1050 - Table 'bahd bbka' already exists

Because when this happens to whole thing stops. In other words I need to find a way of making phpmyadmin insert the data and if it finds that the table is already there, it will just skip that and put in what is missing.

Thanks in advanced.

[hatchet]

Look at your sql file - remove the parts (at the top most likely) where it says
CREATE TABLE `bahd bbka` (
`field1` varchar(14) NOT NULL default '',
`field2` varchar(14) NOT NULL default '',
PRIMARY KEY (`field1`)
) TYPE=MyISAM;

should work just fine.

[hatchet]

Or better yet change it to
CREATE TABLE IF NOT EXISTS 'bahd bbka' (
etc
etc) etc

[kakarotto]

So if I have:

CREATE TABLE nuke_bbforums (
forum_id smallint(5) unsigned NOT NULL auto_increment,
cat_id mediumint( unsigned DEFAULT '0' NOT NULL,
forum_name varchar(150),
forum_desc text,
forum_status tinyint(4) DEFAULT '0' NOT NULL,
forum_order mediumint( unsigned DEFAULT '1' NOT NULL,
forum_posts mediumint( unsigned DEFAULT '0' NOT NULL,
forum_topics mediumint( unsigned DEFAULT '0' NOT NULL,
forum_last_post_id mediumint( unsigned DEFAULT '0' NOT NULL,
prune_next int(11),
prune_enable tinyint(1) DEFAULT '1' NOT NULL,
auth_view tinyint(2) DEFAULT '0' NOT NULL,
auth_read tinyint(2) DEFAULT '0' NOT NULL,
auth_post tinyint(2) DEFAULT '0' NOT NULL,
auth_reply tinyint(2) DEFAULT '0' NOT NULL,
auth_edit tinyint(2) DEFAULT '0' NOT NULL,
auth_delete tinyint(2) DEFAULT '0' NOT NULL,
auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
auth_announce tinyint(2) DEFAULT '0' NOT NULL,
auth_globalannounce tinyint(2) DEFAULT '3' NOT NULL,
auth_vote tinyint(2) DEFAULT '0' NOT NULL,
auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
auth_download tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (forum_id),
KEY forums_order (forum_order),
KEY cat_id (cat_id),
KEY forum_last_post_id (forum_last_post_id)
);

I need to leave it like:

nuke_bbforums (
forum_id smallint(5) unsigned NOT NULL auto_increment,
cat_id mediumint( unsigned DEFAULT '0' NOT NULL,
forum_name varchar(150),
forum_desc text,
forum_status tinyint(4) DEFAULT '0' NOT NULL,
forum_order mediumint( unsigned DEFAULT '1' NOT NULL,
forum_posts mediumint( unsigned DEFAULT '0' NOT NULL,
forum_topics mediumint( unsigned DEFAULT '0' NOT NULL,
forum_last_post_id mediumint( unsigned DEFAULT '0' NOT NULL,
prune_next int(11),
prune_enable tinyint(1) DEFAULT '1' NOT NULL,
auth_view tinyint(2) DEFAULT '0' NOT NULL,
auth_read tinyint(2) DEFAULT '0' NOT NULL,
auth_post tinyint(2) DEFAULT '0' NOT NULL,
auth_reply tinyint(2) DEFAULT '0' NOT NULL,
auth_edit tinyint(2) DEFAULT '0' NOT NULL,
auth_delete tinyint(2) DEFAULT '0' NOT NULL,
auth_sticky tinyint(2) DEFAULT '0' NOT NULL,
auth_announce tinyint(2) DEFAULT '0' NOT NULL,
auth_globalannounce tinyint(2) DEFAULT '3' NOT NULL,
auth_vote tinyint(2) DEFAULT '0' NOT NULL,
auth_pollcreate tinyint(2) DEFAULT '0' NOT NULL,
auth_attachments tinyint(2) DEFAULT '0' NOT NULL,
auth_download tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (forum_id),
KEY forums_order (forum_order),
KEY cat_id (cat_id),
KEY forum_last_post_id (forum_last_post_id)
);

?

[kwvarga]

I would leave the CREATE TABLE IF NOT EXISTS like he says in his first post

[hatchet]

Exactly Kyle. you need to leave it like
CREATE TABLE IF NOT EXISTS 'nuke_bbforums' (
etc..etc..

[kakarotto]

you are kool lol