Re: using between

From: Rob Brooks Well, we have this db with various ip address ranges and the country of origin associated with each ... the format is: countryOfOrigin FromIP ToIP --- -- US some lower bound some upper bound Canada some lower bound some upper bound Etc... So the

Re: using one query to save data in 4 tables

From: James Black Basically, I want to store a user in one table, then get the id for the user I just saved, and store three more rows, each in a different database, using the user's id in the insert statements. I don't think it can be done with a single statement, but you actually don't need

latin2_croatian_ci collation bad.

It was bad in version 4.0 and it's bad in 4.1. Characters should be sorted like this: a b c d e f g h i j k l m n o p q r s t u v w x y z I fixed latin2.xml file and uploaded it at http://www.ambra.rs.ba/files/latin2.xml -- MySQL General Mailing List For list archives:

Server not resolving and hostnames

I'm running multiple mysql servers on a local network. One of them has an additional network interface to the outside world. This server is the only one properly resolving any hostnames. All other servers fail to resolv anything. I'm running bind9 named for my outside domain and a local domain

Need help coverting MDB SQL

Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a forum run by MDB and in the transfer as you know...it won’t work. I have used PHPBB and I like it and want to use it. We need to convert the MDB to SQL. I have DL 2

Re: Need help coverting MDB SQL

- Original Message - From: Ricky Groleau [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 26, 2005 10:13 AM Subject: Need help coverting MDB SQL Hello, I have tried and i have failed. I am trying to help out a non-profit site in their move. The old site had a

Re: Need help coverting MDB SQL

Microsofts Acesss that makes ASP pages. The databsae is saved as MDB. Yes, it does have a uplink, my problem is lack of experience with SQL. It asks for localhost, but of course that i smy computer and I dont have any SQL or anything on it. I tried to send it to my sever, but I am lost..is it

Slow access Apache + PHP + MySQL

Hi List, I have 4 web based systems developed using PHP4 and MySQL accessed for 10 users. The Web Server and Database Server were running ok on a Mac OS X 10.3 G4 dual. However, since we move to a new server, the access becomes very slow. This was not expected since we move to a 64 bits high

InnoDb ERROR

Hi, I'm getting the following error in my logfile 050325 15:44:57 InnoDB: ERROR: the age of the last checkpoint is 120801862, InnoDB: which exceeds the log group capacity 120792269. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10

Re: Need help coverting MDB SQL

Sorry, I don't know how to help you with this; I've never really worked with MDB files or ASPs. I have no experience with the tools that you are using to extract data from the MDB files so I can't answer your questions about IP addresses either. Maybe someone else on this list can help

RE: Slow access Apache + PHP + MySQL

Your request is just to broad to answer. There are lots of places to look but I doubt php is causing your slowdowns. Poorly written php code will cause slowdowns not the server compiled php though. Lots of server monitoring script monitoring and logging you can start to trace down problems like

RE: Need help coverting MDB SQL

Try MydbPAL at www.it-map.com. Its a FREE product that will do a complete .mdb (access) to My SQL translation - schema and data. There is a learning curver but you can follow the tutorial which takes you thru an mdb conversion Tim Hayes -Original Message- From: Rhino [mailto:[EMAIL

Optimizing server variables for unindexed queries

Greetings, Suppose I have a MySQL server which processes lots of queries that cannot use indexes on VARCHAR fields because they involve REGEXP clauses and LIKE '%...%', most of them also having an ORDER BY. Both MyISAM and InnoDB tables. What would be the best server variables to tune in that

help-a-noob: WHERE statement not working

Dear list, Happy Easter if anyone else is working. This statement is returning a syntax error when I insert the WHERE line: -- SELECT tasks.task_id, tasks.name AS taskname, tasks.deadline, tasks.project_id,

Re: help-a-noob: WHERE statement not working

- Original Message - From: Chris Kavanagh [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 26, 2005 9:41 PM Subject: help-a-noob: WHERE statement not working Dear list, Happy Easter if anyone else is working. This statement is returning a syntax error when I

install Mysql----to ./mysql_install_db ERROR

mandrake 10.1 mysql 4.1.10a [EMAIL PROTECTED] bin]# ./mysql_install_db Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-' for key 1 Fill help tables angin continue next steup also error [EMAIL PROTECTED]