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
