Hi,
1 day ago i haved power fail on my MySQL server version 2.23.41 (original
RedHat distr.)
Now i can connect to server only on local interface, no network connection
allowed.
When tying to connect to server with mysql client i recieve this msg: ERROR
2013: Lost connection to MySQL server during q
what's nested SQL?
can you tell me more about it?
if i want to use STL and DEv-CPP , do you know how to do it ?
thanks.
>
> Look for MyC on mysql.com - if you can't find it, email me directly.
> The most recent version supports nested SQL, too. The
> Escapade server-side programming language is
> >Release: mysql-3.23.52 (Source distribution)
Update to 3.23.53a! That solved my problems.
/Nicklas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
very thank you !:)
if i have more question will ask you again.
thank you again!
> Subject:RE: about use Dev-cpp and C++
>
> > what's nested SQL?
> > can you tell me more about it?
>
> Nested SQL allows you to do all kinds of interesting things in MySQL
> that you can't do now - sub-selec
Hi
I have written a web application that is hosted in a server which uses
the default character set. This causes problems in the sorting that
MySQL does because most of the data is in Greek. When developing it
locally, I run the MySQL server with the greek character set and sorting
works fine.
Hi there,
I am working on the replication feature of MySQL. I am managed to replicate
the servers(both versions are 3.23.52 on Win 2K). Ay yhe my.ini file, the
bin-log files are declared as log-bin=c:\mysql\log_files.bin and as I FLUSH
LOGS the new log file's name is increased by 1, like log_files
Mike,
A lot of my Oracle / MySQL questions got answered by searching the
archives at for "Oracle" (so many!) or "Oracle ..."
e.g "Oracle Backup" etc.
Thanks,
Sam Bauer, Oracle DBA
-
Before posting, please check:
http://www
** Reply Requested When Convenient **
This is probably a permissions issue but I can't seem to iron out the problem here. I
am trying to connect to the datasource I have set-up for a MySQL database. When I boot
JBOSS up I can't seem to get MySQL to authorize the user that I have created. The
pa
Well, if you want your main table to have foreign keys into the tables
that maintain your other data (Studios, Genres, Actors, etc) then you
need to populate your other tables first. You will be referring to those
tables when you perform your inserts into your main table to gain access
to the corre
> what's nested SQL?
> can you tell me more about it?
Nested SQL allows you to do all kinds of interesting things in MySQL that
you can't do now - sub-selects, for example; or if you're a lazy programmer
(like me!) you want to do grouping and sorting in ways that would be
difficult (and complicate
We are looking to move to a mySQL db for an application that will possibly
process 100's of millions of rows a day and are looking to do it cheaper
than an oracle solution. I am new to the mySQL arena and am interested in
the groups experience in what mySQL does not do (especially related to
backu
I haven't a directory called "data" in the mysql directory and I never
specified where mysql have to put the database.
I try to find where mysql is supposed to get the mysql.host and the
database but i don't find it yet
So in which file I can't get this information ?
thanks
yoann
Andrew Braithwa
Here is a (stripped) list of steps needed to recreate this problem.
---
# mysql -u root -p
..
mysql> CREATE DATABASE `user_db`;
Query OK, 1 row affected (0.00 sec)
mysql> USE mysql;
Reading table information for completio
Ed,
I feel that your response to this problem is not in the spirit of the open
source world (more like the RTFM response that you would get from a support
desk). We should be encouraging new users with replies like:
"Yes - this is quite a common problem with new installs - you could try x, y
or
On Thursday 17 October 2002 19:33, Sandeep Murphy wrote:
> Our JSP application has connections to both Oracle and MySQL... In each
> page there are nearly a dozen queries executing on a MySQL db. at the
> begining of each page, a connection is opened and at the end they are
> close.. Ideally, if th
I'm trying to import an access database table into MySQL
This is what I've done:
created a database testdb in access with a table cop
exported the table as comma separated values into cop.txt
created a database called testdb in mysql,
created a table called cop of the same structure as the acces
ok thanks,
in fact I did :
cd /usr/local/mysql
chown -R mysql.mysql *
./bin/musql_install_db
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql
chown -R root /usr/local/mysql/bin
encore merci ;p
yoann
Andrew Braithwaite a écrit:
You need a data d
hi all,
I just finished to compile mysql 4.04 beta but when I start mysqld I
have this error
# mysqld -u mysql &
[1] 19034
22:10:55 babar:/usr/web/mysql# 021017 22:10:55 InnoDB: Out of memory in
additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: You may get
> Load issue resolved. Whew! Looking forward to 4.0.5 with the same fix.
> Such a relief! Thanks for all the work to resolve this!
Als here the loadissues have been resolved, I had to run .49a and had to
miss a couple of innodb features for it, but finnaly .53 works again as
stable as .49 has been
Dear friend:
Can the mysql run on a embed system that like MOTOROLA MC68EZ328 and PPSM OS or
WinCE ?
[EMAIL PROTECTED]
2002-10-18
-
Before posting, please check:
http://www.mysql.com/man
I converted one table from Paradox to Mysql with 532.458 registers. After
that I try converted more 473.493, but i recept this error:
Key Violation.
[MyODBC][ODBC 3.51 Driver]
[mysqld-3.23.39-max-nt] Sort Aborted
My table:
Create table FichaFin
FinID MEDIUMINT NOT NULL AUTO_INCREMENT,
Fi
I'm trying to use the mm.mysql JDBC drivers on windows NT
I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted
it into my jdk1.2.2/jre/lib/ext folder.
I try to connect with
import java.sql.*;
public class dbconnect
{
public static void main(String[] args)
{
String ur
I was reading a book at B&N yesterday which left me with the impression that in MySQL
you can do the following:
Define a group with specific security access.
Then define a list of users that inherit this groups security settings.
Is this correct? If so, will this work under the Windows version
The strange thing I met with is that when I ran
rpm -e XXX.rpm
It said that the package in not installed. But when I ran
rpm -i XXX.rpm
It said that the package already exist.
I am new to MySQL. Any idea is greatly appreciated.
Jack
Jack Chen
>Description:
On Redhat 8.0 all attempts to connect through a non-local socket
result in the mysqld crashing.
For example: telnet host 3306
Results in the mysql log:
Number of processes running now: 1
mysqld process hanging, pid 11473 - killed
I'm trying to enable innodb , I installed mysql-3.23.52 from the ports
collection
I cp my-medium-.cnf my.cnf
then mv my.cnf to /etc
I uncommented the innodb lines
and created ibdata1 directory in the data directory (/var/db/mysql)
I stopped mysqld now it refuses to restart
unless I remove my.cnf
Curious if this is normal behaviour, or if my table is just not put together
very well. I have a table consisting of approximately 4.5 million contacts,
listed by company name/city/state/zip - The system this is running on is a
PowerEdge 1400sc, 1ghz p3, 1 gig ram, 18gb scsi drive. These are the
Dear
After I had mysql use raw device with innodb instead datafile, I
started mysql
and got an error like following;
021018 14:11:18 mysqld started
021018 14:11:19 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
I
Sorry: Was to dull to use the bugscript - did not know how to use emacs to
send it; anyway here it is:
[maclef:/usr/local/mysql] maclef# ./bin/mysqlbug
Finding system information for a MySQL bug report
test -x /usr/bin/emacs
Using editor /usr/bin/emacs
You can change editor by setting the envir
mysql,query
Lee Denny wrote:
I'm trying to use the mm.mysql JDBC drivers on windows NT
I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted
it into my jdk1.2.2/jre/lib/ext folder.
You need to put .jar file (ie. mysql-connector-java-x.x.x-beta-bin.jar)
into jre/lib/ext
You need a data directory in the mysql directory. Did you run the install
script?
The install script is at: scripts/mysql_install_db
For a normal linux/unix install you need to do the following
---
cd /usr/local/mysql/
groupadd mysql
useradd -g mysql
Will,
Do you have a user/host pair for the client in the user table within the
mysql database?? It's not good enough just to have a user, the host has
to be setup too.
> I cannot connect from my Windows machine to the MySQL database running
on
> the Linux server.
>
> I have tried several differ
Using FreeBSD-4.6.2---MySQL-3.23.53
I copied my.cnf to /etc and /var/db/mysql
and made a file mysql.sock in tmp (/tmp/mysql.sock)
What do I put in mysql.sock?
At present I'm getting:
Cannot connect to local MySQL Server thought socket '/tmp/mysql.sock' (2)
Thank You,
Douglas V.
-
I have two tables in a mysql db:
|+|
|games |3 |
|+|
|eat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 17 October 2002 12:23, Ireneusz Piasecki wrote:
> When will version 3.23.53a for windows users ?
> I downloaded version 3.23.53 but in zip package were mysql version 3.23.52.
> (innodb not working in this wersion on win98). What about this
>Description:
>How-To-Repeat:
<:/>
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Use --log-slow-queries[=filename] option.
It will log all queries which take more than "long_query_time"
Default value of it is 10 sec and you can ascertain it by "show
variable like 'long_query_time'" query
and set in my.cnf as "long_query_time = value"
I think you'd better refer to the MyS
it is released. at least; it can be found on ftp.sunsite.dk
-kees
> -Original Message-
> From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net]
> Sent: Thursday, October 17, 2002 11:44 AM
> To: [EMAIL PROTECTED]
> Subject: re: when will 3.23.53a be released?
>
>
> Lars,
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 16 October 2002 20:50, Mark Graves wrote:
> Previously I had been a NuSphere subscriber for MySQL (and PHP and Apache).
> As you probably know, NuSphere no longer produces or supports the MySQL
> product. How do I migrate out of the NuSph
I cannot connect from my Windows machine to the MySQL database running on
the Linux server.
I have tried several different programs and they all report an error that
says "Lost connection to MySQL server during connection".
I have read all the articles I can find and searched the archives as well
I believe your only choice is to move this stored procedure into client side
routines.
Ric
- Original Message -
From: "Pradana" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 8:37 PM
Subject: Stored Proc
>
>
> OK,
>
> MySQL does not support the Stor
On Wed, Oct 09, 2002 at 10:18:48AM +0200, Koller Sébastien wrote:
> Hi,
>
> I try to install mytop in order to get some information about my MySQL
> database, after I installed :
>
> - DBI-1.18.tar.gz
> - Msql-Mysql-modules-1.2216.tar.gz
> - Data-Dumper-2.101.tar.gz
> - Data-ShowTable-3.3.tar.gz
Sandeep Murphy wrote:
hi,
I have a problem with the connections and would appreicate a lot if anyone can provide a soln..
Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a connect
SQL, Does it matter which table I enter data into first? Or do I need to
first
put in the data into Studios, Genres, Actors, & Stars first before adding
to Titles and TitleGenres since they use the IDs of the other table? Or
should I convert it to type innodb and make the IDs foreign keys in th
Hi,
It seems to me that you can't connect to MySQL from an other machine at
all. Did you start MySQL with the --skip-networking option? Try removing
that option from the start-up scripts.
\Olaf
Will Merrell wrote:
I cannot connect from my Windows machine to the MySQL database running on
the L
I have exactly the same problem, with version 3.23.53a. I ask myself if
the problem is related with this binary distribution? If I install the rpm
from the same version, there is no problem to run mysql. I just don't like
the layout of the directories, therfore I would like to install the binary
do you know how use STL with dev-cpp?
thanks
> But it would be so nice to write:
>
> MySQLConn DB = new MySQLConn ('host', 'port');
> DB.Login('user', 'pass');
> MySQLTransaction X = new MySQLQuery(DB);
>
> // STL-derived slist:
> MySQLResults Results = X.Query("...");
>
> // STL map:
> map Ro
How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux
RedHat 7.3)?
Does anyone know a solution ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
OK,
MySQL does not support the Stored Procedure ... yet.
So how do I convert the following SQL as a Stored Proc into MySQL ?
Assume I have the following Stored Proc :
-- Start snippet
CREATE PROCEDURE aTest
AS BEGIN
-- Select some columns from table and table b,
-- then put them into a temp t
.
Could we see this php routine, please? Or can you post it to a newsgroup?
Yooors,
Iain Lang.
At 18:23 15/10/02 -0400, Serge Paquin wrote:
I have written a very poor and inflexable PHP function to do this outside
the database. I have not played with doing my own functions in mySQL but
your s
Your glibc update broke MySQL. It was probably already loaded when you
started the update.
Get the latest pre-compiled version ( 2.23.53a) I believe from mysql.com.
You need the latest version with the "a".
Dishko Georgiev wrote:
Hi,
1 day ago i haved power fail on my MySQL server version 2.23
Hi all,
I have used the following script to connect our remote database from my local
machine. The PHP script is at my local machine.
When I tried to connect the database, instead of connecting to the IP provided
in the script, it is searching the Dynamic IP of my Internet Service Provider.
and
Hello Gavin,
Thursday, October 17, 2002, 3:40:11 PM, you wrote:
GL> Thanks for your reply Victoria .
You're welcome.
>> GL> How is the best way to reconstruct this table?
>> Add users again. Or what you mean "reconstruct"?
GL> What I wish to do is add users, I can read the sytax which gives me
Salam,
Thursday, October 17, 2002, 1:04:44 PM, you wrote:
SBS> I need un explanation to the following, or it is a bug which needs a
SBS> fix.
SBS> mysql> select ti from article where match (ti) against ('"computer
SBS> science"' in boolean mode) ;
SBS> .
SBS> 21 rows in set (0.07 sec)
SB
>Description:
MySQL segfaults after recieving TCP/IP connections. Connections to the local socket
work great.
>How-To-Repeat:
Connect via TCP/IP
>Fix:
Unknown
>Submitter-Id:
>Originator:root
>Organization:
Critical Distinction, Inc.
>MySQL support: [none | licence | email support | extende
Hi,
i have the following problem. I have a table wherey to_id
and owner_id are of type unsigned int not null and both
are normal indexes. Unluckily a query like:
--
EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 or owner_id = 3157
--
returns very bad results:
--
table type pos
PHP already has a function that will convert a textual date into a unix
timestamp.
-
strtotime
(3.0.12 - 3.0.18 only, PHP 4 >= 4.0.0)
strtotime -- Parse about any English textual datetime description into a
UNIX timestamp
Description
int strtotime (string
<[EMAIL PROTECTED]> wrote:
> >Description:
> On Redhat 8.0 all attempts to connect through a non-local socket
> result in the mysqld crashing.
>
> For example: telnet host 3306
> Results in the mysql log:
>
> Number of processes running now: 1
> mysqld process hanging, pid 11473 -
I read the indications in the MySQL manual about how to create an user
defineable function and I implemented a dll (I am working in win2000).
When I try to execute the query:
CREATE FUNCTION cuadrado RETURNS REAL SONAME 'cuadrado.dll'
it shows the message:
1105 - Unknown error
I am working
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent
I belive it will work in Windows
Insane
- Original Message -
From: "Terry & Cheryl Haimann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 4:24 PM
Subject: Security
> I was reading a book at B&N yesterday which left me with the impression
that in MySQL you c
// This is a generic function which returns the results
// of a query in list form, so they can be used in place
// of nested queries until it is implemented in MySQL
// If there are no values, it returns the string
// "Empty Nested Set" by default.
function getnestedvals($field, $table, $comparef
Expanding the zip into the lib/ext/ is perhaps not the best idea.
Expand it elsewhere, and copy the JAR file to the lib/ext/ folder.
Also, you don't need to make an instance of the Driver. The static initializer
will register the class with the DriverManager.
Niclas
On Thursday 17 October 2002
Hello,
I need un explanation to the following, or it is a bug which needs a
fix.
mysql> select ti from article where match (ti) against ('"computer
science"' in boolean mode) ;
.
21 rows in set (0.07 sec)
Now using the truncation operator *
mysql> select ti from article where match (ti
I have a more-or-less stock Red Hat 7.3 machine that I have running
MySQL v3.23.53 built from source. Local socket connections work great,
but it segfaults when it receives a remote connection. Here is the error:
[root@host src]# /usr/local/mysql/bin/safe_mysqld: line 273: 30534
Segmentation
What I am trying to do is on the first webpage. There is a Studio dropdown
(information from the MySQL database) menu. When someone picks a studio
the results go to a different webpage showing just the movies in that
studio. How do I get the results onto the second page?
How can I do it in dr
Hi there
Problem:
I've got two debian linux pc's
One is my server on which I would like to install te mysql server,
one is my workstation.
First trying to install the mysql server on my server I seem to have done something
wrong. With installation I had no problems (standard .deb installtion)
bu
Hi,
If I had to guess - I would say that you do not have permissions for the
datadir.
Try the following:
Chown -R mysql:root /usr/local/mysql/data (or wherever your datadir is)
And
Chmod -R 660 /usr/local/mysql/data (or wherever your datadir is)
Cheers,
Andrew
Sql, query, wi
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
> Is there an way to get out of my way? Uninstalling mysql-server
> and installing again didn't do the trick
Look in the manual FIRST before porting, please - this is a
" Big cleanup in replication code (less logging, better error messages, etc..)
I have been having periodic problems with lost connections with my 4.0.2
slave and master. No errors, other than lost connection, retrying etc. But
sometimes the connection doesn't come back even though show slave sta
>Description:
When running mysql-test sequence, two of the BDB tests cause mysql to
apparently bomb -- all other tests run ok (used --force to verify)
Extract of test log is:
.
.
.
backup 0.0 0.0 0.1 [ pass ]
bdb-alter-table-1 ..
dear everybody,
I have tree linux 7.3 machines on which MySQL-3.23.51-1.i386.rpm,
MySQL-client-3.23.51-1.i386.rpm and MySQL-shared-3.23.51-1.i386.rpm is
installed. the intrusion detection system snort loggs to these machines.
Every machine is set up the same way and contains the same table. The d
I'm concerned about memory usage of mysql connections.
I've been reading the mailing list archives but I'm
still clueless.
I need to buy a new server for a mysql database that
will have at least 500 persistent connections from an Apache
server with mod_perl.
I'm checking the memory usage of the d
> I copied my.cnf to /etc and /var/db/mysql
> and made a file mysql.sock in tmp (/tmp/mysql.sock)
>
> What do I put in mysql.sock?
Nothing. The server creates it when it starts up. Read the docs.
sql, query
-
Before posting,
Folks,
I have several independent users on one linux machine. They all want
to run apps that use mySQL. All of these apps are browser driven. Is
there a HOWTO for this situation? Can someone offer guidance?
~~~ Dan 0;-D
Austin, TX
hi,
I am using win-xp and command prompt to access mysql.
I try to retype a very long insert line into the command prompt, but the
command prompt would not allow me to type all my insert query. There seems
to be a limit to the characters I can insert when in mysql.
I can type any amount of charact
Thanks, I did it and it works.
I just would like to know one more thing.
You mention a "slow" log option, how do invoke that type specifically?
I restarted mysql with safe_mysqld --log & and it created a myserver.log
file in the data directory, but it seems to log ALL queries and is
growing pretty
I have this problem in MySQL
select id from usuario;
ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
How can I solve this problem?
thks
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi Mark,
Yes, the code is wrapped by a try , catch, finally block but still we r facing
suspended connections.. :(
am using MysqlFront to administer the dbs and i can kill the suspended/delayed
processes manually..
Does mysqladmin provide any other additional services??
thnx,
sands
-Ori
Oh, it's my "little" mistake.
By the way, when version *.53 for windowze users ?
Regards
I. piasecki
- Original Message -
From: "Ireneusz Piasecki" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 17, 2002 12:23 PM
Subject: What about 3.23.53a max for windows ?
> Hi.
>
Corin,
Thursday, October 17, 2002, 3:09:08 PM, you wrote:
CL> i have the following problem. I have a table wherey to_id
CL> and owner_id are of type unsigned int not null and both
CL> are normal indexes. Unluckily a query like:
CL> --
CL> EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 o
Renato Silveira wrote:
> I have this problem in MySQL
>
> select id from usuario;
> ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
>
> How can I solve this problem?
>
Repair it ! ;)
See : http://www.mysql.com/doc/en/REPAIR_TABLE.html
> thks
>
>
--
Joseph Bueno
-
squeeb,
Thursday, October 17, 2002, 3:38:46 PM, you wrote:
>Description:
saadcdu>
Did you installed the client package?
--
For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___
Hello!
I would like to know if someone has the solution to my problem.
I was using MySQL Administrator for Windows yesterday and everything was
working fine (I use dBTools also). Today when I tried to access MySQL
(default version for Linux 7.2) I received the message:
"Lost connection to MySQL
Hi All!
I've Select like this:
SELECT ExpDepDate, ActArrDate FROM oceandata
It works beautifully
But When I modify it like this
SELECT ExpDepDate, ActArrDate, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as
Act_Est FROM oceandata
I'll get nothing, just a empty screen with a browser!
I'm using U
Anyone has tried MySQL 3.23.5x (or even 4.x) on
Caldera OpenLinux eDesktop 2.4 ?
I am considering setting up a server on Linux but I
want to know if MySQL has any preoblem on Caldera's .
Thanks
filter: SQL, database, MySQL
=
-
Benoit St-Jean
[EMAIL PROTECTED]
Yahoo!
I'm boxed in a corner and would appreciate some suggestions, please!
Thank You,
Anthony
Original Message
Subject: Access Denied (1045)
Date: Tue, 15 Oct 2002 08:47:05 -0400
From: "Anthony W. Marino" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
I"ve searched about and still hav
Jack,
Friday, October 18, 2002, 5:38:30 AM, you wrote:
JC> The strange thing I met with is that when I ran
JC> rpm -e XXX.rpm
JC> It said that the package in not installed. But when I ran
Remove .rpm
To see what package is installed use
rpm -qa | grep -i mysql
I get the list of installed rpms
Andrew,
Wednesday, October 16, 2002, 10:52:37 PM, you wrote:
AH> I need to be able to insert many rows into a table at once. Only one
AH> field, an incremental serial number will change for each row. Is there
AH> a way to do that in a single query? I need to be able to specify the
AH> start and
Max,
Friday, October 18, 2002, 1:32:34 AM, you wrote:
MK> Here is a (stripped) list of steps needed to recreate this problem.
MK> ---
MK> # mysql -u root -p
MK> ..
MK> mysql> CREATE DATABASE `user_db`;
MK> Query OK, 1 row
Renato,
Friday, October 18, 2002, 1:01:06 PM, you wrote:
RS> select id from usuario;
RS> ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it
RS> How can I solve this problem?
Repair your table:
http://www.mysql.com/doc/en/Repair.html
--
For technical support contracts
>Description:
Mysqld crashes from time to time, there is no backtrace information in error logfile.
>How-To-Repeat:
There is no specific query that causes it. Most often it happens just after select
count(*) from ... queries.
I tried compiling with different options with same effect. I even tried
Aaron,
Thursday, October 17, 2002, 6:18:55 PM, you wrote:
AP> I have a more-or-less stock Red Hat 7.3 machine that I have running
AP> MySQL v3.23.53 built from source. Local socket connections work great,
AP> but it segfaults when it receives a remote connection. Here is the error:
AP> [root@
Karam,
Wednesday, October 16, 2002, 10:58:15 PM, you wrote:
KC> i have a winxp and linux 7.2 on the same machine. I
KC> have mysql on the linux server and MyCC in the win
KC> partition.
KC> i connect to the linux MySQL using the vmware lopback
KC> adapter. everything is working fine.
KC> now w
Ismed,
Thursday, October 17, 2002, 11:02:50 AM, you wrote:
IID> I have test install MySQL ver.4.0.x on RedHat Linux 7.2.
IID> When I test query using MySQL Front(Under Windows) Select now() it's displayed:
IID> '10/17/2002 3:10:20' PM, but when I test using telnet under command line
IID> it's show
Douglas,
Friday, October 18, 2002, 5:01:21 AM, you wrote:
D> I'm trying to enable innodb , I installed mysql-3.23.52 from the ports
D> collection
D> I cp my-medium-.cnf my.cnf
D> then mv my.cnf to /etc
D> I uncommented the innodb lines
D> and created ibdata1 directory in the data directory (/var
Nikolas,
Friday, October 18, 2002, 5:56:10 AM, you wrote:
NG> I have written a web application that is hosted in a server which uses
NG> the default character set. This causes problems in the sorting that
NG> MySQL does because most of the data is in Greek. When developing it
NG> locally, I run
Help (apologies for the length of this email),
I am currently using mysql-max-3.23.49a with a process as follows:
Using tomcat/jsp/servlets, I have written a database connection pooling java
class which establishes connections to mysql, stores them in an array and
manages the distribution of th
Chung,
Thursday, October 17, 2002, 9:48:15 AM, you wrote:
CHn> At the slave server of replication there are log files like
CHn> environment hostname-relay-bin.xxx.
Yes, these logs are used for replication:
http://www.mysql.com/doc/en/Replication_SQL.html
CHn> For what these logs and how c
EMS HiTech company is very glad to announce the NEW software -- MySQL
Import Tool! Now our MySQL Export and Import tools are joined in one
section -- MySQL Utils.
MySQL Import is a powerful cross-platform (Windows and Linux) tool to
import your data quickly from MS Excel, MS Access, DBF, TXT and C
1 - 100 of 178 matches
Mail list logo
