My thoughts exactly!
This article might help:
http://dev.mysql.com/tech-resources/articles/mysql-54.html
It worries me though that 5.1 went through a large number of alpha
releases, then a set of beta releases before the GA release came out.
It looks like they've thrown 5.4 straight out wit
Hi,
To see what will happen to MySQL take a look at how Oracle handled
InnoDb. How many updates have they released since they purchased it? I
really don't know so someone will need to check. Is Oracle is too big
to make MySQL updates any kind of priority? It seems that the larger
the company
I've just been made aware by a client that Oracle have purchased Sun
Microsystems. The article below on Sun's website mentions that Oracle
are committed to Linux and "other open platforms" and mentions the fact
that Java touches practically every business system around.
http://www.sun.com/thi
Hi Alugo,
abdulazeez alugo wrote:
Hi Andy,
Thank you very much you have been really very helpful. All those
mistakes you pointed at in the script about the apostrophe and others,
are simple mistakes I just made in the rush of typing the message; and
yes $conn is the result from mysql_connect
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inser
Hi,
Now I have successfully created a relationship between the two tables but how
do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in
tbl2???
MySQL handles this for you. Simply INSERT the value into tbl1, then
INSERT the value of tbl1_id in tbl2. Then try INS
Hi John,
I would almost certainly suspect some form of foul play, whether that be
internal (i.e. an employee/colleague) or network intrusion. As you've
figured the first thing to do is check which MySQL account is dropping
the database. You already have the timestamp in your binlog so what y
You can use this structure with MyISAM tables. It will work fine
except you won't have the advantage of database-level enforcement of
foreign key constraints--do it with code.
Or use InnoDB tables (enable/load the innobase plugin.)
--
MySQL General Mailing List
For list archives: http://li
Hi Stefano,
I'm guessing your remote (non-local) server is using a different user
account than your local server.
r...@localhost
r...@%
r...@somehost.com
are all different users. If your remote host, or wildhost user account
has the REQUIRE X509 flag (user must be certified) but your local
Hi Seth,
I implemented SSL successfully just a couple of weeks ago on 5.1.30, and
I too found some aspects confusing. Here's my answers from my own
experience so please forgive me if they're inaccurate.
1) On the server side, I believe ssl-ca, ssl-cert and ssl-key are all
required to establ
Hi David,
Why not use a FOR loop in a batch file?
This post seems to be doing the same thing, using MS SQL Server:
http://bytes.com/topic/windows/answers/647680-xp-batch-file-loop-help
Andy
David Scott wrote:
Thanks for responding Gary
I get:
---
Volume in
Hi Mat,
How many databases have you got running on 4.0? You can certainly go
through the motions of downloading each interim release, however my best
advice would be (if time/disk space permits) to dump your databases to
plain SQL files (using mysqldump) obliterate your 4.0 install, install a
0) {
echo ("We have results");
}
else {echo ("Empty!");
}
And if I change the "Joe of Egypt" to "Cleopatra of Egypt" the return is
correct also.
So why would I need mysql_store_result()? Don't forget, I'm using a
SELECT query, not INSERT,
Hi PJ,
Having been a C programmer for a while this makes perfect sense to me.
You call mysql_(real)_query to execute the query and get the results
from the server. Because the MySQL library doesn't know when you've
finished with the result-set, you have to tell it to write the results
to me
To be honest, I got started straight from the MySQL manual. There is a
tutorial section in the manual as well, and it's also available to
download as a PDF.
Links:
Manual (English): http://dev.mysql.com/doc/refman/5.1/en/index.html
Manual (English PDF US Letter):
http://downloads.mysql.com/d
I've just read someone's troubles about getting 5.1.31 installed on
Solaris, and I thought 5.1.30 was the latest stable release. So, I went
onto the website and found that 5.1.31 was released on 19th Jan, but the
only announcement notices I received about that time was for 6.0.9 alpha.
Did an
Hi Philip,
Am I missing something here? (It is late after a long day, I admit!)
In the example case you've given, if the foreign key in Parts is set to
ON DELETE CASCADE, and you delete a row from Manufacturer, MySQL will
first delete the associated records in Parts before deleting the row
f
Hi JD,
I believe the error about mysql.plugin is a red herring - it needs
fixing, but it's not the reason MySQL isn't starting. The second error
is the one about InnoDB not having access rights to the directory.
Check that /var/lib/mysql is writeable by the MySQL user (usually
MySQL.) Make
Hi,
Jake Maul wrote:
*If 1/2 your tables are on server A and the other 1/2 are on server B,
then you've effectively split the read *and* write load between them.
How to do this without modifying the frontend is an exercise left to
the reader. :)
From what I've read in the past about MySQL P
221.130.195.83." is not a valid IP address anyway, but MX records
must also be the hostname of an existing A record, not an IP address.
Regards,
Andy
Andy Shellam wrote:
> Hi Xu,
>
> The check_mysql plugin is part of the standard plugins package (see the
> downloads page a
Hi Xu,
The check_mysql plugin is part of the standard plugins package (see the
downloads page at http://www.nagios.org/download/download.php.)
At a very minimum this plugin will check that the slave's SQL thread is
running and compare the number of seconds it is behind the master,
allowing you to
Hi
I would suggest a Nagios monitoring system, useful for many different checks
and with plugins to check also mysql replication.
I'll second this. The standard check_mysql plugin included with Nagios
allows you to monitor a MySQL slave and alert when the lag behind the
master is larger
Or you could wrap your entire SELECT in another query, and do an IFNULL
around the rating field to convert it to 0 (or some other value
important to you) as follows:
SELECT
movie_id,
<... any other fields from movies table you want ...>,
IFNULL(ratings, 0) AS rating
FROM
(
SELECT mo
Hi
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an
extremely att
Hi PJ,
To be quite honest you may have better luck downloading and installing
MySQL yourself. It's very rare I install anything from the ports on
FreeBSD or apt repositories on Debian, simply because you have little
(if any) control over what goes on. At least if you do it yourself you
know
Hi,
Hi Andy,
the reason I can't use this because fields (columns) in select
statement (p.first_name, p.last_name,...) are actually dynamically
created. In my project different client will select different fields
to be shown. 99% will select first_name, and last_name, but some don't
care abo
Jerry Schwartz wrote:
-Original Message-
From: Andy Shellam [mailto:andy-li...@networkmail.eu]
Sent: Wednesday, December 17, 2008 3:29 PM
To: Lamp Lists
Cc: mysql@lists.mysql.com
Subject: Re: need help with query...
Hi Afan
Why not prefix your field names with the table name?
select
Hi Afan
Why not prefix your field names with the table name?
select
p.first_name AS person_first_name,
p.last_name AS person_last_name,
p.status AS person_status,
p.date_registered AS person_date_registered,
o.org_id AS organization_org_id,
o.org_name AS organization_org_name,
o.org_depar
Hello Hagen,
Hagen Finley wrote:
Should I be using a different datatype for these kind of numerical
values?
Yes. INT is by definition a whole number (0, 1, 2 etc.)
You will want to change the fmarg column to DOUBLE or DECIMAL.
Regards,
Andy
--
MySQL General Mailing List
For list archiv
I think you are missing the point. Where is 'OLD' or 'old' defined?
Before you try to imbed it in a trigger, try the basic query. That seems
to be what its complaining about.
OLD is a virtual table which is only present in a trigger - it's like a
table with the same layout as the table
delimiter //
create trigger jobposts_control
before delete on jobposts for each row
begin
declare dummy varchar(255);
set @counted = (
select count(ad.adsource_id)
from adsource ad, jobposts jp
where ad.adsource_id = jp.adsource_id
and OLD.jobpost_id = jp.jobp
Hi Nishi,
I think what's more relevant is why did you downgrade to 5.0.22? The
sorting issue you're experiencing was fixed for the 5.0.67 community
release. Many bugs will have been fixed between 5.0.22 and 5.0.51a;
downgrading is not a solution. Upgrade. If this is a new system you
could
Hi Bryan,
My gut reaction would be to use a temporary table - create the temporary
table at the start of proc1, run multiple inserts into the temp table
for the results of proc2, then just before proc1 ends, select from the
temp table and drop it.
Andy
Cantwell, Bryan wrote:
I have a proce
Hi Morten,
I think this is valid in MySQL (it certainly is for SQL Server) but you
can use a CASE statement directly in the ORDER BY clause. Try something
like this:
SELECT name
FROM foo
WHERE bar = 34
OR baz > 100
ORDER BY CASE bar WHEN 34 THEN 0 ELSE 1 END ASC, baz DESC
LIMIT 5;
Re
Hi Nishi,
There was a bug in that version that affected the sort order when
combined with a group by statement
(http://bugs.mysql.com/bug.php?id=32202.) There are a couple of
workarounds but they are bad (e.g. removing primary key!)
I would strongly suggest you upgrade to 5.0.67 or possibly
Hi Darvin,
Does this not help?
http://dev.mysql.com/doc/refman/5.0/en/query-log.html
(replace 5.0 with 5.1 if you've already upgraded.)
"The general query log is a general record of what mysqld is doing. The
server writes information to this log when clients connect or
disconnect, and it log
Hi,
For those not familiar with LINQ, it's a new Microsoft feature in it's
.NET languages that is supposed to allow developers to write querying
language (i.e. SQL) code in the same format as the .NET language (e.g. C#.)
The .NET compiler will convert the code into a SQL statement - e.g. I
c
Hi Dave,
You have no primary key on your table, thus MySQL has no way of knowing
when the row is unique and needs to be updated rather than inserted.
REPLACE INTO effectively does the following:
- insert into table
- did a primary key violation occur?
--- yes - delete existing row from table
This mailing list has a stupid configuration. Pressing the answer
button, the message goes to the sender not to the list :-(
Hint - use Reply to All - it's not specific to this mailing list. :-)
Regards,
Andy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
ote:
And I assume you backup script also archives or removes the old log file,
because flush-logs does not start a new log file if there is still one
present
On 10/23/08 2:20 PM, "Andy Shellam" <[EMAIL PROTECTED]> wrote:
Hi Olaf,
We use our mysqldump script to rotate the bin
Hi Olaf,
We use our mysqldump script to rotate the binlogs; it's much safer as it
allows MySQL to do the log rotate natively (if you use logrotate, MySQL
will complain that either the log doesn't exist when it expects it to,
or your slaves will bail out because they didn't know the log was
ch
You might like to try here: http://lists.mysql.com/, then click on
Unsubscribe underneath the "General Discussion" list.
Vidal Garza wrote:
Please let me down of the list.
I resigns from my job.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
Hi Sachin,
What version of MySQL are you running? I believe --log-output was only
added in 5.1 which is why a 5.0 server would fail to start with this
option set. I think the relevant option should also be "log-output" in
my.cnf / my.ini (e.g. log-output = FILE, TABLE.)
It looks like 5.1 g
Hi Sachin,
MySQL is capable of logging all queries to a log file, see
http://dev.mysql.com/doc/refman/5.0/en/query-log.html. This includes
connections, disconnections and executed SQL statements - no coding needed!
If you want this information imported into a database table, a couple of
hou
Hi,
I was also going to go down this route some time back, but then when I
looked at it, it's pretty simple how it works and you can do the same
thing yourself for free.
Take a dump of both servers (mysqldump or via MySQL Administrator) of
the databases in question, then use WinMerge (for fr
ections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL
Community Edition
(GPL)
Anyway I will settle with the mysqld-nt and go on with my
assignment.Thanks For your help.Iam sorry if I have caused you any
inconvenience
Thanks Regards Varuna
On Sun, Oct 5
Varuna,
A polite note - if you post the same question 6 times (especially in the
space of 24 hours) people are going to be more unlikely to help you.
Post the question once, and read people's responses.
Now onto your issues...
When you run "mysqld-nt" you were starting a standalone version
Hi Varuna,
I think you're missing the "-u" option (User for login if not current user.)
Try: "mysqladmin" -u root -p shutdown
(-p without a value indicates to prompt for a password from the terminal.)
Andy
Varuna Seneviratna wrote:
I am using WinXP.I am wanted to shutdown MySQL service from
Hi,
Personally I would do #3 as well. Have an exact copy (structurally) of
your original table, when the record is deleted then move the account's
details to your deleted_users table so it doesn't appear in users but
you still have all the details.
Not sure if it's possible in MySQL but in
Hi Bryan,
My first guess would be to use Nagios's check_mysql plugin. Just
because port 3306 (or whatever your MySQL server runs on) is open
doesn't mean the server is alive and well. check_mysql behaves as a
standard MySQL client, thus avoiding connection errors.
I use the latest plugins
I don't have that much experience with MySQL having mostly worked with
MSSQL, but I'm sure the logic is still the same. I believe the query
"select count(*) as 'count' from logins GROUP BY dawiz" will fail
because "dawiz" is not a column, it's a value within the table.
If I'm not mistaken, a
FYI, we have the same issue with exporting phone numbers from MS SQL.
All phones numbers
in the UK start with zero which causes no end of grief when exporting
data to Excel.
Even if we then change the column data type to "text", it doesn't put
the zeros back in
(it's like Excel has deleted
FYI the manual for 5.0 recommends upgrading to 4.1 first.
"As a general rule, we recommend that when upgrading from one release
series to another, you should go to the next series rather than
skipping a series. If you wish to upgrade from a release series
previous to MySQL 4.1, you should u
Hi Dan,
I cannot speak for EMS or SQLyog, but certainly with the MySQL
Administrator you create the backup files on your client PC (the PC
running the tool) and then when you restore it, you select the file from
your local PC and it sends the SQL commands required to restore the
database to t
or me to remember one way.
Jim
On Mon, Aug 18, 2008 at 3:07 AM, Andy Shellam
<[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi Andrew,
I think he means re-install MySQL and provide a root password (you
said when you originally installed it that you didn't give
lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Andy Shellam
Business Systems Architect
Network Mail
NetServe Support
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1.game_date AS date, s1.begin_time AS time,
s1.loc_id AS loc_id, s1.home_team_id AS hteam, s1.away_team_id AS vteam,
(
SELECT t1.div_id AS div_id
FROM team_season t1
WHERE t1.team_id = s1.home_team_id
AND t1.deleted != '1'
Hi Martin,
Good point, I normally do but was just illustrating the join. I would
also normally fully-qualify each column when using table aliases and
multiple tables to avoid disambiguity.
insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id)
(
select
'36' as sea_id, s1.g
Hi Steve,
You're seeing this error because this query:
select div_id
from team_season where team_id=s1.div_id
is being run independently of the rest, so it doesn't know of "s1" in
this context. You would probably be better with an INNER JOIN here,
something like the following (may need tweak
60 matches
Mail list logo
