MySQL Database Forum

I installed Red hat linux 9 and then i installed mysql. When i tried to to start mysql using safe_mysqld & the daemon got started and then ended in a sudden. Got a message "030828 mysql ended ". What may be the problem. Please help! Thnax in advance Lincy

Hello, I hope this is a much easier problem than I thought: I am doing a query to find the word "mad" in the studios.studio column and in the artists.artist column. I basically only want to have a count of how often the word is found, however, the resulting ids should be counted unique. select studios.id, artists.studio_id from studios,...

Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help? TIA, Wade

Hi. I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in this database has book.frm, book.MYD, book.MYI _AND_ book.TMD. When I've created a database in phpmyadmin/mysql, moved all the files into the proper directory, every table can be looked at and selected but...

Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on one server that can all be classified as...

Updating from Mysql4.0 to 4.1.1, pb with phpMyAdmin 2.6.0-alpha1 and phpAds 2.0 Environment: Sun servers running solaris 2.8 Php 4.3.6 Apache 1.3.29 Mysql 4.1.1

Im trying to build a graph of values from a counterTable. (Eg - get a list of how many times a page was requested in a week period with each y value being a day). If the table looks like this... counterTable +-----+------------+ | id | date |

MySQL v 3.23.56 for pc-linux-gnu on i686 How do I know what database I am 'using' ? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use databasename'. I am now using that database but have no visual cue. How do I include the username, database name, etc in the 'mysql>' prompt?

Hello, I remember seeing some software that will create sample data, but cant remember what it is. Its was also free. Anybody know what it is? Thanks Mike

Hi All I found some files in mysql directory with names like #sql-358_2698.MYD. Is this a temporary file created by an alter table statement? May I delete it since all my tables are ok? Thanks in advance Oswaldo Castro

Hi All Iam using the libmysql.lib in my C++ app, I have a mySQL database setup on a remote server something.dyndns.org and using port 2000, I use the following little bit of code to try and access the database but it just sits there and does nothing. Iam I doing something wrong, not doing something or is there a problem using libmysql with...

Hi all I have been using MS Access for some time and want to convert/move to mysql I should like to import the tables rather than re entering all the data can anyone point me in the right direction or where I can find a good intro to MYSQL?

I have 2 tables: Table1 contains (among other things): ID Data1 Data2 Data3 1 aaa bbb ccc 2 ddd eee fff 3 ggg hhh iii Table2 contains (among other things:

I've been working on a project for awhile now and can't seem to get it working the way I want. What I've got is a database with different category's and products below them. The thing I'm having trouble with is the products all have different sizes and colors, and each (different) product has it's own id and quantity. My first idea was to...

We have a complex statement created from a web application which does not work correctly. During analysis, we could reduce this statement to the following: SELECT * FROM table WHERE ((row1>=0 AND row1<=2 AND 1) OR 0) AND row2=1; "row2=1" is not being computed, we also get results with row2<>1; When we swap the values of our last "AND"...

Dear MySQL Contributors, I am studying for a Master's degree with Henley Management College in the UK, and in the past have used a variety of Open Source Software. As part of my course I am conducting a survey in an attempt to identify the critical success factors for Open Source projects. If you are a user or developer for MySQL, I would...

Can someone please tell me if my problem with the punctuation in a fulltext= search is a bug or limitation? Ultimately the users of the system i built = do not want to have to try using the + search then trying the * search for = all the words which will obviouslly return a lot of results, is there a wor= k around please let me know thanks. ...

I will be out of the office starting 21/08/2003 and will not return until 08/09/2003. I will respond to your message when I return. If you have any urgent queries please contact Stuart Mclean ====================================================================== Disclaimer Notice This message (including attachments) is legally...

I can't seem to find a binary distribution of mysql 4.1. Can some one tell me if there is one and where to get it? Or is it not as simple as finding a setup.exe? -- Chris W "They that can give up essential liberty to obtain a little temporary safety

I've recently downloaded the Windows mySQL 5 binaries. Is there any GUI that supports the creation of Stored procedures? I'm using mySQLcc 0.9.3 and this doesn't seem to like them (from a SQL window) unless there is a trick that I'm missing. Cheers Rob

Hello group, I have a table with the next contents. It lists data about : Who sent what kind of message at what time. For the Level column: The highest level is Critical, the middle is Warning, the lowest is Info. Id Timestamp Level 1 12:00 Info 1 13:00 Warning

No one has replied to my post. ----- Original Message ----- From: "I.P." <jancio_wodnik@wp.pl> To: <mysql@lists.mysql.com> Sent: Monday, August 18, 2003 1:01 PM Subject: mysql 4.0.14 + replication + windows XP PROF Hi, it's my story.

hi there, i am trying to remove values from a list menu if the join table doesnt have keys when a key is selected for instance: locations locationID locations_join locationID shotlistID SELECT SQL_NO_CACHE l.locationID , l.location FROM locations l LEFT JOIN locations_join lj ON l.locationID = lj.locationID WHERE l.locationID NOT IN

First, this may not be the correct newsgroup. I have some relatively basic questions on SQL. I tried to find a newsgroup that was specifically just about SQL, and was surprised to find that all the SQL-related newsgroups seem to be product related. But if I missed something, and someone can steer me to a correct newsgroup, please do so. ...

Hello, Until recently I ran a php/apache mySQL wbsite on MacOSX. For some reason I can't get the machine working again so now the site is offline. I succeeded to copy the MySQL data from the Mac OX partition. However, this is the 'raw' data - not a SQLdump but the frm, myd and myi files for each table. The data is not of much use if I want...