*Please respond before Wednesday, January 29, 2003, if at all possible. *
I am using a PowerMac G4, Mac OS Version 10.2.1. I wanted to learn mySQL so I brought
a book entitled, "SQL Weekend Crash Course." Allen G. Taylor is the author and the
ISBN # 0-7645-4901-4. It has a CD-Rom (the CAUGH
At 4:52 PM -0600 1/27/03, Paul DuBois wrote:
At 14:38 -0800 1/27/03, Jeremy Zawodny wrote:
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a
I am running mysql 3.23, and want to know if I can set the default value
of a column to to_days(now()), or the equivelant. I have tried this,
and the default gets translated to 0.
Thanks
Carlin
-
Before posting, please check:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
...
% backing up my MySQL databases on a Win2K box at home to a Linux box in
...
% hand, I have only 128 MBit upstream from my Win machine, and maybe you
% will have a faster network conn
On Mon, Jan 27, 2003 at 02:21:18PM -0700, Mike Doanh Tran wrote:
> Hi all,
>
> How do i undo the last transaction in mysql?
ROLLBACK
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.8: up 0 days, processed 329,766
On Mon, Jan 27, 2003 at 04:52:40PM -0600, Paul DuBois wrote:
>
> Maybe I should work up a snappy slogan like: 65% more pages, but
> only 25% more thickness!
>
> I guess that's not too snappy. But a'm glad they used thin enough paper
> that it didn't turn into a completely giant book.
If there h
-- this is a resend, its been over an hour, and the 1st hasn't shown up on
the list yet. i'm assuming my mail server dropped it --
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
>a few lines from /etc/mysq
On Mon, 2003-01-27 at 11:23, Pedro Leite wrote:
> Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
> don't ask me why, I'm new to this things.
>
> Any more help would be much appreciated.
> TIA
That's the directory where it should be.
You can also start with
service mysq
Any help from good samaritans? I have no idea to solve this mess!
TIA
- Original Message -
From: "Pedro Leite" <[EMAIL PROTECTED]>
To: "TdA" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 10:23 AM
Subject: Re: mysql.sock is missing
> Hi, I'm getting the same e
If I manually shut down mysql, I usaully use the mysqladmin shutdown
command. However, I noticed that the "red hat" way of stopping mysql in
its init scripts is by issuing a "kill" command to the pid. U, is
this wise? What about if the tables aren't written to disk? Isn't the
"proper" way
At 14:21 -0700 1/27/03, Mike Doanh Tran wrote:
Hi all,
How do i undo the last transaction in mysql?
If you've committed it, you don't. The point of COMMIT is that it
won't be undone.
If you haven't committed it, use ROLLBACK.
Thanks for any suggestions.
Mike
---
Assuming you logging in from the same server on which mysqld is
running, you need a dmiller@localhost user. The "%" wildcard is valid
only for tcp connections. This is thoroughly explained in the MySQL
manual, chapter 4.3.5.
hth,
Doug
On Mon, 27 Jan 2003 15:03:35 -0500, Devin Miller wrote:
>I
- Original Message -
From: "Devin Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 9:03 PM
Subject: Adding a user problem
> I am pretty new to mysql and have been teaching myself slowly how
> to use it. I am however stuck on a problem. I login to mysql a
[2003/1/28 ¤W¤È 07:51:[EMAIL PROTECTED]]
mysql0a01/2807:51:08
³nÅé¦v°tºô01¤ë27¤é·|û§ó·s³qª¾
-
¥»«H¥ó¥Ñ¨§¨§Às¤u§@«Ç¥Nµo,½Ð¤Åª½±µ¦^«H,³o¼Ë§ÚÌ·|¦¬¤£¨ìªº
¦p¤£·Q¦¬¨ì,½Ð¤Wºô§iª¾,§ÚÌ·|±N§Aªº¦W³æ§R°£ªº
--
Hi!
Over the past 2 years several users have complained about optimization of
queries of type
... WHERE col < x;
... WHERE col <= x;
... WHERE col > x;
... WHERE col >= x;
and, indeed, there was a major bug in the InnoDB query estimator. The fix
appears in 4.0.10 and 3.23.56.
"
MySQL/InnoDB-3.2
>>Please can someone tell me how to run a SELECT between databases on a
network. I want to SELECT some data >>from a mySQL server named PC1 to a
table on a second mySQL server named PC2. Thanks in advance.
Hi,
As long as you have a valid logon for each of the databases on each of the
servers, you
Devin,
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> IDENTIFIED BY "password";
>
> The command returns a Query ok and 0 rows affected. However, when I
try to
> login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied
error.
With "mysql -u dmiller -p", the hostname will be "loc
Devin Miller wrote:
>
> I am pretty new to mysql and have been teaching myself slowly how to use
it.
> I am however stuck on a problem. I login to mysql as user root and created
a
> database named devin. I then issue the following commands:
>
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> I
installed mysql onto debian using a deb file. it is running locally fine,
but it isn't openning a TCP port for remote connections to it.
>a few lines from /etc/mysql/my.cnf
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
At 15:03 -0500 1/27/03, Devin Miller wrote:
I am pretty new to mysql and have been teaching myself slowly how to use it.
I am however stuck on a problem. I login to mysql as user root and created a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO dmill
At 14:38 -0800 1/27/03, Jeremy Zawodny wrote:
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a. "Doorstop II") is now available.
Informatio
On Mon, Jan 27, 2003 at 01:17:26PM -0600, Paul DuBois wrote:
> Okay, it seems that the book is making its way to the booksellers now,
> so it's time for a general announcement:
>
> MySQL, Second Edition (a.k.a. "Doorstop II") is now available.
> Information is available at the companion web site,
Anne,
- Original Message -
From: "Anne" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, January 27, 2003 7:35 PM
Subject: Recover mysql database from hotbackup. This is Urgent!!!
> Hi,
>
> We are performing daily hotbackup of the mysql database using the
> script whi
Anybody have an idea about the following error (Errcode: 13)? I am simply
trying to add one more field in the table timesheet.
My phpMySQL version is 3.23.55-nt
Thanks.
-Dhanashri Peramanu
Hi all,
How do i undo the last transaction in mysql?
Thanks for any suggestions.
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Very unlikely. I'm only using 7% of the disk capacity.
gerald_clark wrote:
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF34554
Greetings,
I would like to set up cron jobs on my servers to make backups of my
databases:
1. The reference manual recommends mysqlhotcopy over mysqldump. Any
opinions?
2. What format does mysqlhotcopy save in? sql files? csv?
3. Anyone else doing this with cron? I'd like to see a sampl
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no
I am pretty new to mysql and have been teaching myself slowly how to use it.
I am however stuck on a problem. I login to mysql as user root and created a
database named devin. I then issue the following commands:
GRANT ALL PRIVILEGES
ON devin.*
TO dmiller@"%"
IDENTIFIED BY "password";
The command
Okay, it seems that the book is making its way to the booksellers now,
so it's time for a general announcement:
MySQL, Second Edition (a.k.a. "Doorstop II") is now available.
Information is available at the companion web site, including
a page indicating what's new, links for downloading the accom
At 12:42 27/01/2003 +0100, Gilles Antonetti wrote:
Hi,
Hi there, I tried installing MySQL on Windows Server 2003 (RC1) for eval
and it doesn't seem to be able to start the mysql service.
Thanks for your hints
Gilles
I ran the mysqld service on Windows NET Server without problems,
now I going to
Obafemi,
> Please can someone tell me how to run a SELECT between databases on a
> network.
With MySQL, this is not possible. AFAIK there are no plans to implement
this in the near future, or to implement this feature at all.
Customers using MS SQL Server asked me the same thing, as MS SQL Serve
Vicente,
> I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section
> Variables, language has this value yet 'c:\mysql\share\english'
Does this look Spanish to you?
1064: Algo está equivocado en su sintax cerca '' en la linea 1
Maybe you didn't restart your MySQL server. Another pro
Heikki:
1. I am reading "Managing and using MySQL" from O'Reilly.
The book suggests (page 74) to use the -opt option, but that will make
the db go offline for all practically purposes.
Could I just use:
$ mysqldump --flush-logs mydb > /opt/backup/mydb
and have complete recovery and my users st
Hi,
For the moment you can't.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Isaac Anietye Inyang" <[EMAIL PRO
Hi all,
Sorry to bother the list, since I'm pretty sure the answer is no, but
I'm trying to figure out if it's possible to prevent a user from
dropping some tables in a database while allowing him/her to drop
others. I've seen requests on the list for something similar, but not
a solution.
Sp
>Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no other processes active, says SHOW
PROCESSLIST. The table (myISAM) has l
* Petre Agenbag
> I am having trouble with a query to return only one instance of a name
> in a table.
SELECT DISTINCT name FROM table
> For instance:
>
> idnametowndate
> 1 jacktown1 2002-12-12
> 2 johntown2 2002-12-13
> 3 jacktown4 2002-12-21
> 4 ja
Hi
Sorry if I'm just being feeble minded here but I can't get this to work.
First I take a copy of my database using:
mysqlhotcopy --allowold --noindices db_name /path/path
using the '--noindices' since it says
"--noindices
Don't include full index files in copy to make the backup smaller and f
Duncan Maitland wrote:
>
> I am installing MySQL 4.0.9 on a server running Red Hat 8.0 but am
> running into some showstoppers. I seem to have success compiling - no
> warnings are raised - but mysql_install_db will crash when installing
> the grant tables.
>
> Initially I thought it may have bee
We have been receiving this error frequently
from our mysqlser about our webserver.
1129: Host 'ip-adress' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts'
This is getting anyoing.
Can someone tell me if there is a way
to disable this feature for a certain list
Hi, I'm getting the same error message. mysql here is in /etc/rc.d/init.d,
don't ask me why, I'm new to this things.
Any more help would be much appreciated.
TIA
- Original Message -
From: "TdA" <[EMAIL PROTECTED]>
To: "Pedro Leite" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, Ja
On Mon, 20 Jan 2003, Ed Reed wrote:
> Does anyone have a list of manufactures of financial packages that will
> run with MySQL?
Gnucash 1.7.8 has a PostgreSQL interface. It's about time that someone
adapts the package to MySQL.
Thomas Spahni
--
filter: SQL query
int a=1,b,c=2800,d,e,f[2801
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> Is anyone else seeing it take 4-8 hours for mail to get thru this list
Jeremy> recently?
Normally emails should be delivered quickly; We do however have a
problem in that if there is some problems with the Internet line f
Hi
I am having trouble with a query to return only one instance of a name
in a table.
For instance:
id nametowndate
1 jacktown1 2002-12-12
2 johntown2 2002-12-13
3 jacktown4 2002-12-21
4 jacktown5 2002-12-30
5 johntown2 2002
Hello
Please can someone tell me how to run a SELECT between databases on a
network.
I want to SELECT some data from a mySQL server named PC1 to a table on a
second mySQL server named PC2.
Thanks in advance.
Isaac Anietye Inyang
Systems Engineer
Cooperative Information Network
Obafemi Awolowo Uni
Greetings
Does anyone know the exact syntax to dump all mysql databases, but some of
them have blob columns. When I execute mysqldump --all-databases mysqldump
doesn't work properly whein it reaches these blobs. So I need only syntax to
backup everything and restore everything back without having
Hello all,
I suppose that there is a bug in the mysqlcc version 0.8.9-beta (Windows)
and previous versions 0.8.7 and 0.8.8.
The bug is repeatable in different constellations:
1.1) Connecting to a localhost server (version 3.23.39-max-nt) as user
'',
1.2) Trying to open e second connection to t
Steve,
Exactly, the lcreceive has multiple records that match
an id in lcopen. I use mysqldump to create an
enclosed file - wood.sql for your reference. The
database name of my file is "wood", it contains 2
tables "lcopen" and "lcreceive". "lcopen" contains
the letter of credits (L/C) I have op
There are a couple of things you can try, first make sure your process is
started. /etc/rc.d/ mysql start should do the trick.
TDA
- Original Message -
From: "Pedro Leite" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 26, 2003 11:04 PM
Subject: mysql.sock is missing
>
Hi,
I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section
Variables, language has this value yet 'c:\mysql\share\english'
- Original Message -
From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
To: "Vicente Valero" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monda
> I'm trying to get the Nth record of a query which i don't know nothing
> but the table name.
> I mean something like select * from table where . "give
> me the Nth result";
SELECT * FROM table LIMIT N,1 ;
Alec
--
Hi there, I tried installing MySQL on Windows Server 2003 (RC1) for eval
and it doesn't seem to be able to start the mysql service.
Thanks for your hints
Gilles
-
Before posting, please check:
http://www.mysql.com/manual.php
Vicente,
> How can I change my error language in SQL (MySQL)? Have I to introduce
a new
> set-variable in my.ini?
In the [mysqld] section of my.cnf / my.ini, type:
language=spanish
Alternatively, you can start mysqld with the --language=spanish option.
Regards,
--
Stefan Hinz <[EMAIL PROTECT
Hi,
select * from table where LIMIT HOW_MANY_RESULT_YOU_WISH;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "
* [EMAIL PROTECTED]
> I've been a member of this mailing list for quite a long time and very
> thankful that most of my difficulty in creating queries are being answered
> by just reading responses to questions. Right now I have a problem in
> creating a query (in fact I'm not sure if this is possi
will a LIMIT start,end work ?
>= Original Message From alx <[EMAIL PROTECTED]> =
>HI all
>I'm trying to get the Nth record of a query which i don't know nothing
>but the table name.
>
>I mean something like select * from table where . "give
>me the Nth result";
>
>I hope someone can he
Hi,
select * from table where LIMIT N,1
More details at:
http://www.mysql.com/doc/en/SELECT.html
Regards,
Joseph Bueno
alx wrote:
HI all
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where . "give
me th
hi guys i was wondering if sub selects were possible in mysql 4 ? more
specifically , whenever i do a join , i sometimes require a distinct select on
the field in the first table and the second table may have many rows therefore
returns the same value more than once from the first table which re
HI all
I'm trying to get the Nth record of a query which i don't know nothing
but the table name.
I mean something like select * from table where . "give
me the Nth result";
I hope someone can help me.
TIA
Bye
Alx
-
Befor
i think i am replying to this post abit late ..but go through this doc it
will probably help you
http://gurulabs.com/ext3-reiserfs.html
cheers
David Ziggy Lubowa
Network Engineer
One2net (U)
web: www.one2net.co.ug
Tel: +256 41 345466
-Original Message-
From: Nicholas Gaugler [mailto:[EM
Hello,
How can I change my error language in SQL (MySQL)? Have I to introduce a new
set-variable in my.ini?
Thanks
___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
-
hello list,
libmysql.c: In function `mysql_real_connect':
libmysql.c:1348: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.c:1348: too few arguments to function `gethostbyname_r'
libmysql.c:1348: warning: assignment makes pointer from integer without a
cast
make
Hello, I need help.
I want to create a table with a numeric primary key as index in my sql. I
want this
index will be automatic. I've tried an auto_increment column, but if insert
a non-correlative value then all new entries continue from this
non-correlative value (1,2,3,4,1026,1027,...). It is p
64 matches
Mail list logo
