PDA

View Full Version : importing table into database


azlezoo
11-11-06, 10:22 PM
I've been trying to import a table into one of my databases, however, I keep getting the following error. I've looked in the MySQL documentation and the forum here but I'm at a loss what to do next. Any ideas would be greatly appreciated! TIA!

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-pow13
-- Generation Time: Nov 11, 2006 at 03:24 PM
-- Server version: 4.1.18
-- PHP Version: 4.4.4
--
-- Database: `dfwcfids`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_content`
--
CREATE TABLE `jos_content` (
`id` int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,
`title` varchar( 100 ) NOT NULL default '',
`title_alias` varchar( 100 ) NOT NULL default '',
`introtext` mediumtext NOT NULL ,
`fulltext` mediumtext NOT NULL ,
`state` tinyint( 3 ) NOT NULL default '0',
`sectionid` int( 11 ) unsigned NOT NULL default '0',
`mask` int( 11 ) unsigned NOT NULL default '0',
`catid` int( 11 ) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int( 11 ) unsigned NOT NULL default '0',
`created_by_alias` varchar( 100 ) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int( 11 ) unsigned NOT NULL default '0',
`checked_out` int( 11 ) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL ,
`urls` text NOT NULL ,
`attribs` text NOT NULL ,
`version` int( 11 ) unsigned NOT NULL default '1',
`parentid` int( 11 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`metakey` text NOT NULL ,
`metadesc` text NOT NULL ,
`access` int( 11 ) unsigned NOT NULL default '0',
`hits` int( 11 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `idx_section` ( `sectionid` ) ,
KEY `idx_access` ( `access` ) ,
KEY `idx_checkout` ( `checked_out` ) ,
KEY `idx_state` ( `state` ) ,
KEY `idx_catid` ( `catid` ) ,
KEY `idx_mask` ( `mask` )
) ENGINE = MYISAM AUTO_INCREMENT =98;

MySQL said: Documentation
#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 '

CREATE TABLE `jos_content` (
`id` int(11) unsigned NOT NULL auto_increme' at line 1

azlezoo
11-12-06, 12:00 AM
Well, time will tell but I think I have this problem solved. This just wasn't working so I deleted all tables in the database and then copied them over from the other database I wanted to import information from. That appears to have worked... thus far. Not sure what sort of clean-up will be needed when all is said & done but... fwiw... this immediate problem is solved. Thanks!