Moving DB

2003-07-09 Thread Sparky Kopetzky
I have a database that is getting too big for the drive it's on. How do change my.ini to make it see everything after I move the mysql/data folder?? or is there more to it than that?? BTW - I'm running on Windows NT 4.0 SP6 w/ gig of ram... Robin E. Kopetzky Black Mesa Computers/Internet Service

Insert problem

2003-06-30 Thread Sparky Kopetzky
Greetings!! I'm trying this insert and it will not run in batch mode. I think the '' syntax is right but what else am I missing?? insert into registry set registry_program="EA", registry_key="BASE_PATH", registry_value="f:auction"; Robin E. Kopetzky Black Mesa Computers/Internet Se

mysql_connect() error

2003-06-10 Thread Sparky Kopetzky
Good afternoon! I have Apache w/php installed on one server. I have mysql installed on a windows machine. I keep getting this error 'Call to undefined function: mysql_connect()' in my php script. Now, according to what the Redhat RPM is telling me about php-mysql is that I have to have mysql RU

SSL and Windows

2003-06-09 Thread Sparky Kopetzky
Does anyone know how to turn the SSL on for mySql for Windows?? I need to encrypt and decrypt certain items in a database and the manual says add the OpenSSL package but there isn't one for Windows. Help! Thanks in advance!! Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmes

Null problem with SELECT

2003-06-03 Thread Sparky Kopetzky
Greetings! I have a query for a report that accesses columns that could possibly be null. Here's an example: SELECT blah, blah, blah FROM bite bite, person agency WHERE bite.bite_id = "AC-2003-0004" AND agency.person_id = bite.bite_agency_id; bite.bite_agency_id and other fields like this could

Re: Query problem

2003-06-02 Thread Sparky Kopetzky
No, not swearing - just As Soon As Financially Possible!!! Robin *** Still need an answer if someone can help * - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Sparky Kopetzky" <[EMAIL PROTECTED]>; "My Sql List"

Query problem

2003-06-02 Thread Sparky Kopetzky
I have a view I need to create from several tables where I'm looking up one value from a table and need to add it to the Select stmt like this: SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id = bite.bite_animal_sex_id), type (SELECT type_meaning FROM type WHERE type_id