Hi there!
After include /usr/local/bin on the library path as was suggested
by ED appears to work because isn't complaining about any more but
It broke again on something different.
Please any Idea?
Thanks
Jose Albert
Here the output
\...
I'm still trying to build mysql-3.23.51
Hi folks,
I just upgraded to mysql-max-3.23.52-1 because I realized that the standard
mysql does not support transactions. I still have a transaction problem with
many clients reading the same data (every read causes an update on one column
so that the read value should be unique in the whole
Prior to Redhat updates, database was working fine.
Did updates, rebooted, and now remote queries can't
connect.
This 7.3 system never had mysql logging on, and I
can't figure out how to turn it on to help with
troubleshooting. I started getting some messages
about the innodb...so I added
Hi,
I got a problem on how to create a query on my data, where I want to get the
item which is having a 'busy' and not having a 'complete' value.
Sample data
Number reason
1 busy
2 complete
1 complete
2 complete
3 busy
4 complete
5 complete
3
I have a problem which I'm not sure the best way to go about.
We will be shipping products based on weight and I have two types of
product with differing weights. Basically we want to charge one price
for shipping less than 10 KG and one for anything over that.
I wonder how to go about it. I
!-- saved from url=(2001)http://www.konon.com/ --
!°æȨËùÓÐ:¶«Ý¸¿ÆÄܵç×ӿƼ¼ÓÐÏÞ¹«Ë¾(http://www.konon.com,
1998-2001,!²ß»®ÖÆ×÷£ºÒ¦Á¦ÎÄ [EMAIL PROTECTED]
html
head
title¿ÆÄÜÖ¸ÎÆ¿¼ÇÚϵͳÌײͷ½°¸/title
meta http-equiv=Content-Type content=text/html; charset=gb2312
style type=text/css
Egor Egorov [EMAIL PROTECTED] writes:
1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)
Why do Linux distributions ship broken MySQL packages? The newly
released
Hello Folks
I am so far using japanese characters with mysql without any problem.
But today when I try to insert some japanese characters, only one character
get truncated to a . (dot) mark.
How can I set the default charset in the .cnf or .ini file ?
With MyISAM, I used to set in the mysql
Hi all,
i have an application writing bulk inserts periodically to a MyISAM
table. This table has a multi-column index on two integer fields, in
this way i can have an good query speed. Bulk insert are very speed, but
when the table grows up to 20/25 MB, almost the inserts have a very slow
I just installed RedHat 8.0 with MySQL support. Because of different reasons I
then wished to upgrade to the newest version, and unistalled the package that
came with Redhat.
I installed afterwards these packages:
MySQL 3.23.53 Server
MySQL 3.23.53 Client programs
MySQL 3.23.53 Libraries and
I've considered raw filesystem, but it seems a bit difficult, or even
impossible, to
copy db file to other servers, especially when making replication
slave servers.
Any not bad means to backup MySQL db using raw filesystem?
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub
Hello everybody,
I have a big problem with the Full Text index functionality with MySQL 3.23.
In fact, I really don't understand what is happening...
I have a table built this way :
CREATE TABLE MyTable (
Id bigint unsigned NOT NULL,
Num varchar(20) NOT NULL,
Title varchar(150) default
Tim,
Tuesday, October 15, 2002, 12:18:43 AM, you wrote:
TK For example, I have a table ALPHA and a table BRAVO.
TK ALPHA has a field called STRING1
TK I want BRAVO to have a field whose contents would be those of ALPHA.STRING1
TK How do I define this kind of field, so that the content of
kayamboo,
Tuesday, October 15, 2002, 12:31:39 PM, you wrote:
k I am so far using japanese characters with mysql without any problem.
k But today when I try to insert some japanese characters, only one character
k get truncated to a . (dot) mark.
k How can I set the default charset in the .cnf
Description:
when I'm connecting to mysql-server via tcp/ip then the mysql-server
cuts the connection and it restarts the mysql-server.
when I don't make connections from other hosts than it's running well
until i make connections via tcp/ip from other hosts.
I'm running MySQL 3.23.37 on a RedHat 6.2 with a custom 2.2.22 kernel.
Recently I stopped being able to connect from a remote client, with a
mysqld process hanging message in the log and a lost connection
message on the client, and I found in the archives that this is
probably due a recent update
mysql:ÄúºÃ!
µÃÖªÄúÕýÔÚΪÄú¹«Ë¾µÄ²úÆ·ÔÚ½øÐÐÍøÂçÉϵÄÍƹ㡣
ÎҳϿҵØÏëÏòÄãÍƼöÒ»´¦£¬ÄÜ´ó´óÌá¸ßµç×ÓÉÌÎñ³É½»ÂʵÄÕ¾µã£¬²¢ÇÒ»¹ÊÇÃâ·ÑµÄ¡£
Õâ´¦µØ·½¾ÍÊÇ¡ª¡ª´«ÆæÉÌÍøhttp://www.legendb2b.com
´«ÆæÉÌÍøÊÇÒ»¼ÒÃâ·ÑµÄ£¬¹ú¼Ê»¯µÄµç×ÓÉÌÎñÕ¾µã£¬ÊÇÈ«ÇòµÚÒ»¼ÒÌṩ¡°×éȺ·¢¡±
I know that I cannot use mysqlhotcopy or table lock if I use innodb. ;)
I asked how I can backup db file when I choose to use raw filesystem
regardless of table type. It need not be a hot backup.
I think it's a little silly to use dump method in order to make backup.
--
Chung Ha-nyung
How do I install the source of .49? When I use the rpm, the source files in
/usr/src/redhat/BUILD is removed automatically. I can't seem to find the
.tar file. Does anybody use MyLua (Stored procedures for mysql). I've been
struggeling for a couple of days to get the source of mysql installed to
Please forgive me for double posting, but I can't remeber if my mysql
list subscription is still active.
Hi Folks,
I have weird problem here. My MySql runs on a 7.2 Rh Linux
kernel-2.4.9-43 MySql is version 3.32.36
Everything was doing fine the last major maint. was when I ran up2date
on the
Hello MYSQL,
In access Now() as table field default sets the field when a new
record is created. In SQL Server there is getdate() suser_sname()
Is there an equivalent for MySQL?
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
Hi,
Iam back on this list after being diverted by job change - moving house etc.
I've just set up one of my machines with Mandrake 9.0 and went for the
included MySQL install (3.23).
When I try to do anything I get an error saying that the 'mysql.sock' could
not be found.
I remember that this
In Mysql (http://www.mysql.com/doc/en/Date_and_time_functions.html)
funnily enough:
NOW() orSYSDATE()
will return what you want.
Regards
M
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 12:56
To: MYSQL
Subject: Insert default Date
Hi folks,
I just upgraded to mysql-max-3.23.52-1 because I realized that the
standard mysql does not support transactions. I still have a transaction
problem with many clients reading the same data (every read causes an
update on one column so that the read value should be unique in the
Hi, I read the book, but there is not explain about it.
I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace the
privileges?
There are two tables ('db' and 'tables_priv') in mysql database.
I gave
Hello list,
I tried to install 2.23.53 (upgrade from .49a) but mysqld won't start (so i
had to put back to old .49a).
It does give a strange error messages:
./mysqld: unrecognized option `--innodb_data_home_dir='
./mysqld Ver 3.23.53-max for pc-linux-gnu on i686
This is strange imho, It is
Ive searched about and still haven't been able to resolve my problem.
Scenario:
1) OS is RH 7.3.
2) Installing MySQL 4.04-Pro binary tarball.
3) Ordinary user, userX.grpX, is installing tarball themselves on a
shared server accessed via telnet.
4) This installation will be userX's instance
On Tue, 15 Oct 2002, Alexander Burbello wrote:
Hi, I read the book, but there is not explain about it.
I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace the
privileges?
There are two tables
Hi,
In ./sql/handler.h in line of code no. 297 the right declaration
for optimize() function is :
virtual int optimize(THD* thd,HA_CHECK_OPT* check_opt);
This was find it in MYSQL 4.0.4 Linux Source Distribution(tarball)
Regards,
Gelu
_
Arthur,
Tuesday, October 15, 2002, 2:56:13 PM, you wrote:
A In access Now() as table field default sets the field when a new
A record is created. In SQL Server there is getdate() suser_sname()
You can't use the return value of a function as a default value.
A Is there an equivalent for
George,
Tuesday, October 15, 2002, 2:55:14 PM, you wrote:
GP Iam back on this list after being diverted by job change - moving house etc.
GP I've just set up one of my machines with Mandrake 9.0 and went for the
GP included MySQL install (3.23).
GP When I try to do anything I get an error
OK two thinks to lookat
1. Use GRANTS as you will not have so much truble with them
2. Use mysqlaccess this will tell you if you have got the privileges
right..
If a user can select in 'user' table then he can do so on all databases.
(what ever is set in 'db')
If a user can select in 'db'
Dyego,
Monday, October 14, 2002, 10:16:15 PM, you wrote:
DSdC Exists plans to release 4.0x series a stable ?
DSdC When ?
It will be first marked as gamma and only after then as stable.
DSdC And 4.1 series... exists plans to release a alpha ?
DSdC when ?
Before this year ends ..
--
For
Hi
I need to insert the same auto increment value in 2 different tables
simultaneously.
I am new to the MySQL.Is there any function which helps for this type of
manipulations?
Or I need to store the value in host variable and update the tables with
this host variable?
Greatly appreciate you
mysql,query
Hello!
Maybe I've missed something in the docs... how can I turn compression on
using JDBC with Connector/J? Or is it turned on by default? If so, how
can I check if it's on or off?
Regards,
Max
-
Before
Hi,
I've just tried to upgrade MySQL to version 3.23.53 (binary version from
www.mysql.com) and found some strange things. I previously used 3.23.47
and when I first tried to start the new version I got this error message:
Fatal error: Can't change to run as user 'mysql' ; Please check that
Description:
When I was installing binaries from \
http://hpux.cs.utah.edu/hppd/hpux/Development/Languages/mysql-3.23.52/ \
I got an error message that there is not guile-SHLIB. I enforced it \
by option in swinstall but then I received \
You can use TIMESTAMP field for this. It's automatically assigned current date if you
don't insert anything in this field type or insert null.
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 7:56 AM
To: MYSQL
Subject: Insert default Date
TIMESTAMP does what you want, but if you for any reason wish to update records
(mass updates) at the mysql prompt without updating the TIMESTAMP, you'd be out
of luck. For databases where I know that mass updates to data files will be
required, and I want to preserve the user's LAST_MODIFIED
I just upgraded from 3.32.51 to 3.23.53. With MySQL 3.23.53, mysqld
wouldn't start. In the error log, the error was that it couldn't change to
the mysql user. The mysql user did indeed exist. A downgrade back to
3.23.51 fixed this problem. Any thoughts?
By the way, I install via RPM
as far as i know, you can only have one auto_increment field. you'd have insert,
then grab the id and update that record, just like you've said. make sure that
you grab the last assigned id using a valid method. if it's a sign-up form, do
something like the following to make sure you are
Hi all,
Does anyone have any experience with running a v3 master and v4 slaves?
Will it work? - I can't see why not...
Thanks in advance,
Andrew
sql, query
-
Before posting, please check:
Hi,
I have these errors when compiling mySQL 4.0.4 on Solaris 8 using Forte C
v7. Somme can help me please ? I use these compilation options :
CC=cc CFLAGS=-Xa -fast -xO4 -native -xstrconst -mt \CXX=CC CXXFLAGS=-noex
-xO4 -mt \./configure --prefix=/usr/local/mysql --enable-assembler
Error
According to the replication compatibility table, you can.
http://www.mysql.com/doc/en/Replication_Implementation.html
-J
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:36 AM
To: [EMAIL PROTECTED]
Subject: MySQL Replication -
Ed,
Its slightly difficult doing it exactly as my email is on my W2K laptop -
but here goes:
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
If I run mysqld, I get
I tried 3.23.52 rather than 3.23.53. This solved both the remote
connection problem I had in 3.23.37, which was caused by the glibc
upgrade, and the Can't change to run as user 'mysql' problem, which
I had on 3.23.53.
Both questions are FAQs this month. The Can't change... could be a
3.23.53 bug
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: MySQL server crash on Red Hat 8.0
Description:
The safe_mysqld daemon makes segmentation
Kees,
thank you for notifying us.
I downloaded mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz from ftp.sunsite.dk.
It does not contain InnoDB. It looks like The MySQL AB build master or the
web team have made an error. The error will be corrected as soon as
possible.
Regards,
Heikki Tuuri
Heikki Tuuri wrote:
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, October 12, 2002 11:20 AM
Subject: innodb not using correct index
Is there a way to find out what index an sql query is using? I know you
can
use
- Original Message -
From: Max Morawski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 15, 2002 7:55 AM
Subject: Compressed JDBC protocol
mysql,query
Hello!
Maybe I've missed something in the docs... how can I turn compression on
using JDBC with Connector/J? Or is
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:56 PM
Subject: Re: innodb not using correct index
Heikki Tuuri wrote:
Walt,
- Original Message -
...
Heikki,
Thanks for
On Tue, Oct 15, 2002 at 05:13:24PM +0300, Antonios Christofides wrote:
I tried 3.23.52 rather than 3.23.53. This solved both the remote
connection problem I had in 3.23.37, which was caused by the glibc
upgrade, and the Can't change to run as user 'mysql' problem, which
I had on 3.23.53.
On Tue, Oct 15, 2002 at 02:35:34PM +0100, Andrew Braithwaite wrote:
Hi all,
Does anyone have any experience with running a v3 master and v4 slaves?
Will it work? - I can't see why not...
Works well, yes. We have a .51 master with 4.0.{3,4} slaves.
--
Jeremy D. Zawodny | Perl,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
due to an unfortunate error on my side the MySQL-3.23.53-Max binaries we just
released yesterday have not been compiled with InnoDB support.
If you want to run MySQL 3.23.xx with InnoDB databases, please stick with a
previous version for the
On Tuesday 15 October 2002 10:59 am, Heikki Tuuri wrote:
Walt,
- Original Message -
From: walt [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:56 PM
Subject: Re: innodb not using correct index
Heikki Tuuri wrote:
Hi evryone,
I've developed a java program that extract data from C-ISAM files and put it
in a MySQL DB.
It creates temporary files, load them into temporary tables and then update
the db from those temp tables.
This application is executed every night. Unfortunatly, once in a while
there's some
Description:
safe_mysqld eats all available cpu
How-To-Repeat:
install glibc-2.2.4-30 (and other current patches) from RH errata
Fix:
none yet (can't downgrade system libs safely)
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: none
George,
Tuesday, October 15, 2002, 5:09:47 PM, you wrote:
GP Its slightly difficult doing it exactly as my email is on my W2K laptop -
GP but here goes:
GP error: 'Can't connect to local MySQL server through socket
GP '/var/lib/mysql/mysql.sock' (2)'
GP Check that mysqld is running and that the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
thanks for reporting this.
On Tuesday 15 October 2002 15:13, Predrag Malicevic wrote:
As far as I know, the statically compiled glibc (that you guys at MySQL
are using when making binary distributions) should be compiled with
I have a table named projects. Within that table, one specific column is
called costing and is of the following schema (projects float(8,2)). Nothing
fancy. The interface that updates information to this table where the column
(projects) resides in via a php web script. Within that script it is
On Tue, 15 Oct 2002, harm wrote:
Same error here. If I install the new binaries I get the error. If I
only update mysqld to .53 I get the error as well. .52 works fine.
.53 version tries to load nss dynamic libraries from
/home/serg/binaries/Glibc/lib, if you really want to run the .53
Hi, I read the book, but there is not explain about it.
I would like to know when I give privileges to the user, in the table
level, and after I give privileges in the database level. Do I replace
the privileges?
Any time you execute a query, MySQL looks for the privileges needed for
HELP!
We are running RH 6.2 and when we applied all the current patches including upgrading
glibc, MySQL 3.23.41 stopped working. It would not start and produced the following
error 5 times per second.
Number of processes running now: 1
mysqld process hanging, pid 21458 - killed
021011
Hello All,
I'm just plugging away at a converion project where we are migrating to mySQL.
I am getting increasingly down on the poor support for importing dates into mySQL.
In the near future could we expect a function that is basicaly the opposite to
date_format where the first
Egor,
Run
ps ax | grep mysqld
to see if mysqld is already running.
This returns '11276 pts/1S 0:00 grep mysql'
I have checked and cannot find mysql.sock anywhere.
Cheers
George
-
Before posting, please
I need to get Linux on my WinCE based handhelp PC and intend to run MySQL on
it. The unit has a Hitachi SH-4 processor and I will be useing the tux web
server. I cant find any info on running MySQL with tux, or running MySQL on
a SH-4 processor. Has anyone trised this? Does anyone have any ideas?
Hello,
I have been having trouble with MySQL Updates now for sometime. It involves
making changes to a field who's type is varchar. The problem is intermitent
(I hate that), but usually manifests itself when a period . is part of the
text in the update.
So if I have a field that looks like
Group,
Here is my query:
explain select phones.*, ops.plid, ops.box, ops.mac from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and (phones.suffix1 = ops.phone)
order by
ops.mac
My describe of the phones table and the ops table:
Phones:
After reading all the postings of this issue (and a
couple of private replies) I'm wondering if the
upcoming .53a is the solution, or should I downrev
my glibc?
--- no spam [EMAIL PROTECTED] wrote:
Prior to Redhat updates, database was working fine.
Did updates, rebooted, and now remote
Lothar Jenisch wrote:
Hello,
I have a problem with replication and LOAD DATA INFILE.
I use version 3.23.37 on Liunx distribution.
1. I check the replication with a manual i.e. insert and
delete of one record. This works fine without problems.
2. I do a
LOAD DATA INFILE 'file.txt'
On 15 Oct 2002, at 9:32, Karl Stubsjoen wrote:
So if I have a field that looks like this
My_Text_Field
|HELLO WORLD|
and I try to change it to:
HELLO WORLD.
(note the . at the end)
It fails.
You're not providing enough information for people to be very
helpful. What is the
Perl has functions to do this.
If you are writing an import, use language native functions.
For a load data in file, just how would you expect this to work?
Serge Paquin wrote:
Hello All,
I'm just plugging away at a converion project where we are migrating to mySQL.
I am getting
On Tuesday, Oct 15, 2002, at 08:30 America/Phoenix, LAFONTAINE Julien -
LYO ([EMAIL PROTECTED]) wrote:
Hi evryone,
I've developed a java program that extract data from C-ISAM files and
put it
in a MySQL DB.
It creates temporary files, load them into temporary tables and then
update
I've been trying for a week to get MySQL installed on a Solaris
system running on Intel, not Sparc, and am rather at the end of
my line. I know almost nothing about the process of compiling
things, but various people have given me advice and I still can't
get it to work.
All I want is a
Serge Paquin wrote:
Hello All,
I'm just plugging away at a converion project where we are migrating to
mySQL. I am getting increasingly down on the poor support for importing dates into
mySQL. In the near future could we expect a function that is basicaly the opposite
to
Serge,
What are you used to in the database that you are migrating from?
My guess on what would be nice is something like the ORACLE to_date and to_char
functions, which work in query strings and load data statements:
http://www.llcsystems.com/FAQ/oracle_SQL/oracle_SQL_11.htm
Though if
Description:
compile fails on redhat-7.2 if --with-libwrap option to ./configure
is specified; works fine without said option
How-To-Repeat:
./configure --with-libwrap
Submitter-Id: submitter ID
Originator:[EMAIL PROTECTED]
Organization:
MySQL support: none
Synopsis:
Hi everyone!
I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but
without any luck
Please guys can anyone give me an idea about?
Any help will be highly appreciated
-Jose
Specs: solaris 9, gcc-3.2, mysql-3.23.53
configured as:
CC=gcc CFLAGS=-O3 \
CXX=gcc CXXFLAGS=-O3
I'm not getting an error message.
This is what is on my FreeBSD box
MySQL-4.0.0-ALPHA-CONFIGURED.TAR.TZ
4.0.0-ALPHA
FreeBSD Version 4.4
We are questioning this version for production. I've had problems in the
past and think its time to do a downgrade to version 3.23. We've taken
owner of
Jesse Sheidlower wrote:
I've been trying for a week to get MySQL installed on a Solaris
system running on Intel, not Sparc, and am rather at the end of
my line. I know almost nothing about the process of compiling
things, but various people have given me advice and I still can't
get it to
hello,
I'm running version 4.0.3-beta-max-log on SunOS 5.8 (Generic_108528-15
sun4u sparc SUNW,Sun-Fire-280R)
output from mysqlshow -V:
mysqlshow Ver 9.4 Distrib 4.0.3-beta, for sun-solaris2.8 (sparc)
I'm finding that executing either 'show variables' from a mysql session
or 'mysqladmin
Now we are getting load averages 30 on 3.23.50
It seems like a single long query (1-2 minutes) can push the system over the edge and
cause most queries to lock even though they are on tables not related to the long
query. Then the load average goes through the roof.
I hear that 53 will fix
Hi all. What's the quickest way to copy a table so that all column
attributes such as auto_increment and primary key along with all indexes get
copied over? I like using:
create table new_table select * from old_table
But it doesn't copy any indexes or those special attributes I mentioned
I've upgraded from MySQL-max 3.23.52 to MySQL-max 3.23.53
I'm running Linux, kernel version 2.4.17
I tried installing the binary version of MySQL, and followed all the steps
under:
http://www.mysql.com/doc/en/Installing_binary.html
as I've always done for all my versions of mysql.
when I ran
Hi all,
I use a mix of innodb and MyIsam tables under 3.23.52.
As mysqldump does not supports BLOB, how do you export / import databases
for backup puposes. I dont want to stop the engine to backup or use a tool
that exports all databases (like Innodb hot backup). I want to backup a
On 15 Oct 2002, at 12:10, Serge Paquin wrote:
I'm just plugging away at a converion project where we are
migrating to mySQL. I am getting increasingly down on the poor
support for importing dates into mySQL.
Why are you blaming MySQL for that problem? You could just as well
say it
We have a client who wants to switch their hosting over to us, but has an
issue with his MySQL database.
It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently
times out when he is doing the dump.
What is the best way to go about getting this data on to one of our systems?
We have a large application made using a special database/product (not an SQL
database). This application also uses CGI (writen in C). CGI is used on every
transaction to send a request to the product and format the result.
We want to write a log of EVERY transaction made by the customer in a
I am trying to make a query that usses the same table twice. I have a table
of scores and a table of teams and the scores table has both the visitors
and home team in it as an ID that is in the teams table. I can't get my
MySQL statement to work, it does not like the parentheses.
SELECT
Hi,
Well I've tried to export 12 million rows with success from mysql to Oracle.
I used MS Access and created an ODBC connection to get the data from Mysql,
then i exported all rows to a .csv file. Then i used Oracle Sql-loader,
because I wanted em in an Oracle DB.
But you can import it to
Hi,
It happens to me too.I think are some problems with GLIBC.
RED HAT 8.0 install MySQL ver 3.23.52.I install from source distribution
MySQL ver 4.0.4 and nothing change.
MySQL seems can not create socket file(BAD FILE DESCRIPTOR) and for this
reason make the error.It want to create a child
[EMAIL PROTECTED] wrote:
Hi everyone!
I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but
without any luck
Please guys can anyone give me an idea about?
Any help will be highly appreciated
-Jose
Specs: solaris 9, gcc-3.2, mysql-3.23.53
configured as:
CC=gcc CFLAGS=-O3 \
I did check out the link below, in which someone else has an
error identical to mine, and Sinisa Milivojevic replied
basically saying that the answer is described in detail in the
Manual.
Well, I can't find it in the Manual. There are things somewhat
related in the various Solaris sections,
Hello all.
I have encountered an really annoying problem in MySQL 3.23.49 on Win32.
I am using InnoDB because I need transactions. I use autocommit off.
I'll try best to describe the problem I have:
I have two sessions to my DB.
Session 1 inserts some data into a table, then commits.
Session
Thanks very much for your replay
Is very interesting but how to change that declaration on mysql or
on the headers if there is any to modify. I have others Linux boxes
running mysql fine but each time I have to deal with the others
sparcs Solaris is really a real nightmare .
Regards
Jose
- Original Message -
From: Jesse Sheidlower [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 5:07 PM
Subject: Re: Problems installing on Solaris/Intel
I did check out the link below, in which someone else has an
error identical to mine,
On Tuesday 15 October 2002 04:53 pm, [EMAIL PROTECTED] wrote:
Thanks very much for your replay
Is very interesting but how to change that declaration on mysql or
on the headers if there is any to modify. I have others Linux boxes
running mysql fine but each time I have to deal with the others
At 11:10 -0700 10/15/02, David Yee wrote:
Hi all. What's the quickest way to copy a table so that all column
attributes such as auto_increment and primary key along with all indexes get
copied over? I like using:
create table new_table select * from old_table
But it doesn't copy any indexes
At 14:56 -0400 10/15/02, Bill Leonard wrote:
We have a client who wants to switch their hosting over to us, but has an
issue with his MySQL database.
It's about 1.4 million rows, and about 350MB of data. PhpMyAdmin apparently
times out when he is doing the dump.
Is that a MySQL issue, or a
On Tuesday 15 October 2002 05:07 pm, Jesse Sheidlower wrote:
I did check out the link below, in which someone else has an
error identical to mine, and Sinisa Milivojevic replied
basically saying that the answer is described in detail in the
Manual.
Well, I can't find it in the Manual. There
1 - 100 of 138 matches
Mail list logo