MySQL Database Forum

This is a freebie for you. Visit : http://bullseye.tvheaven.com Thank you.

I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is...

Hi, I am using MySQL for a table which will have 100M+ records, avg length of records being 130 bytes. When the number of records reach approx. 25M (and the file size close to 4GB), the rate of inserts falls drastically from 800 per second to 30-40 per second. Details: * MySQL 3.23.58 on Fedora Core 3

Hi all! Is it possible to bind MySQL 4.1 to more than 1 interface? Will multiple 'bind-address=x.x.x.x' statements do the job? Regards, Evert

Hi. We're running mysql 4.1.2-alpha on a Redhat linux box. Every time we have a power outage, or the machine shuts down w/o shutting down the database, I always have the error InnoDB: Unable to lock DATADIR/ibdata1 with lock 1, error: 11: fcntl: Resource temporarily unavailable (edited location of DATADIR to protect the innocent)

Hi everyone I'm using the "MySQL Administrator" program to keep tabs on the health of a web system i am developing. I think it's nice to have quick (gui) feedback on the query cache, memory variables, and other status variables. I've noticed that one of the status variables, "Aborted_connects" has been increasing steadily. This is...

I have a datetime field that records date and time. This field records when rec is created. I also have a timestamp field that records whenever the record is updated. I noticed that when i first create the record, the update time is about 3-5 minutes before the create time. The update time and create time has to be identical. How can one lag...

Help! I try to install mysql++ for SuSE 9.3, but I cannot compile any C++ program. Does anybody have any experience on this? Thanks, Matthias

Hello guys Just wanted to let you know that we added a new web gateway t *mailing.database.mysql* at TechieGroups.co From our web site you can read and reply to messages posted in thi group and you can also see old messages from 06-26-2003 to the presen day The url to the web gateway for this forum is

I need to create report where will be shown total quantity of all rows for every hour in some data range. I have a table where I have column in DATETIME format. I have problem to create sql query where I have to get result of the all counts for every hour of the date range. Something like that: from starting hour to final hour = total row...

ANNOUNCEMENT: A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a new Usenet newsgroup: comp.databases.mysql The proposal and related discussion can be read in the Usenet group news.groups ... feel free to weigh in and make any suggestions you may have. Message-ID: <1118086694.23087@isc.org>

configure goes goes fine but make produces loads of problems I installed GNU versions of make, tar and libiconv and all installed fine. I hope someone know what this means ? <unknown> 0xe38 /usr/local/lib/libz.a(infblock.o) <unknown> 0xe3c /usr/local/lib/libz.a(infblock.o)

How do you get the current month - 1 month? (so not a particular day, but the whole month) Thanks, Gary

Hey all, Here's a question for you, my hosts have told me that that one my pages, php, was causing their server to reboot because there were too many open connections and that they should be closed. Now, correct me if I am wrong but I thought that the connections were closed after a minute of inactivity. Does this sound right? Could...

Hi all, I just cannot get the services to start for mysql and notice that there is no my.ini to delete. How do I create a new one? Many thanks Sam

Hi All, I have a situation here in mysql: The table desc is: Field Type Null Key Default Extra -------- ------- ------- ------ ---------- -------- dn_date date PRI 0000-00-00 dn int(10) PRI 0 ctr1 int(10) YES (null)

Hello, I would like to know whether it is possible to return prematurely from the body of a MySQL 5 procedure. It seems MySQL 5 only allows the RETURN keyword in PROCEDURES, so I end up having to solve this problem by using a whole bunch of nested IF statements. Is there a better way? Thanks! Neil

Does anyone know how to do a sort to find the most recent distinct records. We have records with equipment, and activities the equipment was used for, but I need a distinct list of where the equipment currently is, if I do a distinct ...order by date, it will perform the distinct first, ahead of ordering. Thanks for your help.

Hi all, since a few years I use the following statement to find duplicate entries in a table: SELECT t1.id, t2.id,... FROM table AS t1 INNER JOIN table AS t2 ON t1.field = t2.field WHERE t1.id < t2.id

Hello jsut a quick question... Is it possible to alter the DATABASE structure after it is CREATED AND POPULATED WITH RECORDS. For example RENAME fields, Change datatypes etc... If not what is the best way of doing it and then restore my data? I use MySQL - MyISAM tables Thanks!!!

When doing an insert into...values, how do I pad out a timestamp field?

Hi all Well, I didn't want to have to bring this question to someone else to answer, but I am truly flummoxed and could use some help. It all boils down to trying to find the number of jobs available in a particular state. I have two tables, one called STATES and one called WORK. Here are excerpts from both: STATES table: StateID |...

I did a mysqldump --opt database -u username -p > outputfile.txt on Machine A, which is running 4.0.12. Then on Machine B, which is running 4.1.12 I did the following, mysql -u username -p database < outputfile.txt It loaded about 20 tables file, but then I got an error saying there is a syntax error. Please help. Thanks, Yasaswi

I can retrieve today's date: mysql> SELECT CURDATE() AS begin; +------------+ | begin | +------------+ | 2005-06-01 | +------------+ 1 row in set (0.00 sec)

Hello all, This might sound so rudimentary nobody pays any attention to it, but in all the manuals I have scoured in the last week - trying to understand the fundamentals of My SQL - it has never been discussed - and I need to know the following:- (1) "What is the structure of a database" (What is the directory tree like on the server) -...