FAQ

MySQL > mysql > February 2008

Search Discussions

125 discussions - 378 posts

  • Hi, I have a performance problem with one of my SQL queries. It's a rather complex one so I'll spare you the details. This is the situation: In my system, there's messages, tags and keylists. Each ...
    Yves GoergenYves Goergen
    Feb 10, 2008 at 10:30 pm
    Feb 11, 2008 at 10:09 pm
  • Hi, I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason /tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and restart it causing db corruptions as there is no ...
    IanIan
    Feb 28, 2008 at 10:05 am
    Mar 1, 2008 at 10:41 am
  • We need to replicate a table to a third part. The information in the table is pretty much public, with the exception of one column. Is it possible to replicate all of the tables with the exception of ...
    Gary W. SmithGary W. Smith
    Feb 20, 2008 at 12:17 am
    Feb 21, 2008 at 4:24 pm
  • Hello, This time I'm rearly not sure if this is possible to do. I've got two queries that I would like to bring together to make only one query ... I've got a list of users And also a login table I ...
    RichardRichard
    Feb 19, 2008 at 4:55 pm
    Feb 20, 2008 at 10:02 am
  • Dear List, I want to create a stored procedure that runs a query using the "IN" operator (or is "IN" a function???) on values sent as argument. That is, my procedure should be called with something ...
    Magne WestlieMagne Westlie
    Feb 7, 2008 at 1:58 pm
    Feb 12, 2008 at 9:39 am
  • Hi Everyone, I am attempting to write a PHP application that reads info from a MySQL database, and I'm wondering if I can set up a column in one table that gets it's info from a field in another ...
    Jason PruimJason Pruim
    Feb 28, 2008 at 5:59 pm
    Feb 28, 2008 at 9:23 pm
  • Hi List, i wrote this alrready in mysql-forum a few days ago, but did not get any answer. :( i try to do backup with mysqldump from external host with routines. mysqldump -R -h my.host.name -u myuser ...
    Andre HübnerAndre Hübner
    Feb 20, 2008 at 8:20 am
    Feb 21, 2008 at 12:26 pm
  • hi list, how can I rename a database with full innodb tables ? The version is 4.1 Thnaks all
    Thomas RasoThomas Raso
    Feb 12, 2008 at 4:20 pm
    Feb 13, 2008 at 9:25 pm
  • Hi, I've got an error message from MySQL 5.0 that I don't understand. UPDATE "message_revision" SET "HasData" = 1, "Data" = (SELECT "Data" FROM "message_revision" WHERE "MessageId" = 7 AND ...
    Yves GoergenYves Goergen
    Feb 5, 2008 at 4:26 pm
    Feb 7, 2008 at 11:06 am
  • I'm looking for a good way to store user preferences. The most straightforward way is just to add a column to the Users table for each preference we're looking to store. Downside is that it requires ...
    Waynn LueWaynn Lue
    Feb 28, 2008 at 9:52 am
    Mar 3, 2008 at 6:14 pm
  • Hi all: Our sistem crashed and we're trying to recover our data. The disc is fine but the OS is gone, so I'm trying to get at the actual mysql databases document. Does anybody know where to look for ...
    Riccardo PerottiRiccardo Perotti
    Feb 8, 2008 at 8:55 pm
    Feb 11, 2008 at 1:34 am
  • Hi All, My web server log error is " NULL::dba can't connect to mysql" The above error shows occasionally in the error log file of apache. Every thing is fine on the mysql database server. It happens ...
    Krishna Chandra PrajapatiKrishna Chandra Prajapati
    Feb 26, 2008 at 5:08 am
    Feb 26, 2008 at 6:52 pm
  • I have three or four different ALTER TABLE commands I need to run on a 9 million row table (related to the previous email I sent). I've tried running it before and it just takes way too long, so I ...
    Waynn LueWaynn Lue
    Feb 23, 2008 at 11:55 am
    Feb 26, 2008 at 2:09 am
  • I'm considering studying for: Certified MySQL Associate (CMA) http://www.mysql.com/certification/candguide#t21 At first glance, it seems to follow: ...
    ThufirThufir
    Feb 20, 2008 at 11:13 am
    Feb 25, 2008 at 1:29 pm
  • So I am trying to use mysqldump --tab for the first time. I am running into the same problem everybody does on their first try --- Errcode: 13. I have set the permissions on the target directory to ...
    Mike SpreitzerMike Spreitzer
    Feb 22, 2008 at 11:41 pm
    Feb 23, 2008 at 6:00 am
  • Hello, I don't know if it is possible to do this with mysql alone ... Here goes : I've got a database list which is like to following : Num | Name | Colour ------------------------------------------- ...
    RichardRichard
    Feb 14, 2008 at 3:34 pm
    Feb 16, 2008 at 4:54 pm
  • Hi there, I'm new with innodb and I'm not sure it's good to go with innodb for my personnal goals. Ok, let's assume I 've a table and want to select the first 10 rows from that table but I want to be ...
    Frederic BelleudyFrederic Belleudy
    Feb 4, 2008 at 10:00 pm
    Feb 5, 2008 at 4:26 pm
  • I'm trying to figure out which limits I'm hitting on some inserts. I have 50 plus tables lets call them A_USER, B_USER, C_USER etc which I daily refresh with updated (and sometimes new) data. I ...
    PhilPhil
    Feb 28, 2008 at 4:20 pm
    Mar 5, 2008 at 11:15 am
  • hello i have a table "vote" which has the columns "voter" and "candidate". i would like to make a list of the most popular candidates *except* those who are on my favorite list. using a sub-select, ...
    Olav MørkridOlav Mørkrid
    Feb 27, 2008 at 2:05 pm
    Feb 28, 2008 at 10:39 am
  • I am new to MySQL, and wonder if I have done something terribly stupid. I have an InnoDB table with 27 million rows. Without thinking very much, I issued the following command through the GUI ...
    Mike SpreitzerMike Spreitzer
    Feb 19, 2008 at 10:20 pm
    Feb 20, 2008 at 9:59 pm
  • Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a ...
    Esbach, BrandonEsbach, Brandon
    Feb 18, 2008 at 10:07 am
    Feb 19, 2008 at 7:15 am
  • We're trying to upgrade from 4.1.20 to 5.0.54. The problem is running mysql_upgrade. It's turning out to be that about 70% of our tables (over 800GB) are being needing repair. The question is, will ...
    Hayden LivingstonHayden Livingston
    Feb 17, 2008 at 3:01 am
    Feb 17, 2008 at 3:38 am
  • I have two different databases on the same 5.0 server that have the same tables and structure. They also have very nearly the same data. For one of the tables I'd like to run a query to find the ...
    James EatonJames Eaton
    Feb 11, 2008 at 10:28 pm
    Feb 12, 2008 at 4:08 am
  • Hello, I have like 50K databases on my server, one for every user. I am experience delay in the command 'use database' which is issued by every user when he connects to the database. Can anyone here ...
    ImadImad
    Feb 1, 2008 at 11:44 pm
    Feb 3, 2008 at 12:06 am
  • Hello I am running a Freebsd server: 1. Software: Apache 1.3 mysql 5.0.27 php 4.4 2. Hardware: 2 intel procerssors 4 gb ram RAID 10 with hard drives 15K rpm I am having this problem quite often now. ...
    VeeJayVeeJay
    Feb 10, 2008 at 9:42 am
    Jun 16, 2008 at 9:51 am
  • I have a table with millions of rows. I am not sure exactly how many rows it has, I get a different answer every time I ask! What's going on here? This DB is used only by me, and only by explicit ...
    Mike SpreitzerMike Spreitzer
    Feb 21, 2008 at 4:41 pm
    Feb 21, 2008 at 6:16 pm
  • Greetings, I've got a retail operation with mysql 5.0.22 on linux pc's across the country, and i need some input on setting up a backup strategy, preferrably without purchasing a package. We're ...
    P. EvansP. Evans
    Feb 15, 2008 at 4:50 pm
    Feb 19, 2008 at 9:37 pm
  • I have a MYsql table with following columns Node ID, Comment ID, Text, Date. Coment ID is primary key. For each Node ID there are one or more comment IDs (comments). There is a threshold ...
    Santosh KilledarSantosh Killedar
    Feb 17, 2008 at 12:52 am
    Feb 19, 2008 at 4:53 pm
  • table users id user_id user_name 1 M100001 Shirley 2 M100002 Bruce 3 M100003 Fred 4 M100004 Albert 5 M100005 Elizabeth 6 T100001 Helen 7 T100002 Tracy 8 T100003 Charles 9 T100004 Jack 10 T100005 Ann ...
    King C. KwokKing C. Kwok
    Feb 18, 2008 at 8:34 am
    Feb 19, 2008 at 11:09 am
  • Hello: I just stumbled on this hard to explain problem. Below select * from BigTable (BigTable has 5 million rows) takes forever to even print out the first row. as you could see from the sql, it is ...
    DvdDvd
    Feb 7, 2008 at 7:16 pm
    Feb 8, 2008 at 5:14 am
  • Hello! I am looking for an easy solution for eliminate duplicates but on a row level. I am having 2 tables. 1 destination for all not duplicated info (a) and 1 for input table (b) which might have ...
    Artifex MaximusArtifex Maximus
    Feb 4, 2008 at 4:36 pm
    Feb 8, 2008 at 12:54 am
  • Hi thank you for reading my post Is there a development workbench or development/ administration studio available for linux? Whether from MySQL AB itself or other 3rd party companies? Thanks -- View ...
    LegolasLegolas
    Feb 7, 2008 at 10:59 pm
    Feb 7, 2008 at 11:36 pm
  • Having a bit of trouble deleting 8645 duplicate rows... #//mySQL is broken and you can't reference a table you're deleting from in a subselect. #//http://www.thescripts.com/forum/thread490831.html ...
    Daevid VincentDaevid Vincent
    Feb 5, 2008 at 2:44 am
    Feb 5, 2008 at 9:57 pm
  • Hi, I'm wondering if the following can be done.... UPDATE tbe_gallery SET tbe_gsa.gsa_paperprice = tbe_gallery.gallery_gsaprice_paper WHERE tbe_gallery.gallery_id = tbe_images.img_rel_id AND ...
    M i l e sM i l e s
    Feb 28, 2008 at 3:09 am
    Feb 29, 2008 at 8:16 pm
  • I'm reading "SQL for dummies" and one of the more interesting sections was on recursion. The example query was something like: WITH RECURSIVE ReachableFrom (Source, Destination) AS (SELECT Source, ...
    ThufirThufir
    Feb 27, 2008 at 7:27 am
    Feb 27, 2008 at 2:52 pm
  • I have a table countrystats defined as CREATE TABLE IF NOT EXISTS `countrystats` ( `proj` char(6) NOT NULL default '', `country` char(50) NOT NULL default '', `score` double default NULL, `nusers` ...
    PhilPhil
    Feb 27, 2008 at 12:04 am
    Feb 27, 2008 at 1:12 pm
  • Hello there, I am running OS X Leopard on an Intel based iMac machine... Followed the instructions to a T and everything works as described in: ...
    Unnsse KhanUnnsse Khan
    Feb 23, 2008 at 10:08 am
    Feb 26, 2008 at 2:31 am
  • I just got an email from the list robot asking me to confirm my request to unsubscribe. The only problem is, I did not ask to unsubscribe! Is anybody else getting this? Thanks, Mike
    Mike SpreitzerMike Spreitzer
    Feb 25, 2008 at 4:56 pm
    Feb 25, 2008 at 5:30 pm
  • I'm doing a top 10 list from a database based on a group by and order by, something like select UserId, count(*) as NumActions from Actions group by UserId order by NumActions desc limit 10; Is there ...
    Waynn LueWaynn Lue
    Feb 22, 2008 at 10:38 am
    Feb 25, 2008 at 7:31 am
  • I'm doing the above migration as mentioned in the subject line. I figured I would use the MySQL Migration Toolkit to help it along but it won't let me connect to my 3.23.49 server. Is there any other ...
    Ed CurtisEd Curtis
    Feb 22, 2008 at 6:05 pm
    Feb 22, 2008 at 7:38 pm
  • I am trying to relocate MySQL and a database to another hard drive on the same system. According to this page, http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the impression that ...
    Kevin ChenKevin Chen
    Feb 21, 2008 at 7:44 am
    Feb 21, 2008 at 3:29 pm
  • Hi, this Thursday, Stewart Smith will give a MySQL University session: http://forge.mysql.com/wiki/Checking_Memory_With_Valgrind Please register for this session by filling in your name on the ...
    Stefan HinzStefan Hinz
    Feb 20, 2008 at 12:33 pm
    Feb 21, 2008 at 1:13 pm
  • I'm trying to change the definition of a field and getting 1025 errors when I try. Here's a simplified reproducible test case, on MySQL 5. CREATE TABLE `Users` ( `UserId` int(11) NOT NULL, PRIMARY ...
    Waynn LueWaynn Lue
    Feb 19, 2008 at 9:53 pm
    Feb 20, 2008 at 3:53 am
  • Hi, Is it possible to call from within MySQL an external PHP script ? I've read "MySQL Stored Procedure Programming" from O'Reilly but found nothing :( How can I do this ? Any help would be ...
    Mário GamitoMário Gamito
    Feb 19, 2008 at 7:55 am
    Feb 20, 2008 at 1:08 am
  • Hi All, I am working with MYISAM tables split by year, like: data2003, data2004, data2005, data2006, data2007, data2008, all having the same definitions. To speed up the query process, I also defined ...
    C.R.VegelinC.R.Vegelin
    Feb 18, 2008 at 4:33 pm
    Feb 19, 2008 at 11:09 am
  • Hello, I need to insert one entry(one line) containing 10 values, some from a form(ok) but some from two other tables, what is the best way to do this ? Say for example I need to enter this ...
    RichardRichard
    Feb 17, 2008 at 9:09 pm
    Feb 17, 2008 at 10:26 pm
  • Hi, I have a small issue that i can get my head around to solve: Is it possible to do a select from two tables using a union all (select * from t1 union all select * from t2), and have it display the ...
    Miguel VazMiguel Vaz
    Feb 17, 2008 at 12:04 am
    Feb 17, 2008 at 7:40 am
  • If I have (2) tables. Like GROUP , CODE GRP1, AA GRP1, AB GRP1, AC GRP2, BA GRP2, BB GRP2, BC And; USER , UCODE ME, AA ME, AC YOU, AA What's the best way to query to find out if "ME" has all codes in ...
    Shawn CummingsShawn Cummings
    Feb 14, 2008 at 7:41 pm
    Feb 15, 2008 at 2:12 pm
  • I'm running into a difficult to reproduce problem with a view which is similar to the following: ---- CREATE TABLE Common ( COMMON_ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, COMMON_NAME VARCHAR(50), ...
    Lev LvovskyLev Lvovsky
    Feb 12, 2008 at 1:18 am
    Feb 14, 2008 at 6:42 pm
  • Hi All, Is there any plan to release a binary version for mysql-5.1.23-maria-alpha for Linux 64 for AMD ? Thanks in advance for your help, Mariella Looking for last minute shopping deals? Find them ...
    Mariella PetriniMariella Petrini
    Feb 14, 2008 at 1:18 pm
    Feb 14, 2008 at 6:05 pm
Feb 2008
123
Group Navigation
period‹ prev | Feb 2008 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions125
posts378
users154
websitemysql.com
irc#mysql

154 users for February 2008

Baron Schwartz: 18 posts Peter Brawley: 14 posts Yves Goergen: 11 posts Mike Spreitzer: 9 posts Moon's Father: 9 posts Mos: 9 posts Richard: 9 posts Phil: 8 posts Waynn Lue: 8 posts Paul DuBois: 7 posts Rob Wultsch: 7 posts Ian: 6 posts Andre Hübner: 5 posts Ben Clewett: 5 posts Dan Buettner: 5 posts Gary W. Smith: 5 posts Joerg Bruehe: 5 posts Magne Westlie: 5 posts Saravanan: 5 posts Thufir: 5 posts
show more
Archives