In the last episode (Jan 29), Igor Kutsyy said:
> Could you help me with this. I`m trying to increment values of
> primary auto_increment field from table, and ofcourse it is not
> working. Could you tell me how to construct a query correctly.
> +---+--+--+-+-+--
dell 4100 256mb, 11gb hd, Redhat 8.0 grub-linux
linux novice cannot resolve apache-php-mysql linkage.
local closed system (No modem, no www access, no internet)
I have tried to create a database of 7 tables with about 840mb
of data since the 20th of November 2002. My own db handler (.cpp's)
will
In the last episode (Jan 28), Salada, Duncan said:
> I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686.
> I'm trying to create a fulltext index on an existing myisam table and
> running up against an error. From what I can tell, I'm using the
> alter table command correctly, but I
Hi all,
I am trying to get my mysql database to be searchable
by
date, by both current and past events.
My perl program doesn't compile--- here's an excerpt--
package Date::Range;
my $range = Date::Range -> new ($date1, $date2);
error message:
--
can't locate object method "new"
We're having difficulties compiling MySQL on a RedHat 6.2 machine and then
installing on a RedHat 7.2 machine. This has worked in the past. The
reason for doing this is to avoid the gcc 2.96 compilation problems
indicated on the mysql.com download page.
The symptoms are that the 'make instal
Hi!
> > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
> > > i686. I'm
> > > trying to create a fulltext index on an existing myisam table
> > > and running up
> > > against an error. From what I can tell, I'm using the alter
> > > table command
> > > correctly, but I keep get
>Description:
While building 4.0.9:
gcc -O3 -DDBUG_OFF -rdynamic -o test-ssl test-ssl.o -lstdc++
../dbug/libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib
-lssl -lcrypto -lz -lcrypt -lnsl -lm -lpthread
libvio.a(viosocket.o)(.text+0x2b6): In func
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark --
...and then Mark Stringham said...
%
% Well it looks like I have limited options.
Yep. Hey, you could always host with me ;-)
%
% I'm guessing that the web host will let me have limited rights to the
% server as it is - probably only b
Well it looks like I have limited options.
I'm guessing that the web host will let me have limited rights to the
server as it is - probably only basic FTP and other limited DB rights -
I do hve some control using phpmyadmin to manipulate data.
I'll almost bet that they won't let me run a task
Well it looks like I have limited options.
I'm guessing that the web host will let me have limited rights to the
server as it is - probably only basic FTP and other limited DB rights -
I do hve some control using phpmyadmin to manipulate data.
I'll almost bet that they won't let me run a task
It´s happen exactly the same with me. Do you have some suggestion to
solve this?
I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
I can make connections from the server... including the use of other
hostnames for test purposes. All my PHP/MySQL sites are up and running.
I can access the databas
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have MySql on Windows.
> Today i had an electrical power interruption in the middle of working.
> The database remain not consistent and i could not continue working with it.
>
> Is there any Recovery after crash mechanis
ok will try that too...
- Original Message -
From: "Sherzod Ruzmetov" <[EMAIL PROTECTED]>
To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 7:07 AM
Subject: RE: mysql php and blank variables...
> :when i type
> :mysql_query("insert into tabl
Hello Inbal,
Wednesday, January 29, 2003, 4:13:24 PM, you wrote:
IO> Hi All,
IO> I have MySql on Windows.
IO> Today i had an electrical power interruption in the middle of working.
IO> The database remain not consistent and i could not continue working with it.
IO> Is there any Recovery after cr
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 11:29 AM
To: Joe Stump
Subject: Re: InnoDB / MyISAM
Your message c
You need to run [analyze table] to create the index stats...do this
reasonable often (once a day for a well-used table).
Running [optimize table] on the table recreates index stats AND
reorganizes/defrags/coalesces data pages...do this once a week or so.
Look up the mysqlcheck utility--it lets yo
> Try this, this is what I used (I didn't need things like innodb, but
> needed static linkings):
>
> king as jdisher# more foo
> CFLAGS="-O3 -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT
> -D_THREAD_SAFE -DHAVE_BROKEN_REALPATH -I/usr/local/include/pthread/li
> nuxthreads" CXXFLAGS="-O3 -pipe
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
mysql 3.23.49-8.2 debian
--
mysql, sql, query, sql, sql, sql
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.5 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
It is now available in source and binary form from the Connector/J
download pages at http://www.mysql.com/downloads/api-jdbc-dev.html and
mir
>Description:
After fixing a table with myisamcheck on Linux, the auto_increment on
Solaris was completely off (very large 9-digit integer instead of
around 50,000). My suspicion is that this has to do with an endianness
issue.
(I had to use Linux since the Solaris version of myisamcheck just han
Hi Mark,
Thanks.
The memory that we are using is ECC.
The reason I have only 16 connections is because that DB is used only
for updates.
In reality for that DB we use 3 or 4 connections maximum.
We have a mirror copy used for customers which has a lot of
connections.
Mariella
At 10:22 AM 1/29/0
Hi,
We just cvsup'd a FreeBSD machine from 4.6.2 to 4.7, made world,
and installed a new kernel. Now mysql is complaining :
Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre
ad/uthread_create.c (errno = ?)
030129 10:36:35 mysqld restarted
Fatal error 'Can
* heiko mundle
> we use this table mobile_pos
>
> +-+-+-+
> | team_id | time| geometry|
> +-+-+-+
> | 3 | 2003-01-28 16:17:06 | 727105 5282634 651 |
> | 5 | 2003-
* Wong Zach-CHZ013
[...]
> In table a, the columns are
> my_date - longtext
> num - int(11)
[...]
> Q:
> How do I convert 08/06/2002 to 2002-08-06 format
LONGTEXT is not a good column type for dates, you should use the special
'date' type, see http://www.mysql.com/doc/en/Column_types.html >.
To c
is there a way to use the date part of a datetime field that still uses the
index on the datetime field? i've tried a few different things and it keeps
saying in the explain it says that its a possible_key, but NULL for the key
--
mysql, sql, query, sql, sql, sql
--
hi all,
which is the command to rebuilt innodb tables
indexes?
(if exists).
many thanks.
(mysql,sql)
__
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
http://it.yahoo.com/mail_it/foot/?http://it.m
Dear my friends,
My boss wants a database application running on linux
machine without XWindows.
Is it easy to make the connection to MySQL with GNU
C++ .
Is perl better then GNU C++ in this case?
How is Jave ?
TAC.
__
Do you Yahoo!?
Yahoo! Mai
Hi!
I've got one question which belongs to the new query cache in 4.01.
I wonder why the cache should be deleted if there's a statement like update,
insert etc.
I think it must be considered that there are possible situations where this
isn't the best way.
For example:
1) select * from DATABA
Could you help me with this. I`m trying to increment values of primary auto_increment
field from table, and ofcourse it is not working. Could you tell me how to construct a
query correctly.
+---+--+--+-+-++
| Field | Type | Null | Key |
this command should get your data moved to a new sql table
insert into table2
select
(concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2)))
from table1;
- hcir
On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote:
Hi
I have a few tables in a database Z, namely
table
dell 4100 256mb, 11gb hd, Redhat grub-linux
linux novice cannot resolve apache-php-mysql linkage.
local closed system (No modem, no www access, no internet)
I have tried to create a database of 7 tables with about 840mb
of data since the 20th of November 2002. My own db handler (.cpp's)
will tak
have you looked at the mysql command
flush privileges
- hcir
On Tuesday, January 28, 2003, at 02:05 PM, Jon Miller wrote:
When granting someone permissions are these permissions dynamic or do I
have to reload mysql?
Also we have a developer who stated he cannot access the database
remotely. I
Hi!
> -Original Message-
> From: Erlend Hopsø Strømsvik [mailto:[EMAIL PROTECTED]]
>
> > -Original Message-
> > From: Salada, Duncan [mailto:[EMAIL PROTECTED]]
> >
> >
> > Hello everyone,
> >
> > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
> > i686. I'm
> > t
> > I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with
> linuxthreads
> > (2.2.3) and still encounter the 'strange threading'
> behavior described in J.
> > Zawodny's blog.
> >
> > Here's the situation...
> >
> > 1/ there are three threads which lock and then write to two
> different
> >
On Tue, 28 Jan 2003 17:12:14 -0700
Mariella Di Giacomo <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on
> Sun Solaris 2.8 and I have got the binaries form the mysql web site.
> The machine I am using has 32GB of RAM + 64GB of swap.
>
I was reading about user defined functions, and although they sound
interesting, I can't find many examples of their use. If anyone is using
them, what are you using them for? Are they a way to manipulate data
going into a record, or a way to run pre-defined queries?
-bill
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark --
...and then Mark Stringham said...
%
% Does anyone have a suggestion as to how I could run a periodic mysql dump
% for a db that is hosted remotely - IE a web host. I do know that this host
% does not support crons.
Do you want it dumped on
Jon:
Reload the permissions tables.
It looks like your permissions for Joseph are on the money ... are other
people able to access the database remotely?
Gerald Jensen
- Original Message -
From: "Jon Miller" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January
> >Description:
> With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used
> to do like this:
> mysqlhotcopy --user=root --password=foo -q --allowold
> --record_log_pos backup.log_pos db1 db2 backup $TMPDIR
> After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy
>
Hi All,
I have MySql on Windows.
Today i had an electrical power interruption in the middle of working.
The database remain not consistent and i could not continue working with it.
Is there any Recovery after crash mechanism in mySql?
Thanks, Inbal
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
INDEXING PROBLEM
I'm building an application which will have a self install script,
intended for use by many people. One particular area of the program
requires the need for an index. If I create this index when I build the
table or ap
You need to include the (correct) Root password in mysql_connect(h,u,p)
On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote:
>Warning: Access denied for user: 'root@localhost' (Using password: NO)
>in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
>
>Warning: MySQL Connection Failed: Access denie
FLUSH PRIVILEGES
On 29 Jan 2003 07:05:29 +0800, Jon Miller wrote:
>When granting someone permissions are these permissions dynamic or do I
>have to reload mysql?
>Also we have a developer who stated he cannot access the database
>remotely. I've granted him privileges as follows since he works on
I have a hit logger tool, which does approximately 200,000 INSERTs a day
into tables.
The other application uses the same tables to run somewhat complex SELECT
queries.
Since these tables will be large, SELECT queries are quite slow.
Indexing the tables produced prefect results for these SELECT q
Dirk,
you're right. LOCAL is disabled by default with all newer versions of
MySQL (server and client). One can enable LOCAL by _compiling_ MySQL
with --enable-local-infile, but this is not possible for binaries, of
course.
The manual says you can enable LOCAL with --local-infile=1, either for
the
Hi All,
I recently downloaded and installed MySQL-3.23.55 for Windows XP.
Previously I was running MySQL-3.23.53-max-nt, but now the Service entry
that appears under the Services List under Administrative Tools runs
3.23.55-nt when started, when I would prefer it to run 3.23.55-max or
3.23.55-max
:when i type
:mysql_query("insert into table_name ('$var list'...); i come
:up with a bunch
:of
:blank/empty variables...
Try to debug your query by outputting to the stdout instead of sending to
the
mysql server. You can do it by simply echo()ing your query as it is to the
bro
vim m wrote:
Hi: I am new to Mysql. I have installed mysql3.23.55
on linux RH7.1. Now mysql is running successfully on
my system.
When I try connecting thru
java(mysql-connector-java-3.0.1) I am getting an
Access Denied error. It says mysql@machinename access
denied.
Now i tried from command li
Dear Sir/Madam,
Here I've attached one Table of MySQL, named as "M_Filed". When I am
trying to select all tables from VB, it gives me following error
Run-time error '-2147467259 (80004005)':
[TCX][MyODBC]Got error 127 from table handler
Waiting for your reply.
Regards,
Shripal.
Hi,
we use this table mobile_pos
+-+-+-+
| team_id | time| geometry|
+-+-+-+
| 3 | 2003-01-28 16:17:06 | 727105 5282634 651 |
| 5 | 2003-01-28 16:19:22 | 728220
Hi,
I think you misunderstood /proc/sys/fs/file-max meaning, it IS
an averall machine limit, not per process.
From linux kernel documentation
(/usr/src/linux/Documentation/sysctl/fs.txt):
"file-max & file-nr:
The kernel allocates file handles dynamically, but as yet it
doesn't free them again.
T
Hello again!
Thanks for all who replied. Im currently setting up Mysql 4.1 to test with
my codes. Unfortunately, Binaries for 4.1 version are not yet available. I
Followed the steps in building from development source and encountered some
problems.
In the process of cloning 4.1 branch, while i
- Original Message -
From: "Mariella Di Giacomo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 29, 2003 1:12 AM
Subject: mysqld got signal 11; This could be because you hit a bug
> Hello,
>
> I am running mysql serve
have look at http://www.mysql.com/doc/en/mysql_install_db.html
[EMAIL PROTECTED] wrote:
Description:
When I tried to start MySQL server with
shell>/usr/bin/safe_mysqld &
it gave me the error:
-
Starting m
Hi Stefan,
Thanks to Dobromir, this works with mysql 3.23 too:
select user_profile.user_id
from user_profile
left join team_member
on
(team_member.user_id=user_profile.user_id and team_member.team_id=2)
where team_member.user_id is NULL;
Regards Heiko
- Original Message -
Subject: R
A understand that a problem with temporary tables is that you can't
do a self-join in MySQL 3.xx using temporary tables. I have a situation
that requires exactly this (the alternative is not algorithm-effective).
I wonder if the following is a practical solution: to create a copy of the
tempo
> -Original Message-
> From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
> Sent: 28. januar 2003 10:46
> To: [EMAIL PROTECTED]
> Subject: Re: Mysqlhotcopy and reuilding indexes
>
>
> In article <[EMAIL PROTECTED]>,
> Erlend Hopsø Strømsvik <[EMAIL PROTECTED]> writes:
>
> > Hi
> > Sorry if
> -Original Message-
> From: Salada, Duncan [mailto:[EMAIL PROTECTED]]
> Sent: 28. januar 2003 20:40
> To: '[EMAIL PROTECTED]'
> Subject: problems creating fulltext index
>
>
> Hello everyone,
>
> I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
> i686. I'm
> trying to cr
On 1/28/03 3:42 PM, "Jon Miller" <[EMAIL PROTECTED]> wrote:
> Warning: Access denied for user: 'root@localhost' (Using password: NO)
> in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
>
> Warning: MySQL Connection Failed: Access denied for user:
> 'root@localhost' (Using password: NO) in
> /v
In the last episode (Jan 28), Jonathan Disher said:
> On Tue, 28 Jan 2003, Jesse Sheidlower wrote:
> > I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and have
> > been getting stuck in the configure phase. I'd be grateful for any
> > suggestions.
> >
> > I'm running FreeBSD 4.7 on a single
On Tue, Jan 28, 2003 at 01:20:16PM -0500, Grigor, Peter wrote:
> Heya Folkth:
>
> I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads
> (2.2.3) and still encounter the 'strange threading' behavior described in J.
> Zawodny's blog.
>
> Here's the situation...
>
> 1/ there are th
On Tue, Jan 28, 2003 at 04:28:53PM -0500, Jesse Sheidlower wrote:
> >
> > Out of curiosity, which version of gcc are you using?
>
> As I posted a few lines up, it's gcc 2.95.4 ;-)
Oh, err. Hm. Right. I can read. Yeah.
> After I sent the original message, I tried to play around with the
> co
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 29 January 2003 5:11 PM
To: Inmate 67859432
Subject: Re: just a question.
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you
I am using mysql 3.23.59. By using the command mysql -h Remote
--database=db -uuser -ppassword --execute "load data local infile
.." I get error nr. 1148: "The used command is not allowed with this
MySQL Version". Before I used mysql 3.23.37 and the above command was
OK. I tested the --execute
Has anyone any experience of running MySQL on Netware 6? I am thinking
of porting our helpdesk to Netware AMP (Apache/MySQL/PHP) to better
integrate it with eDirectory.
Cheers,
Martin S.
--
Martin Skjoldebrand
http://www.skjoldebrand.org
> I've since given up, installed with the exact configure line shown
> in the MySQL docs, FreeBSD section, and it worked perfectly, so I'm
> worrying about moving my grant tables from 3.23.49 and so forth,
> instead of getting Linuxthreads to workBut I'd be happy to try
> to get this fixed, esp
i have a select that seem to be taking too long for what it is, and after
looking over the documents i can't seem to find a better way.
probably some things that would help:
-on a datetime field, is there a way to look at everything from a month that
still uses the index.
-is there a way to caus
hi all..
having a little problem with mysql_query()... for some reason when i type
mysql_query("insert into table_name ('$var list'...); i come up with a bunch
of
blank/empty variables... im using apache 1.3.4x mysql 3.2.3.x wwinME ..
any ideas how to fix the problem...?
---
Outgoing mail is ce
Hello,
I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and
'slave-stop' have at least been thought of at some stage (they're listed in the
COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just
been through the change logs for version 4, an
Hello,
I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun
Solaris 2.8 and I have got the binaries form the mysql web site.
The machine I am using has 32GB of RAM + 64GB of swap.
At the certain point I got :
>Description:
When I tried to start MySQL server with
shell>/usr/bin/safe_mysqld &
it gave me the error:
-
Starting mysqld daemon with databases from /var/lib/mysql
030128 08:56:42 mysqld ended
Thank you all for your help. I think that is all I need to do is select
it by row.
> -Original Message-
> From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 28, 2003 2:02 PM
> To: Christopher Lyon; MySQL Mailinglist
> Subject: Re: sql query using select and row f
Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied for user:
'root@localhost' (Using password: NO) in
/var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Error
MySQL said: Acces
73 matches
Mail list logo
