Hi All,
Does anybody have some advise on automating the install of mySQL and our DB
on a PC/Laptop with no user interaction required.
Does the SETUP.EXE take any paramaters to auto install without the user
dialogs?
Thanks,
Jim
Daevid,
>> > > This is my first trigger I'm trying to write.
>> > > I have two tables. 'stores' and 'zipcodes'.
>> > > I want to automatically set the latitude and
longitude of the store using
>> > > it's zipcode lookup in the zipcode table.
>> > > DELIMITER $$;
>> > > DROP TRIGGER `store_coo
I've never written a trigger, but the error implies that you can't update the
stores table when in a trigger ON the stores table.
This makes sense, especially if you consider an 'UPDATE' trigger - the trigger
would become recursive.
So, rather than deciding which combination are recursive and w
> > This is my first trigger I'm trying to write.
> >
> > I have two tables. 'stores' and 'zipcodes'.
> >
> > I want to automatically set the latitude and longitude of
> the store using
> > it's zipcode lookup in the zipcode table.
> >
> > DELIMITER $$;
> >
> > DROP TRIGGER `store_coord`$$
> >
> >
Googling for "mysql profiler" brings a link:
http://amr.activechannel.net/myprofiler.htm
Well... that looks like something really good. I have a question for
all of list subscribers: has anyone use this tool? Does it really do
what it pretends to do?
On 5/15/06, sheeri kritzer <[EMAIL PROTECTED]>
I'm having some trouble writing this trigger and wasn't sure what I'm
doing wrong. My goal is after a row has been added to tcphdr it will
pull data from several other tables based on the NEW rows event.cid and
event.timestamp and insert it into acid_event. However I'm not sure how
to tell the WHER
Barry wrote:
Hello everyone!
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on that day noone clicked on the link.
I use this query:
SELECT DATE(c_clicktime) AS clicktime, count(c_id
On Monday 15 May 2006 05:10 am, Mattias Andersson wrote:
> Hi.
>
> I can't figure out how to set the session variable SQL_LOG_BIN when
> using the mysql command-line client.
> I want to do something like: #mysql -u root -pmypasswd --sql_log_bin = 0
> < somefile.sql.
could be the fact that you have
Check out line 1 of the fill_help_tables.sql file. (on my
installation it was in /usr/share/mysql) See if there is an errant ".
There shouldn't be, of course, but that's the problem according to
MySQL.
-Sheeri
On 5/15/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I start from an up-to-dat
I've had this same problem -- if the database loses connection at the
same time the log file flushes, you need to SET MASTER_LOG_FILE and
MASTER_LOG_POS again and restart. I believe this probably qualifies
as a bug if you want to report it.
The reason the slave isn't updating log5 is because it'
You cannot get data out of a database if it's not in the database. If
there's no data for a day, you cannot get 0 for that day, because the
day does not exist in the database. You could make a "calendar"
table, one row per day, and join it with a count to get 0 for the day.
-Sheeri
On 5/15/06,
Yes -- did it help?
-Sheeri
On 5/15/06, Miles Thompson <[EMAIL PROTECTED]> wrote:
Sheeri,
So even if I am executing mysqld-nt.exe from the directory where it is
installed, preface it with the full path?
Never thought of that - worth a try.
Thanks - Miles
At 05:23 PM 5/12/2006, sheeri kritz
I don't know what version you're running, but a
mysql -?
will show you the variables you can set. It's not ALL variables you
can set that way, just a few. You will see that the variable you're
trying to set cannot be set via a command on the commandline.
However, your first command could be to
I'm not sure what you mean by profiler -- where are you getting your
information from? It's not referenced in the article I sent. If you
mean checking to see if indexes are being used during a query, check
out the EXPLAIN syntax.
http://dev.mysql.com/doc/refman/5.0/en/explain.html
-Sheeri
On
Peng Yi-fan schrieb:
> Hi,
>
> I would like to change the path of a database's log. Which command I should
> choose?
>
> Thanks.
>
> Peng
Change the config files ?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives
Hi,
I would like to change the path of a database's log. Which command I should
choose?
Thanks.
Peng
Hi.
I can't figure out how to set the session variable SQL_LOG_BIN when
using the mysql command-line client.
I want to do something like: #mysql -u root -pmypasswd --sql_log_bin = 0
< somefile.sql.
When trying to run this mysql tells me:
/usr/bin/mysql: unknown option '--sql_log_bin'
I figure
Sheeri,
So even if I am executing mysqld-nt.exe from the directory where it is
installed, preface it with the full path?
Never thought of that - worth a try.
Thanks - Miles
At 05:23 PM 5/12/2006, sheeri kritzer wrote:
I'm going to guess that the path variable is only looking at the MySQL
Hello everyone!
The mysql documentation doesn't show any good infos er examples about
writing procedures.
To be more specific:
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on
Hi Comunity,
I need some help from you. In replication i want to update old binary files,
but server is not updating old files. It is updatin only current using
binarylog only.
The scenario is, my master is updating log-5 file(say) and slave is reading
data from it, and updating itself to curren
Hello everyone!
The mysql documentation doesn't show any good infos er examples about
writing procedures.
To be more specific:
I have a table with saved clicks by users.
Now i want to draw a graph with a php extension.
Problem is: if i let me show the clicks, one day is missing.
Because on
Daevid,
> This is my first trigger I'm trying to write.
>
> I have two tables. 'stores' and 'zipcodes'.
>
> I want to automatically set the latitude and longitude of the store using
> it's zipcode lookup in the zipcode table.
>
> DELIMITER $$;
>
> DROP TRIGGER `store_coord`$$
>
> create trigger `s
22 matches
Mail list logo
