Grokbase Groups MySQL mysql July 2009

Search Discussions

93 discussions - 320 posts

  • A client deleted their database and did not have a slave in place for backup. No scheduled dumps either. However, I have set up a slave to the master for one table. These tables hold DNS data for ...
    Scott HanedaScott Haneda
    Jul 8, 2009 at 4:50 pm
    Jul 21, 2009 at 8:04 pm
  • I have a 70GB database that I need to put on another box I'm building (Ubuntu 9.04 w/ext4, 1TB drive). I copy these files from the existing database (stopped it first of course) via USB HD. Doing a ...
    Daevid VincentDaevid Vincent
    Jul 14, 2009 at 2:35 am
    Jul 15, 2009 at 5:50 pm
  • Hi all, i use "select * from table_name where start_postion between min_postion and max_postion" to select all the record in the ranges, when the ranges is very large,such as 8000000(about 1000 ...
    Jul 13, 2009 at 4:03 am
    Jul 14, 2009 at 1:03 am
  • Before I simulate a total server failure, master1 is using binary file msyql-bin00001 position 2231467 and it's slave master2 is following the correct file at the correct position. This is after ...
    Cantwell, BryanCantwell, Bryan
    Jul 31, 2009 at 5:08 pm
    Jul 31, 2009 at 8:17 pm
  • I have been using the Linux version of MySQL for five years, also used it on a Windows ME system even though documents said you couldn't. Recent a friend asked me to help him get it up and running on ...
    Jul 10, 2009 at 4:08 pm
    Jul 16, 2009 at 4:18 pm
  • Dear All, I have been using MySQL on FreeBSD for 3 years and encounterd a lot of problems related to thread management. And 1 year ago, I found that my FreeBSD box does not go well with any MySQL ...
    Blog Tieng VietBlog Tieng Viet
    Jul 6, 2009 at 3:33 pm
    Jul 9, 2009 at 2:43 pm
  • I'm trying to get a count for columns in 2 tables at once. I have sessions and downloads tables and would like to get some basic stats. mysql describe sessions; ...
    Jul 8, 2009 at 7:30 pm
    Jul 9, 2009 at 12:54 am
  • Hello, I'm serving a burly Drupal install and at some points throughout the day the mysql threads go way up and iowait peaks. I'm not sure which is causing which but during this time the server is ...
    Milan AndricMilan Andric
    Jul 31, 2009 at 6:15 pm
    Aug 3, 2009 at 6:28 pm
  • Hi, I have a table "orders" with the columns item_id INT FK items(id) customer_id INT FK customers(id) status_id TINYINT -- Between 1 and 4 always ordered_at DATETIME delivered_at DATETIME There are ...
    Jul 21, 2009 at 9:53 am
    Jul 23, 2009 at 1:53 pm
  • I have an issue that Mysql will not start on my local machine. I noticed a few days ago on a restart that I got an error saying that Mysqld had encountered a problem and had to close. I did not pay ...
    Jul 11, 2009 at 4:52 pm
    Jul 14, 2009 at 12:42 pm
  • I need to log fairly large numbers of historical events relating to mailing list activity on a per-recipient basis, a kind of audit trail if you like. So for a given user, I might log the fact that ...
    Marcus BointonMarcus Bointon
    Jul 1, 2009 at 5:57 pm
    Jul 3, 2009 at 2:22 pm
  • Can't find anything on the web that deals with my problem(s). I have to display thousands of book listings by title, sub_title with 10 books per page. The php/mysql code works fine - except: ASC or ...
    Jul 17, 2009 at 6:21 pm
    Jul 17, 2009 at 10:51 pm
  • Hi, I'm working on a table that has about 12 columns against which arbitrary queries must perform really well. Currently there are a lot of indexes on the table, but I'm hitting some problems - and ...
    Jul 12, 2009 at 4:40 pm
    Jul 13, 2009 at 8:53 pm
  • Daevid VincentDaevid Vincent
    Jul 23, 2009 at 11:48 am
    Oct 9, 2009 at 6:40 pm
  • Hi list, i use mysqldump --tab to create database dumps. this will produce txt and sql files. the resulting sql files is owned by the user but the resulting datafile is owned by mysql.mysql is there ...
    Walter harmsWalter harms
    Jul 23, 2009 at 3:11 pm
    Jul 27, 2009 at 10:47 am
  • I have a new slave I setup against a new master server. The master server has 4 log files in it, the most current being updated on the 16th. The slave server on the other hand has several files, many ...
    Gary SmithGary Smith
    Jul 16, 2009 at 9:08 pm
    Jul 19, 2009 at 7:48 pm
  • hi all, I have backup all the database files(innodb engine). Now I want to recover it as myisam engine offline. Any suggestions?
    Jul 15, 2009 at 12:59 pm
    Jul 17, 2009 at 9:25 pm
  • I'm having random query slowness that i can only reproduce once. My main question is that the query runs faster the second time around but i dont have query cache enabled here is some info from mysql ...
    Jul 15, 2009 at 10:53 pm
    Jul 16, 2009 at 8:39 pm
  • In our database we have an Organizations table and a Contacts table, and a linking table that associates Contacts with Organizations. Occassionally we manually add to the linking table with ...
    Matt NeimeyerMatt Neimeyer
    Jul 14, 2009 at 2:09 pm
    Jul 14, 2009 at 8:05 pm
  • Hi, I have numbers separated with commas saved into a TEXT Field, for example: ROW1: 10,5,2,8, ROW2: 2,7,9,65 ROW3: 99,100,55,10,88, etc... Now i want to make a query like this: SELECT * FROM table ...
    Jul 7, 2009 at 1:32 am
    Jul 7, 2009 at 7:45 pm
  • I have an application that crates a users email info in MySQL every time they login into the application. The only problem is once I remove their account from the application/Linux, their user data ...
    Carlos WilliamsCarlos Williams
    Jul 6, 2009 at 1:58 pm
    Jul 6, 2009 at 5:14 pm
  • Hi, I have a very ad hoc sorting requirement and would like to know how this can be achieved. The requirement is as follows: I have a table (of say 100 records) with 3 DATE fields: date_field_1 , ...
    Ravindra HarigeRavindra Harige
    Jul 2, 2009 at 5:18 pm
    Jul 5, 2009 at 2:48 pm
  • We have a multi-column primary key with an auto-increment column as the 3rd column in the primary key in InnoDB. Is there a requirement to have the auto-increment column as the leftmost column in the ...
    Kyong KimKyong Kim
    Jul 31, 2009 at 2:00 am
    Jul 31, 2009 at 11:07 pm
  • Hello. I have 4 tables: MainTable (Main_ID, Main_Name) Table1 (Source1_ID, Source1_Name, Main_ID) Table2 (Source2_ID, Source2_Name, Main_ID) Table3 (Source3_ID, Source3_Name, Main_ID) And a search ...
    Rytsareva, Inna (I)Rytsareva, Inna (I)
    Jul 27, 2009 at 7:58 pm
    Jul 27, 2009 at 8:20 pm
  • Hi; I would like to test the following: update maps set map where site=mysite; to see if there is such an entry in maps. If there is, then update. If there is not, then I would like to execute an ...
    Victor SuberviVictor Subervi
    Jul 26, 2009 at 5:11 pm
    Jul 26, 2009 at 5:47 pm
  • Changed limits: max_open_files: 2048 max_connections: 1024 table_cache: 507 I'm getting the below warning in my event viewer: Changed limits: max_open_files: 2048 max_connections: 1024 table_cache: ...
    Jul 20, 2009 at 11:08 am
    Jul 20, 2009 at 4:41 pm
  • Hello, I've downloaded and installed MySQL 5.1 on the machine where I work. However, during the server configuration thru MySQL Instance Server Config Wizard, on the screen "Ready to execute...", the ...
    Carlos A. OctavianoCarlos A. Octaviano
    Jul 17, 2009 at 2:52 am
    Jul 17, 2009 at 10:29 pm
  • Hi all, i am trying to install mysql 5.1.35 in my linux platform, i do it from source distribution, but there is a serious problem when i login it, the error message is bellow: *shell mysql -p -u ...
    Jul 16, 2009 at 6:59 am
    Jul 16, 2009 at 11:26 am
  • I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do is run perl¹s ...
    Hagen FinleyHagen Finley
    Jul 14, 2009 at 6:28 pm
    Jul 14, 2009 at 8:37 pm
  • Hello, I am returning to mysql after long break, so not experienced with details. I inherited a text file with the mysql DDL statements which create database and tables, etc. Each 'create' or 'drop' ...
    Artie ZiffArtie Ziff
    Jul 14, 2009 at 12:47 am
    Jul 14, 2009 at 4:05 pm
  • If I am looking for a application that will connect to MySQL and allow me to make database / table / user / permission modifications via a graphical tool, is there something specific out there you ...
    Carlos WilliamsCarlos Williams
    Jul 13, 2009 at 6:11 pm
    Jul 13, 2009 at 9:44 pm
  • Hello, I'm developing a web application that requires to store large files in a MySQL database. The files can range up to 2Gb. In my understanding the upper limit for the SQL queries (thus insert ...
    Daniele Development-MLDaniele Development-ML
    Jul 13, 2009 at 12:08 pm
    Jul 13, 2009 at 2:33 pm
  • I have been getting this error on a database: Incorrect key file for table '/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table is causing this error? TIA, ZK
    Zakai KinanZakai Kinan
    Jul 9, 2009 at 5:56 pm
    Jul 9, 2009 at 8:06 pm
  • I know this seems very basic and I checked Google before posting but it appears that many of the manuals / guides online reference something a bit more extreme than what I am looking for. I am ...
    Carlos WilliamsCarlos Williams
    Jul 29, 2009 at 6:57 pm
    Jul 29, 2009 at 7:41 pm
  • Hey, all. I'm trying to "get" indexing -- like, when do you specify an index name during index creation, is index use implicit or explicit, and, honestly, how exactly does it work, anyway? I've been ...
    Ken D'AmbrosioKen D'Ambrosio
    Jul 27, 2009 at 3:30 pm
    Jul 29, 2009 at 10:35 am
  • Hi All, I have a mysql cluster setup with 2 nodes. I would like to log all updates for a certain, only updates, not inserts, is it possible? would i be able to tell when it was updated and from what ...
    Jul 28, 2009 at 2:58 pm
    Jul 28, 2009 at 11:12 pm
  • Hello, I am evaluating MySQL. I am coming from Microsoft SQL Server 2005. This may have been discussed before but I have not been able to find it. In SQL Server you are able to define a user-defined ...
    Jeff LanzarottaJeff Lanzarotta
    Jul 28, 2009 at 6:37 pm
    Jul 28, 2009 at 6:41 pm
  • Hi All, Is it possible to store the timezone with datetime data type in mysql or any other approach available to achieve this in mysql. Looking for your help. Thanks, Manoj
    Manoj SinghManoj Singh
    Jul 28, 2009 at 11:59 am
    Jul 28, 2009 at 1:59 pm
  • Using version 5.0.6x on RH. The question I have is about the updating of indexes. Say I have a table with a primary key and one or more indexes. I run an INSERT statement by way of a call to ...
    Jul 26, 2009 at 3:08 pm
    Jul 27, 2009 at 4:15 am
  • Trying the latest phpMYAdmin on Mac OS X. Everything is set up correct but I get #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) And I am telling ...
  • hi all, i use mysqldump to backup my database, the command line is; mysqldump -p -u -h database_name database_name.sql i find in the database_name.sql, there is a line: Not dumping tablespaces as no ...
    Jul 14, 2009 at 10:32 am
    Jul 23, 2009 at 12:26 pm
  • Hello, we are trying to move a Joomla Site and the administrator does nowrk. Using MySQL 5.1.36 on MAC OS X Server. How can I fix this?
  • hi guys i am very new to mysql . i want to learn this but i don know where to start what to do. so please enlighten me . Looking for local information? Find it on Yahoo! Local ...
    Shridhar kyrlageriShridhar kyrlageri
    Jul 15, 2009 at 1:07 pm
    Jul 15, 2009 at 11:20 pm
  • Hi Folks, can someone give me some info on what I need to download here?? I just bought a new 64 bit laptop.... Im sitting on the MySQL dowload site and wondering if Im looking at the correct package ...
    Michael AbbottMichael Abbott
    Jul 11, 2009 at 3:09 pm
    Jul 13, 2009 at 2:57 pm
  • After getting table replication to work by including the USE database on the creation scripts, I have run into a rather large problem. We have 5 databases on the server which get replicated to ...
    Gary SmithGary Smith
    Jul 11, 2009 at 4:05 am
    Jul 11, 2009 at 4:09 pm
  • Here is steps take to get to the problem. Version is 5.1.35 To be on the safe side, I did this prior to executing the scripts. I deleted the mysql directory and the mysql-log directory, recreated ...
    Gary SmithGary Smith
    Jul 11, 2009 at 12:12 am
    Jul 11, 2009 at 1:38 am
  • Good Day. I hope someone can assist me. I have a freeradius server running off mysql. Now I would like to use triggers to negate some of the traffic logged within it. I tried to use following as ...
    Marcel GrandemangeMarcel Grandemange
    Jul 7, 2009 at 9:45 pm
    Jul 8, 2009 at 7:22 am
  • Hi guys I am going to fetch out the data from remote mysql database according to timestamps colmmen, however my local date is different from the one on remote mysql database, how can I get right ...
    Nathan HuangNathan Huang
    Jul 4, 2009 at 6:49 am
    Jul 4, 2009 at 2:26 pm
  • Hi My stock serial number format is 00001A - 99999A, 00001B - 99999B ... 00001Z - 99999Z. These stocks are check in to warehouse in different order, so the worker may check in the stocks like 00001A ...
    Jul 24, 2009 at 5:27 pm
    Jul 24, 2009 at 5:45 pm
  • How the F do you remove a user from the grant table?!! The site is down too by the way... (root@localhost) [(none)] SHOW GRANTS FOR 'madc'; ERROR 1141 (42000): There is no such grant ...
    Daevid VincentDaevid Vincent
    Jul 23, 2009 at 12:41 pm
    Jul 24, 2009 at 5:04 am
Group Navigation
period‹ prev | Jul 2009 | next ›
Group Overview
groupmysql @

120 users for July 2009

Gary Smith: 17 posts Gavin Towey: 16 posts Marcus Bointon: 11 posts Daevid Vincent: 10 posts Johnny Withers: 10 posts Carlos Proal: 8 posts TianJing: 8 posts Carlos Williams: 7 posts Darryle Steplight: 7 posts Jerry Schwartz: 7 posts Mos: 7 posts Dan Nelson: 6 posts Morten Primdahl: 6 posts Russbucket: 6 posts B: 5 posts Gary: 5 posts Hagen Finley: 5 posts Michael Dykman: 5 posts Nathan Sullivan: 5 posts Brent Baisley: 4 posts
show more