MySQL Database Forum

Hi, I'm trying to script a backup program using mysqlhotcopy. I've got the script in /root/ and i'm calling mysqlhotcopy from there. I can get the script to work if i pass the password on the command line, but i'd rather store it in a seperate file that I can controll access to. I've tried creating a .my.conf file and including it in the...

Hello All, I have a strange problem with a UNION of 3 queries. The 3 separate select-queries return (at this point) respectively 4, 3 an zero rows, but the UNION returns no rows at all. When I take the query that returns 0 rows, and put it in front of the other two, everything to go fine (I get 7 rows), but this is of course no real...

Gentle People, I think I read some where on how to do this, maybe I'm wrong. I'm working on someone elses PHP code which updates an existing database - One of the programmers used to generate a unique key (a transaction code) for every purchase using a hash - A second programmer thought the idea of using the unique numeric ID field,...

Hi, I am confused with this query I have to write a query that will select data from many tables having a username field where username is given. I used something like, select * from tbl1,tbl2 where username = 'user' but it gives a result with all the fields of one to the second table.

I have a table called order_shipment with primary keys order_id, order_item_seq_id etc. I also another table called order_item with primary keys order_id, order_item_seq_id etc. I want all the order_id's which look like '7000%' that are in order_item but not in order_shipment. Please help me with creating the sql. I tried UNION, LEFT OUTER...

Hi again, This works perfectly in v4, but in v3.23 it throws a syntax error. I can't see what it is at all... Very frustrating! SELECT DISTINCT page_system_name FROM page_data JOIN menu_data ON menu_data.menu_group = page_data.menu_group WHERE page_hidden = 0 ORDER BY menu_data.menu_group_display_order, page_data.page_display_order

Hi, I'm trying to compile the latest mysql source in a Sun box: # uname -a SunOS bucktown 5.8 Generic_108528-20 sun4u sparc SUNW,Ultra-80 My configration looks like this: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors \ -fno-exceptions -fno-rtti" ./configure \

Can anyone recommend any MySQL server consultants? I'm in need of a MySQL performance expert. We have a growing database with some tables that need optimization. We also need someone who knows about the internal structure of MySQL and would be able to fine tune our installation and provide answers to my questions about why it is acting the...

Hi, I am responsible for a growing website. It is password protected and we collect data on everyone who logs in. Every month we produce a report on the trends of users which can result in some very unwieldy sql statements. We are running MYSQL with SunOne ASP on a Solaris box. Can anyone help with a way of improving the script - this...

How do I import Access database into MySQL?

I have the following query that runs quickly (0.5 secs): select ZipListMatrix.ZipListMatrixID, ZipListMatrix.ZipID, ZipListMatrix.CarrierRouteID,ZipListMatrix.ListID, ZipListMatrix.Quantity,List.DisplayOrder from ZipListMatrix join List join UserList on List.ListID = UserList.ListID on ZipListMatrix.ListID = List.ListID where...

HELLO FRIENDS. HERE A FANTASTIC NEWS FOR MYSQL WINDOWS USER. READE THIS. The article is grab from www/internetnews/com/ DO YOU THINK THAT IS A GOOD NEWS ? ----------------------------------------------------------------------------- Open source database server company MySQL's next production release of its open source MySQL database server...

Hi all, I'm trying to setup a database (mysql 4.0) for my snooker club and have run into a little problem, being new to myslq and php. I want to setup a table where all the results will go, then query this table to get players averages etc. So will look something like this. | score | h_playerid | a_playerid | h_score | a_score |...

What Linux directory ought the mysql-administrator and mysqlcc executables be installed? Granted, they'll run from anywhere but is there a common path used by most Linux distributions? Signed, Obsessive compulsive Linux newbie

I am trying to do a Restore on a dump file (see below) but I get the "failed copying a .frm file" error. ******** RESTORE TABLE ListMembers FROM '/home/virtual/thefrugallife.com/var/www/html/12all/backups/1089048410_Mon05 -07-2004.sql'; +-------------+---------+----------+--------------------------+ | Table | Op | Msg_type |...

Hi, I have multiple queries like this: SELECT col1, col2, col3, col4 FROM table1, table2 where table1.col1 = table2.col1 and table1.col2 = 1 ORDER BY col3 desc LIMIT 5 and

Hello, After doing indexing of a relatively large database (4 million records), I see some files that all begin with "#sql-" in my data directory. They are identical in size to the regularly named data files in that directory. Are they some backup or temporary files that were left behind? Is it safe to delete them? Thanks.

This may be old news, but it's kinda frustrating and I wonder if Something Can Be Done: mysql> grant all on *.* to 'jeff_dev@localhost' identified by 'my^son^daniel'; ERROR 1145: The host or user argument to GRANT is too long mysql> grant all on *.* to 'q_dev@localhost' identified by 'my^son^daniel'; Query OK, 0 rows affected (0.00...

Folks, I have 3 mysql replicated servers ( 1 master + 2 slaves). One thing I noticed is that every once in a while the data (*.MYD) and index (*.MYI) files for a table may differ from the other mysql servers. Now my question is this: If I have identical data files on each server (verified by using checksums), should the indexes...

I have a table which contains two strings and a date. page_views ----------------- sessionId page timestamp This is added to each time someone views a page on our site. I want to

I'm not that great with MySQL...so I was hoping someone could help me out. The query I'm running is too slow...can anyone tell me what I can do to speed it up..if I can at all? I was wondering if because ZipListMatrix has 3.3 million rows that 8 seconds is all the faster it's going to be. Any help is greatly appreciated! I have already...

First, let me introduce myself to the group. My name is Rich and I've been doing databases for about 25 years with the last 10 being pretty much MS SQL Server. I've become intrigued with MySQL and would love to use it on a project. I'm trying to work with stored procedures and am having a problem. Here goes: Software: Windows NT, VB6, MySQL...

Does anyone have examples opening Mysql Db in Vb? Thank you.

Hi everyone, I'm having trouble accessing a Mysql database containing checkbox data that is posted from a form. I use the serialize function to store the checkbox values in an array (in a column called "CHECKBOX"). Each row in the table has this format: a:2:{i:0;s:7:"Peanuts";i:1;s:9:"Cows_milk";}

I use binary log on mysql system. Yesterday i found some hacking attempt on my machine. ( I found some unknown queries on binary log) But i don't get any information about hacking query connection on binary log file.. ( username, host.. i don't know anything ) only thing that i know is "thread_id".