Ooh. I can from cmd-line not set any variable not listed there.
That explains it all.
Yes, I will put the command in the script-file instead then.
Thanks alot.
/Mattias
sheeri kritzer wrote:
I don't know what version you're running, but a
mysql -?
will show you the variables y
--variable-name=value.
---snip---
Perhapps the problem comes from that this is a sessions-variable...?
The problem I would like to solve is to not bin-log some special data
imports.
Any one that could help me figure this out?
Thanks alot.
Regards,
/Mattias
--
MySQL General Mailing List
For l
file btr0cur.c line 366
Last time write locked in file btr0cur.c line 359
---
The whole logfile can be found at:
https://saga.compricer.se/saga_publishlog.err
my.cnf:
---
[mysqld]max_connections = 15000
log-slow-queries = mysql_slow.log
long_query_time = 5
old-passwords
---
All possible help would
e etc.
If you have any suggestions please let me know, thanks for your precious
time!
Best Regards,
Mattias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This one goes for $169, and you get longitudes and latitudes.
http://www.buyzips.com/platinum-expanded.htm
Regards,
Mattias Håkansson
- Original Message -
From: "Jack Lauman" <[EMAIL PROTECTED]>
To: "MySql"
Sent: Monday, June 27, 2005 2:29 AM
Subject: Cal
Yes, It's pretty obvious now. Thank you all for the help.
Mattias Håkansson
- Original Message -
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 05, 2005 12:15 PM
Subject: Re: Weird Query Result
> Not weird at all...
> As you can see
OOBAR' but still I receive these
results.
Anyone have a clue what is causing this?
Thank you for your time,
Mattias Håkansson
At 2005-01-18 04:53, Craig Hoffman wrote:
I upgrade to 4.1.9 last night and I keep getting this error in PhpMyAdmin
after I changed the root password (yes I changed both pw's). Does anyone
have a solution on how to fix this? I'm running a Mac 10.3.x
#1251 - Client does not support authenticati
At 2005-01-17 15:12, shaun thornburgh wrote:
I am attempting to create a database and have a query. Is it possible for
mysql to contain the possible field values in the database rather than
creating the options in the application?
For example Field_A can only be Yes or No, Field_B can be 50% or
Please also note hat UPDATE returns the number of records updated. If your
UPDATE returns 0, you know that the record does not exist, and you might
want to INSERT instead.
At 2005-01-15 14:54, you wrote:
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL statement if
Update action is failed?
I may be asking for too much. If Select statemnet have to be used to
determine the existence of a recordset, what is an efficient way to
execute Insert if Update is
g the data and then upgrading from 4.0 to 4.1(.8 or .9).
At 2005-01-14 11:35, you wrote:
Mattias,
please use
innodb_table_monitor
to print the contents of the InnoDB internal data dictionary.
http://dev.mysql.com/doc/mysql/en/InnoDB_Monitor.html
Regards,
Heikki
- Original Message ----- From:
copy of this data and could easily reproduce the error by
restoring the data and then upgrading from 4.0 to 4.1(.8 or .9).
At 2005-01-14 11:35, you wrote:
Mattias,
please use
innodb_table_monitor
to print the contents of the InnoDB internal data dictionary.
http://dev.mysql.com/doc/mysql/en
e frm files. This will give you a fresh 4.1
table space to import into.
-Eric
On Thu, 13 Jan 2005 16:37:39 +0100, Mattias J <[EMAIL PROTECTED]> wrote:
> Earlier today we tried upgrading one of our MySQL servers from 4.0.15 to
> 4.1.8 using RPMs. This resulted in corrupted InnoDB
gs in the database (such as #3859, #3594, #3147) that talk
about similar symptoms. Are these problems in any way related to any bug?
Could we have done anything wrong during the upgrade (I did not perform it
myself)? What could we do to prevent this from happening when upgrading the
other servers?
Hi there.
I have a little problem with a sql-query I'm trying to get together.
Well I got it to work halfways.
I have a table with items, which are composed of 1-6 other items, which
is saved in the same table.
You might call it a recursive query, I need to get the names of the
components tha
Hello!
Is there a need for adding an index to a key which already primary?
>From the dump file it would look something like this:
PRIMARY KEY (id)
KEY id (id)< Is this nescesary ?
);
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
which one is the biggest datatype:
enum('true', 'false');OR
tinyint(1);
I mena biggest when it comes to store them on disk.
Thank you,
Mattias.
at random situations
that involve the children doing UPDATEs and the father SELECT.
I am not sure of this.
What could be the problem?
/Mattias
Program received signal SIGINT, Interrupt.
0x40137544 in __libc_read () from /lib/i686/libc.so.6
(gdb) bt
#0 0x40137544 in __libc_read () from /lib/i686/li
at random situations
that involve the children doing UPDATEs and the father SELECT.
I am not sure of this.
What could be the problem?
/Mattias
Program received signal SIGINT, Interrupt.
0x40137544 in __libc_read () from /lib/i686/libc.so.6
(gdb) bt
#0 0x40137544 in __libc_read () from /lib/i686/li
Hello everybody...
I have a table with 3 columns (companyno, discountgroup, discount) it can
look like this
companyno, discountgroup, discount
12345,1,10
12345,2,20
12345,3,0
98765,1,15
98765,2,10
Can I use the REPL
2;
execute
it works but I want to do it all at once. Isn't this posible with MyODBC and
ASP? I have done it with MicrosoftSQL and it works there.
/Mattias
-
Before posting, please check:
http://www.mysql.com/manual.ph
I have a problem that i don't know if mysql can solve, my customer wants the
date format to be
YYWWD (year,week, day of week)
Its no problem with geting a date from the database in this format typing
select DATE_FORMAT('020515', '%y%v%w');
Now to the problem, is there any way I can make an ins
but I don't know
how to set these options.
So far my Database is pretty small with just 20 tables but it will grow fast and i
want to use the best connection from start.
Anybody have any ideas?
Regards Mattias Persson
---
t;[EMAIL PROTECTED]>
To: "Mattias Persson" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 31, 2001 4:46 AM
Subject: Re: OleDB
> This works for me...
>
> var connectionString = "Provider=MySqlProv;
> Integr
Anyone know how to write a connectionstring for the OleDB in ASP. I get all
different kinds of errors when i try to do this.
I write
rsDB.ActiveConnection =Provider=MySQLProv; Data
Source="server=localhost;DB=test"
but it don't work
-
I have two tables, one for the articles and one with orderrows. When I update the
price in the article table i want to make a query to update the price in orderrows on
all rows with a certain orderstatus.
I can't figure out how to write this query...
I tried
UPDATE orderrows SET price = artic
My query:
SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
I have a problem with MySQL and a query. If I type the Query in a program with direct
db connect, in my case EMS Mysql manager, everything works OK but when I use it from
an ASP page it don't. I don't get any matches, it e
My query:
SELECT vgrupp, type, count(*) FROM main GROUP BY vgrupp, type
I have a problem with MySQL and a query. If I type the Query in a program with direct
db connect, in my case EMS Mysql manager, everything works OK but when I use it from
an ASP page it don't. I don't get any matches, it e
Any ideas?
/Mattias
>Hi!
>
>I've just installed (a couple of days ago) mysql.
>I will use mysql for using with hlstats. That is
>a stats-program for HalfLife Counter Strike. (game)
>
>But I got errors... I guess it's a problem with mysql
>or me not kno
Maybe I should add that I run:
OS:
Linux 2.2.18 (Slackware 8.0)
mysql --version :
/usr/local/mysql/bin/mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)
Hardware:
intel Pentium 133, 96Mb memory
/Mattias
>Hi!
>
>I've just installed (a couple of days ago) mysql.
>I w
---
I've asked in the hlstats-forum with no luck.
Any help is welcome!
If you want more info, I'll give it to you!
Thanks! :o)
/Mattias
-
Before posting, please check:
ht
following gives me the last date but not the corresponding rate:
SELECT currency_rate.currency_id, MAX(currency_date), currency_rate
FROM currency_rate
GROUP BY currency_id
Mattias Jiderhamn
Expert Systems
[EMAIL PROTECTED
Hi folks,
I got a strange problem, we're running a webhosting company and during peekhours,
mysql really hits the cpu peek. I do believe there
is one or more clients that are running high loads of querys without actually closing
them, or perhaps even running querys that
dosn't timeout. Is there
Have anyone tried TopLink with MySQL and if so, how does it work?
[EMAIL PROTECTED]
35 matches
Mail list logo
