yoku0825,
Thanks for answering, I've just find out what happened.
I'm using OpenSUSE 13.2, and by default it uses systemdlogger and not
syslog, so, my super complex solution for this case was replacing
systemdlogger for syslog! :-D
Worked like a charm.
Regards,
Stephan Higuti
O
sn't log in syslog.
My client section config is:
[client]
#password = [your_password]
port= 3306
socket = /var/lib/mysql/mysql.sock
syslog
Have any of you tried this?
Thank you in advance.
Stephan
how to ensure that rows are accessed
in a specific order. Any help on how to achieve this is greatly
appreciated.
Thanks in advance,
Stephan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nds_Behind_Master are not
decreased.
Only after a complete restart of mysql (replica) the replica recovers.
Any idea?
Thanks for any help!
Stephan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es in certain tables (create, update,
delete) with MySQL and e.g. raise external programs?
If it's not possible now, does anyone know of plans to integrate such a
feature in one of the future versions of MySQL?
Kind regards,
Stephan
--
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
do you mean that InnoDB have no table-size limit?
if size is that important to you get an 64-Bit system an should be able
to go for Terrabytes without Raid an MERGE.
Greetings
Stephan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
But MySQL even doesn't ask me for a password but returns immediately this
error.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 10:14
When I start MySQL with "mysql -u root -p" I get again the error 1045
("Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)".
What am I doing wrong ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stepha
Thanks for the advise.
However I have some additional questions:
ad 2) How can I check the grant privileges ?
ad 3) How can I "run this as the mysql root user" ?
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[
Hi Jim,
thanks for the advise.
What you tell all works. But even after this I still get the same error 1045
when typing "grant all on *.* to stw". Why ?
Stephan
- Original Message -
From: "James Cradock" <[EMAIL PROTECTED]>
To: "Stephan Wölfel" <[
When I try to execute "grant all on *.* to stw" where stw is my user name, I get an
error 1045 ("Access denied for user: '@127.0.0.1' (Using password: NO).
Is there a way to check for user datas ? Or how to resolve this
In the third chapter of the MySQL manual I don't understand the mentioned "shell>".
Where must I type in this and the following instructions or what does it mean ?
Until now I have found and started the winmysqladmin.exe file. But how to c
et = mysql_use_result(db);
num_fields = mysql_num_fields(rsltSet);
while ((row = mysql_fetch_row(rsltSet))) {
unsigned long *lengths;
lengths = mysql_fetch_lengths(rsltSet);
for (i=0; i
OS: XP
mysql version: 4.0.14, for Win95/Win98 (i32)
Thank you for your time and help
Stephan
-
oreign keys I expect the developers that they have red
the theory and standards about it and having them implemented. Because
adding a feature to an app and saying - if any problems occure - "was
just a trail you have to reimplement it" is imho absurd.
best regards
Stephan
--
MySQL
methode with the DBI
package - if I remember right - which escapes the characters which need
escaping.
How to use/escape strings properly is documented at this webside:
http://www.mysql.com/doc/en/String_syntax.html
best regards
Stephan
--
MySQL General Mailing List
For list archives: http://list
o know if I can use the transaction and foreign
keys facilitys in relation with access or if there are any knowen problems.
Of curse I could test it myselfe but I thought maybe someone has already
done it and would be so kind to tell me.
Thank you for your time.
best regards
Stephan
--
MySQL Gener
hat I could
find was deleting records from mysql.user. Is there another way?
Thanks,
Stephan Samuel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
= ... mysql replika user
master-password= ... mysql replika user password
master-port=26001
server-id=2
I don't see any InnoDB settings...? Both, Master and Replika have the
InnoDB Files in the DataDir...
Thanks,
Stephan
Jeremy Zawodny wrote:
On Thu, Mar 27, 2003 at 10:55:28AM
ard data directory; I did not
configure any InnoDB Option, since we are not currently using InnoDB.
What's wrong? Why do I get InnoDB datafiles (ib_arch_log_00,
ib_logfile0, ib_logfile1, ibdata1) with only MyISAM Tables?
Thanks for your help!
Stephan
--
MySQL General Mailin
es, if you ran with --log, take a look at the
details of what thread 7 did to cause the crash. In some cases of really
bad corruption, the values shown above may be invalid.
The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is ca
I use mysql-4.0.4.
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscr
d: Usage: /usr/ccs/bin/ld [options] [flags] files
collect2: ld returned 1 exit status
Thanks for helping me!
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
d: Usage: /usr/ccs/bin/ld [options] [flags] files
collect2: ld returned 1 exit status
Thanks for helping me!
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
Thanks, it was just about the set the right for the mysql user, as - you
already correctly mentioned - mysql runs as user mysql.
Thanks and regards,
Stephan Gloor
> Stephan Gloor wrote:
> >>On Fri, 4 Oct 2002, Stephan Gloor wrote:
> >>
> >>
> >
> On Fri, 4 Oct 2002, Stephan Gloor wrote:
>
> > When trying to create an index on
> >
> > Table ANSCHLUSS:
> > | ID | int(11) | | PRI | NULL| auto_increment |
> > | TELEFON | varchar(20) | | MUL | |
are 28'103'092 KB
available. root, the owner has rights enough, mysql is started from the root
user.
(drwxr-xr-x2 root root 35 Oct 4 08:08 tmp/)
OS: Linux
Thanks and regards for any comment.
Stephan Gloor
-
his.
Kind regards,
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To uns
I think you should use this statement. I did not try it.
DELETE FROM hinvoice h
USING dinvoice d
WHERE h.nof=d.nof
AND h.tgl < '2002-09-01';
Regards
Stephan
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 13,
Hello,
I need to do an update on a table :
* Something like this : *
UPDATE my_table mt
SET mt.field1 = mt.field1 + 1
WHERE mt.id = 100
*
And there can have concurrent updates on this record. is there a risk of 2
(or more) updates done at the same time an
Maybe it is because some of your id are bigger than 127 wich is the limit
for the Tinyint and when it is converted to this type, "127" is replacing
all your id bigger than 127. Then you have multiple id with 127.
Regards,
Stephan
-Original Message-
From: [EMAIL PROTECTE
all the updates done in a queue ... ?
Thank you for your help
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
e, & some code goes there.";
php?>
proposed method:
Fields with only word characters (or word and any of ",.-") are left intact.
i strongly recommend a similar change in mysqldump's --xml behaviour, as the
current behaviour seems downright evil.
Take care, :)
ction to find out such information as:
- What memory regions are allocated? (buffer pools, a log buffer?)
- How are the blocks in memory managed (processes involved)? Aging out of
dirty blocks?
- How are log files produced (by what process and when)?
Any help is appreciated.
Thanks,
St
Have you tried the command : "EXPLAIN SELECT select_options"
(http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
what Indexes are used ...
Stephan
-Original Message-
From: David Bordas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 5:16 PM
T
I've had a similar problem before. My workaround was to read the image into a string,
then escape the string (replace ' with \' etc). Then use an INSERT statement to put it
in the database. That works fine wih any sized image.
Stephan.
-Original Message-
From: [
myODBC 2.5 and mySQL 3.23.43
Mit freundlichen Grüssen
Stephan Schröder
===
Dipl. Ing. Stephan Schröder
Software & Entwicklung
ProWebMa Hosting GbR
Web: htt
NULL | NULL | 3689 |
where used |
+---+--+---+--+-+--+--++
1 row in set (0.00 sec)
Can someone tell me why the index is not hit???
Thanks,
Stephan
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
]]
> Gesendet: Freitag, 26. Oktober 2001 11:32
> An: Stephan Skusa
> Cc: [MYSQL]
> Betreff: Re: Problem compiling MySQL-4.0.0-alpha with charset german1
>
>
> On Fri, 26 Oct 2001, Stephan Skusa wrote:
>
> > if I do a
> >
> > ./configure --prefix=/usr/local
latin1_de results in the same problem!
> -Ursprungliche Nachricht-
> Von: Thomas Spahni [mailto:[EMAIL PROTECTED]]
> Gesendet: Freitag, 26. Oktober 2001 11:32
> An: Stephan Skusa
> Cc: [MYSQL]
> Betreff: Re: Problem compiling MySQL-4.0.0-alpha with charset german1
>
rc/mysql-4.0.0-alpha'
make: *** [all-recursive-am] Error 2
Where is the problem??
TIA
--
Stephan Skusa mailto:[EMAIL PROTECTED]
Lippe-Net Online-Service http://www.lippe-net.de
Herforder Strasse 309 tel.: +49 (0)521 - 977 998
#x27;d be curious to
> hear what you find.
Haven't done it yet ...
Ciao, Stephan
--
sql table
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
index that
only need an update.
Is it a good idea to do that much index manipulations that aren't
necessary?
Ciao, Stephan
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Hello,
I need some help for database optimization ... is there any documentation
about tuning server parameters except this one in MySQL-documentation which
ist not very detailed I think especially in case of effects on server or
threads.
TIA
Stephan
Hello,
I need some help for database optimization ... is there any documentation
about tuning server parameters except this one in MySQL-documentation which
ist not very detailed I think especially in case of effects on server or
threads.
TIA
Stephan
I don't think it's a OpenBSD Problem ... I've got the same behavior
on several Unix - Machines ... running 3.23.33 - 3.23.39 ...
> -Ursprungliche Nachricht-
> Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 23. Juli 2001 12:43
> An: [EMAIL PROTECTED]
> Cc: [EMAIL P
What about installing and using phpMyAdmin??
http://phpmyadmin.sourceforge.net/
> -Ursprungliche Nachricht-
> Von: Joseph Maxwell [mailto:[EMAIL PROTECTED]]
> Gesendet: Samstag, 21. Juli 2001 12:58
> An: [EMAIL PROTECTED]
> Betreff: How to create table in msql DB through cgi script
>
>
mn q02 (!! not 30 as expected 10+20=30).
It seems that every row was touched twice by the update statement.
Why? What went wrong with the system? What can I do to repair and prevent this?
Ciao, Stephan
P.S.
- q02 is not a key
- isamchk -e doesn't report any errors
- MySQL 3.22.32
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ...
RTFM: http://www.mysql.com/doc/J/O/JOIN.html
> -Ursprüngliche Nachricht-
> Von: Bruce Stewart [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 16. Juli 2001 11:54
> An: Mysql-Help (E-mail)
> Betreff: Outer join syntax..
>
>
> Hi all,
>
> MyS
cept this large mailings ... ;o)
> -Ursprungliche Nachricht-
> Von: Colin Faber [mailto:[EMAIL PROTECTED]]
> Gesendet: Mittwoch, 23. Mai 2001 05:43
> An: Stephan Skusa
> Cc: [MYSQL]
> Betreff: Re: Another signal 11 dump ...
>
>
> have you tried trussing the mysqld
Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes
seems not to be the solution for the signal 11 at 0 o'clock ... stated
some weeks ago!
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a r
>Description:
Unpackaged 3.23.37 and ran configure:
...
checking size of char... 0
configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if you have libm.a
in /lib, /usr/lib or some other standard
hi ... how can i build queries that save the value of ... for example
jpg-files ?
in their binary-code there are many '\0' - characters which terminate a
string ... so how can i tell the mysqlserver to save it anyway ?
-
Before
The Cron-Jobs working on all tables of these database are
all running between 2:00 and 4:00 ... none at 0:00!
> -Ursprungliche Nachricht-
> Von: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 7. Mai 2001 15:24
> An: Stephan Skusa
> Cc: MySQL
> Betreff
i use mysql 3.23.34a and using BLOB's and timestamps leads to errors (
when giving all timestamps the value "now()" only some of them return
the correct date the BLOB's don't even return anything ... )
... is this version that buggy ?
is a temporary table. Every time I execute this statement
manualy
using tool mysql everything works fine.
TIA
Stephan Skusa
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace t
Hi
I am trying to insert some BLOB's in my database - i created the table
already and when i use the standard-insert-commando i give the position
on my harddisk of this file. So far so good. But when i try to get the
data back from the database, i simply get nonsense or nothing
I use ( windo
is a temporary table. Every time I execute this statement
manualy
using tool mysql everything works fine.
TIA
Stephan Skusa
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace t
Hi - i have a problem giving names to some tables or fields. using a
name like "select" or some predefined SQL-standard-words causes errors
because it is not seen as a name, but as a command.
any solution to this ?
-
Before pos
Number of processes running now: 1
mysqld process hanging, pid 30175 - killed
010322 05:16:56 mysqld restarted
/usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen.
-Ursprüngliche Nachricht-
Von: Stephan Skusa [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 22. Mär
Hello,
I've got a problem. If I remove multiple udf-Funktions of one udf-Library i
get a
'lost connection' error.
I'm using a sql-script deleting for example 4 functions and then recreate
them (because
of an update of the .so)
Any ideas??
TIA
DUAL is a dummy table in oracle ... !
In mysql you have two way to set variables:
1. set them directly via SET @variable={ integer expression | real
expression | string expression }[,@variable= ...].
2. or do something like select @variable:={ integer expression | real
expression | string expre
What does this message in my logfile mean??
010227 21:23:01 Verbindungsabbruch 1976 zu db: 'database' user: 'user'
host: `archimedes.int.lippe-net.de' (Fehler beim Lesen eines
Communication-Packets)
If that's the case u r running it but not really using it ... !!
> -Ursprüngliche Nachricht-
> Von: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
> Gesendet: Donnerstag, 8. Februar 2001 22:24
> An: Chan, Kwok-Hing; '[EMAIL PROTECTED]'
> Betreff: Re: Maximum Capacity and Stability
>
>
> I c
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that
a column that is displayed
and has no grouping function applied to it MUST also appear in the GROUP
BY-clause!!!
The result:
fldNAME fldMONAT sum(fldSALARY)
boris 1 10200
stephan 1 6000
DEFAULT '-00-00 00:00:00' NOT NULL,
PRIMARY KEY (fldNAME, fldMONTH)
);
with following records:
INSERT INTO groupbyTEST VALUES ( 'stephan', '1', '1000', '2001-01-25
23:12:29');
INSERT INTO groupbyTEST VALUES ( 'boris', '1
65 matches
Mail list logo
