Hi there,
Lost connection to MySQL server during query
This is an error message from MySQL when I try to connect to my remote
MySQL server. Does anyone know what this message mean. I'm completely
puzzled.
I used to make the same connection with the exactly the same command
routinely get connect
>From: Paul DuBois <[EMAIL PROTECTED]>
>
>At 12:58 +0200 10/10/02, Alex Polite wrote:
>>Is there any way I could display a MySQL database as a filesystem
>>under Linux?
>
>What does that mean?
There's a long (though obscure) history of using database-like engines as filesystems.
There are consid
Hi,
I have database that has grown in size, I want to see what ID files have
been deleted. Is there a way or do I have to print out the list and find
them myself?
Is there a sql or query statement that will let me find them.
Chuck Payne
On Saturday, Oct 12, 2002, at 04:24 America/Phoenix, Pierre Vaudrey
wrote:
> I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage
> package but I ran with the following error :
> [Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql
> dyld: mysql Undefined symbols:
> /sw/lib/libreadlin
we had the same problem. We had mysql and BIND running on single server.
Upgrading BIND helped to solve this problem.
.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org ::.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday,
On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote:
> Hello All:
> I am attempting to delete a table from a database,
> then recreate it and load data into the table.
> The drop and create commands are working properly,
> here's a screen dump:
>
> mysql> DROP TA
Recently our DB, which is running MySQL 3.23.52, started experiencing
intermittant load spikes, of the magnitude of 200+ load averages. Normally,
our high spike is about 0.90 load. When this starts happening, we notice a
lot of processes "cleaning up" within the database. Can someone clue me in
Here's something:
http://no.spam.ee/~tonu/modules.php?name=News&new_topic=2
Anthony
Jayce^ wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Actually, I remember reading about a mysqlfs system, like that, cd to a table,
>ls for records.. rm to remove and such. that was over a year ago
Hello,
#If I have a file "t.txt"
>>
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
<<
# A table
>>
CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
Hello
After a reboot, the database server running Redhat 7.2 and mySQL
3.23.41-1 started acting funny. When I try to telnet to port 3306 of the
server, nothing happens and when i check in the log file for mysql, i
get something like:
Number of processes running now: 1
mysqld process hanging, pi
Norris,
Saturday, October 12, 2002, 2:11:36 AM, you wrote:
NJ> I have the following query:
NJ> select phones.*, ops.plid, ops.box, ops.mac
NJ> from phones, ops where
NJ> (ops.box = 'Mcds') or (ops.box = 'Mn3300') and
NJ> (phones.suffix1 = ops.phone) order by ops.mac
NJ> When I change the or
>Description:
When I create a fulltext index I get:
ERROR 1005: Can't create table './inventory/#sql-4024_116c.frm' (errno: 140)
>How-To-Repeat:
alter table inventory.item add fulltext(storeId, catId, itemNo, title,
type, publisher, condition, color, subCategory, descri
Dear sir,
Please anybody could tell me how to start mysql-max to work with DB.
What i did : start mysqld like
./configure --prefix
=/usr/local/mysqlit starts like
Starting mysqld daemon with databases from
/usr/local/mysql-max-3.2
See the ZEROFILL column attribute:
http://www.mysql.com/doc/en/Column_types.html
http://www.mysql.com/doc/en/Numeric_types.html
If necessary, you can use an ALTER TABLE command to add that
attribute to the appropriate columns.
- steve
At 10:11 AM -0700 10/11/02, Bry
At 10:11 -0700 10/11/02, Bryan Koschmann - GKT wrote:
>Hi,
>
>Does MySQL provide for any way to "pad" a field? I have accounts numbers
>that vary from 3-5 digits, and would like them 8 digits padded by zeros
>(479 becomes 0479, 17234 becomes 00017234, etc). I know I could
>probably write a scr
Dear Sir/Madam,
I have tried the config below, and I successfully see the replicated record in
client side but only ONCE.
After I have seen the replication works. I continued with my normal
transactional work including altering table structure.
But later when I checked the replication status. Wel
Chuck,
> I have database that has grown in size, I want to see what ID files have
> been deleted. Is there a way or do I have to print out the list and find
> them myself?
Assuming by "files" you mean rows, and assuming a table named t1, a column
in it named id, and you having done something lik
I was wondering, what happens if two programs use the embedded mysql
library and try to access the same database?
Or, what happens if you run the mysql database server on the machine and
use the embedded mysql library to access a database?
how does the mysql lib require the application writer
Group,
I have the following query:
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
When I change the order by to a field in the phones table - sorts just fine
and produces results
There has been such a project for quite a while. Take a look at
http://no.spam.ee/~tonu/ and find the link about SQLFS.
j- k-
On Thursday 10 October 2002 02:58, Alex Polite wrote:
> Is there any way I could display a MySQL database as a filesystem
> under Linux?
>
> alex
--
Joshua Ku
Hi folks,
I am using the MySQL C++ API to put together a football management game.
I wont bore anyone with the implementation details, basically I would
like to know how to distribute the games database so that an end-user
does not need to have MySQL installed to run it. I am running MySQL
3.23
Hi there,
This is an error message from MySQL when I try to connect to my remote
MySQL server. Does anyone know what this message mean. I'm completely
puzzled.
I used to make the same connection with the exactly the same command
routinely get connected easily. But all in a sudden, I cannot
At 6:58 -0500 10/11/02, rick wrote:
>I know how to make a whole batch SQL script silent (-s option of
>mysql), but is there a way within a script to make one or more
>individual statements silent? In Oracle PL/SQL, it can be done
>using echo on/off and termout on/off.
Not really, though mayb
ok.
> At 10:10 -0400 10/11/02, Michael T. Babcock wrote:
> >John Ragan wrote:
> >
> >>try corereader. it will run queries against your mysql, oracle,
> >>and ms sql server (and anything else laying around). you can
> >>switch between your servers with a click.
> >>
> >Am I the only one gett
At 11:01 +0530 10/11/02, Insanely Great wrote:
>Greetings...
>
>I dont think that there is any SQL statement to do that.
>
>As of changing the name, You can just go to the data directory of MySQL and
>change the name of the directory of the database. MySQL stores each database
>as a directoyr so c
Hello All:
I am attempting to delete a table from a database,
then recreate it and load data into the table.
The drop and create commands are working properly,
here's a screen dump:
mysql> DROP TABLE IF EXISTS testthis;
Query OK, 0 rows affected (0.16 sec)
mysql> CREATE TABLE t
At 11:50 -0400 10/11/02, Edward Peloke wrote:
>sql query
>
>when I am defining a table, how do I set the default of a datetime column to
>the current time? I tried setting the default to now() but it just fills
>the column with 00:00 etc..
You don't. Default values must be constants.
The TIME
rick wrote:
>I know how to make a whole batch SQL script silent (-s option of mysql), but is there
>a way within a script to make one or more individual statements silent? In Oracle
>PL/SQL, it can be done using echo on/off and termout on/off.
>
>
Just for testing, I created a script "noecho
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, I remember reading about a mysqlfs system, like that, cd to a table,
ls for records.. rm to remove and such. that was over a year ago at least..
check sourceforge or google, I bet they'd be able to tell more. Archives
might too.
Jayce
At 13:15 +0300 10/11/02, Victoria Reznichenko wrote:
>Abhi,
>Thursday, October 10, 2002, 8:30:43 PM, you wrote:
>
>A> I am not able to connect mysql server after executing this command
>
>A> ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
>A> sort_buffer=4M -O read_buffer_size=1M
T
Group,
I have the following query:
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
When I change the order by to a field in the phones table - sorts just fine
and produces results
>Description:
Server version 3.23.49-log
Protocol version10
OS Linux atlas 2.4.18-5smp #1
Mysqld two days ago began to crash on accepting non-local mysql connections. After a
day of database testing and debug researching I used the --skip-name-resolve in t
We found the same thing, after installing the glibc auto-rpm from Redhat.
The updated glibc packages from Red Hat will whack your
/etc/nsswitch.conf file. That is, it will mess with the order of how
things are searched for.
We noticed this with mysql not being able resolve remote server IPs.
Group,
I have the following query:
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
When I change the order by to a field in the phones table - sorts just fine
and produces results
I had the same problem. No, in MySQL you can't. But
you can use number_format() function of PHP. Check PHP
Manual for How-to
Nikos
--- Putte Koivisto <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
> Is there a simple solution to define MySQL to use
> comma i
Tim,
Saturday, October 12, 2002, 1:21:59 AM, you wrote:
TJ> I am attempting to delete a table from a database,
TJ> then recreate it and load data into the table.
TJ> The drop and create commands are working properly,
TJ> here's a screen dump:
TJ> mysql> DROP TABLE IF EXISTS tes
Is there a way to find out what index an sql query is using? I know you can
use explain, but those are just "possible" indexes that the query might use.
I'm trying to find out exacly what execution path it is taking. Something
similar to Oracle's "set autotrace on;"
MySql version - MySQL-Max-3
Pretty interesting stuff:
http://www.osnews.com/story.php?news_id=836
http://newsforge.com/article.pl?sid=02/03/22/204220&tid=9
Anthony
Anthony W. Marino
Pres./CTO, AWM Objects
David Garamond wrote:
> Jan Steinman wrote:
>
>> Today's "modern" operating systems really stopped evolving in th
At 10:10 -0400 10/11/02, Michael T. Babcock wrote:
>John Ragan wrote:
>
>>try corereader. it will run queries against your mysql, oracle,
>>and ms sql server (and anything else laying around). you can
>>switch between your servers with a click.
>>
>Am I the only one getting tired of these non-
On Thu, Oct 10, 2002 at 05:56:31PM -0500, Paul DuBois wrote:
> At 12:58 +0200 10/10/02, Alex Polite wrote:
> >Is there any way I could display a MySQL database as a filesystem
> >under Linux?
>
> What does that mean?
What I want is a device that actually is an interface to a db table.
I mount (r
At 12:58 Uhr +0200 10.10.2002, Alex Polite wrote:
>Is there any way I could display a MySQL database as a filesystem
>under Linux?
We have created a virtual filesystem using MySQL as storage, using
the LD_PRELOAD version of AVFS. The filesystem logic is written in
Perl (embedded perl interprete
I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage
package but I ran with the following error :
[Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql
dyld: mysql Undefined symbols:
/sw/lib/libreadline.4.2.dylib undefined reference to _tgetent expected
to be defined in /usr/lib/libSyste
Perumal,
Saturday, October 12, 2002, 11:27:44 AM, you wrote:
P> Please anybody could tell me how to start mysql-max to work with DB.
P> What i did : start mysqld like
P> ./configure --prefix
P> =/usr/local/mysqlit starts like
P> S
Tonino,
Friday, October 11, 2002, 10:05:42 AM, you wrote:
T> Just a short question - Does anyone know the progress of stored
T> procedure support in MySQL 4
Stored procedures will come in v5.0
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spon
Paul,
Thursday, October 10, 2002, 5:59:39 PM, you wrote:
PG> i would like to know if row level grants are in development
PG> or are planned to be soon.
PG> i am writing a software and i need row level grants,
PG> so i would like to know if i'd better wait for mysql to include
PG> this feature or
jfield,
Thursday, October 10, 2002, 1:33:10 AM, you wrote:
jazdc> After adding a key to a nullable column, null values will
jazdc> successfully join through to null values in other tables.
jazdc> This only seems to happen when the index is added after
jazdc> the row contains null values. This af
Anthony,
Friday, October 11, 2002, 5:26:39 AM, you wrote:
AWM> There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
AWM> this users environment (RH 7.3).
AWM> "my.cnf" has been modified to include individual "user", "port" ,
AWM> "bind-address" and "host" specifics (and etc
At 15:46 +0200 10/11/02, Alex Polite wrote:
>On Thu, Oct 10, 2002 at 05:56:31PM -0500, Paul DuBois wrote:
>> At 12:58 +0200 10/10/02, Alex Polite wrote:
>> >Is there any way I could display a MySQL database as a filesystem
>> >under Linux?
>>
>> What does that mean?
>
>What I want is a device
Hi,
Does MySQL provide for any way to "pad" a field? I have accounts numbers
that vary from 3-5 digits, and would like them 8 digits padded by zeros
(479 becomes 0479, 17234 becomes 00017234, etc). I know I could
probably write a script to fix that before entering the data into the
database,
Ok, I've been having this problem every so often and it's happening
more and more these days and I still can't figure out a solution. I
know this sounds vague, but maybe you can help me make it less so...
I'm running version 3.23.44 and after a while, the maximum number of
connections is reac
hi guyz
i ve to alter my table n make two fields primary key
(well the combination of the two to be xact)
any idea how to do dis ?
thnx a mill
toby
:S:S:S:S:S:S:S mysql query :S:S:S:S:S:S:S
_
Join the worlds largest
51 matches
Mail list logo
