Unix Technical Forum

Help on Syntax error please

This is a discussion on Help on Syntax error please within the MySQL forums, part of the Database Server Software category; --> I'm new to MySQL. Sorry for asking for some probably very basic help. The following code is from a ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 08:38 AM
Gilles
 
Posts: n/a
Default Help on Syntax error please

I'm new to MySQL. Sorry for asking for some probably very basic help.

The following code is from a Dump of a php forums database (openBB software,
now discontinued).
It was installed on a server running MySQL 4.0.18

================================================== ======
-- MySQL dump 9.11
--
-- Host: localhost Database: Apxxxxxxxxxx
-- ------------------------------------------------------
-- Server version 4.0.18

--
-- Table structure for table `ap_active`
--

CREATE TABLE ap_active (
member varchar(50) NOT NULL default '',
lastaction int(10) NOT NULL default '0',
record varchar(32) NOT NULL default '',
ip varchar(15) NOT NULL default '0',
location varchar(100) NOT NULL default '',
invisible enum('1','0') NOT NULL default '0',
inforum int(4) NOT NULL default '0',
KEY member (member),
KEY inforum (inforum)
) TYPE=MyISAM;

--
-- Dumping data for table `ap_active`
--.
...... etc
================================================== ======

When trying to restore the base, I get:
.................................................. ..............................
MySQL said: #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 ap_active (
member varchar(50) NOT NULL default '
.................................................. ..............................

On my system:
-MySQL is version 4.1.9
-phpMyAdmin is 2.6.1
(Apache 1.3.33 and php 4.3.10, just for information)

What is wrong? I can't figure it out, sorry, I'm new to SQL and I only found
a MySQL 5 manual online so far.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:03 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com