Moving DB
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 Services www.blackmesa-isp.net
Insert problem
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 Services www.blackmesa-isp.net
mysql_connect() error
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 RUNNING on the web server just so I can talk to the other windows server. That doesn't make any darned sense!!! PHP runs perfectly on the web server until it hits the mysql code. What am I missing here as I'm REALLY dumb when it comes to Linux. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net
SSL and Windows
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.blackmesa-isp.net
Re: Query problem
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 [EMAIL PROTECTED] Sent: Sunday, June 01, 2003 19:52 Subject: Re: Query problem Hi everybody, I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-) We are not going to swear are we ? Best regards Nils Valentin 2003 6 2 07:30Sparky 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 = bite.bite_type_id), etc... However, I haven't found an example of how to do this and I need this ASAFP!! Apreciate any help. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Null problem with SELECT
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 and will be null and I still want them to display as null. But the rest of the columns from the select come up empty. What can I do to allow the query to run even with the nulls? Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query problem
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 = bite.bite_type_id), etc... However, I haven't found an example of how to do this and I need this ASAFP!! Apreciate any help. Robin E. Kopetzky Black Mesa Computers/Internet Services www.blackmesa-isp.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]