Dont use mysqldump to import. Use mysql. I can't remember the exact
syntax, but reference mysql.com for mysqldump, then in the syntax example
for that, they show you how to import it.
Ryan Shrout
Production Manager
Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
(859) 653-3341
- Origina
duction Manager
Athlonmb.com
http://www.athlonmb.com
[EMAIL PROTECTED]
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Vigile" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 9:54 AM
Subject: Re: Duplicate of Everythi
hlonmb.com
http://www.athlonmb.com
[EMAIL PROTECTED]
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Vigile" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 9:34 AM
Subject: Re: Duplicate of Everything in Table
> http://www.athlonmb.com
> [EMAIL PROTECTED]
>
>
> - Original Message -
> From: "Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]>
> To: "Vigile" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Friday, April 06, 2001 1:57 AM
&
I have a table, that DOES NOT have a primary key, but is setup like this:
Field Type Attributes Null Default Extra Action
PageID int(11)No 0Change Drop Primary Index Unique
ArticleID int(11)No 0Change Drop Primary Index Unique
PageTitle textNo
I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[AuthorID] [int] NOT NULL ,
[Date] [datetime] NOT NULL ,
[SubjectID] [int] NOT NULL ,
[Pages] [
The LIMIT is irrelevant. It doesn't work with or without that there.
I put the die(mysql_error) in and the result wasn't very helpful...
I had another suggestion from a person saying to remove the first set of
column names to make the query like this:
$insert_query = "INSERT INTO news VALUES ('
Okay, another question from the stumbling idiot: what's wrong with this code:
$insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link,
Information, Status) VALUES ('', 'asdf', '2001-03-19 00:33:47', '1', 'asdf', 'asdf',
'asdf', '2') LIMIT 0, 30";
$insert_result = mysql_quer
