problem with dumpfile use with mysql

Anon

Please help me with using a dumpfile to add data to a table. I'm quite new to this.

I have tried the following commands to get the dumpfile data into a mysql database:

mysql -u username -p database < dumpfile;
mysql -u username database -p <;
mysql -u username database -p < dumpfile;
mysql -u username -p password database <;
mysql -u username -p password database < dumpfile;

I keep getting the error:
ERROR 1064: You have an error in your SQL syntax near '(insert any command above)' at line 1.

The dumpfile is named: dumpfile (no extension)
The dumpfile is located on the desktop.
I'm using windows 98, mysql 3.22.34-shareware-debug

Anon

The error indicates that you have a problem with the contents of your dumpfile.

Anon

The following is the dumpfile. Its from a tutorial at devshed. Could you tell me the syntax error so I can fix it?

Table structure for table 'url_list'

CREATE TABLE url_list (
uid varchar(8) NOT NULL,
title1 varchar(30) NOT NULL,
url1 text NOT NULL,
title2 varchar(30) NOT NULL,
url2 text NOT NULL,
title3 varchar(30) NOT NULL,
url3 text NOT NULL,
PRIMARY KEY (uid)
);

Dumping data for table 'url_list'

INSERT INTO url_list VALUES( 'john', 'Melonfire', 'http://www.melonfire.com', 'Devshed', 'http://www.devshed.com', 'PHP.Net', 'http://www.php.net');
INSERT INTO url_list VALUES( 'bill', 'Yahoo', 'http://www.yahoo.com', 'Slashdot', 'http://www.slashdot.org', '32Bit.com', 'http://www.32bit.com');

Anon

Without having ever used MySQL on Windows98, I can't be positive this will help you out, but...I think the problem is that mysql is looking for the redirected file in your current directory. Can you just put the dumpfile in the c:\temp directory, CD to that directory, then try it? Also, I don't know if Win98 supports redirection; if you made your dumpfile using mysqldump in Win98, redirecting to a file using the ">" symbol, then it should take the "<" for taking input to mysql.

Hope this helps.

Anon

Make sure the table doesn't already exist. If it does comment out the create table part.

Anon

See if this makes any difference:

-uusername -ppassword

The spaces like '-u username' can sometimes not work.

Regards,
Nadia

Anon

See if this makes any difference:

-uusername -ppassword

The spaces like '-u username' can sometimes not work.

You also need to use 'mysqldump', not 'mysql'.

Regards,
Nadia