"Thalis A. Kalfigopoulos" wrote:
> Check you don't have empty strings as empty remarks, but that you have NULLs.
> Even with empty strings as remarks though you can bypass them with an extra WHERE
>condition :-)
That was it. I was storing empty strings, instead of NULLs. Thanks!
AMK4
> You're right. Is there anyway around this hassle of having to do all the
> different IDs? Something like:
>
> DELETE FROM Page wheres articleid=articleid and pageid=pageid limit 1
>
> Would that work?
>
> Ryan Shrout
> Production Manager
> Athlonmb.com
> http://www.athlonmb.com
> [EMAIL PROTEC
Check out urSQL at http://www.urbanresearch.com/ursql
On Thu, 5 Apr 2001, Kevin Xin Lin wrote:
> Can any one share with me a good free admin/client GUI for win32?
>
> Thanks.
-
Before posting, please check:
http://www.mysq
Hello Kevin,
Friday, April 06, 2001, 1:07:48 AM, you wrote:
KXL> Can any one share with me a good free admin/client GUI for win32?
It looks like there is no such thing at all. Artronic is extremely
slow and buggy. TcX's GUI client is noting more than a graphical
version of console cli
On Fri, 6 Apr 2001, Vigile wrote:
> I have a table, that DOES NOT have a primary key, but is setup like this:
>
> Field Type Attributes Null Default Extra Action
> PageID int(11)No 0Change Drop Primary Index Unique
> ArticleID int(11)No 0Change Drop Primar
> So, when I am calling info from this database, I get doubles of
> each result. How can I delete just one of each entry, so I am
> left with just:
Use:
DELETE FROM WHERE LIMIT 1
Jens
-
Before posting, please check:
htt
On Fri, 6 Apr 2001, K. C. Huang wrote:
> The question is regarding the previleges config on a virtual server enviroment.
>
> I managed to set the previleges for the user so that he can not access databases
>other than his own, but one problem still bothers me.
>
> The user is able to list (sho
On Thu, 5 Apr 2001, Kris Gonzalez wrote:
> when adding a new user or changing the authentication information for
> existing users, the changes often do not take effect unless i take down
> and restart 'mysqld'. example: changing root's password and exiting
> the mysql client, i cannot log back
[EMAIL PROTECTED]
-
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 unsubscribe,
On Thu, 5 Apr 2001, Dennis Gearon wrote:
> Are people using Mysql using foreign keys and how are they using them?
> It seems that the way to use them is with the scripting language used to
> access the database.
>
Sure we are...the manual way i.e. one insert/delete at a time for each foreign ke
I am a new member of the list and expect this has been discussed, my apologies.
Having recently upgraded our NT mysql, I'm suddenly having a problem with
last_insert_id:
rstemp.open "select last_insert_id() as recordid",connection
used to work by now gives an error, is this a known bug?
I have a table, that DOES NOT have a primary key, but is setup like this:
Field Type Attributes Null Default Extra Action
PageID int(11)No 0Change Drop Primary Index Unique
ArticleID int(11)No 0Change Drop Primary Index Unique
PageTitle textNo
The question is regarding the previleges config on a virtual server enviroment.
I managed to set the previleges for the user so that he can not access databases other
than his own, but one problem still bothers me.
The user is able to list (show databases) all the databases on the server ev
you can also use expect...such as:
#!//expect
spawn mysql -u root -p
expect "password:"
send "password\r"
expect "mysql>"
send "use db1"
expect "mysql>"
send "alter table ...\r"
expect "mysql>"
send "exit\r"
expect eof
also, since expect uses the tcl language, you could create a tcl list wit
On Thu, 5 Apr 2001, Roel Vanhout wrote:
> Hi all,
>
> Is there a way to turn the query logging on and off while the database
> server is running? Right now I have a script that stops and restarts the
> database with loggin on or off depending on the parameters, but this is
> not so great; I was
On Thursday 05 April 2001 20:38, Steve Werby wrote:
> "Sasha Pachev" <[EMAIL PROTECTED]> wrote:
> > First, we can somewhat expand the list - add the words "database", "sql",
> and
> > "query" to the sentry list.
> >
> > Second, if you forget one of those words, you will get a reply from the
> bot
On Thursday 05 April 2001 20:15, Jonothan Farr wrote:
> > First, we can somewhat expand the list - add the words "database", "sql",
and
> > "query" to the sentry list.
>
> Congratulations "[EMAIL PROTECTED]"!!! You have been selected to
receive a
> free spam-o-matic.
If we have a problem with
On Thu, 5 Apr 2001, Gerald Clark wrote:
> Another thought.
> These are isam tables, not myisam tables.
> Unless the two machines are the same hardware type and operating system,
> you
> can't just copy the files over. Use msqldump.
>
Actually I was under the impression that the way the files w
when adding a new user or changing the authentication information for
existing users, the changes often do not take effect unless i take down
and restart 'mysqld'. example: changing root's password and exiting
the mysql client, i cannot log back in to the mysql client using the new
password...i
I think what is needed here is a small perl program that
does a "show databases"
and then
pseudo code Q&D:
#!/bin/perl -w
use MySql;
$command = $ARGV[0];
$dbh=MySql->connect('mysql','localhost');
$sth=$dbh->query('show databases');
while ($db=$sth->fetchrow) {
`$command`;
}
Martin Hubert
Fr
On Thu, 5 Apr 2001, Santiago LLobet wrote:
> Hi,...
>
> We've got a MySQL server running with a lot of different databases that have the
>same table-structure.
>
> Does anybody knows how to make an SCRIPT that performs an administrative task
>(like ALTER TABLE 'table_name') in all the d
Mark Lo wrote:
> I would like to know how to store chinese in MySQL Databases. What
> type of column should I use ??
http://www.unicode.org/
Read up on UTF-8
--
Michael T. Babcock (PGP: 0xBE6C1895)
http://www.fibrespeed.net/~mbabcock/
-
On Thu, 5 Apr 2001, MCA Department PESIT wrote:
> hi there,
> my data directory is /var/lib/mysql . i have created a .my.cnf file
> here. i have restarted mysql and now i am not sure whether the entries are
> being read from the cnf file. can you tell me how to confirm this ?? thanks
> in
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
> "Thalis A. Kalfigopoulos" wrote:
>
> > > +--++--+-+
> > > | task | comment |remarks | history |
> > > +--++--+-+
> > > | task_1 | cmt_1
Hello All,
I'm trying to install MySQL RPM with php.
Should I use:
--with-mysql or
--with-mysql=/usr/bin or
--with-mysql=/path/to/mysql ?
Thanks for any suggestion/comment in advance!
--
Best regards,
Kenneth mailto:[EMAIL PROTECTED]
-
On Thu, 5 Apr 2001, Pete Koning wrote:
> Greetings!
>
> Quick background: i have extensive RDBMS experience (sybase, progress)
> but have been "out of the loop" in this field for a few years working
> as a sys-admin for a linux/unix-based ISP in Canada.
>
> We want to host a web-based resource
>
> > - Require the person to be either subscribed to the list or that the
> > email should contain the word 'MySQL'.
>
> I don't think this will be effective. I just checked the last 10 messages I
> posted to the list. 6 had 'mysql' in the body and 4 didn't...and I was
> surprised that man
Hello All,
I have been trying to figure out why the below query doesn't quiet produce the
results we are looking for. I was hoping some one maybe able to shed some lite
on why QUERY #3 returns the wrong results. If addition information is needed,
please feel free to respond privately, off the li
"Michael Widenius" <[EMAIL PROTECTED]> wrote:
> This thing has been up a couple of times over the years. The problem
> is that requiring people to be subscribers to the mailing list before
> posting will only confuse the poor people that don't expect to get 100
> emails per day after subscribing.
I installed it and got it up and running very quickly and easily. It is
really a great product. Access2sql utility works great, as does the ODBC
linking and the table create/modify utility. If you find out anything
about how to get BLOBS to work with it, let me know.
-
"Thalis A. Kalfigopoulos" wrote:
> > +--++--+-+
> > | task | comment |remarks | history |
> > +--++--+-+
> > | task_1 | cmt_1| rmk_1| |
> > | task_1 | cmt_2
"Llorenc Sole" <[EMAIL PROTECTED]> wrote:
> I'm trying to figure out how to select records from an events
> database which (from today) will take place on next weekend. The
> table has a from_date and a to_date fields, among other. I've found a
> way mixing PHP with SQL, but I'm curious to know if
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
>
> Db -> table1, table2 and table3
>
> SELECT table1.task, table2.comment, table2.remarks, table3.history
> FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
> LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
>
> Resul
To whom it may concern,
How can I set a datasource name (DSN) for a database in MySQL?
Thank you,
Ha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
On Wednesday 04 April 2001 04:03, Max Hammond wrote:
> I'll just add that if anyone wants a dump of the data causing this, drop
> me a note at [EMAIL PROTECTED] and I'll mail it to you, it's about 2500
> rows, and only that one field necessary to crash it.
>
> Cheers,
>
> Max
Fix:
--- 1.11/sql
Hi!
> "Eric" == Eric Fitzgerald <[EMAIL PROTECTED]> writes:
Eric> This is an open plea to the MySQL team. The amount of spam and other noise
Eric> on the list has been growing more and more every day. I would like to make
Eric> a couple basic plea's. The first, is that you require a post
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello ,
Peter> Few time ago I've started to get the following problems, which several
Peter> times allready lead to data lost for me.
Peter> Here is the example:
Peter> I found the followings in my application error log:
Hi All,
Sorry if I'm missing something totally daft here...
I've got my master and slave hosts (both runng MySQL 3.23.36) configured
roughly as-per the HOWTO, ( as follows ) to replicate the "test"
database, but not the "mysql" database [btw. it's not clear from the
docs that if you omit both bi
Hi,
I'm trying to figure out how to select records from an events
database which (from today) will take place on next weekend. The
table has a from_date and a to_date fields, among other. I've found a
way mixing PHP with SQL, but I'm curious to know if is there a neat
and pure SQL version usi
Hi, it works very well via MyODBC with either SQLCONNECT(), SQLEXEC() into local
cursors or Remote Views stored in a local VP database.
>From: "Christopher Davis" <[EMAIL PROTECTED]>
>To: "mysqllist" <[EMAIL PROTECTED]>
>Subject: Visual Foxpro 6
>Date: Thu, 5 Apr 2001 10:01:57 +0100
>I wish to
One thing you should do to protect your MySQL 'instance' , is have it running
on a system 'behind' your 'front line' defenses (i.e. Firewall) and not 'on
it'.
Setup MySQL to listen only on the interface that your webserver or other
'client' is communicating on (we have a 'private' network conne
Maybe they just seeing if MySQL is 'as open' as Interbase...
http://www.securityfocus.com/frames/?content=/templates/advisory.html%3Fid%3D3152
There are a lot of 'robotic probes' going on out there (most commonly looking
for FTP access).
Just 'batten down the hatches' and keep monitoring...
It's late.. I want to catch some sleep.. but I found a few on the incidents
list..
http://www.securityfocus.com/bid/926
http://www.securityfocus.com/bid/975
According to some people on the incidents lists there seems to be one or
two probes going on for MySQL servers.. dunno what they're look
Gary Huntress wrote:
>
> My firewall has denied and logged several of the following messages:
>
> Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306
> L=40 S=0x00 I=26581 F=0x T=39 (#2)
>
> As you can see, it is a spoofed IP trying to connect to the mysql port.
> I've
Are people using Mysql using foreign keys and how are they using them?
It seems that the way to use them is with the scripting language used to
access the database.
-
Before posting, please check:
http://www.mysql.com/manual.p
My firewall has denied and logged several of the following messages:
Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306
L=40 S=0x00 I=26581 F=0x T=39 (#2)
As you can see, it is a spoofed IP trying to connect to the mysql port.
I've looked around at basic security sites
Can any one share with me a good free admin/client GUI for win32?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
Gerald,
I grabbed the correct rpm for zlib under RedHat/RPMS - but I still get the
error message:
>rpm -ivh zlib-1.1.3-6.rpm
Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
I'm logged in as root. Any ideas?
Thanks,
Chris B
-Original Message-
From: [EMAIL PR
It was mentioned to me today that there are various RAID policies necessary
for optimal performance for diffferent programs such as SQL, Oracle, etc.
Are there any special or recommended policies (like stripe size, etc) for
MySQL running under Solaris 8/i86 with a PERC2/DC configured for RAID 5 on
Hi,
If you use DBTools (http://dbtools.vila.bol.com.br), using the import text
wizard you have a lot of parameters to set, including date format and
separators. Unfortunatelly, runs only on windows platforms.
[]'s
Crercio
-Original Message-
From: Kevin Xin Lin [mailto:[EMAIL PROTECTED]
> "GC" == Gerald Clark <[EMAIL PROTECTED]> writes:
GC> Perl/DBI, or any mysql client on Linux should connect to mysql on NT
GC> with no problem. Why would you need ODBC?
Except that perl/DBI requires an underlying C library for the DBMS in
question. I understand that the sybase libs might
Hi there,
I have many files need import into mysql database. Unfortunately, the
date format in my csv file is mm/dd/, so is there a wordaround that
I don't need write another script to convert all my files?
Thanks.
Kevin
Thanks for all the advice about using Visual Foxpro 6 with MySQL. I have started to
create my application and have come across a strange problem.
In MySQL i have a field in a table called Address1, it is VARCHAR(40) ... when i
create my view i can run the sql and see the results no problem.
Howdy, all.
I note that subqueries are in the "to be done real soon" list.
Is anyone working on this for 4.0 or 4.1? I note that it did not seem to
be in the 4.0 todo, but sometimes things make someone's hot project list
without being reflected in the todo.
Scott
Scott Ellsworth
[EMAIL PROTE
We are looking for an offsite Web Developer to work on an upcoming
project that will include MySQL programming.
Please respond to [EMAIL PROTECTED] and we will give you the project
details.
Thank you,
Maroa Gikuuri
-
Before
Hi,
Does anyone have any experience with MyAccess
(http://www.accessmysql.com) by Hubertus Hiden? (This is an Access
Addin which queries MySQL via ODBC for importing and exporting data
and tables.)
We have a client who uses Access and I'm determining if we
should develop in
William Goedicke wrote:
>
> Finally we get to my question. Can anyone give me pointers on how to
> setup the linux box so that I can run crash-me against the remote NT
> box's SQL Servers. Crash-me is running fine on the linux test server
> and I've been experimenting with unixODBC and other ut
I think William mentioned MS-SQL - as opposed to mysql - on the NT
box...
P
On Thu, 5 Apr 2001, Gerald Clark wrote:
> Perl/DBI, or any mysql client on Linux should connect to mysql on NT
> with no problem. Why would you need ODBC?
>
>
>
> William Goedicke wrote:
> >
> > Dear Y'all -
> >
Perl/DBI, or any mysql client on Linux should connect to mysql on NT
with no problem. Why would you need ODBC?
William Goedicke wrote:
>
> Dear Y'all -
>
> I've developed a diff-based testing framework in perl. It's used to
> qualify modifications we want to make to systems (i.e. applying
>
Hi, guys,
This is Jing. I need a favor. I am trying to run two mysql servers
on one machine. But I do not know how to do it correctly.
I created a database using mysql, the database is a part of our
product. And meantime, we have another mysql with the third party
s
Dear Y'all -
I've developed a diff-based testing framework in perl. It's used to
qualify modifications we want to make to systems (i.e. applying
patches, installing applications...) for deployment to a thousand some
odd machines. The testing framework runs on linux and tests target
machines th
It's not possible to do in one step in MySQL.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
"roger westin" <[EMAIL PROTECTED]> wrote:
So a question
I have two tables. And i want to... (i just show you)
Table 1.
OwnerChar(30)Uniqe
FileChar
>one.in case if he selects multiple fields, how could i
>provide my user with all set of records which contains
>what all data he placed in query form.
I think you want to study a bit more on MySQL and PHP. If you take the time
to go to sites like www.devshed.com you might get an idea of how My
"Graham Nichols" <[EMAIL PROTECTED]> wrote:
> I've developed my mysql databases/tables on a local intranet server.
> What's involved in correctly copying them to an online linux machine
Stop the mysql server on the intranet and FTP the files in the MySQL data
directory to the MySQL data directory
Hi!
I tried a test similar to Peter. There is a table with 3 integer
columns. There is a primary key on the first column and a non-unique
key on the second column. I wrote a Perl program which inserts rows
one at a time, and also selects rows one at a time.
I ran the tests on a Linux 2-CPU Xeon
On Thu, Apr 05, 2001 at 06:42:25PM +0200, Leif Sundin wrote:
> I have problems with mySQL-maker, I can't connect to my mySQL
> database. I have a account at http://www.cihost.com At home we have a
> local network, and my friend have a mySQL database on his computer..
> and that database I can conn
thanks,
I'm going to give that a try
kevin
--
>From: Gerald Clark <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: [mysql] cant start mysqld process
>Date: Thu, Apr 5, 2001, 1:21 PM
>
> Another thought.
> These are isam tables, not myisam tables.
> Unless the two machines are
Hi all,
Is there a way to turn the query logging on and off while the database
server is running? Right now I have a script that stops and restarts the
database with loggin on or off depending on the parameters, but this is
not so great; I was wondering if there is another way. Also, is there a
w
$ mysqladmin -u -p create
and then
$ mysqldump -h -u -p | mysql
-h -u -p
or
$ mysqldump -h -u -p > dbdump.sql
$ mysql -u -p < dbdump.sql
cheers,
roel
On Thu, Apr 05, 2001 at 05:06:24PM +0100, Graham Nichols wrote:
> I've developed my mysql databases/tables on a local intranet ser
Hi,
I have problems with mySQL-maker, I can't connect to my mySQL database. I have a
account at http://www.cihost.com
At home we have a local network, and my friend have a mySQL database on his computer..
and that database I can connect to very easy.
So why can't I connect to my mySQL database
Hi.
I guess we all are waiting for subselects in Mysql...but can you do many
sql-commands in a single execution, with a nice finally-result-select at
the end? Many roundtrips feels bad...
kind regards
Tomas
Another thought.
These are isam tables, not myisam tables.
Unless the two machines are the same hardware type and operating system,
you
can't just copy the files over. Use msqldump.
"Kevin J. MacDonald" wrote:
>
> In my mysql/data/mysq directory all the permissions are set to 660.
> Any ideas
How do I add a user?
P.S. ALL YOUR MySQL DATABASE ARE BELONG TO US!!
---
Clinton Ecker
http://www.phaedo.cx
http://www.picabomb.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
Hi there,
So a question
I have two tables. And i want to... (i just show you)
Table 1.
OwnerChar(30)Uniqe
FileChar(80)
OIDint(not in use yet)
Table 2.
IDintuniqe and so on
OwnerChar
NameChar
adress
etc
Hi,
I've developed my mysql databases/tables on a local intranet server. What's involved
in correctly copying them to an online linux machine please?
regards,
Graham Nichols
In my mysql/data/mysq directory all the permissions are set to 660.
Any ideas on what host.ISM file that it is looking for. I never seen it
before and when I check the old server I can't find it.
thanks
kevin
--
>From: "Brian Warn" <[EMAIL PROTECTED]>
>To: "Kevin J. MacDonald" <[EMAIL
>Description:
Pretty simple, just try to do a "match(column) against ('text') in the
HAVING clause of a SELECT statement. Restarts my database server every
time.
>How-To-Repeat:
Above
>Fix:
Restructure the query. The reason I want to do this is to run the
Hello,
I just finished moving my database to another machine. It was running fine
and after I rebooted I now get an error when I try to run safe_mysqld &.
When I look in mysql/data/comproom.err file, I get a message about '... cant
find file: './mysql/host.ISM' (errno: 13)
thanks for any help
Andre,
innobase_log_arch_dir should be the same as innobase_log_group_home_dir.
Now there is an extra 'mysql' in the path. You probably do not
have that directory existing, and Innobase asserts a failure.
I am sorry, I will change the assert to an error message in the next release,
but have bee
Hi,
I'd like to run a mysqlclient on a homemade communication hardware
running pSOS operating system.
Has somebody already ported the mysqlclient to pSOS ?
If not, what should I begin with, and how difficult would it be ?
Thanks
Christophe
Hi,
I use the following my.cnf:
[mysqld]
innobase_data_home_dir = /opt/mysql/var/
innobase_data_file_path = ib_data1:10M
innobase_log_group_home_dir = /opt/mysql/var/
innobase_log_arch_dir = /opt/mysql/mysql/var/
set-variable = innobase_mirrored_log_groups=1
set-variable = innobase_log_files_in_
Hi,...
We've got a MySQL server running with a lot of different databases that have the
same table-structure.
Does anybody knows how to make an SCRIPT that performs an administrative task (like
ALTER TABLE 'table_name') in all the databases?
Do I have to use a script like this ?
US
Are the Mysql supplied statically linked binaries built using these optimised glibc
2.2 libraries, or are they just the stock standard 2.1.3 libraries?
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Sinisa Milivojevic <[EMAIL PROTECTED]> 2001/04/05 05:06:45 >>>
Peter Zaitsev writes:
> Hello mysql
Peter Zaitsev writes:
> Hello mysql,
>
> I've resenty tried to becnhmark mysql in really simple case.
> I need to select indexes really fast so I did "select * from pages
> where hash=11" there was a key on hash and the query returned only
> one row. The query was constant and serv
Hello mysql,
I've resenty tried to becnhmark mysql in really simple case.
I need to select indexes really fast so I did "select * from pages
where hash=11" there was a key on hash and the query returned only
one row. The query was constant and server ad no other load.
I've run this on
I get the error "ld.so.1: ./mysql: fatal: libncurses.so.5: open failed: No such file
or directory" when trying to run MySQL for the first time after installation and on
all attempts since.
I've install this under SunOS 5.8.
There may or may not be related configuration error messages. In eith
Greetings!
Quick background: i have extensive RDBMS experience (sybase, progress)
but have been "out of the loop" in this field for a few years working
as a sys-admin for a linux/unix-based ISP in Canada.
We want to host a web-based resource center powered on the backend by an
RDBMS. Documents
"Ghetalion" <[EMAIL PROTECTED]> wrote:
> I figure since there are various ways to sort information in SQL, there
must
> be some way to sort the most frequent bit of information. Example:
>
> SELECT term FROM table ORDER BY mostfrequent(term)
>
> ID TERM
> 1 a
> 2 a
> 3 f
> 4 z
> 5 a
> 6 i
> 7 i
>
You could use Count(term) and GROUP BY term
like
SELECT COUNT(term) AS rank, term FROM table GROUP BY term ORDER BY rank
or something like that, and that should return something like
4, a
3, z
2, i
etc
I'm new to MySQL, but that would work in SQL Server and Oracle, depends of mysql
supports
hai friends,
i am going to provide a query service.
for that i am using a Mysql database server for
mainting the databse.i will provide my user with a
query form that contains several fields.the user is
free at his selection of the fields of course atleast
one.in case if he selects multiple
On Thu, 5 Apr 2001, Gerald Clark wrote:
I forgot to mention that the permisions are already set to mysql:mysql
660
> MySQL Server wrote:
> >
> > Hy!
> >
> > I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36.
> > It works fine with some databases I created with 36.
> > But I co
Could someone explain to me *exactly* what I need to do to access a
mysql server on my linux box from a python program on my windoz box?
The python program works fine on the linux box and I think I should
be able to run it on the windoz box simply by changing the connection
parameters but I can't
We cache all of our output for 1 second. We have larger values for cache
timeouts for pages that change less often (hourly / daily), but the 1 second
cache allows the proxy web accelerator to serve content without
re-requesting the same thing as two milliseconds ago (reducing concurrent
MySQL acc
[EMAIL PROTECTED] writes:
> Hi,
>
> after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you
> for your hints), I can't start start the DB with the start.server script.
>
> I created a /etc/my.cnf file with the following values:
>
> [mysqld]
> innobase_data_home
Hi,
we use mysql with replication, all works fine.
Now we wan't exclude some tables from the replication.
I enter in my.cnf the line
binlog-ignore-db = news
(stop the master and restart the master after the change in my.cnf)
After this, the master don't repliacted any databases,
only the tab
Hi,
after succesfully compiling mysql-3.23.36 on my HP-UX11 box (Heikki, thank you
for your hints), I can't start start the DB with the start.server script.
I created a /etc/my.cnf file with the following values:
[mysqld]
innobase_data_home_dir = /opt/mysql/var/
innobase_log_group_home_dir =
Hello ,
Few time ago I've started to get the following problems, which several
times allready lead to data lost for me.
Here is the example:
I found the followings in my application error log:
Query - #1017 [opal.local] - Can't find file: 'g04stat_languages.MYD' (errno: 2)
select visitors,loa
MySQL Server wrote:
>
> Hy!
>
> I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36.
> It works fine with some databases I created with 36.
> But I copied some databases from 29 and I get this
>
> mysql> use lumina;
> Didn't find any fields in table 'absences'
> Didn't find any
After restarting a slave, I got the following error:
010405 11:07:28 Slave: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'xxx-bin.001' at position 289
010405 11:07:28 Error reading packet from server: log event entry exceeded
max_allowed_packet - increase max_allo
Hi!
I have just read your suggestion for building mysql++. Since I cannot build
it successfully I have some more questions for you.
I have installed fallowing software on Sun ULTRA 1 under Solaris 2.6:
- gcc 2.95.3
- mysql 3.23.5
- fltk-1.0.10
My intention is to install m
1 - 100 of 128 matches
Mail list logo
