we use mysql 3.23.46-max-nt at customer pc. Some customers use Windows2000,
but some use Win98. Mysql Database that run at Win98 platform, sometimes
crashes, and i cannot repair it. The error often ise 144 Error that "TABLE
CRASHED AND LAST REPAIR FAILED".
Tables that crashed Win2000 can be repai
Does anybody know how to make log files for each of my
databases?
Thanx
sql, query
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr
I'm just getting started with FULLTEXT indexes for a
table and am seeing some very off-base results. While
it may be something I'm doing, I didn't see anything
in the online manual to indicate why these results
would be so bizarre.
Here is a test table I've created:
create table ft_test
(id s
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
Hi all.
I've been using MySQL-4.0.3 (on Slackware-8.0) for a week or so now, and
have noticed that the command:
mysqladmin shutdown -ppassword
doesn't shut down all mysql processes.
I use the following script to backup our database and restart mysql:
---
cd /root/sql/backups
for I in EnergyS
If it installed on Pro at home, it should do the same
on another pc running Pro.(in a perfect world maybe)
try these troubleshooting steps.
FIRST: check you Privileges. Make sure you are
authorized to install software on the system.
2ND: instead of double clicking the setup.exe, use
XP's ad
I am unable to install either version MySQL 4.03 or the release MySQL 3.23
on a XP professional operating system. No error message is produced, double
clicking the setup.exe file only produces a flashing hourglass for a second
and then nothing, no error messages. Suggestions anyone.
Stange thing
I have a bit of a problem. I need to do something kinda odd that I'm
hoping to get help with...except for any suggestions of changing my
table structure. This might seem weird but I need to try and make it
work as it is.
I have a table called pwdata that looks like the following:
id fiel
I am unable to install either version My SQL 4.03 or the release My SQL 3.23
on a XP professional operating system. No error message is produced, double
clicking the setup.exe file only produces a flashing hourglass for a second
and then nothing, no error messages. Suggestions anyone.
Stange thin
Dear sirs or ladies
After changing releases from:
php-4.0b2 to php-4.0.3pl1 and
apache_1.3.12 to apache_1.3.14
using the same mysql
# mysql -V
mysql Ver 11.18 Distrib 3.23.52, for sun-solaris2.7 (sparc)
using php include file:
=
mysql_pconnect("localhost","nobody","") or die("Could not
I'm running mysql version 3.23.51 on Mac OS 10.2 and have administrator
access. The program that I am writing attempted to log in at least three
unsuccessful times and is now locked out. I am getting a 1044 error and
everything I've read shows the problem as being with the properties set up
>> This handles part of the problem but a true load balanced master
>> solution is needed. There's no real advantage in spending 5, 10 or
>> $20,000 on a failover master if you can't load balance and the spare
>> will just sit idle.
> Sure there is. If your master blows up, you have a spare wait
hi,
We noticed that a select statement using an "order by" that should
return 0 rows fails on large table (~11 million rows), due to the
following error:
Out of sort memory.
Increase daemon sort buffer size (becomes 3, Database error.)
We searched the lists and found the following reference to
Hi all,
We have just finished developing and application in C++ that uses a
mysql 3.23.52 database on Linux. It went into productions this morning and
now we are having problems with multiple select statements. When one user
runs a very learge select query, it locks the tables involved so no
Hi!
- Original Message -
From: ""Anthony R. J. Ball"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, September 09, 2002 7:52 PM
Subject: Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
>
> > Just out of interest, do you see the equivalent of a core file when this
>
At 12:40 PM 9/9/2002, you wrote:
>Hello,
>
>Without giving me the RTFM, and in 25 words or less...
>
>Can someone tell me what an index column is and does for a query?
>
>Thanks,
>
>Will
Will,
Without an index the entire table has to be read to find the
results of the query. Even simpl
It means mysql does not own its directories and files.
chown -R mysql
/usr/local/that-long-directory-name-that-should-have-been -symlinked
Richard W. Berriman wrote:
>The contents of the error log in
>
>mysql-3.23.49a-pc-linux-gnu-i686/data is:
>
>
>020908 17:00:27 mysqld started
>
>
>02090
Hi,
I'm missing an answer to a topic which came up a couple of days /weeks ago.
For a database i'm administrating I would like to find out, which numbers
(of invoices)
are missing in our database. Is there a way to get this result set thru SQL?
Or do I have to do it with for example Java?
I think
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote:
> This handles part of the problem but a true load balanced master
> solution is needed. There's no real advantage in spending 5, 10 or
> $20,000 on a failover master if you can't load balance and the spare
> will just sit idle.
Sure
Hi folks,
just wanting some headsup on the following question.
How does the index_priv catch in at all?
Does a missing index_priv also block me to create a table with indexes in the
create-statement?
Or does it only affect the later creating of indexes?
Thanks in advance,
Thomas
sql, query
I have a table
key1,key2,key3
or thereabouts.
Now I want to update the value of key1 with that of a reference record
for all values of key3.
In very non-sql terms:
for all r,s in key2,key3
if r.key3 == s.key3 AND r.key2 =
AND s.key2 !=
then s.key1 = r.key1
(Just to make it more inte
No index:
Go to the library and find a book without using the card catalog.
Index:
Go to the library and find the book in the card catalog, it will tell
where the book is.
On Monday, September 9, 2002, at 01:40 PM, Will K. wrote:
> Hello,
>
> Without giving me the RTFM, and in 25 words or les
Will K. wrote:
> Can someone tell me what an index column is and does for a query?
Extra data to make the query faster.
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock
-
Before posting, ple
Hello,
Without giving me the RTFM, and in 25 words or less...
Can someone tell me what an index column is and does for a query?
Thanks,
Will
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle. Master servers should intelligently talk to each
other and determine duplica
walt wrote:
> Derrell Durrett wrote:
>
> > I'm running server version: 3.22.32, on SunOS 5.6 Generic_105181-17.
> > The code is perl 5.6.1, using DBI and DBD::mysql as the interface. We
> > have code that prepares a group of statement handles for use in doing
> > various queries and inserts in a
> Just out of interest, do you see the equivalent of a core file when this
> happens? Or anything in the mysql logs?
Don't see any cores... here is the error log entry
mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it wa
Dear all,
I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux
box (Mandrake 8.2) and for 2 months was working perfectly. After migrating
some data from an other installation (Windows 2000 / mysql 4.0.1 alpha log)
my FULL-TEXT indexes stop functioning. I am issuing the fo
Mysql Query
---
Just out of interest, do you see the equivalent of a core file when this
happens? Or anything in the mysql logs?
DSL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I think I have solved this - though what I had to do was weird.
In mysql-VERSION/support-files there's a program called comp_err.
You need to cd to the share/language directory and run
# comp_err errmsg.txt errmsg.sys
Then run scripts/mysql_install_db.
Why should I have to do this? Sounds lik
Duane,
yes, you can change the last data file as auto-extending.
Shut down mysqld, edit the my.cnf file, and start mysqld again.
Another solution is just to add another file ibdata2:
innodb_data_file_path = ibdata1:1000M;ibdata2:10M:autoextend
Best regards,
Heikki
Innobase Oy
Copied message
Hi,
Did the usual RPM install, got the usual message
[root@us-penguin MYSQL]# rpm -Uvh MySQL-4.0.3-0.i386.rpm
Preparing...###
[100%]
1:MySQL #
I don't even have a master.info file to remove.
The master.info file never gets written. It won't start replication at all.
It just keeps writing the same error to the log file:
"Slave thread: error connecting to master: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES) (0), retry
On Sun, 8 Sep 2002, David Lurie wrote:
> Neither of the two binary mysql-max 3.23.41 from the MySQL website will run on
> my system after installation.
>
> Both configure and mysql_install_db fail due to missing dynamic link libraries
> /usr/lib/libdl.so.1 and libnsl.so.1. The system does have lib
I just installed the 4.0.3 binary of mysql on our
solaris 2.7 development box, and whenever I do a show variables,
mysql crashes... I can view some variables, and going through
the list is seems that querying 'log_slave_updates' is the one that
is killing mysql...
mysql> show variables like '
Hello all,
I'm hoping someone can confirm this for me.
We're using InnoDB, but when I set it up originally, I just specified the
size of the data file:
innodb_data_file_path = ibdata1:1000M
Being new to it and all at the time, I wasn't aware of the autoextend
capability. But now I'm being as
Any experienced database person will probably tell you that reaching
fifth normal form usually makes your database cumbersome to work with.
Though in theory is the best setup.
It looks like you are trying to create a cascading structure, which I
think is one of the harder database designs to gr
insert ignore into select from
will skip duplicates.
Karl J. Stubsjoen wrote:
>Hello,
>
>How can I determin what erros occur from an "Insert into select from"
>statement? Namely, I'm looking for any duplicate record errors. It is
>important to inform the user (in a web browser) whether or not
Mark Sibly wrote:
>Hi,
>
>I'm new to this list, and have a few basic MySql questions:
>
>* Is it safe to convert a timestamp field to a datetime one? ie: will this
>'touch' each row and stuff up the ordering (hopefully not!).
>
What happend when you tried it on a test table?
>
>
>* I'm buildi
Why is that a problem?
Chuck \"PUP\" Payne wrote:
>Well I am glad for the help :). I am get an old table clean up but need to
>re-index my table. I think there is on small problem. It's is ISAM table and
>not myISAM.
>
>Chuck Payne
>Magi Design and Support
>
>Mysql and sql
>
>
Hello,
I need to do an update on a table :
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 and my field and the result of the
query to damage the field or does a
The source is written in C.
Check out the mysql client program.
Many of the utilities listed on the MySQL site are
also 'C' programs. You can download some of them and
take a look.
I would not recommend this as your first exposure to 'C'.
You might want to hire a programmer to assist you until
yo
I think the "point" of a question is to get the correct answer.
The correct answer was given.
David Lloyd wrote:
>Hmmm...
>
>>Specify the fields you want in your query.
>>
>>example:
>>SELECT stat_id, stat_name, stat_data FROM build_stats
>>WHERE stat_date LIKE ...
>>
>
>I think you miss the poi
See the FAQ; but basically, use symlinks.
/var/mysql/database1 -> /disk1/database1
/var/mysql/database2 -> /disk2/database2
... or just mount /var/mysql/database1 as another partition.
/etc/rc.d/init.d/mysql stop
cd /var/mysql
tar -czf database.tar.gz database1
rm -rf database1
mkdir database1
Thanks. A cron job that runs mysqladmin that flushes the tables every
15 mins or so is now in place. A flush-only user has been created to do
this.
I wonder if any negative impact for other databases could be expected at
any point.
--
Mark P. Hennessy
Looks like there is a problem with 4.0.3 or I am doing
something wrong:
First I tried to upgrade from rpm,
linux:/home/me/TMPOUT #
rpm -e MySQL-4.0.3-0.i386.rpm
error: package MySQL-4.0.3-0.i386.rpm is not installed
linux:/home/me/TMPOUT # rpm -i MySQL-4.0.3-0.i386.rpm
package MySQL-4.0
Hello Everybody,
I am tring to install MYsql 3.23 on Solaris 2.5.1
AS there is no binary available . I have downloaded
the source code and compiling . I am running gcc 2.6
I am getting the following error (as below) while
compiling.
Any help is appreciated. I checked the line 126 in
file mf_temp
Bonjour,
I configured two of my servers for replication.
On the master I added :
log-bin
master-host = xxx..
master-user = x
master-password = x
master-port = 3306
server-id = 14
master-connect-retry=10
binlog-do-db=db1
binlog-do-db=db2
binlog-do-db
use
rpm -e --nodeps ...old package
rpm -i package
- Original Message -
From: "mahdi samia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 09, 2002 3:06 PM
Subject: Installing of MySQL
> Hello all,
> I am a new MySQL programmer and I have alot of problems
> with Ins
I hope everyone grabs the headers from that message (and any other spam
they receive) and reports it to spamcop.net to help us all block these
people.
PS, this has nothing to do with MySQL, Databases or ACID compliance, but
this line should ironically get me past the spam filter :)
--
Michae
Hello all,
I am a new MySQL programmer and I have alot of problems
with Installing of new version of this package.
I installed Redhat 7.3 and mysql package from it.
when mysql running received a message base on no access to server.
I downloaded MySQL-3.23.52-1.i389.rpm and MySQL-client-3.23
Hello,
Is anyone using Borland's C compiler with Windows (XP) ? I am trying to
compile/link a very simple MySQL client written in C, using MySQL include
files and mysqlclient library, but it does not want to work. What command
line(s) should I use to have it compiled right ? By advance, thank you
Hello Richard,
I just went through something similar with upgrading from 3.23.49 to 4.03.
The reason you can't connect to MySQL is
>020908 15:53:33 mysqld ended
This should obviously not be here.
Check the error logs to see if they say anything important and/or helpful
there. Most likely found un
Hi!
I am trying to install mysql 3.23.52 from source distribution. I
have given this command
shell> ./configure --prefix=/usr/local/mysql --with-innodb
after sometimes it gives the following error
CONFIGURING FOR INNODB
NOTICE: I have to make the Innobase directory:
/opt/siemobile/shris
For the one who need help about using Flush and Mysql,
there is a tutorial in the phpbuilder.com, which is
enough good.
Nikos
---
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &t
Hi all,
I've been playing with Fulltext, and for a while there, I though it was a
good solution, but I do need something that doesn't use stopwords... For
example, if Bob Smith was the primary speaker at MOST conferences, then I'd
need a search for Bob Smith to return accurate results, not be ign
Hello
I'm having a problem compiling the version of the subject, the problem is
with the gethotsbyname function and the message is the next:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1325
58 matches
Mail list logo