On 3/11/09, Thomas Spahni wrote:
> > I am searching for a generic command to monitor that MySQL instance is
> > up and running. I don't have any know-how about the schema of the DB.
> What about 'mysqladmin ping' ?
Hi Thomas
thank you. That was the command
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
For now I can workaround with MyISAM,
but if the feature is no longer on the list, then it would be better
to choose another more cumbersome approach or switch the db entirely.
Many thanks for a short update.
Cheers, -sven
--
MySQL General Mailing List
For list archives: http://lists
ng at your answer and asking Google I've
already seen that MySQL knows DISTINCT BINARY also.
Thanks a million, Chris!
--
sven fuchs fon: +49 (58 45) 98 89 58
artweb design fax: +49 (58 45) 98 89 57
breite straße 65www: http://www.artw
ble's and varchar field's collation is set "utf8_unicode_ci".
Is there anything I can do to have MySQL distinguish these characters?
(mysql --version is Ver 14.7 Distrib 4.1.22, for apple-darwin8.8.1
(i686) using EditLine wrapper)
Thanks in advance!
--
sven fuchs
rticles on MySQL , a lot of books and the manual but I cant get any
answer.
Thanks for any answer wich will solve my problem.
Sven Åke Johansson
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
:
> select max(id) from bla1;
That's not what I want. I need the ID of the row just inserted (for
referencing it from another table).
If I select the max(id), then one the hand someone might have added another
row in the meantime and on the other hand is still don't get the ID
PDATE @myid:=id
doesn't work, since I can't assign user variables in this part.
So, is there a way to INSERT an entry if neccessary and always get the id of
the entry?
Sven
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Warning: mysql_query() [http://www.mysql.com/doc]: Your query requires a full
tablescan (table bb1_designelements, 78 rows affected). Use EXPLAIN to optimize your
query.
I get this error on every products i tested
ot; column2 (string) : ");
if (is_null[1])
fprintf(stdout, " NULL\n");
else
fprintf(stdout, " %s(%ld)\n", login, length[1]);
/* column 3 */
fprintf(stdout, " column3 (string) : ");
if (is_null[2])
fprintf(stdout, " NULL\n");
0 - U-001F: 0xxx 10xx 10xx 10xx
U-0020 - U-03FF: 10xx 10xx 10xx 10xx 10xx
U-0400 - U-7FFF: 110x 10xx 10xx 10xx 10xx
10xx
(http://www.cl.cam.ac.uk/~mgk25/unicode.html)
Anyway... 65,536 is enough for me :)
ers. But about those four-byte sequences: Will
that be implemented _after_ MySQL gets longer VARCHAR columns? If not,
a new version with four-byte sequences would not be able to handle my
tables anymore, right?
- Maybe you should change the error message in SHOW INNODB STATUS ;)
Than
n:
- 4.1.1-alpha-standard-log
- Official MySQL-standard binary
- i686
- pc-linux (debian 3.0 woody)
Sven
Schlund + Partner AG
Brauerstraße 48
76135 Karlsruhe
Dipl.-Inf. Sven Woltmann
[EMAIL PROTECTED]
http://www.schlund.de
--
MySQL Genera
Hello,
I am using MySQL 4.0.16 on Debian GNU/Linux at the moment. In this database
there are over 4,5 Mio. entries!
The Database crashs with follow errors:
031217 19:21:06 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.0.16-log' socket: '/opt/lampp/var/mysql/mysql.so
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
What gave you that idea? Firebird (and InterBase of course) use
a at least 1 file per database, but that's all. Can you define
"regular files"?
My idea of Firebird is the f
I set the isolation level to READ_REPEATABLE and use mysqldump | bzip2
to get the result. I've tested the restore and it's fine!
So how does mysqldump handle binary data?
If it does embed the data into the SQL-statement somehow, that's crap,
since SQL-Statements are limited in length.
--
MySQL
So far, it seems that MySQL, MaxDB, PostgreSQL, and Interbase/Firebird are
possible candidates.
Does anyone know why we should or should not use any of these? Does anyone
know of other possibilities?
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-eng
displays only one row.
So I`d like to display the query result as a vertical table
If anybody knows a better way to do it, I`d really appreciate it
Thanks for your help in advance.
Best regards,
Sven
-
Before posting, please
(".") :
Two Points would give back "2.2." and "1.1."
Three Points would give back "2.2.1." and "1.1.3." etc.
I tried to use a REGEXP, but didnt succeed.
Can you help?
Gruß aus Essen
Sven Schäfermeier
__
load a text file containing the names into my
my query?
2. How do I have to build the update statement itself? Can I use some
kind of variable?
Thanks for your help in advance
SVen
-
Before posting, please check:
http
on where to look up that problem would be very
welcome.
"select name, surname, pemail, course
from memberscopy
where nation = '$f_nation'
order by course "
Thanks for your help in advance,
Sven
---
bile='$pmobile',
pemail='$pemail',
marital='$marital',
spouse='$spouse',
children_number='$children_number',
children_names='$children_names',
27;,
marital='$marital',
spouse='$spouse',
children_number='$children_number',
children_names='$children_names',
hobbies='$hobbies',
membershi
1. delete any whitespaces between the column name and the "=" and the
values.
2. try using
columnname="value"
That works for me.
On Thursday, May 16, 2002, at 09:59 AM, Daniel Lim wrote:
>
> Hi there,
> I have MySql version: 3.23.36 running on RedHat 7.1, it has been
> w
a list (or even better a
download location) of all available UTF-8 national character sets and a
small description on how to get them working as fast as possible?
Thanks for your understanding and help,
Sven
On Thursday, May 16, 2002, at 08:40 AM, Roger Baklund wrote:
> * John D. Stein
Hi guys,
just found a way that works, though it's not very elegant. (see below)
and I do not know why it didn't work...
Although it's working now, I'd still appreciate your comments.
Regards,
Sven
code:
while ( my (
$u_id, $u_surname, $u_name, $u_rank, $
help.
sven
code:
my $sth = $dbh->prepare(
"select *
from memberscopy
where name = '$f_name' and surname = '$f_surname' "
);
$sth->execute;
#combine perl variables with dat
not correctly updated.
>
> Help and hints will be greatly appreciated...
>
> Regards,
>
> Sven
>
>
>
>
> sub do_data {
>
>
> my $curl = param('curl');
> my $name = param('firstname');
> my $surname = param('s
| 1 | Erik| Austrian |
| 1 | Maria | Austrian |
Is there any way that I can get a line count of the result set and the
details with onl one query?
Thanks for your help!
Sven
-
Be
on my box the following helped:
(su to root)
chown -R mysql /usr/local/mysql/var (check if this is the path to your
mysql var )
(exit root)
that should do it.
also check in the user and host table if a connection from localhost is
allowed for the specific user..
Cheers,
Sven
On Monday, May
Hi !
Just read about the possibility of replicating two databses.
Can you tell me how to do it or send me a (link to a) manual?
Thanks,
Sven
On Monday, May 6, 2002, at 03:11 PM, Dicky Wahyu Purnomo wrote:
> On Mon, 6 May 2002 07:44:04 +0200
> "Ewan Sadie" <[EMAIL PROTECTED]&
;s just an idea from a newbie, so do not put too much trust in it :)
Sven
On Monday, May 6, 2002, at 02:44 PM, Ewan Sadie wrote:
> I have installed MySQL on two of my MS-Proxy servers. I am logging all
> web browser logs to MySQL.
> I want to replicate the database to a central server where
elect me.hobbies, me.experi [..] from memberscopy me, priv_details pd
where pd.id=me.id;
What can i do?
For help I would be really grateful!!
Regards,
Sven
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
On Sun, Apr 21, 2002 at 02:44:32PM +0200, Roger Baklund wrote:
> * Sven Huster
> >
> > This manual is f@#$% up, since it seems like there is no manual for
> > stable versions online or at least some annotations that say in which
> > version a feature was introduced (it
e there is no manual for
stable versions online or at least some annotations that say in which
version a feature was introduced (it's not nice to lookup every change
in the ChangeLog).
I suspected that the online version reflects the most
None
Event ID: 7031
Date: 4/14/2002
Time: 4:24:25 PM
User: N/A
Computer: SECRET
Description:
The MySql service terminated unexpectedly. It has done this 1 time(s). The
following corrective action will be taken in 0 milliseconds: No action.
Do you know what I can do to avoid this?
Thank
esort used here?
According to the MySQL doc (5.2.7, example 5) this should work
using the index without any additional sorting.
btw:
MySQL-3.23.49-max-log running on FreeBSD 4.4-RELEASE
Thanks
Regards
Sven Huster
-
B
rid of the daemon.
anything i can do to solve this??
thanks a LOT for all help.
Mit freundlichen Gruessen / Best regards
Sven Hoffmann
___
thingk IT-Dienstleistungsgesellschaft mbH
CAE-Support
fuer EDS Informationstechnologie und Service GmbH
Tel.: +49 337
Hello,
I'm new in the world of MySQL and have a question:
What Software can I use to programm MySQL clients for HTML(XML) or Java
? Is there a
Software which is easy to use ?
Thanks a lot for answering,
Sven Hammann.
-
B
gcc can´t
find executable.
does anyone know some help for a beginner?
thanx in advance
sven
MEGA Malereinkaufsgenossenschaft e.G.
Sven Gauger, EDV-Abteilung
Fangdieckstraße 45
22547 Hamburg
office: 040 / 54004
Hello!
How do I get the size of a blob?
I want to do something like this:
SELECT * FROM blob_table WHERE size(blob_column) > 1024;
Best regards
Sven
--
---
>>> ANDURAS AG - solutions
values are displayed as 1.Q#NaN. All normal double values work fine.
(This has been observed with Window 98/NT and 2000).
When I transfer the data back to Linux or Solaris they are still O.K.
Does anybody know how to solve or workaround this problem ?
pair.
If I move the db files to another computer (RedHat 6.2 with mySQL
3.23.32) isamchk doesn't complain but finds and repairs some errors.
What is error 22 ("Invalid argument"?!) and how do I get around it?
Sven M. Sorensen
Unive
e db files to another computer (RedHat
6.2) isamchk doesn't complain but finds and repairs some errors.
What is error 22 ("Invalid argument"?!) and how do I get around it?
Sven M. Sorensen
University of Southern Denmark
---
i think the server does not run with privileges
to write to /root
regards
Sven Huster
Senior IT Systems Engineer
Sven Huster
Senior IT Systems Engineer
> -Original Message-
> From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
> Sent: 30 August, 2001 20:51
> To: [EMA
it also was my first idea to check /var/log/messages
immediately, but nothing in there.
we now run our servers as diskless machines over nfs
on the netapp filer for +6 month and no errors at all,
on any of the machines.
regards
Sven Huster
Senior IT Systems Engineer
> -Original Mess
On Thu, Jun 14, 2001 at 07:30:01PM -0500, Paul DuBois wrote:
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> At 1:36 AM +0200 6/15/01, Sven Huster wrote:
> >Hi there
> >
> >can i somehow easily recreate the auto_increment col if is was no
= 1604185 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
010615 08:09:27 mysqld ended
System: FreeBSD 4.3-RELEASE
MySQL: MySQL-Max-3.23.39 over nfs
thanks
regards
Sven
-
Before posting, p
row.
thanks
regards
Sven Huster
-
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]>
etapp filer)
regards
Sven Huster
Senior IT Systems Engineer
> -Original Message-
> From: Wouter de Jong [mailto:[EMAIL PROTECTED]]
> Sent: 13 June, 2001 10:21
> To: [EMAIL PROTECTED]
> Subject: load-balancing with NFS
>
>
> *This message was transferred with a tria
ce in...
Any suggestions?
Regards,
Sven
-
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]>
Hi list
got a problem againcan't delete :
$db=mysql_pconnect($host,$dbuser,$pass) or
die($dbfehler);
echo "$userto";
mysql_query("use $dbase;");
mysql_query("DELETE FROM $dtable where loginid = '$userto' ");
wha
s no problemselecting works!
But how to search in all rows? What is the wildcard command?
thanks in advance
sven
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
>Please help me.
>Thanks in advance.
>
>Sandeep
I think you can restart the server with --skip-grant-tables and change the
password then.
regards
Sven Huster
Senior IT Systems Administrator
*BSD, Linux, Solaris
-
B
+31 (0)35 6219819
>www.nibble.nl
have you tried
mysql -u root?
Normally only user root has all privileges
Create others with GRANT, check manual
Check
http://www.mysql.com/doc/A/c/Access_denied.html
http://www.mysql.com/doc/G/R/GRANT.html
Hope it helps
regards
Sven Huster
Senior Unix System
Am 00:20 30.03.2001 schrieb Joshua Chamas:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Sven Huster wrote:
> >
> > Hi there,
> >
> > i anybody out there running mysql on a netapp filer as data storage?
> >
>
>Yes, I
Hi there,
i anybody out there running mysql on a netapp filer as data storage?
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
-
Before posting, please check:
http://www.mysql.com/manual.php
scribing? Try: http://lists.mysql.com/php/unsubscribe.php
maybe OT:
but i am using it for session storage for www application since 2 month,
not temp tables.
no problem so far. works quite stable and really fast.
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
> > Am 11:22 16.03.2001 schrieben Sie:
> > >*This message was transferred with a trial vers
Am 17:21 16.03.2001 schrieb Jeremy D. Zawodny:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>On Fri, Mar 16, 2001 at 11:32:42AM +0100, Sven Huster wrote:
> > Am 11:22 16.03.2001 schrieben Sie:
> > >*This message was transferred with a trial vers
eas about this?
>
>MySQL server: FreeBSD 4-Stable
>
>regards
>
>Sven Huster
>Senior Unix System Administrator
>*BSD, Linux, Solaris
>
>
>-
>Before posting, please check:
> http://www.mysql.co
cause everything else stays the same, but not more
traffic on the db
+ if i switch the db of the cpu goes down to 1-5%.
any ideas about this?
MySQL server: FreeBSD 4-Stable
regards
Sven Huster
Senior Unix System Administrator
*BSD, Linux, Solaris
How do I post a new binary distribution for inclusion in the page
http://www.mysql.com/downloads/mysql-3.23.html
?
I would like to contribute a standard binary distribution for DEC OSF
4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql
on this platform is a major pain, requi
63 matches
Mail list logo
