mysql Forum - Page 238

MySQL Database Forum

MySQL database (open source) - Ask questions about mysql server, setup, queries, optimization, errors, tables, syntax, functions, SQL, storage engines, MySQL cluster, replication, scalability, availability, stored procedures, views and more.

newest replies last post

views

+ Post


1 1,501 [Q] Database design thread by: Eric \| last post Jul 23 '05 by: Bill Karwin I have what should be a fairly simple design question. I usage of mySQL will revolve around a common group + user system. There can be multiple groups and each group will contain some subset of users. Each group will have a custom set of data whose values vary per user. So basically a sample structure might look like this: (some details... MySQL Database
0 402 [Q] Database design thread by: Eric \| last post Jul 23 '05 by: Eric I have what should be a fairly simple design question. I usage of mySQL will revolve around a common group + user system. There can be multiple groups and each group will contain some subset of users. Each group will have a custom set of data whose values vary per user. So basically a sample structure might look like this: Database MySQL Database
2 1,945 Tracking Arrivals & Sending Email Notification? thread by: Grady \| last post Jul 23 '05 by: Eric Help. I need to create a simple database that tracks equipment arrivals (and departures) at my facility. What I want is to create a simple form, which the receptionist could fill out, every time someone delivers something at the front door. The form would simply have a place to put the time/date, delivery method, addressee, and a brief... MySQL Database
0 1,096 Tha new rollax repliccas has finelly arrived chivalrous thread by: Josefina Durham \| last post Jul 23 '05 by: Josefina Durham ----XYGZV54616273PDAZYV Content-Type: text/plain; Content-Transfer-Encoding: 7Bit The new craze is finnally here - one of the bast sites that can give you the things you've allways wanted to get - watchees, repliccas to be correct, of the bast brand s in the world! Impress you're lady with tag heur, roleex, and more. You naame it - We... MySQL Database
1 3,115 Trouble Changing Datadir Location thread by: trt08010 \| last post Jul 23 '05 by: Michael A. Capone I'm new to MySQL so hopefully this all makes sense. I'm running mysql-3.23.58-14 on Fedora Core 3 and everything installs and comes up correctly using default locations for everything. However, I installed an 800GB RAID5 array in the server and created a new file system on it and I attempted to move the datadir location to the new file... MySQL Database
5 1,301 db/table design question thread by: G \| last post Jul 23 '05 by: Jeff North Hi, I have table/db I need to create that has a rectangle structure even when normalized, but the difficulty is that the rows can have a large number of column - over the max of what mysql can handle. If I put the data in vertical format I lose a lot of functionality. If I split the tables into n number of tables and keep the data on the... MySQL Database
0 1,541 Security Center Advisory thread by: PayPal \| last post Jul 23 '05 by: PayPal <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <STYLE type=text/css> ..dummy {} BODY, TD {font-family: verdana,arial,helvetica,sans-serif;font-size: 12px;color: #000000;} MySQL Database

0 1,224 understanding SHOW INNODB STATUS thread by: Michael A. Capone \| last post Jul 23 '05 by: Michael A. Capone Hi Folks, Is there any decent documentation out there that will give a good breakdown on how to interpret the output of SHOW INNODB STATUS (or actually, in 4.1, "SHOW ENGINE INNODB STATUS")? I've looked everywhere, and I can't seem to find any articles that will give a line-by-line breakdown and interpretation for this. There's apparantly... MySQL Database
4 1,541 Duplicating records... thread by: Jon Cooper \| last post Jul 23 '05 by: Jon Cooper I have looked long n hard at the Insert Select as being the answer to my need to create duplicate records. (Purpose is basically to allow someone to create a duplicate of an existing email template then modify it). I have tried all sorts of variations on: INSERT INTO emaillist SELECT * FROM emaillist WHERE emailid = #url.emailid# (inc... MySQL Database
4 2,813 My AMP application does not know the mysql data files reside on the same linux server thread by: MLH \| last post Jul 23 '05 by: MLH A programmer developed an AMP (Apache/MySQL/PHP) application for me. When he was done, he sent me the PHP files and the MySQL dump file. Now, when I connect to the application on my LAN using http://192.168.1.106/~mlh/credifree/index.php the AMP app still thinks the data resides somewhere else. It runs fine - as long as I leave my LAN's... MySQL Database
1 3,350 SOUNDEX function / in php - how to ? thread by: siliconmike \| last post Jul 23 '05 by: Philip Ronan Hi I'm using SOUNDEX mysql function to find similar sounding names from a table with 2 million distinct names. Unfortunately there is a single soundex code for every 200,000 names! Meaning there are only 200,000 distinct codes for 2 million entries. Is there any other function / library / technique to work around this immense 1:10... MySQL Database
1 1,892 Multiple Update - Record Locking advice thread by: oldandgrey \| last post Jul 23 '05 by: oldandgrey I'm looking at producing an application that will allow multiple users to order multiple items/ parts from what would effectively be an online store. These users could be ordering several hundred items/ parts at a time, each item/ part ordered representing one box or several hundred. Each part record will require the "total stock" to be... MySQL Database
1 1,640 full-text score returning 0 thread by: Ray Gurganus \| last post Jul 23 '05 by: rgurganus I'm using mysql 4.1.7 on one machine and 4.1.9 on another, and on both I'm having trouble returning a score on a full-text index. The following returns 26 records and all scores of 0: SELECT article.title, article.article_id, MATCH (body,subtitle,summary,title) AGAINST ('church') AS score FROM article WHERE MATCH... MySQL Database
3 2,142 Storing partial dates thread by: Murphy \| last post Jul 23 '05 by: Murphy I am creating my first mySQL database to store genealogy information and would like fields for date of birth and date of death. Unfortunately some older records are quite vague with only the year being available in some cases. I am concerned that if I store only the year or month & year where available then when the information is retrieved... MySQL Database
1 1,512 What naming convention does mysql use for database files? Where does it put them? thread by: MLH \| last post Jul 23 '05 by: MLH I asked mysql to create a database named credifree (see below) and later checked for filenames on the system like credifree but I found nothing indicating that mysql created any filenames like credifree - ideas as to why not? From the captured screen-text below, you can see that the credifree database does indeed exist... ... MySQL Database

5 1,228 query problem thread by: Danny Kjærgaard \| last post Jul 23 '05 by: Felix Geerinckx Hi. I have a table containing: id, date, open, close, high, low, volumen, share_id The table is used for daily stock information. I want to make a query that count rows where open, close, high,low, volumen, share_id are the same for the last 2 days that are in the date field. MySQL Database
0 1,117 Replication Setup thread by: Frank Natoli \| last post Jul 23 '05 by: Frank Natoli Am attempting to setup master/slave replication in Windows environment. Both master and slave are running WinXP. Master appears to be logging correctly, but cannot get slave to update its databases and tables from the master. MySQL 4.1.10a-nt is running on the master. MySQL 4.1.7-nt is running on the slave. Only workgroups are used on LAN,... MySQL Database
0 1,045 fedora core 3 or rhel 4 thread by: yasaswi \| last post Jul 23 '05 by: yasaswi Does MySQL server run well on RHEL 4 or on Fedora core 3 without any problems? Any production issues? Thanks, Yasaswi MySQL Database
2 1,113 Group votes into low, medium and high thread by: lannsjo \| last post Jul 23 '05 by: lannsjo I have a table with votes: --------- \| vote \| \| 5 \| \| 1 \| \| 9 \| \| 6 \| \| 2 \| \| 1 \| \| 3 \| MySQL Database
0 1,743 InnoDB Deadlock behavior when selecting by primary key for update thread by: steven \| last post Jul 23 '05 by: steven In both mysql version 4.0.16 and 4.1.8 I'm running into deadlock behavior that I don't understand: can anyone explain why the following happens? Heres a basic table definition that exhibits the behavior and some data I inserted: create table deadlock_test ( id integer not null, primary key(id) ) type=innodb; MySQL Database
1 1,303 Kind of a security question (I guess) - it's a bit confusing thread by: MLH \| last post Jul 23 '05 by: Aggro mysql -h host -u user -p Running the above command expects actual values to be substituted for host and user. User I know about. That can be root. And now I know that this root has NOTHING to do with the linux OS login root. But host, now, that's a different matter. I think I have 2 host name options. One is appserver and the other is... MySQL Database
0 1,013 x86_64 thread by: yasaswi \| last post Jul 23 '05 by: yasaswi Is any one using 4.1.10-standard server (x86_64) on RHEL 3, in production? Do you know of any issues or problems? Also do you actually notice the performance benefits of going with 64 bit MySQL? Faster queries etc? Thanks, Yasaswi MySQL Database
1 3,073 mysql_init() initialization problem thread by: Chinmay Shah \| last post Jul 23 '05 by: Chinmay Shah hi, when i try to call the mysql_init function it is not getting initilized properly. can someone help me thanks chinmay MySQL Database

0 1,050 Error logs thread by: John \| last post Jul 23 '05 by: John Hi I'm using mysql 3.23.54 over Red Hat Linux 9. I'm having problems with the error logs. I've run mysqld start --l, mysqld start --log, mysqld start --log-error, and mysqld start --log=MyErrors.log and not once managed to find a log file. I'm running mysql and then issuing:- SELECT * FROM myFile WHERE 1; MySQL Database
1 4,389 How to configure remote host connectivity? thread by: Fred \| last post Jul 23 '05 by: Bill Karwin I just started using MySQL, and cannot find how to configure host access in the my.cnf file. I want to be able to allow access to a MySQL database from a remote host, and also from a particular network. How do you configure access of this sort? -Thanks MySQL Database

+ Post