Hi,
it happend again and I can't fix it, may be someone has a working
solution and information on that:
I installed the most recent mysql 5.6 community on a server and do get a
lot of "errno: 24 - Too many open files".
There are suggestions to increase the open_files_limit, cha
Hi,
we recently had a software bug who wrote gigs of data to our database in
a loop and finally filled the whole system.
O.K. we could serverside use a separate partition/storage for the
database directory, but I was wondering is mysql has a feature/option to
set some sort of "minimum disk free"
db have to be identically?
Thanks a lot for any hint or suggestion!
Best regards . Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reini...@filmakademie.de
Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.fi
Am 08.06.10 12:05, schrieb Rob Wultsch:
> On Mon, Jun 7, 2010 at 11:59 PM, Götz Reinicke - IT-Koordinator
> wrote:
>> Hi,
>>
>> we do have different LAMP systems and recently I started to put some
>> mysql databases on one, new master server. (RedHat, Fredora, MySQL
bases to the master
after sucessfully running a master-slave-setup? Will the new database be
copied/created on the slave automatically? Or do I have to create tham
twice?
Thanks for any comments and sugesstions. Best Regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 420
F
r should I export the dbs and than import
tham?
Best regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reini...@filmakademie.de
Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de
Eintragung A
majk.sko...@eventim.de schrieb:
>> -Ursprüngliche Nachricht-
>> Von: Götz Reinicke - IT-Koordinator
>> [mailto:goetz.reini...@filmakademie.de]
>> Gesendet: Mittwoch, 25. November 2009 12:05
>> An: mysql@lists.mysql.com
>> Betreff: Virtual servers
ual servers.
What RAID would be the better choice? 10 or 01?
What do you think?
Thanks for any suggestions and best regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 420
Fax +49 7141 969 55 420
E-Mail goetz.reini...@filmakademie.de
Filmakademie Baden-Württemberg GmbH
ne large 1+0 or 0+1 as 1.2TB would be more than enought.
Or may be I do split things up like this: one raid 1 for the system, one
raid 1 for logfiles, one raid 1+0/0+1 for the database.
Any suggestions?
Thanks and best regards,
Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 9
Perhaps not the most elegant way:
- Create a temporary table
- Select-insert into the temp-table
- Use the temp-table for a delete-join or a 'NOT IN'-statement or something
like that
Hey all
I am stuck here (thinking wise) and need some ideas:
I
Somebody needs to lay off the drugs. LOL
Gabriel Mahiques wrote:
the real pronuntiatios is.. MAIESEKUELE spanish, spanish... the rest
is a dream...
when I start up the system, it say... "wellcome.. I'm the best...my name
is MAIESEKUELE and I'm free oh yea...
I wan
Jay Blanchard wrote:
[snip]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
[/snip]
Cool, then do it!
It would all depend on how he has his feet and inches saved in the
table, and of course, the field names. If
ASN value.
Is it better to do an 'insert ignore' into ASNINFO when I have to look one
up, or is it better to try to fetch the ASN information to see if it exists,
and then if it does not exist, do the insert. I figure the fetch is one sql
command, and the insert is one sql command, s
they change the license for future versions of
MySQL you can continue to use the last version which was released under
the GPL.
Regards
--jm
But, it would be a good idea to support the further development of the
database by contributing to MySQL either by donations or license fees.
Espec
Yes. I installed zlib in /usr/local/zlib and openssl in
/usr/local/openssl. I then added /usr/local/zlib/lib and
/usr/local/openssl/lib to the /etc/ld.so.conf file and ran ldconfig.
It still was giving me errors. So I had to manually add the paths to the
Makefiles and it worked.
Enrique
I couldn't find the an rpm for the lastest version of zlib, openssl, etc...
I could use the mysql rpm but does it have all of the features and
extras in it or does it come barebone? Does it know where to look for
all of the necessary libraries and includes? I have never ventured into
th
t we had to buy RHEL in order to be compatible
with the hardware.
I do not use binaries if I can help it. I much prefer to compile
everything from source, so that I can enable or disable features and
modules to my liking. With binaries you get what someone else has
compiled for you. Isn&#
th-openssl-includes=/usr/include/openssl
--with-openssl-libs=/usr/lib
I found a similar error in the archives but it was from a year or so
ago. I tried it anyway and it didn't work. Does anyone have any suggestions?
Thanks
Sean
--
MySQL General Mailing List
For list archives: http://
Not Apache, Mysql-4.1.13. I did look in the Mysql acinclude.m4 and it is
looking for ssl.h in the includes folder (which does exist) and it's
looking for libssl.a in the libs folder which does exist.
So, I'm kinda confused as to why it says it's not found.
Peter J Milanese
ror in the archives but it was from a year or so
ago. I tried it anyway and it didn't work. Does anyone have any suggestions?
Thanks
Sean
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I am new to mySQL. Someone gave me a "dump" file and i need to do an
import from linux. How can i go about doing this can someone help me?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server not starting beginnig two-three days ago. All went well until then, when i had
some large queries on server, and i think that was the moment when it crashed. I tried
increasing the amount of innodb_buffer_pool_size from 8 to 16M , it started now, but
the same list of errors appears in
Hello!
I'm using a WLS server and MySQL. Where am I supposed to put the
"mysql-connector-java-3.0.11-stable-bin.jar" to make sure WLS will find it? I've tried
several places ie. under ttk and right under classes. Still WLS doesn't find my
mysql.jar file. It wo
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1 hs daniel
Hi!
I got a table, champions, looking like this:
id class winner_1 winner_2 year
-
0 hd carl mattias 1957
1 hs daniel
It works fine (with a little tweak).
SELECT DISTINCT CASE WHEN c1.winner_1 = c1.winner_2 THEN c1.winner_1 ELSE c1.winner_2
END AS winner FROM champions c1,champions c2 ORDER BY winner ASC
is what I wanted. Thank you very much! Btw, I can't help my webhotel is rotten and
only uses old ver
it since the names are in two columns
so, there must also be a UNION included
do a union and then select distinct on the result from the union
that should do it (eller hur?)
-Ursprungligt meddelande-
Från: Jonas Lindén [mailto:[EMAIL PROTECTED]
Skickat: den 17 februari 2004 16:01
Till
Hello!
I got a table, champions, looking like this:
id winner_1 winner_2
0carl mattias
1daniel carl
2erik
*
FROM champions
WHERE champions.class_name
Someday please help me. Am I not using the right version of php? Or is it mysql?
I wonder why even I already sey NOT NULL in Mysql field but Delphi (with
MyODBC 3.51.06) still enable to save to the Table!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run
mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen.
I download Mysql for Windows but not purchase the Commercial Licence yet. Is
there a time based restriction here?
--
MySQL General Mailing List
F
. This works with Access but apparently not with MySQL.
> Clearly I am missing something fundamental regarding differences between
> MySQL's and Access's interactions with data aware components.
>
> Can anyone suggest what it is that I am missing and how can I coax my
>
I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and
also Delphi 8 .Net to provide web services application, I want to know how
to make a web services application using Mysql? Or is there similiar
technology like .Net but using Mysql?
--
MySQL General Mailing List
For list
Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hop
Dear All,
How do I know that User "USER1" already login to Mysql?
I am creating multiuser program and need to set only one User Name uses at
same time. If there is 3 users that my login as User1, User2 and User3.
William
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
45 AM
Subject: upgrading
Hi, a while ago I upgraded from version 3.23.54 to 4.0.16 I downloaded the
rpm's to usr/src/rpm
I can't remember the syntax to install all the rpm's it was something like
' U rpm ' any help appreciated
I have to write this up so best I get it
I am doing transfer from MS SQL.
In MS SQL while I connect as "USER1" my table will be create as User1.TableName.
This will avoid conlict with other user.
Now, how do I do that in Mysql? Or, maybe there is such system in Mysql. Is there any
Mysql reference talk about this matter?
The database is working fine, by the mysql command hangs indefinitely. Any thoughts
how I can determine the cause?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I should add that I can access the database via a java program, just not
using the mysql command.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'mysql -A sampdb' hangs as does every other mysql command. There are no
recent entries in hostname.err.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:52 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: R
BTW, nothing's changed in my.cnf...
.my.cnf
---
[client]
host=localhost
user=jim
password=password
No query, I just entered 'mysql sampdb'. It hung indefinitely; I had to kill
the window.
Since I couldn't get into mysql I don't know the value of any variables
Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to
the latest release of Mac OS X this past weekend. As far as I can tell, the server
seems to be running, but when I attempt to execute the mysql command it just hangs.
Any ideas?
Thanks,
jim
--
MySQL Ge
Does MySQL support update from other table?
I run this query and get error:
UPDATE TableA SET Division=TableB.Division
FROM TableB
WHERE TableA.Code=TableB.Code
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
I try convert this MS SQL Statement but an error occurs:
UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE
FROM a,b
WHERE a.ACCODE=b.ACCOUNT_OLD
Is there any syntax doing same as above?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Will be any problem if I install MySQL 4.0.15 for Win on the Server that
already has MS SQL 2K under W2K Server?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there one that's especially outstanding?
Thanks,
jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adam,
It works! I also had to run the initialization script...
Thanks very much for the help.
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE
l make the ownership/group changes you suggest below and let you
know the results.
Thanks!
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installati
Adam,
Well, you were right about there being logs :) (I hadn't looked into the data dir
since it required root and I was reluctant to setup a root user--live and learn.)
031009 11:12:10 mysqld started
031009 11:12:11 InnoDB: Operating system error number 13 in a file operation.
InnoDB
Adam,
Yes, that's how I'm starting it. There are 2 reasons that lead me to believe that it's
not running:
1. when I issue "mysql -h localhost test" I get this msg:
ERROR 2002: Can' connect to local MySQL server through socket
'/tmp/mysql.sock
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is
the server won't start and there don't seem to be any logs available to help diagnose
the problem. I've tried both
sudo safe_mysqld
Starting mysqld daemon with databases from /usr/local/my
ql. Reinstalled everything, still i couldn't make it.
Pacakage availabe now : -
[EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql
MySQL-bench-4.0.13-0
MySQL-server-4.0.13-0
MySQL-shared-4.0.13-0
MySQL-shared-compat-4.0.13-0
MySQL-devel-4.0.13-0
MySQL-client-4.0.13-0
MySQL-embedded-4.0.13-0
Mysql-D
Hi Team,
I am unable to start the mysql service at my red hat 8, below is the
error. What it is all about ?
/usr/sbin/mysqld: ERROR: unknown option '--log-bin # required
for re
plication'
030829 01:01:37 mysqld ended
Thanks in advance
Suresh A.
--
MySQL General Ma
for some reason I'm still unable to set user rights. But
without having the option presented to me, I'm unsure how to fix the problem.
Again, I am running Windows 2000. Thanks again for any insight!
Regards,
Kirsten
Kirsten Belkhiria
Solutions Manager
Technik IT
Web Development and N
tall file in my mysql\bin on my hard drive. Could it be that I
didn't download it correctly? I have been able to run mysqladmin with no
problem - but i am getting "access denied" errors when I attempt to access
databases on my hard drive - that's why I'm assuming that I h
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
I just migeate from MS SQL to MySQL but have problem on "Cascade Update".
Suppose I have BOOK and LIST_TYPE tables like this:
BOOK, field: Book_Name, Book_Type
LIST_TYPE, field: Book_Type
If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the
content of Book_Type (
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
Don't reply or they'll get your Email address. ;-)
Regards
**
* K e i t h B u r k e*
**
* Experience IT Ltd * Phon
Sorry, my bad.
What is this PAGER and where do I run your test script from?
Regards
**
* K e i t h B u r k e*
**
* Experience IT
Michael T. Babcock wrote:
>May I rephrase your comment?
>
>"I need to send E-mails to people from MySQL data".
>
>I recommend just doing a SELECT on the data in question and generating
>the E-mails from PERL or PHP or whatever other language you are using.
N
Walt,
Sorry, let me explain in a little more detail.
I have an Access front end ODBC'd to a Foxpro database [I hate
Foxpro :-p No choice, another company developed it for our customer.] on
a Windows server. I get it to export the data to couple of files, tar,
gzip, then f
are in
there twice and no more than that.
Regards
**
* K e i t h B u r k e*
**
* Experience IT Ltd * Phone : +353 1 xxx x
be able to send Emails to people from MySQL command
line.
I'm importing a text file of users via a cronjob. MySQL process
the data and segragates it into different tables. My problem is that I
want MySQL to Email the plain text passwords to the users before it
MD5's them. I cannot
Any suggestions on how to load images from a web site into a MySQL db? I would like
to set up a page that allows you to select an image from the local machine and load
it to my MySQL DB on my web server.
I'm not sure if it would just be a regular insert statement or something else?
T
I have a databse on mysql server that authenticates users... However mod_auth did
not have access to the database containing the user info. How can I set up my
database with adequate permissions to allow mod_auth to access that database without
leaving the database wide open...
/Thanks
Tim
Hi all,
there must be some kinds of technical difficulties as I'm also not
able to unsubscribe at the moment.
At 14:28 29.01.02 +, you wrote:
>could you be subscribed under two (or more) email addresses?
>
>Peter
>
> > -Original Message-
> > From: Yuxia Li [mailto:[EMAIL PROTECTED]]
ot; 10 tables :(
>
>I'd say that a UNION over 10 tables is a sure sign for a bad DB design.
That's for sure. Fortunately it wasn't my idea but unfortunately I'm not
able to convert it so I have to use workarounds for now :(
>-
large and I have to "manually join" 10 tables :(
At 15:04 28.01.02 +0100, you wrote:
>* Tobias Kremer :: IT
> > Thanx dn. I know how to build joined selects but the problem is that those
> > two tables are not joinable. I don't have an entry in table 1 which
> >
ave to make either various
>selects or create an extra table which stores just this
>information ?
>
>
>=Yes it can be done in a single statement, eg
>
>SELECT *
> FROM userid, title, date_created
> WHERE -join the tables together-
> ORDER BY date_created
>
>
Hi Hayan,
have a look at:
http://www.mysql.com/doc/L/O/LOCK_TABLES.html
for information on (un)locking tables.
At 11:48 28.01.02 +0300, you wrote:
>Hi, Is there a way to lock a table so that only one user can change it and
>then unlockit?
>I need to do this coz I want visitors to
Hi list,
Assume I have various tables which all have these three fields:
userid, title, date_created
Now I want to create a list containing entries
of all tables ordered by date_created with a single select.
Is this possible or do I have to make either various
selects or create an extra table
72 matches
Mail list logo
