If your users are on Windows, try out SQLyog for which I am a beta tester.
Its very simple to use and fast.
Download it at http://www.webyog.com/sqlyog
Insane
- Original Message -
From: "Rafael E. Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 3:54
On Sat, 2002-10-19 at 00:04, Dave Best wrote:
> I hope this is the right mailing list so here goes..
>
> Anyone have any good information on how to setup PHP and mysql?
>
> I downloaded the latest mysql binaries and placed them in
> /usr/local/mysql
>
> php was already installed on my system
Dear Sir/Madam,
I had a problem with mysql. Actually mysql was
accepting a space after a column name, which I think
its not supposed to accept. This problem frustrated me
a lot, it gave a error stating field does not exist.
Eventually I corrected it by removing the space.
Thanks & Regards
Uma
I hope this is the right mailing list so here goes..
Anyone have any good information on how to setup PHP and mysql?
I downloaded the latest mysql binaries and placed them in
/usr/local/mysql
php was already installed on my system, redhat 7.2 but for some reason it
couldn't find any of the m
Here's a little thing I wrote a while ago on how to do this so I wouldn't
forget. There are probably better ways to go about this - If anyone knows
of any so I could update this thing, please let me know.
http://www.hatesville.com/~jtx/apache.txt
This is how I usually set up my installations fo
>Description:
Attempting to connect to MySQL Server 3.23.53 (also tested
with 3.23.51) causes a message to appear on the root console:
/usr/local/mysql_3.23.53/bin/safe_mysqld: line 273: 22766 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --based
Hello!
I've installed and re-installed MySQL on Windows (binary) multiple times,
using multiple versions (3.x and 4.x). The reference manual discusses a
script called mysql_install_db, in the /scripts folder. I can't for the
life of me find such a script anywhere on my machine.
Do I need to do
I'm having trouble with a an obscene amount of aborted_connects on my
MySQL database servers. I have 3 dedicated database servers, one of them is
a master database with 2 slaves, and the other 2 are stand-alone
database servers. All connections are being made by PHP pages on Apache web
servers.
Using FreeBSD-4.2.6, apache+modssl, and mod_php4
Intel pentium 4 @ 1.5G
256M of memory
1st hard drive 19 G ide
2nd hard drive 40 G ide (mysql installed on drive 2)
mysql-max-4.0.3-beta-unknown-freebsdelf4.6.2-i386
downloaded from ftp I believe San Diego USA
"Mysqld got signal 11"
021018 17:5
hi steve,
there was a thread concerning compilation of mysql on solaris three days
ago. one of the postings had a link:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116929:200208:ngkbacmgkmgkdbbfgjdo
to an earlier posting where j warburton describes how he successfully
compiled mysql (3.23.51)
Using FreeBSD-4.2.6, apache+modssl, and mod_php4
Intel pentium 4 @ 1.5G
256M of memory
1st hard drive 19 G ide
2nd hard drive 40 G ide (mysql installed here)
"Mysqld got signal 11"
021018 17:50:30 mysqld started
INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
INN
I was running mysql 3.23.26 on freebsd 4.6 without a problem. Then I had a
runaway high load cpu event and figured I should at least get later code
before complaining. So I grabbed 3.23.52 (the latest freebsd package).
My databases are in /var/db/mysql.
My root partition is mounted readonly.
W
Hello,
I'm brand new to mysql. I've installed the necessary packages in my
linux box to have mysql running.
I can run a number of administration tools, like mycc and phpMyAdmin.
However, to convince the people here to use it, I need an application
that will let me create forms for data entry and
Hello,
I'm brand new to mysql. I've installed the necessary packages in my
linux box to have mysql running.
I can run a number of administration tools, like mycc and phpMyAdmin.
However, to convince the people here to use it, I need an application
that will let me create forms for data entry a
You guy recommend that I download the binaries instead of the source code.
In the Win32 version of 4.0.4 is SSL enabled or do I need to download the
source code and apply the flags that you mention in your sort version of the
SSL Documentation so far.
Also I would like to know if the Pro version h
021018 17:50:30 mysqld started
INNODB: Error:datafile /home/mysql/mysql/data/ibdata1 is of a different size
INNODB: than specified in the my.cnf file!
INNODB:Assertion failure in thread 138207232 in file os0file.c
send bug report to [EMAIL PROTECTED]
mysqld got signal 11
key_buffer_size = 167
Hello All,
As suggested earlier, it was the glibc update fault. Either downgrade your
glibc which fixed a DoS fault, or remove your present rpm(s) and install
with the latest RedHat rpm(s) at http://www.mysql.org.
Glenn
-
Be
Hi all,
I've been trying to compile .51 and .52 under Solaris 8, and I get errors
under both versions. Here's the error under .52:
make[3]: Entering directory `/usr/local/src/sql/mysql-3.23.52/sql'
g++
-DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\""
-DSHARE
Hi all,
I've been trying to compile .51 and .52 under Solaris 8, and I get errors
under both versions. Here's the error under .52:
make[3]: Entering directory `/usr/local/src/sql/mysql-3.23.52/sql'
g++
-DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\""
-DSHARE
I had similar problem in my case.
The solution was that maybe you are accessing the column which has data
which is greater then the specified in Max_data_allowed in my.cnf.
Change it to something more and I hope that the problem is solved ?
Insane
SQLyog - The Definative GUI For MySQL
http://www
> Thank you, but at this point I am pretty sure that my problem is not a
> matter of entries in the user table. When I attempt to telnet
> into port 3306
> the connection is immediately dropped. I don't really know if
> any connection
> is actually established at all, it may be established and imme
Thank you, but at this point I am pretty sure that my problem is not a
matter of entries in the user table. When I attempt to telnet into port 3306
the connection is immediately dropped. I don't really know if any connection
is actually established at all, it may be established and immediately
drop
Hello all,
I'm new to this list and I was wandering if one of you would be able to
help me with the following problem.
I've been trying, unsuccessfully, to compile mysql 3.23.51 on Solaris 9
(sparc). I'm using gcc 3.2 and bintools 2.13. I used the following
configure command: ./configure -prefix
Hi, This is the same error that I am getting, except that in my case the
server does not die, I just cant connect from another machine. All I get is
this error, which seems to be because the server is not responding to the
3306 port. or something like that.
I don't know if this is the same problem
Hello,
Wonder if anyone has experience with Chinese and mySQL. I have a column to
capture chinese which is in blob. Does any one know how to write a code in
Java to insert the chinese value?
I am currently using mySQL version 3.23.52-max-nt. Do I need to add
character-set as the manual mentio
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 October 2002 16:16, Engin Gunduz wrote:
> A little typo in mysql_convert_table_format.sh
> of mysql-3.23.53 distro:
>
> print "$table is alread of type $opt_type; Ignored\n";
>
> must have been
>
> print "$table is already of type $op
Temporary tables are per thread.
WHat guarantee do you have that your next page gets the same thread?
Martin Thomas wrote:
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 conn
rpm -e XXX
Jack Chen wrote:
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
--
You answer a simple question that is in the table of contents 200 times
in a week, and see how short
your replies get.
Andrew Braithwaite wrote:
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 sup
Thanks for the reply.
-rw-rw 1 mysql mysql 12766 Oct 10 12:16 bob-bin.072
-rw-rw 1 mysql mysql 506213 Oct 15 09:11 bob-bin.073
-rw-rw 1 mysql mysql 40391597 Oct 17 12:52 bob-bin.074
-rw-rw 1 mysql mysql 98 Oct 17 12:53 bob-bin.075
-rw-rw 1 mysq
Hi,
Run mysqld_safe with the --log-bin switch (it will recreate a new bin log at
each crash, so it's much more simple to see which query is responsible for
the crash).
Regards,
Jocelyn Fournier
- Original Message -
From: "Eric" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTE
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the telephone
line.
But I have a problem to implement the SQL que
Dear friends,
I am developing a database application for our saleses
with PHP and MySQL.
Our sales must call the customers on time. They may
not be late to call the customers. The may not miss
the appointment to meet the customer on the telephone
line.
But I have a problem to implement the SQL que
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
We currently receive a lot of reports from people running Red Hat
Linux (7.x and 8.0) that cannot access MySQL via TCP/IP after updating
the GNU C library (glibc) via Red Hat's up2date updating tool. MySQL
simply crashes in this case, only downgra
Chuck,
last_insert_id() is per-connection. How do you see two users getting the
same auto_increment value?
PB
-
- Original Message -
From: "Chuck Tomasi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 18, 2002 9:07 AM
Subject: Using AUTO_INCREMENT like SEQUENCE
>
Hi,
I know there is more than one reason that this error can occur, but I have
not seen a good guide to debuging.
It might help, if you are using DBI to do a trace to a log file. I have
this happen every once in a while, but can't track it down because it is
one query out of hundreds and I can'
Will,
|||)So I still need some more ideas.
I have to learn your problem each time again when I setup a new machine every half a
year.
I try each time the following hostnames:
localhost (didn't work 4u)
127.0.0.1 (IP for localhost)
hostname (e.g. databaseserver.mydomain.com- what you called the
General Info:
OS: Mac OS X
MySQL version: 3.23.52 (Jaguar)
PERL: 5.6.0
DBI: 1.30
I've got an application that was written to use Oracle sequences, as such
the program pulls a sequence number then creates a file based on that
number and populates a database record with infomation. I've read
ever
are you getting this problem with an API like php or perl cgi.. or is
this command line. i was having a similar problem, but i couldn't
access anything. i was trying to remotely connect to the mysql via
command line and it would boot me. even on the server itself if i
included the '-h hostna
try 'ps aux | grep mysql' rather than using top... i dont' think you can
grep a top session.
Jack Chen wrote:
if the server is running?
I tried to use:
top | grep mysql -
but not working. Any suggestions?
Thanks!
Jack Chen, Stein Lab, Cold S
Brent Baisley wrote:
about the same amount of time, then you don't have a proper index.
The query above needs to read the entire table to compile the stats,
your query should just need to read the records that are NJ if it
really is using the index correctly.
The results would also be inter
On Fri, Oct 18, 2002 at 11:23:06AM -0400, Jack Chen wrote:
> if the server is running?
>
> I tried to use:
>
> top | grep mysql -
ps ax | grep mysql
works better. Top is (in my mind) more for interactive.
-
Before posting, p
Hi All,,
I am getting this error and mysqld is dying out while tring to access a
particular table in a particular databae while others don't fail..
ERROR 2013: Lost connection to MySQL server during query
Plz Help as early as possible.
Regards,
Animesh
[EMAIL PROTECTED]
DeepRoot Linux Pvt.
>Description:
dmalloc identifies memory leaks when using mysqlclient c library once a malloc and
associated free have been used. Although these memory leaks are not within the
mysqlclient library itself they are found in mainly nsswitch.c and elf libraries such
as dl-open.c and dl-version.c that
HI,
I'm on a win98 2ED system, running
- Apache 1.3.26 + php 4.2.3
- Mysql 3.23.52 (started server is mysqld)
I'm running some php scripts, that works with a database.
Every script, makes a db_connect.
It happens that, after a certain time (I don't know how much, and
I don't know if it really invo
That is not normalizing your data. Normalization would be to create a
States table that would list all states (perhaps having abbreviation,
full name, country, etc) and then you would only store a code linking to
the states table. Although this is one of those special cases where full
normaliza
if the server is running?
I tried to use:
top | grep mysql -
but not working. Any suggestions?
Thanks!
Jack Chen, Stein Lab, Cold Spring Harbor Labs
1 Bungtown Road, Cold Spring Harbor, NY, 11724
Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED]
+
hi,
after issuing a query from my application, the pointer changes and has an
inscription (SQL) underneath it.
Normally the pointer should come back to normal, after the query is
complete. unfortunately it doesnt, i have to click on other buttons before
it comes back to normal.
Is there somethin
Thank you to both of you who responded to my question. I have checked both
of these issues and found that neither solve my situation.
1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the
user table. Is there something else that has to be done to set up the host?
2) According
perumal,
Friday, October 18, 2002, 3:44:00 PM, you wrote:
p>I installed linux based mysql-3.23.47-i386.rpm and
p> mysql-max-3.23.47-i386.rpm sucessfully. I could able to run server while
p> machine booting itself but I am not able to run mysql to create database
p> and tables.
Please,
Hello Douglas,
Friday, October 18, 2002, 5:05:38 PM, you wrote:
First of all answer to the mailing list, not to me :)
D> I just downloaded"mysql-max-3.23.53a-unknown-freebsdelf4.7-i386.tar.gz"
D> to /home
D> I did a pkg_add and got message
D> "invalid compressed data--format violated
D> I tri
VR> kewl,
VR> Thursday, October 17, 2002, 6:33:38 PM, you wrote:
>>Description:
kacdp>> Mysqld crashes from time to time, there is no backtrace information in error
logfile.
>>How-To-Repeat:
kacdp>> There is no specific query that causes it. Most often it happens just after
select count(*) from
Hi,
> >Description:
> kacdp> Mysqld crashes from time to time, there is no
> backtrace information in error logfile.
> >How-To-Repeat:
> kacdp> There is no specific query that causes it. Most
> often it happens just after select count(*) from ... queries.
> kacdp> I tried compiling with different
>Iago Sineiro wrote:
>> Hi all.
>>
>> I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed
>> MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it
with
>> parameter --nodeps.
>>
>maybe it need the mysql-devel package
>
>--
>frankie
mysql-devel package is installed.
Iago Sineiro wrote:
Hi all.
I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed
MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with
parameter --nodeps.
maybe it need the mysql-devel package
--
frankie
-
bas,
Friday, October 18, 2002, 3:59:02 PM, you wrote:
bdvaodc> REALFROM: [EMAIL PROTECTED]
>Description:
bdvaodc> MySQL crashes after issueing the following command :
bdvaodc> UPDATE BGW_Master, ICA_1_SplitInter
bdvaodc> SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt
bdvaodc> WHERE BGW_
Hello
I meet a strange problem:
when I create a new table, the mysql cleint loose connection with the server.
Synopsis:
$ mysqladmin -u mysql -px create temp
(no problem reported, /var/lib/mysql got a new directory 'temp')
$ mysql -u mysql -px temp
mysql> create table oups ( id
Dear sir,
I installed linux based mysql-3.23.47-i386.rpm and
mysql-max-3.23.47-i386.rpm sucessfully. I could able to run server while
machine booting itself but I am not able to run mysql to create database
and tables.
Please tell me what command I should put in command line to work wi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 17 October 2002 18:23, Steven Roussey wrote:
> 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!
Thanks for the confirmation! Sorry, that it took so long... Th
Hello,
At the mysql documentation it says that;
Windows NT disk i/o may benefit from a larger number of
innodb_file_io_threads . Does anybody have any idea about the maximum value
of
innodb_file_io_threads? (Default value is 4)
Cheers
Okan
> It looks like you have a dynamic IP your end and the mysql
> server is looking
> for a fixed IP.
Nope, you read it wrong, both of you. MySQL is printing out YOUR IP
address, not the address of the server. It's complaining that you don't
have permission to access the data you want.
sql, query.
Ismed,
Friday, October 18, 2002, 3:40:02 PM, you wrote:
IID> But It didn't happen if I'm using mysql ver < 4.0.0
I tested it on 4.0.4 with MyCC, MySQLGUI and mysql command-line client
and they worked without any problems ..
IID> --
IID> Friday, October 18, 2002, 6
D> Thank you,
D> innodb is compiled in but disabled, it is from the
D> FreeBSD ports collection - mysql-3.23.52_1 version
What is mentioned in the error log? Did you set up
innodb_data_file_path?
--
For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c
This email is sp
kewl,
Thursday, October 17, 2002, 6:33:38 PM, you wrote:
>Description:
kacdp> Mysqld crashes from time to time, there is no backtrace information in error
logfile.
>How-To-Repeat:
kacdp> There is no specific query that causes it. Most often it happens just after
select count(*) from ... queries.
Hi,
I have read the MySQL manual that the automatic reconnect is
implemented since version 3.21.18.
Also according to the C API manual, the mysql_real_connect will set the
automatic reconnect flag in MYSQL structure.
However, I cannot find any instruction to switch off this automatic
reconne
I have now ReadTheFineManual ;-) and learned that I can use
autoextend and create a new innodb-data file by changing my.cnf and
restart mysql. I've also done just that with success, now I have an
autoextend database file and two static ones.
Is there any simple way to monitor the free space of my
If your contacts are all North American, and this is a typical query, you
may well profit significantly from normalizing the address data. To do so,
create a Cities table and a States table (perhaps call it Regions if you
need to account for CDN provinces). The Cities table would look like:
CityID
>Description:
MySQL crashes after issueing the following command :
UPDATE BGW_Master, ICA_1_SplitInter
SET ICA_1_SplitInter.I1_Proc_Dt = BGW_Master.I1_Proc_Dt
WHERE BGW_Master.I1_FileName = ICA_1_SplitInter.I1_FileName
AND BGW_Master.I1_runDate = ICA_1_SplitInter.I1_runDate
AND ICA_1_SplitInter.I
CM Miller wrote:
Very new to MySQL and I've done a search on
google.com, but really couldn't find the answer that I
am looking for.
Where should I install MySQL? I'm running RH 7.3 and
I've installed the tgz file under my directory
/home/CMMiller, is this right, or anywhere else? I
see it is a
But It didn't happen if I'm using mysql ver < 4.0.0
--
Friday, October 18, 2002, 6:00:02 PM, you wrote:
EE> Ismed,
EE> 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 usin
Hi,
I have read the MySQL manual that the automatic reconnect is
implemented since version 3.21.18.
Also according to the C API manual, the mysql_real_connect will set the
automatic reconnect flag in MYSQL structure.
However, I cannot find any instruction to switch off this automatic
reconn
Hi all.
I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed
MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with
parameter --nodeps.
So I try to install Mysql modules for Perl.
First I try with RedHat 7.2 rpm package but it didn't work. It needs
libmysqlclien
I have a question about innodb, some of my users get an error code 1114
saying that a table on an innodb database is full.
When I do a show table status i get the following size comments (all
tables display one or another of these two).
Comment: InnoDB free: 5849088 kB; InnoDB free: 3072 kB
Commen
>From the Manual:
How to reset a forgotten root password.
http://www.mysql.com/doc/en/Resetting_permissions.html
Also, don't forget -p when connecting as root.
Quoting Marc Dirix <[EMAIL PROTECTED]>:
> Hi there
> Problem:
>
> I've got two debian linux pc's
> One is my server on which I would
Mario,
Friday, October 18, 2002, 11:57:18 AM, you wrote:
MN> How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux
MN> RedHat 7.3)?
MN> Does anyone know a solution ?
Work with BLOB fields as with usual fields, but don't forget to escape
chars. You can also use LOAD_FILE()
Hi all.
I installed MySQL 4.0.4 in RedHat 7.2 using rpms. Also I installed
MySQL-bench rpm package, it saids it needs DBD-MySQL and I isntall it with
parameter --nodeps.
So I try to install Mysql modules for Perl.
First I try with RedHat 7.2 rpm package but it didn't work. It needs
libmysqlclien
Very new to MySQL and I've done a search on
google.com, but really couldn't find the answer that I
am looking for.
Where should I install MySQL? I'm running RH 7.3 and
I've installed the tgz file under my directory
/home/CMMiller, is this right, or anywhere else? I
see it is also under /usr/s
If its a binary data then you have to properly escaped it with \ otherwise
it wont get inserted
Rest is same like any other insert statement.
Insane
SQLyog - The Definative GUI for MySQL
http://www.webyog.com/sqlyog
- Original Message -
From: "Mario Nicoletti" <[EMAIL PROTECTED]>
To: <[EM
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
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
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
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
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
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
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
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@
>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
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
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
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
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
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
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
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
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/
__ ___ ___
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
-
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
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.
>
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
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
1 - 100 of 178 matches
Mail list logo
