Is it an option to drop the table and recreate and repopulate it?
I would give it a try and think that your problem will be gone.
You can easily do that with mysqldump. Ask again if you need more
help.
Alex Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26:
I've made some progress
Or you can add
safe_show_database
to your my.cnf, or call safe_mysqld with the added option
--safe_show_database
do you have to compile mysql with some special parameter? My version
(3.23.37, SuSE rpm) fails with a unrecognized command error when I try to
start it after having inserted
Greetings list,
I'm having a MySQL login problem that I cannot figure out, and (surprise
surprise), I'm something of a newcomer to MySQL. I have read two decent
MySQL books, searched the MySQL.com online manual, and searched the web for
everything I can think of, to no avail.
Here is my
Hi,
try command: flush privileges;
flush tables;
Michal Dvoracek [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Thu, 23 Aug 2001, Dave Walcott wrote:
Greetings list,
I'm having a MySQL login problem that I cannot figure out, and (surprise
surprise), I'm something of a newcomer to MySQL. I have read two decent
MySQL books, searched the MySQL.com online manual, and searched the web for
everything
On Thu, Aug 23, 2001 at 12:24:53AM -0700, Dave Walcott wrote:
Greetings list,
I'm having a MySQL login problem that I cannot figure out, and
(surprise surprise), I'm something of a newcomer to MySQL. I have
read two decent MySQL books, searched the MySQL.com online manual,
and searched
On Thu, Aug 23, 2001 at 09:40:36AM +0100, Dvoøáèek Michal wrote:
Hi,
try command: flush privileges;
flush tables;
The flush is automatic with GRANT for him. The issue is with
'localhost' vs. all other hosts.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo
On Thu, Aug 23, 2001 at 03:45:05PM +0800, Alan Tai wrote:
grant all
on dbname.*
to user identified by 'password';
check the manual for more detail. seems like you are missing the
'host'.
That's okay. As the manual says, that's a shorthand way of specifying
user@%. But that doesn't
What's wrong with this? I get the error: Warning: Supplied argument is not a
valid MySQL result resource in /home/sites/site49/web/vragen/vragen.php on
line 42
$query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY id
DESC;
$result = MYSQL_QUERY($query);
$number =
Hello,
Currently to connect to mySQL server I use MS Access and ODBC. I have
noticed that the update when scrolling through records is not very good.
Can anyone recommend and suggestion so FREE programs to view and edit data.
Thanks
Neil
On Thu, Aug 23, 2001 at 10:10:05AM +0200, Martin Kampherbeek wrote:
What's wrong with this? I get the error: Warning: Supplied argument
is not a valid MySQL result resource in
/home/sites/site49/web/vragen/vragen.php on line 42
Can we see lines 1-41 as well, if they're relevant. Surely you
BODY background=back_main.gif
pfont face=VerdanabAsk your question to aan Mohammed
Allach/b/font/p
form action=addvraag.php method=GET
TABLE border=0 cellpadding=0 cellspacing=1 width=580
TR
TD align=left width=100font face=Arial size=2Naam:/TDTD
align=left width=220
INPUT
Hi
Is it possible to tell MySQL not to be case-sensitive about table names?
Thanks
Deon.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
First, Try this:
NOT EQUAL is != rather than
$query =
SELECT * FROM question WHERE answer != '1' AND id250 ORDER BY id DESC;
$result =
mysql_query($query) or die('MySQL Query Failed. Error '.mysql_errno().':
'.mysql_error());
$number = mysql_num_rows($result);
-Jason Garber
Lead
Hi,
I have a problem with one machine running Debian kernels 2.4.7 (2.4.9)
on Intel EtherExperssPro100 and mysql-3.23.39. When I try to upload data
into database, I get the error in %Subj%. The command used is:
bioadmin@caribou$ cat apernix.contig.sql | mysql --host=pednew ApernixK1
ERROR 2006
Jeremy,
Do you stay up all night also, reading and responding to the MySQL mailing
list? :)
Thanks for the answer on your MySQL setup. I had mistakenly taken 15
connections to be 15 queries. However, I am impressed with the preformance
of MySQL. Do you have any data on how many
Dear Chris
I'm sorry to be really ignorant, but what is VPN? Any suggestions are
welcome!
Regards
Elizabet
-Original Message-
From: Chris Lathem [EMAIL PROTECTED]
To: Elizabeth Alderton [EMAIL PROTECTED]
Date: 22 August 2001 21:21
Subject: Re: Data Encryption
What about talking to
Dear Chuck
Your idea has given me an idea.
How about:
When we actually collect the data, we encrypt it so that it is actually held
in mysql in an encrypted form? Then it can speed up and down the phone
lines in the 'raw' so to speak, but it's still in code so no one can get it
anyway?
We
On Thu, Aug 23, 2001 at 04:32:57AM -0400, Jason G. wrote:
NOT EQUAL is != rather than
Really? I've used them both with good success. Where does one
succeed and the other fail?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408)
On Thu, Aug 23, 2001 at 08:25:56AM +0100, Elizabeth Alderton wrote:
Dear Chris
I'm sorry to be really ignorant, but what is VPN? Any suggestions
are welcome!
Virtual Private Network.
What he's getting at is that you could try and setup a secure
(encrypted) tunnel of some sort between your
Sorry, my bad, should work...
do a:
mysql_connect(,,) or
die('MySQL Query Failed. Error '.mysql_errno().': '.mysql_error());
Using a little debugging (or die()) can be very helpful in determining what
the problem is...
-Jason Garber
At 01:36 AM 8/23/2001 -0700,
This is the error I get: MySQL Query Failed. Error 1030: Got error -1 from
table handler
First, Try this:
NOT EQUAL is != rather than
$query =
SELECT * FROM question WHERE answer != '1' AND id250 ORDER BY id DESC;
$result =
mysql_query($query) or die('MySQL Query Failed. Error
Hi everyone.
I want to migrate Oracle DB into MySQL DB.
Could you please tell me the way in detail or helpful sites?
Thanks in advance!!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Another tip that I have used ALOT...
When a query fails, go to the command line and try executing it and
variations of it there to find the problem.
-Jason Garber
At 10:48 AM 8/23/2001 +0200, you wrote:
This is the error I get: MySQL Query Failed. Error 1030: Got error -1 from
table
to give a particular user access to the database,
log in as root and type
grant all on databasename.* to username identified by password
to restrict that user to connecting from a particular host
grant all on databasename.* to username@hostname identified by password
the two options above
Dear Jeremy, Gregor
Thanks and sorry for not being more specific.
First of all we use an ISP who runs a Unix server. They won't give us ssh
without a dedicate server - too expensive for us.
Then we use Windows clients (95, 98) not on a network.
We transfer the data down a phone line from the
Unfortunately in this world Marketing is all and perceptions
are reality.
MySQL is a very good product, but is somewhat unknown
compared with other databases.
Oracle gives to system managers a feel of security because
if something goes wrong, they can blame Oracle as their last
resort, but if
Hello mysql,
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
l/var\-DSHAREDIR=\/usr/local/mysql/share/mysql\
-DHAVE_CONFIG_H -I../bdb/build_unix -I../innobase/include
Hey all I've been a bit of a dweller on this list for quite some time
now.
I'd like to throw a question out for all of you.. I have at least a decent
understanding of the concepts behind a relational database, but I'd like a
little more information on the theory, etc... does anyone know of
Date |Thu, 23 Aug 2001 08:10:11 +
From |Neil Tompkins [EMAIL PROTECTED]
Hello!
NT Hello,
NT Currently to connect to mySQL server I use MS Access and ODBC. I have
NT noticed that the update when scrolling through records is not very good.
NT Can anyone recommend and suggestion so FREE
Date |Thu, 23 Aug 2001 10:25:39 +0200
From |Deon de Villiers [EMAIL PROTECTED]
Hello!
DDV Hi
DDV Is it possible to tell MySQL not to be case-sensitive about table names?
It's default behavior of MySQL on Unix-like system.
On windows you can use aliases.
Look here:
If I am not mistaken...
You could write a script that uses PHP to look at the database, create a
file, and download it to the browser over an HTTPS connection (128 bit
ssl). You would need some sound security protecting access to the download
page. You could use the same script to accept a
Date |Thu, 23 Aug 2001 01:34:52 -0700 (PDT)
From |Himadri Mandal [EMAIL PROTECTED]
Hello!
HM Dear Friend,
HM We are a group of students experimenting with MySql.
HM We have installed MySql version 3.2 under Red Hat
HM Linux 6.0
HM We can login to MySql from all the users of Linux
HM server,
John Coggeshall wrote:
Hey all I've been a bit of a dweller on this list for quite some time
now.
I'd like to throw a question out for all of you.. I have at least a decent
understanding of the concepts behind a relational database, but I'd like a
little more information on the
correct. however, as I stated you would need the key to decrypt it in the
end to be able to use the data. With a slight modification to an md5 or
sha-1 javascript it could be done. However, if the key is ever comprimised
you are in trouble.
chuck
- Original Message -
From: Elizabeth
When I try to create an index on any table with greater than about 200,000
records, it hangs using show processlist shows the process to have died. I
have even tried moving the data out of the table, creating the index on the
empty table and moving the data back in again, but the process moving
=?euc-kr?B?vcnD5rq4?= writes:
Hi everyone.
I want to migrate Oracle DB into MySQL DB.
Could you please tell me the way in detail or helpful sites?
Thanks in advance!!
You should take a look at our crash-me pages which will point you to
the differences in data types.
Regarding
For theory, I'd recommend a book called Microsoft SQL Server 7
Administrator's Guide published my Prima Tech. It's a big book. It should be
at your local bookstore and is packed with all kinds of theory about
relational databases.
The theories do apply to any SQL server.
You will definitely
Scott Chamberlain wrote:
When I try to create an index on any table with greater than about 200,000
records, it hangs using show processlist shows the process to have died. I
have even tried moving the data out of the table, creating the index on the
empty table and moving the data back in
Peter Zaitsev writes:
Hello mysql,
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
l/var\-DSHAREDIR=\/usr/local/mysql/share/mysql\
-DHAVE_CONFIG_H -I../bdb/build_unix
I downloaded the libraries but I'm experiencing problems in installing
them. I've decompressed them then I've run automake and autoconf. No
problem. At this point I tried ./configure but during the process it stops
with an error saying that cannot find mysql libraries in ' ' . What does it
Antonio Scotti writes:
I downloaded the libraries but I'm experiencing problems in installing
them. I've decompressed them then I've run automake and autoconf. No
problem. At this point I tried ./configure but during the process it stops
with an error saying that cannot find mysql
Are you using BIND? You may want to make sure you applied your new changes
to it and also make sure your
/etc/host.conf has the right order for searching in it.
Rob
- Original Message -
From: Tim Cadell [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001
Hi
Is it possible to use 2 or more fields to become the primary key. I have a
table
CREATE TABLE tmptraining (
rowid int(10) unsigned NOT NULL auto_increment,
sid char(32) NOT NULL default '',
expiry date NOT NULL default '-00-00',
arenaid tinyint(1) unsigned NOT NULL default '0',
Hello Sinisa,
Thursday, August 23, 2001, 3:42:53 PM, you wrote:
SM Peter Zaitsev writes:
Hello mysql,
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
l/var\
I am not sure about the primary key.
You can create a UNIQUE index on (field1, field2, field3, field4)...
(I have done this)
This will prevent any duplicate rows from being inserted.
Hope it Helps,
-Jason Garber
Lead Programmer - pulseaday.com
At 08:07 AM 8/23/2001 -0400, you wrote:
Hi
Is
Peter Zaitsev writes:
Hello Sinisa,
Thursday, August 23, 2001, 3:42:53 PM, you wrote:
This is strange As I've compiled plain gcc 2.2.4 into other directory
and now running --with-other-libc= and It swears about glibc 2.2.3
therefore my system glibc is 2.2.0 and I have never used 2.2.3
Tim Cowan wrote:
Hi
Is it possible to use 2 or more fields to become the primary key. I have a
table
Yes
CREATE TABLE tmptraining (
rowid int(10) unsigned NOT NULL auto_increment,
sid char(32) NOT NULL default '',
expiry date NOT NULL default '-00-00',
arenaid
How about 'Database System Concepts' by Abraham Silberschatz and others.
It takes you from relational calculus through index data structures,
transactions, concurrency control and new db applications.
You could also look at the classics by Date Introduction to database
systems 7th ed.
---
somebody know what means this error (with mysql_connect)
thank you
Nicolas.
PS : i don't have the file mysqld_errors.txt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Sir,
I was able to successfully use the JDBC driver to connect from a
Linux computer to a mysql database resident on another computer
running Linux. The Linux computers are running Java Version 1.1. I
am now trying to use the same JDBC driver to connect from a Sun
Solaris 8 to a Linux
Hi, I am running mysql-3.22.27 for many months. But
today, the mysqld always core dump. The running
platform is FreeBSD3.4.
I checked the dumped core and find that it seems that
the core dump has something with the
/usr/lib/libc_r.so file when it called the thread
subroutine.
Please help me!
Hi all,
Brand new to this list.
I have MySQL running happily on my NT laptop. I decided it was time to
migrate to Linux so I have set up an old Mac (nubus) with Linux-PPC-2000Q4
and have tried to install MySQL with varying degrees of difficulty.
After some very futile attempts at a source
when i'm connecting to the base with the prompt = no problem
in a file test toto.c :
mysql_connect(MSQL_IDENBASE,localhost,root,mysql);
== no problem
But in a big application, when i try to connect by
mysql_connect(MSQL_IDENBASE,localhost,root,mysql);
== error 2004
Somebody know something
Peter Zaitsev writes:
Hello Sinisa,
If I'm not mistaken this shows version 2.2.4
SM And your compiler was built with which glibc ??
2.2.0 from suse 7.1
--
Best regards,
Petermailto:[EMAIL PROTECTED]
You have got only one vestige left :
Check out urSQL from http://www.urbanresearch.com/ursql
On Thu, 23 Aug 2001, Neil Tompkins wrote:
Hello,
Currently to connect to mySQL server I use MS Access and ODBC. I have
noticed that the update when scrolling through records is not very good.
Can anyone recommend and suggestion
Hiya,
Yes, when you install from an rpm you just get the server, so you need to
download the client programs binary in a seperate rpm and install them too.
Also, the rpm decides where to install everything so you don't actually end
up with a base install dir for MySQL. Your data directory
Hello,
I have libz-1.1.3-284 installed on my Linux but when i try install
apache 1.3.20 with mysql 3.23 and php 4, i've the message
collect2: ld returned 1 exit status
make[2]: *** [target_static] Error 1
make[2]: Leaving directory `/home2/mvmendes/apache/apache_1.3.20/src'
make[1]: ***
Assuming you are on windoze, try www.mysqlfront.de. I use it on my NT
laptop.
GP
- Original Message -
From: j.urban [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 3:08 PM
Subject: Re: mySQL Interface Programs
Check out urSQL
Hello,
I am trying to find a distribution of the source for the
Include files and libraries for develpment for OS X.
Does anybody know where I can get this??
I'm trying to get the dbf2mysql converter to work in OS X
but somebody told me that I needed to install the
developer edition of
Thanks Paul,
Can I install the Client from the same rpm that the server came from or is
it a diff download?
George
- Original Message -
From: Paul Foxton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 3:02 PM
Subject: RE: Installing on Linuxppc???
Hiya,
I tried it in the command line. And it works. But in the programm is still
doesn't.
MySQL Query Failed. Error 1030: Got error -1 from table handler
Message-Id: [EMAIL PROTECTED]
Date: Thu, 23 Aug 2001 04:53:44 -0400
To: [EMAIL PROTECTED]
From: Jason G. [EMAIL PROTECTED]
Subject: Re:
Hi!
Maybe you already have a my.ini or my.cnf
file in winnt or winnt\system directory, or
some other directory and
that overshadows the file you have in C:\
What do
dir /s my.cnf
dir /s my.ini
say?
Your innodb start options look ok. For some
reason MySQL does not see the options
you have
- Original Message -
From: [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 4:03 PM
Subject: Re: where should the mysql folder be?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
I´m converting an old DBF aplication to MySql an I´m having a very strange problem.
When I first execute a query it takes from 12 to 30 seconds to have an answer, after
that it runs in about 2 or 3 seconds.
It´s a very large file (ZipCodes) and I must seek by ZipCode, by State/City/Street
OK folks - I found it - tucked away in the /home/ folder.
GP
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 3:59 PM
Subject: Re: where should the mysql folder be?
- Original Message -
From: [EMAIL PROTECTED]
on 8/23/01 12:35 AM, Werner Stürenburg wrote:
Is it an option to drop the table and recreate and repopulate it?
I would give it a try and think that your problem will be gone.
You can easily do that with mysqldump. Ask again if you need more
help.
Hi, Werner:
I tried this, and it didn't
main.cc: In function `void if_conn()':
main.cc:464: no matching function for call to `MysqlConnection::clinet_info
()'
main.cc:529: no matching function for call to `MysqlConnection::clinet_info
()'
make: *** [main.o] Error 1
I am using mysql++-1.7.9, and do not see any references to
Peter Zaitsev [EMAIL PROTECTED] writes:
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
It builds just fine with glibc 2.2.4 on a current development version
of Red Hat Linux (Roswell + a few minor updates).
Did you
From: Elizabeth Alderton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 23, 2001 9:26 AM
...
Dear Chuck
Your idea has given me an idea.
How about:
When we actually collect the data, we encrypt it so that it is
actually held
in mysql in an encrypted form? Then it can speed up
Hello,
I am trying to convert a hex number that is stored in a mysql db into an ip
address. Here is my problem: I can convert the original integer into a hex
number like so:
For example:
mysql select distinct HEX(ip_src) from iphdr;
---
|ip_src|
---|
|80B7EB99 |
I cant appear greek fonts in my web pages.
My configuration is:(linux, apache-tomcat, JBoss application server and
mysql)
I make some JSP pages and i have problem with the greek fonts.
I put a meta tag:META HTTP-EQUIV="Content-type" CONTENT="text/html;
charset=ISO-8859-7"
but i doesnt work.
What
Being a newbie to database design, I wonder if those more experienced could
give me an opinion on what constitutes good practice - as opposed to what
is technically possible. I know what I want to do is technically possible,
but am I lining mself up for trouble by doing it?
I know that it is a
I recently installed MySQL, Ver 11.15 Distrib 3.23.38, for Win95/Win98
(i32), on a Windows 95 system running version 4.00.950C. When I tried to
initialise the database I got the following error:
C:\mysql\binmysqld
InnoDB: The first specified data file c:\dbData\dbData1 did not exist:
InnoDB: a
I just set up a master/slave replication scheme and all is well,
but through the procedure did get bit on the tail.
After the setup, and after the master and slave mysql servers
had been started, I got some error messages that pointed to
a type in the slave's my.cnf file. I shut the slave down,
try using inet_ntoa() function.
On Thu, 23 Aug 2001 12:19:54 -0700
Jamil Farshchi [EMAIL PROTECTED] wrote:
Hello,
I am trying to convert a hex number that is stored in a mysql db into an ip
address. Here is my problem: I can convert the original integer into a hex
number like so:
A query with a ORDER BY clause over a numeric field,
will be fast if this field have a index or this doesn't influence the anwer
time of the query.
Thanks.
--
Gregorio R. Alberdi Díaz - [EMAIL PROTECTED]
AVILÉS
--- Werner Stürenburg [EMAIL PROTECTED] wrote:
Calvin Xu schrieb am Donnerstag, 23. August 2001,
03:16:09:
select
subject,subhead,subsubhead,data2,data3,see_also
from npl_detail where ( (subject like '% asia %'
OR
subhead like '% asia %' OR subsubhead like '% asia
%'
or data2
I have this table
+---+--+--+-++--
--+
| Field | Type | Null | Key | Default| Extra
|
+---+--+--+-++--
--+
| ID| int(10) unsigned | |
On 23-Aug-2001 Giannis wrote:
I cant appear greek fonts in my web pages.
My configuration is:(linux, apache-tomcat, JBoss application server and
mysql)
I make some JSP pages and i have problem with the greek fonts.
I put a meta tag:META HTTP-EQUIV=Content-type CONTENT=text/html;
On 23-Aug-2001 Tim Cowan wrote:
Hi
Is it possible to use 2 or more fields to become the primary key. I have a
table
CREATE TABLE tmptraining (
rowid int(10) unsigned NOT NULL auto_increment,
sid char(32) NOT NULL default '',
expiry date NOT NULL default '-00-00',
arenaid
On 23-Aug-2001 Filippo Galante wrote:
I´m converting an old DBF aplication to MySql an I´m having a very strange
problem.
When I first execute a query it takes from 12 to 30 seconds to have an
answer, after that it runs in about 2 or 3 seconds.
Because it's got the index ( maybe the
Chris,
mysqld.exe in version .38 was accidentally compiled with
__NT__ defined. Use mysqld-max.exe from the same
distribution or download a newer version from www.mysql.com
Note that the web page www.innodb.com/bugfixes.html
contains information about known bugs, patches to them,
and, if
mysql explain select * from dominf.domip order by ip desc;
'ORDER BY something DESC' does not use an index. It must
be ascending. See the manual.
Also, I forgot, if you do this often and it needs to be in DESC order, you
can always alter the app to create and use an extra column 'ip_desc
My thoughts exactly when i fisrt suggested a VPN. I think it would be one of
the best alternatives. You said you use an ISP. Do you mean a dialup? How
long does this data transfer normally take?
Chris Lathem
Network Administrator
SkyHawke Technologies
[EMAIL PROTECTED]
601.605.6100 Ext. 109
Fax:
I had trouble learning column permissions on Win98 because a possible bug
got in my way. I think that there is a problem with the tables_priv part of
the user verification. According to mysqld, I am using Ver
3.23.39-max-debug for Win95/Win98 on i32 of the program. I submit this bug
because I
I think you have bigger issues going on with your setup than killing a perl
script causing corruption issues. I have experienced very little (almost no)
corruption with any of my mysql tables using various versions of mysql for
extended periods of time (the times the tables were corrupted it was
Hello Trond,
Thursday, August 23, 2001, 8:01:33 PM, you wrote:
TEG Peter Zaitsev [EMAIL PROTECTED] writes:
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
TEG It builds just fine with glibc 2.2.4 on a current
Look at your /etc/my.cnf where the location of mysql socket is specified.
Also, I think RH 7.0 has a MySQL rpm installation already there. All you do
is to enable it with /usr/sbin/setup.
Hope this helps.
Shu
At 01:28 PM 6/1/2006 +0530, sachin wrote:
Hello,
I am working on RH Linux 7.0
MySql
Elizabeth Alderton schrieb am Donnerstag, 23. August 2001, 09:44:36:
Thanks for suggesting cron - can you tell me what it is?
cron is a program on Linux to run scheduled programs. So you
write a program and tell cron to execute it in any kind of
interval you can think of. I don't know if you
It's safe_show_database, not safe_show_databases
Ulv Michel [EMAIL PROTECTED] wrote:
Or you can add
safe_show_database
to your my.cnf, or call safe_mysqld with the added option
--safe_show_database
do you have to compile mysql with some special parameter? My version
(3.23.37, SuSE
Hi !!
I'm trying to compile mysql-3.23.41 on a FreebSD 3.3 box but I can't
I'm using latest gnu make version and this is the first time that I have
problems compiling mysql so if any of you can help me I'll appreciate.
Thanks in advance.
Angel.
Making all in client
gmake[2]: Entering
also try enabling the slow-log and track down any long queries.
just did that, so we'll go through that now, there are some in there...
Have you tuned any of the cache parameters for the large amount of
memory you have?
yes, we have done extensive tuning. Is there something I can provide to
Contact your ISP and ask them if they already have and/or are willing to
set-up something for you. Here's an instance. One host I have used before
is TierraNet. They use cron to run a CGI script, named crontask.cgi, at
3AM. You can put anything you want to in that script (Perl, C/C++, etc.)
Jeremy Falcon schrieb am Donnerstag, 23. August 2001, 21:46:02:
Contact your ISP and ask them if they already have and/or willing to set-up
something for you.
clip
Yes, there are always many ways to do things - but before I give
another, I'd really like to hear about the kind of task at
Hi,
I am using mod_perl and MySQL 3.23.38 on Red Hat Linux
6.2 and my following codes occasionally got an error.
$SQL = 'SELECT col1,col2 FROM table1'.
' WHERE keya=1 AND keyb=2';
$STH = $DBH-prepare($SQL) || die $SQL;
if ($STH-execute() = 1) {
$rec =
At 08:02 23/08/2001 -0400, [EMAIL PROTECTED] wrote:
Hi!
Are instructions available for building the MySQL source tree on a Win32
platform for a Win32 target?
Not yet. However here the basic steps.
Minimal Requirements:
- VC++ 6.0 compiler
- MySQL source distribution:
Hello thanks before all,
i've have a mysql 3.22.15 gamma , and 3.22.16 gamma in two Solaris on
Sparc ( SunOS 5.7, 5.8 ). This mysql are in a site in production, and
i'd like to join the data bases in another data base in another machine
( solaris on Sparc ).
I've installed in this third
Hello List!
I am having an extremely unusual problem with MySQL3.22.27 running on a
Sun UltraII Solaris 7 (latest patches applied). This implementation of
MySQL 3.22.27 has been rock solid for better than 2 years now.
We have a primary/failover system here, and the primary
I execute this SQL with mysql 3.23.39 (all platform, Windows98, Windows2000 and Redhat
Linux 7.1), but it's very very slowly.
alter table mytable order by my_column;
mytable has 3,000,000 rows, my_column is define as char(15).
But when mytable has 1,000,000 rows, it's very fast,
1 - 100 of 131 matches
Mail list logo
