Re: beginner needs help servin up a lan

2005-07-12 Thread nephish
Well thanks, these look as if to be exactly what i have been looking
for. will test this stuff out when i get to work, thanks again.

<>< 


On Tue, 2005-07-12 at 10:10 +0300, Gleb Paharenko wrote:
> Hello.
> 
> 
> These links could be helpful:
>   http://dev.mysql.com/doc/mysql/en/export-of-data.html
>   http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html
> 
> For more information search in archives at:
>   http://lists.mysql.com/mysql
> 
> 
> 
> 
> nephish <[EMAIL PROTECTED]> wrote:
> > Hello there
> > 
> > i need to import an entire database or find a way to get all the info in
> > a microsoft access .mdb database into a MySQL database.
> > here is another trick, the access database is on an WinXP computer, the
> > MySQL database is on a debian linux computer. They are on the same
> > internal network though.
> > is this even possible ? if so, where can i read up on how to do it?
> > 
> > thanks,
> > shawn <><
> > 
> > 
> > 
> 
> 
> -- 
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
><___/   www.mysql.com
> 
> 
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: beginner needs help servin up a lan

2005-07-12 Thread Gleb Paharenko
Hello.





These links could be helpful:

  http://dev.mysql.com/doc/mysql/en/export-of-data.html

http://dev.mysql.com/doc/mysql/en/mysql-tools-with-access.html



For more information search in archives at:

  http://lists.mysql.com/mysql









nephish <[EMAIL PROTECTED]> wrote:

> Hello there

> 

> i need to import an entire database or find a way to get all the info in

> a microsoft access .mdb database into a MySQL database.

> here is another trick, the access database is on an WinXP computer, the

> MySQL database is on a debian linux computer. They are on the same

> internal network though.

> is this even possible ? if so, where can i read up on how to do it?

> 

> thanks,

> shawn <><

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: beginner needs help servin up a lan

2005-07-11 Thread Jason Pyeron


odbc driver for your MySQL database on your windows machine.

export tables in access to odbc source that you created

On Mon, 11 Jul 2005, nephish wrote:


Hello there

i need to import an entire database or find a way to get all the info in
a microsoft access .mdb database into a MySQL database.
here is another trick, the access database is on an WinXP computer, the
MySQL database is on a debian linux computer. They are on the same
internal network though.
is this even possible ? if so, where can i read up on how to do it?

thanks,
shawn <><






--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-   -
- Jason Pyeron  PD Inc. http://www.pdinc.us -
- Partner & Sr. Manager 7 West 24th Street #100 -
- +1 (443) 921-0381 Baltimore, Maryland 21218   -
-   -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you 
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Beginner needs help

2002-02-25 Thread Michael Stassen


This is the 3rd incorrect answer out of 6 replies to this question.  It
sure is a good thing we have a manual!  Yes, you can insert multiple
rows with one INSERT statement.  You just have to get the correct
syntax.  It's 

INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...),(...),...

See http://www.mysql.com/doc/I/N/INSERT.html

Michael

On Mon, 25 Feb 2002, daniel wrote:

> o
> i don't think you can
> you'd just have to post two separate insert statments
> you can run them both at the same time if you like though
> 
> INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7',
> 'MySQL & mSQL');
> INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3',
> 'Mastering Regular Expressions');
> 
> the only other way to do it would be to
> import the data from another database like this:
> INSERT INTO table [ (coloumn...) ] SELECT ...
> 
> OR
> 
> use a LOAD DATA and import a text file.
> 
> hope that helps
> 
> 
> - Original Message -
> From: "Bob Rea" <[EMAIL PROTECTED]>
> To: "daniel" <[EMAIL PROTECTED]>
> Sent: Monday, February 25, 2002 4:40 PM
> Subject: Re: Beginner needs help
> 
> 
> > On Monday 25 February 2002 03:51 pm, you wrote:
> > > my $0.02:
> > >
> > > insert into TABLE (booknum, isbn, title) values ('001',
> > > '1-56592-434-7', 'MySQL & mSQL');
> > >
> > > you want to keep all your field names on the left of
> > > values and all your data on the right.  only two sets of
> > > brackets "()".
> >
> > But I'm trying to insert *two* sets of values in the same
> > insert statement. What am I doing wrong?
> >
> > --
> > Bob Rea
> >



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Beginner needs help

2002-02-25 Thread daniel

o
i don't think you can
you'd just have to post two separate insert statments
you can run them both at the same time if you like though

INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7',
'MySQL & mSQL');
INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3',
'Mastering Regular Expressions');

the only other way to do it would be to
import the data from another database like this:
INSERT INTO table [ (coloumn...) ] SELECT ...

OR

use a LOAD DATA and import a text file.


hope that helps



- Original Message -
From: "Bob Rea" <[EMAIL PROTECTED]>
To: "daniel" <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 4:40 PM
Subject: Re: Beginner needs help


> On Monday 25 February 2002 03:51 pm, you wrote:
> > my $0.02:
> >
> > insert into TABLE (booknum, isbn, title) values ('001',
> > '1-56592-434-7', 'MySQL & mSQL');
> >
> > you want to keep all your field names on the left of
> > values and all your data on the right.  only two sets of
> > brackets "()".
>
> But I'm trying to insert *two* sets of values in the same
> insert statement. What am I doing wrong?
>
> --
> Bob Rea
>
> **
>"On the side of the box, under 'System
> Requirements', it said 'Requires Windows
> 95 or better'. So I installed Linux."
> **
>
> [EMAIL PROTECTED]  http://home.earthlink.net/~sfpetard/
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Beginner needs help

2002-02-25 Thread Eric Mayers

Bob, 

This is just a guess, but looking at
http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way
to do multiple inserts looks like:

INSERT INTO a VALUES (1,23),(2,34),(4,33);

a(col1, col2)..  Perhaps multiple inserts requires that you specify all
columns in the order that the table was defined?  I suggest you try:

INSERT into book
 values (
 null,  #booknum
 '1-56592-434-7',   #isbn
 'MySQL & mSQL',#title
 'Yarger',  #authlname
 'Randy Jay',   #authfname
 "O'Reilly",#publisher
 null,#pubdate
 null,  #dewey
 null,  #lcnum
 null,#checkin
 null,#checkout
 null   #duedate
 ),
 values(
 null, 
 '0-312-25313-3',
 'Coup de Grace',
 'Borthwick',
 'J S',
 "St Martin's Minotaur",
 null,
 '813.54-dc21',
 'PS3552.O756 C68 2000'
 null,
 null,
 null
 );


> -Original Message-
> From: Bob Rea [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 3:34 PM
> To: [EMAIL PROTECTED]
> Subject: Beginner needs help
> 
> 
> I'm getting a syntax error when I try to insert more two 
> sets of values into a table. 
> 
> I have looked at the manual on the insert statement, and 
> don't see what is wrong. 
> 
> Can someone tell me.
> 
> Here's the info.
> mysql> describe book;
> +---+-+--+-+-++
> | Field | Type| Null | Key | Default | Extra
>   |
> +---+-+--+-+-++
> | booknum   | int(20) |  | PRI | NULL| 
> auto_increment |
> | isbn  | varchar(14) | YES  | | NULL|  
>   |
> | title | varchar(50) | YES  | | NULL|  
>   |
> | authlname | varchar(20) | YES  | | NULL|  
>   |
> | authfname | varchar(20) | YES  | | NULL|  
>   |
> | publisher | varchar(20) | YES  | | NULL|  
>   |
> | pubdate   | date| YES  | | NULL|  
>   |
> | dewey | varchar(20) | YES  | | NULL|  
>   |
> | lcnum | varchar(20) | YES  | | NULL|  
>   |
> | checkin   | date| YES  | | NULL|  
>   |
> | checkout  | date| YES  | | NULL|  
>   |
> | duedate   | date| YES  | | NULL|  
>   |
> +---+-+--+-+-++
> 12 rows in set (0.00 sec)
> 
> Here's the attempt:
> mysql> INSERT into book(
> -> isbn,
> -> title,
> -> authlname,
> -> authfname,
> -> publisher,
> -> pubdate,
> -> dewey,
> -> lcnum
> -> )
> -> values (
> -> '1-56592-434-7',
> -> 'MySQL & mSQL',
> -> 'Yarger',
> -> 'Randy Jay',
> -> "O'Reilly",
> -> null,
> -> null,
> -> null
> -> ),
> -> values(
> -> '0-312-25313-3',
> -> 'Coup de Grace',
> -> 'Borthwick',
> -> 'J S',
> -> "St Martin's Minotaur",
> -> null,
> -> '813.54-dc21',
> -> 'PS3552.O756 C68 2000'
> -> );
> ERROR 1064: You have an error in your SQL syntax near 
> 'values(
> '0-312-25313-3',
> 'Coup de Grace',
> 'Borthwick',
> 'J S',
> "St Martin's Minot' at line 21
> 
> TIA
> 
> -- 
> Bob Rea
> 
> **
>"On the side of the box, under 'System
> Requirements', it said 'Requires Windows
> 95 or better'. So I installed Linux."
> **
> 
> [EMAIL PROTECTED]  http://home.earthlink.net/~sfpetard/
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: Beginner needs help

2002-02-25 Thread Daniel Rosher

Change it to 

INSERT into book(
 isbn,
 title,
 authlname,
 authfname,
 publisher,
 pubdate,
 dewey,
 lcnum
 )
 values (
 '1-56592-434-7',
 'MySQL & mSQL',
 'Yarger',
 'Randy Jay',
 "O'Reilly",
 null,
 null,
 null
 ),
 (
 '0-312-25313-3',
 'Coup de Grace',
 'Borthwick',
 'J S',
 "St Martin's Minotaur",
 null,
 '813.54-dc21',
 'PS3552.O756 C68 2000'
 );

i.e. drop 'values' for the second row

Regards
Dan

> -Original Message-
> From: Bob Rea [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 26 February 2002 12:34 p.m.
> To: [EMAIL PROTECTED]
> Subject: Beginner needs help
> 
> 
> I'm getting a syntax error when I try to insert more two 
> sets of values into a table. 
> 
> I have looked at the manual on the insert statement, and 
> don't see what is wrong. 
> 
> Can someone tell me.
> 
> Here's the info.
> mysql> describe book;
> +---+-+--+-+-++
> | Field | Type| Null | Key | Default | Extra
>   |
> +---+-+--+-+-++
> | booknum   | int(20) |  | PRI | NULL| 
> auto_increment |
> | isbn  | varchar(14) | YES  | | NULL|  
>   |
> | title | varchar(50) | YES  | | NULL|  
>   |
> | authlname | varchar(20) | YES  | | NULL|  
>   |
> | authfname | varchar(20) | YES  | | NULL|  
>   |
> | publisher | varchar(20) | YES  | | NULL|  
>   |
> | pubdate   | date| YES  | | NULL|  
>   |
> | dewey | varchar(20) | YES  | | NULL|  
>   |
> | lcnum | varchar(20) | YES  | | NULL|  
>   |
> | checkin   | date| YES  | | NULL|  
>   |
> | checkout  | date| YES  | | NULL|  
>   |
> | duedate   | date| YES  | | NULL|  
>   |
> +---+-+--+-+-++
> 12 rows in set (0.00 sec)
> 
> Here's the attempt:
> mysql> INSERT into book(
> -> isbn,
> -> title,
> -> authlname,
> -> authfname,
> -> publisher,
> -> pubdate,
> -> dewey,
> -> lcnum
> -> )
> -> values (
> -> '1-56592-434-7',
> -> 'MySQL & mSQL',
> -> 'Yarger',
> -> 'Randy Jay',
> -> "O'Reilly",
> -> null,
> -> null,
> -> null
> -> ),
> -> values(
> -> '0-312-25313-3',
> -> 'Coup de Grace',
> -> 'Borthwick',
> -> 'J S',
> -> "St Martin's Minotaur",
> -> null,
> -> '813.54-dc21',
> -> 'PS3552.O756 C68 2000'
> -> );
> ERROR 1064: You have an error in your SQL syntax near 
> 'values(
> '0-312-25313-3',
> 'Coup de Grace',
> 'Borthwick',
> 'J S',
> "St Martin's Minot' at line 21
> 
> TIA
> 
> -- 
> Bob Rea
> 
> **
>"On the side of the box, under 'System
> Requirements', it said 'Requires Windows
> 95 or better'. So I installed Linux."
> **
> 
> [EMAIL PROTECTED]  http://home.earthlink.net/~sfpetard/
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Beginner needs help

2002-02-25 Thread Nathan

Get rid of the second "values".

mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
-> "O'Reilly",
-> null,
-> null,
-> null
-> ),
-> (
-> '0-312-25313-3',
-> 'Coup de Grace',
-> 'Borthwick',
-> 'J S',
-> "St Martin's Minotaur",
-> null,
-> '813.54-dc21',
-> 'PS3552.O756 C68 2000'
-> );



- Original Message - 
From: "Bob Rea" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 25, 2002 4:33 PM
Subject: Beginner needs help


I'm getting a syntax error when I try to insert more two 
sets of values into a table. 

I have looked at the manual on the insert statement, and 
don't see what is wrong. 

Can someone tell me.

Here's the info.
mysql> describe book;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra
  |
+---+-+--+-+-++
| booknum   | int(20) |  | PRI | NULL| 
auto_increment |
| isbn  | varchar(14) | YES  | | NULL|  
  |
| title | varchar(50) | YES  | | NULL|  
  |
| authlname | varchar(20) | YES  | | NULL|  
  |
| authfname | varchar(20) | YES  | | NULL|  
  |
| publisher | varchar(20) | YES  | | NULL|  
  |
| pubdate   | date| YES  | | NULL|  
  |
| dewey | varchar(20) | YES  | | NULL|  
  |
| lcnum | varchar(20) | YES  | | NULL|  
  |
| checkin   | date| YES  | | NULL|  
  |
| checkout  | date| YES  | | NULL|  
  |
| duedate   | date| YES  | | NULL|  
  |
+---+-+--+-+-++
12 rows in set (0.00 sec)

Here's the attempt:
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
-> "O'Reilly",
-> null,
-> null,
-> null
-> ),
-> values(
-> '0-312-25313-3',
-> 'Coup de Grace',
-> 'Borthwick',
-> 'J S',
-> "St Martin's Minotaur",
-> null,
-> '813.54-dc21',
-> 'PS3552.O756 C68 2000'
-> );
ERROR 1064: You have an error in your SQL syntax near 
'values(
'0-312-25313-3',
'Coup de Grace',
'Borthwick',
'J S',
"St Martin's Minot' at line 21

TIA

-- 
Bob Rea

**
   "On the side of the box, under 'System
Requirements', it said 'Requires Windows
95 or better'. So I installed Linux."
**

[EMAIL PROTECTED]  http://home.earthlink.net/~sfpetard/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Beginner needs help

2002-02-25 Thread Georg Richter

On Tuesday, 26. February 2002 00:33, Bob Rea wrote:
> I'm getting a syntax error when I try to insert more two
> sets of values into a table.
>
> I have looked at the manual on the insert statement, and
> don't see what is wrong.
>

> ERROR 1064: You have an error in your SQL syntax near
> 'values(
> '0-312-25313-3',
> 'Coup de Grace',
> 'Borthwick',
> 'J S',
> "St Martin's Minot' at line 21

Correct Syntax is INSERT INTO table (fields,..) VALUES (values,...)
You try to use to insert 2 or more records with one insert statement,
that isnt allowed, and therefore the syntax error.

Regards

Georg

mysql,query

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Beginner needs help

2002-02-25 Thread Paul DuBois

At 15:33 -0800 2/25/02, Bob Rea wrote:
>I'm getting a syntax error when I try to insert more two
>sets of values into a table.
>
>I have looked at the manual on the insert statement, and
>don't see what is wrong.

The error message indicates that the problem is at the word "values".
The problem with your syntax is that "values should occur only once:

INSERT INTO tbl_name (column list) VALUES (list of values), (list of values);

>
>Can someone tell me.
>
>Here's the info.
>mysql> describe book;
>+---+-+--+-+-++
>| Field | Type| Null | Key | Default | Extra   
>   |
>+---+-+--+-+-++
>| booknum   | int(20) |  | PRI | NULL|
>auto_increment |
>| isbn  | varchar(14) | YES  | | NULL| 
>   |
>| title | varchar(50) | YES  | | NULL| 
>   |
>| authlname | varchar(20) | YES  | | NULL| 
>   |
>| authfname | varchar(20) | YES  | | NULL| 
>   |
>| publisher | varchar(20) | YES  | | NULL| 
>   |
>| pubdate   | date| YES  | | NULL| 
>   |
>| dewey | varchar(20) | YES  | | NULL| 
>   |
>| lcnum | varchar(20) | YES  | | NULL| 
>   |
>| checkin   | date| YES  | | NULL| 
>   |
>| checkout  | date| YES  | | NULL| 
>   |
>| duedate   | date| YES  | | NULL| 
>   |
>+---+-+--+-+-++
>12 rows in set (0.00 sec)
>
>Here's the attempt:
>mysql> INSERT into book(
> -> isbn,
> -> title,
> -> authlname,
> -> authfname,
> -> publisher,
> -> pubdate,
> -> dewey,
> -> lcnum
> -> )
> -> values (
> -> '1-56592-434-7',
> -> 'MySQL & mSQL',
> -> 'Yarger',
> -> 'Randy Jay',
> -> "O'Reilly",
> -> null,
> -> null,
> -> null
> -> ),
> -> values(
> -> '0-312-25313-3',
> -> 'Coup de Grace',
> -> 'Borthwick',
> -> 'J S',
> -> "St Martin's Minotaur",
> -> null,
> -> '813.54-dc21',
> -> 'PS3552.O756 C68 2000'
> -> );
>ERROR 1064: You have an error in your SQL syntax near
>'values(
>'0-312-25313-3',
>'Coup de Grace',
>'Borthwick',
>'J S',
>"St Martin's Minot' at line 21
>
>TIA
>
>--
>Bob Rea
>
>**
>"On the side of the box, under 'System
> Requirements', it said 'Requires Windows
> 95 or better'. So I installed Linux."
>**
>
>[EMAIL PROTECTED]  http://home.earthlink.net/~sfpetard/
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Beginner needs help

2001-03-05 Thread Rolf Hopkins

I can answer numb 1. for you but not 2.  Look up the manual for mysqldump
and load infile (or something like that, I have to check the manual myself
but I have no time to do that for you).

The other (and probably easier way) is to upgrade your Cobalt machine and
then upgrade your tables from ISM to MYISM.  If you do that, you can then
just copy the .MYD, .MYI and .FRM files from one machine to another.

- Original Message -
From: "Lee Woolcott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 2:40
Subject: Beginner needs help


> Hello
>
> Please excuse my ignorance, I am very, very new to databases and
escpecially
> MySql.
>
> I have a couple of questions that I would be most grateful if someone
could
> answer for me.
>
> 1. I have a Cobalt Raq4 with mysql 3.22.32 installed. I also have a Win98
> machine with 3.23.33 installed. I have managed to set up a simple test db
on
> my windows machine and pull out data with ASP, using PWS. I have also
> managed to set up a simple db on the Raq but have noticed that the
database
> file extensions are different. The raq has .ISD, .ISM and .FRM where as
the
> windows box has .MYD, .MYI and .FRM.
> Does this mean that I can't design the DB on my windows box and upload it
to
> work on the Raq?
> If it can be done can someone please advise me on how to do this.
>
> 2. I don't seem to be able to make a connection using the ASP admin pages
on
> the Raq. I keep getting "can't open connection". Can someone enlighten me
> please, I have followed the instructions very closely. It seems that
> everything on the Raq is different to what is stated in the MySql manual?
> i.e running mysqld gives me command not found but it will run with
> safe_mysqld, the data is stored in a different dir etc.
>
> I am sorry if I am being simple but all I want to do is set up a basic
site
> that will get info from a db using chilisoft ASP.
>
> I thank you in advance and once again please excuse my ignorance.
>
> Best Regards
>
> Lee
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php