If I am your customer and the data related to my web contents and/or
services stored(this is more than likely if the hosting service is used)
in the database at your site, I would definitely claim that the access to
data will be appropriate. Ex, You have Web services using a hosting
service. And
On Wed, 2002-11-27 at 17:05, toby z wrote:
ok guyz i need some inside info .
plz help me with:
2. if i ve to conver a db in foxpro to mysql or sql which one should i
preffer and y
pz do nt use thz hax0r w0rdz
It is really hard to read. Many people here do not speak english
Keys: sql, query
Hi Steve,
I got your email from the MYSQL list, and I undertood that you have
some experience about using Mysql tables in an application developed
by Delphi.
I am just at the begining of the way. Still I am dying to get any response
or see the already existing defined tables of
Hi.
I have a perl script that uses many temporary tables (HEAP mostly) and when running
the script many times in parallel some of the script instances fail.
The query uses temporary tables and recently I discovered that some
of the queries uses filesort (disk access) due to GROUP BY
making the
thnx fo takin the time to reply anyways . :(
toby ..
From: Tonu Samuel [EMAIL PROTECTED]
To: toby z [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: converting from foxpro to mysql ???
Date: 28 Nov 2002 11:47:45 +0200
On Wed, 2002-11-27 at 17:05, toby z wrote:
ok guyz i
I do speak English natively, and I haven't a clue what you're talking about
either.
Andy
mysql query
-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: 28 November 2002 09:48
To: toby z
Cc: [EMAIL PROTECTED]
Subject: Re: converting from foxpro to mysql ???
The environment info was copied from the mysqlbug command by our external
hosting company who truncated the lines therefore the last couple of
characters from each line is not there however it was a Solaris 2.8 binary
download of 4.0.5beta so you would have all of the info anyway.
Description:
Description:
A website we recently built contains a highscore table. People play a game, and can
then submit their name and score to the table.
When viewing the table, I then need to rank the scores using an order by... However
since I want to be able to only select arbitrary intervals in the
Hi All,
I'm writing a application that needs row level security in it so that
only certain users can view/change etc. certain records. I know that
MySQL currently does not have row level security, and when I've asked
this list before I've been given some helpfull suggestions (although
none
Hi Manuel,
On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote:
Hi,
I have a few questions regarding recovery of a database using binary logs.
1) If you have a set of binary logs in your directory mylog-bin.001 to
mylog-bin.nmp, is there an easy way to find out which logs you need to
Michael,
- Original Message -
From: Michael Ryan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 28, 2002 12:34 PM
Subject: Bug Report: Replication in 4.0.5beta
The environment info was copied from the mysqlbug command by our
external
hosting company who
Noel,
I'm sorry if this is obvious, but have you considered putting a firewall in
the way?
If your application is on the same machine as the database, block all
connections except to the port your application runs on (ie probably 80 if
it's a web application)? The firewall will block
Hi, doeas anyone know if it's possible to add 2 or more numeric values
together that are in the same cell in Mysql:
IE: i have a cloumn called price that for any entry may contain more
than one value, lets say £1.00 and £2.00
Is there a way that i can get these values added together ?
I
On Thu, Nov 28, 2002 at 12:48:29PM +, Steve Mansfield wrote:
Hi, doeas anyone know if it's possible to add 2 or more numeric values
together that are in the same cell in Mysql:
IE: i have a cloumn called price that for any entry may contain more
than one value, lets say £1.00 and £2.00
You appear to be violating the repeating value rules of relational
database. Multivalue databases (Pick and Pick like) support this concept
but they are rather uncommon now. You probably need to create a related
table. Actually, you might want to do a little study on the general idea of
Hi all,
I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru
win2000 with using any Front End applications
(SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am
getting the same error message: Error No: 2013 Lost Connection
MySQL server during query. I am being
Hi.
One of my friend, with MySQL v. 3.22.32 and with this commands :
CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
have this error:
MySQL complains:
Column 'con' is used with UNIQUE or INDEX but is not defined as
Dear Mr. / Mrs,
After we installed MySQL Server 3.23.51 for Windows and MySQL Gui
1.7.5-2.
We used a ODBC driver to write data into the database on the MySQL
Server.
When there are more then 250.000 records in the table the MySQL Gui
crashed.
Our Question now is there a solution for our
Hello all ---
I posted this yesterday, perhaps before my subscription took effect,
and so I am not sure that it got distributed. So, forgive the
repetition in sending, if that's the case. Anyway . . .
Here's the question, as succinctly as I can formulate it:
The documentation seems to
Sorry to insist, but nobody has any clues about this ?
I can supply further info if needed.
Is the FLUSH TABLES WITH READ LOCK functionality well tested ?
Having corrupted backups is annoying, and I can't really
take the system down for a 4-hour tape backup... ;(
Message original
* Marco Andriolo-Stagno
One of my friend, with MySQL v. 3.22.32 and with this commands :
CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
have this error:
MySQL complains:
Column 'con' is used with UNIQUE or
The MySQL Manual states the following in the LOAD DATA INFILE section :-
If a filename with no leading components is given, the server looks for the file in
the database directory of the current database.
-Original Message-
From: John Connolly [mailto:[EMAIL PROTECTED]]
Sent: 28
mysql 4.0.5a binary crashed with following error messages.
What's the problem? :(
021128 11:06:23 Slave I/O thread: connected to master
'austin@atis1:3306', replication started in log 'FIRST' at position 4
021128 17:35:52 Slave: received 0 length packet from server, apparent
master
EMS HiTech Company is announcing the next version (1.1) of MySQL Utils --
Powerful Windows/Linix Data Management Utilities for MySQL Server.
You can download the latest version from
http://www.mysqlutils.com/download.phtml
What's new in version 1.1?
1. MySQL Import: possibility of defining
Alice,
Thursday, November 28, 2002, 8:29:14 AM, you wrote:
AT i did create those databases in different databases directories.
AT i saw there r columns_priv, db, host, tables_priv and user tables in the
AT mySQL database directory. Is all these tables control the user data access ?
Yes.
AT and
puckman,
Thursday, November 28, 2002, 12:46:15 PM, you wrote:
patdc A website we recently built contains a highscore table. People play a game, and
can then submit their name and score to the table.
patdc When viewing the table, I then need to rank the scores using an order by...
However since
Marco,
Thursday, November 28, 2002, 3:36:22 PM, you wrote:
MAS One of my friend, with MySQL v. 3.22.32 and with this commands :
MAS CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
MAS varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
MAS have this error:
MAS MySQL
John,
Thursday, November 28, 2002, 2:12:27 AM, you wrote:
JC Here's the question, as succinctly as I can formulate it:
JC The documentation seems to say that one can load a tab-delimited
text
JC file located in the current directory of the client host into a
I have upgraded from 3.23 to 4.0 and I have read over
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up
grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I
really want to since I intend to implement query quotas.
Since this is a production
Hey,
The chroot command line option of mysqld is insecure. Databases which
are located for instance not in the chroot path can be accessed!
More information can be found at
http://www.linuxquestions.org/questions/showthread.php?s=threadid=34314
At 10:50 -0500 11/28/02, Gary Huntress wrote:
I have upgraded from 3.23 to 4.0 and I have read over
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up
grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I
really want to since I intend to implement
On Mon, Nov 25, 2002 at 06:02:19PM -0600, Andy Bakun wrote:
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A-B-C-A relationship, but I only did it with two servers
and I don't have
On Tue, Nov 26, 2002 at 09:39:04AM -0500, Michael T. Babcock wrote:
Is there any plan to be able to have multiple slaves for a master (each
for different databases)?
You can do that today.
I'd like to have a backup site that remotely replicates user data from
multiple sites ... any ideas?
I've done a similar work in 1997 for one of my clients. The password
method will be just part of the security system. But you may want
to consider to implement the RBAC in the database. In that way,
the users whether they are applications, e.g., business objects,
DB interactive tool by human user,
Victoria and Michael:
Thanks very much.
Following on your suggestions, I then went ahead and put the text file
into my directory:
/usr/local/mysql
so that the file was then /usr/local/mysql/absence.txt
and, with that done, the
LOAD DATA LOCAL INFILE absence.txt into table absence;
Hello!
pre
I have MySQL database with data like
name points
a20
b20
c19
d18
e18
is it possible to get with mysql commands ONLY outpt
place repeatings name points
1 2 a 20
1 2 b 20
3 1 c 19
4 2 d 18
4 2 e 18
/pre
first column shows how many persons have beter
Hi!
On Nov 28, Markus wrote:
Hey,
The chroot command line option of mysqld is insecure. Databases which
are located for instance not in the chroot path can be accessed!
Fixed, thanks.
More information can be found at
Hey,
Fixed, thanks.
Good to know. Anyways I'll check it out in the next release!
I always wondered why people spend so much time discussing a bug and
developing various howto and workarounds, instead of submitting a
bugreport and having the bug fixed in one hour. :))
I submitted the bug
On Thu, Nov 28, 2002 at 08:39:06AM -0800, Jeremy Zawodny wrote:
I'd like to have a backup site that remotely replicates user data from
multiple sites ... any ideas?
Oh, that sounds like multiple masters for a single slave. Is that
what you're getting at?
Yes, sorry, I rephrased it
On Thu, Nov 28, 2002 at 02:35:15PM -0500, Michael T. Babcock wrote:
On Thu, Nov 28, 2002 at 08:39:06AM -0800, Jeremy Zawodny wrote:
I'd like to have a backup site that remotely replicates user data from
multiple sites ... any ideas?
Oh, that sounds like multiple masters for a single
i was trying to install mysqlcc and when i execute setup.exe icon it shows
me as follow: windows installer service cannot install the installation
package. You must install a windoes service pack with a most recent
version of the wimdoes installer service .
My OS is windows 98 and i downloaded the
Hi everyone,
Please pardon my extreme case of the NEWBs on this but I need some help please.
Ok I just purchased a book to hopefully clear things up for me, but to no
avail. So this is my dilemma: I want to know about MySQL administration,
specifically the user management portion of the admining.
On Thursday, November 28, 2002, at 08:06 AM, BobJ wrote:
You appear to be violating the repeating value rules of relational
database. Multivalue databases (Pick and Pick like) support this
concept
but they are rather uncommon now. You probably need to create a
related
table. Actually, you
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot see other
customers' databases. (It's more likely that you won't attack
Hi
I wonder if anyone can help or point me in the right direction for this
problem.
Warning: Supplied argument is not a valid MySQL result resource
I get this while running index.php, the site did work then suddenly stopped,
the index.php hasnt been changed.
Machine : Cobalt RAQ4
Hi
It means you are refering to/using a result id that does not exist. Maybe
the query changed or the database is down?
Try echoing the query and the error
echo mysql_error ( [resource link_identifier])
if not could you send more details to give us a little more to go on
Peter
Have MySQL db with hundreds of thousands of event records from
geographically dispersed logging devices. The logs are batched and
auto loaded/parsed into MySQL on a daily/weekly basis depending on
external factors. As an example, during a 7 period, one device
provided 128,000 discrete events of
At 15:18 -0800 11/28/02, [EMAIL PROTECTED] wrote:
Have MySQL db with hundreds of thousands of event records from
geographically dispersed logging devices. The logs are batched and
auto loaded/parsed into MySQL on a daily/weekly basis depending on
external factors. As an example, during a 7
At 22:32 +0100 11/28/02, Stefan Hinz, iConnect (Berlin) wrote:
Dear Lenz,
Removed variable `safe_show_database' as it was not used anymore.
What will ISPs say about this one? They use 'safe_show_database' for their
MySQL setups, so their customers on virtual MySQL hosts cannot see other
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a
value of
-MM-DD HH:MM:SS. Is this value in a form of string?? If I have a
column described as DATETIME data type I should be able to do:
INSERT INTO tablename VALUES (id#, 1997-10-10 24:45:32), right?
but if I do SELECT *
At 15:39 -0800 11/28/02, David Wu wrote:
Hi guys, In mysql, I need to know the SELECT DATETIME(); returns a value of
-MM-DD HH:MM:SS. Is this value in a form of string?? If I have a
column described as DATETIME data type I should be able to do:
INSERT INTO tablename VALUES (id#, 1997-10-10
of course i will full access on those databases in all the databases store
in
our server, and i able to view/update all of them.
but what i meant is my customer want to have the access on their database.
and i don't want them to view those databases that not belongs to the
particular customer.
Hi
I am trying to insert a record to SQLServer database and gettign the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The name 'Mr' is not permitted in this context. Only constants, expressions, or
variables allowed here. Column names are not permitted
Any idea ?
Hi
I'm programming using FLTK Toolkit, mysql 3.23.52 (from source code ) and
mysql++ 1.7.9. On win32, i'm using Visual Studio 6.0 and c++ on GNU/Linux.
On win32, it's ok, but on GNU/Linux Debian, has these errors. But who can I
correct it ?
The source academia.cpp compiles ok, but atletas.cpp
Okay, here we go ...
I would like to do a FULLTEXT search against a query result. There are
multiple columns that have a FULLTEXT index. Hopefully I break this
down in a manner that can be understood.
The fields of interest:
Table events:
event_id [int(11)]
event [varchar(255)]
description
hi,
I now test Mysql+innodb performance, my platform is Solarise 5.8 1G RAM .
I use my-huge.cnf, set the buffer_pool_size = 400M , my bench table is about 100M .
I run 10 threads to Query a innodb table. Query 1* 10 thread would cost 30 second
. When I look the Innodb monitor , i
Hi all,
I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru
win2000 with using any Front End applications
(SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am
getting the same error message: Error No: 2013 Lost Connection
MySQL server during query. I am
My table structure is very simple and does not use big column like
text nor blub at all.
But when I load several million rows into master server using
mysqlimport, on slave I
got the error like
021129 13:24:40 Error reading packet from server: log event entry
exceeded max_allowed_packet;
Hi
I was working with mysql 3.23.41 on linux.
I was able to store and retrieve japanese characters from the db using java
code. I am using Shift_JIS encoding.
yesterday I took a dump of my database and restored it in another linux
machine having mysql 3.23.38.
But now my code is outputting
Hi all,
I am trying to connect to mysql server (3.23.52) on Linux Redhat 8 thru
win2000 with using any Front End applications
(SQLyog251, MySqlwinadmin, winmysqladmin, ...). On every try, I am
getting the same error message: Error No: 2013 Lost Connection
MySQL server during query. I
60 matches
Mail list logo