Erv,
Does MySQL have anything functionally equivalent to the data dictionary
views of Oracle? I am thinking particularly of retrieving, via a SQL
SELECT statement, a list of all my tables, or a list of all the columns of
a particular table along with the columns' attributes.
Installed as
try http://www.appsolute.nl/heraut/
you can use importerscript to run db_dump.sql from you M$ SQL Server into
dezign and then change the db type to mysql.
hth
Norman
-Original Message-
From: Stan Lester [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2002 18:35
To: [EMAIL PROTECTED]
Hello Heikki,
Saturday, January 05, 2002, 11:55:02 PM, you wrote:
Hello mysql,
I'm using mysql 3.23.47 with Innodb and trying to play around with
replication. The replication options are default.
I got one table content occasionally deleted on slave, and note what
HT Who deleted the
Hi!
fil == fil krohnengold [EMAIL PROTECTED] writes:
fil [gcc version 2.95.2; mysql 3.23.47]
cut
fil ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
fil rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.*
fil .libs/libmysqlclient.*
fil
fil ... then I'm stuck there for hours.
Hi,
I have a redhat server, running apache 1.3.20. The server is running a
couple of virtual servers for different websites. I now wish to add a few
new virtual servers/domains to the machine. However (here is the twist)
these sites will need to use a different mysql schema each and have some
Hello,
I have a small Linux server on my company (Pentium-133 with 16 RAM)
and recently i installed mysql-3.23.37 for collect statistics from
proxy. But then i look at ps out, i saw this:
ps -axl|grep mysql
VSZ RSS
... 17840 116453 SW ? 0:00 [safe_mysql
... 10324 4300
Hi
I implemented replication in my databases, and I can see a security problem.
When you configure the slave you must write the replication user password in
the my.cnf file. If somebody access this file will see the password and the
user name, so if he can and want he will get access to the
Sergey Potapov a écrit :
Hello,
I have a small Linux server on my company (Pentium-133 with 16 RAM)
and recently i installed mysql-3.23.37 for collect statistics from
proxy. But then i look at ps out, i saw this:
ps -axl|grep mysql
VSZ RSS
... 17840 116453 SW ?
Hi John
I've been using 3.x for over 18 months now, i upgrade my dev. system to the
latest release as soon as it's available.
However, i deploy projects to many different servers usually running old
versions of 3.x and i've been caught out a couple of times; it's not a
pleasant feeling when you
Hi
If you want to change port from eg 3306 to 3308 then edit the [mysqld]
section in the my.ini file in \winnt to :
[mysqld]
port=3308
Save the file, then restart the service.
To check if the port opened succesfully do netstat -a in the command
prompt.
If that doesn't work, then email me
Matthew:
There is no 'twist' here ... once your Apache server is configured to
support MySQL and PHP, just design the appropriate schema for each website
and create a database for each site requiring MySQL support.
I would suggest you pick up one (or more) of the books available on MySQL
and
* Matthew Darcy
I have a redhat server, running apache 1.3.20. The server is running a
couple of virtual servers for different websites. I now wish to add a few
new virtual servers/domains to the machine. However (here is the twist)
these sites will need to use a different mysql schema each
You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site.
Must be a commercial package or subscription service.
Gerald Jensen
- Original Message -
From: Norman Khine [EMAIL PROTECTED]
To: Stan Lester [EMAIL PROTECTED]
Cc: Mysql [EMAIL PROTECTED]
Sent: Sunday, January
Why not just create separate databases for each virtual server? It sounds
like a perfect situation to create multiple databases, as databases do
provide data separation...
mysql create database Virtual1;
mysql create database Virtual2;
mysql create database Virtual3;
mysql create database
Sorry, I forwarded this worng the first time...
--Brian
-Original Message-
From: Brian E. Beck [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 06, 2002 8:17 AM
To: j.urban
Subject: RE: Using MYSQL and PHP With Vitual Apache Servers ?
In fact, I run 30 virtual servers, and 10 of them
I have a file (data.txt) which contains the data:
ELITEô85.ôQô4 DaysôLilleshallôChris
IMPô75.ôQôTuesFriôLilleshallôSue
LEFTô0.ôôôLeftô
PRESCô24.ôTôOne DayôWrekinôArleen
RECô27.ôQôTuesôWrekinôTony
I use the LOAD DATA DDL statement:
LOAD DATA LOCAL INFILE data.txt INTO TABLE
HI all,
I would be extremely appreciative with solution
suggestions to the problem I am having.
I really could use some help right now !!
I am trying to get a database driven website up and
running that has some amount of security on it (which
i intend to make progresively better). It needs
Yeah useful but that still doesn't solve my problem
-Original Message-
From: Maciek Dobrzanski [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 17:43
To: David Ayliffe; 'MySQL'
Subject: Re: Strange LOAD DATA problem
Also I use the field delimiter ô (ALT+147) because the data MAY
At 17:36 + 1/6/02, David Ayliffe wrote:
I have a file (data.txt) which contains the data:
ELITEô85.ôQô4 DaysôLilleshallôChris
IMPô75.ôQôTuesFriôLilleshallôSue
LEFTô0.ôôôLeftô
PRESCô24.ôTôOne DayôWrekinôArleen
RECô27.ôQôTuesôWrekinôTony
I use the LOAD DATA DDL statement:
this is a perfect explination, I was concerned about the same webserver
(split into virtual) accessing different databases.
Out of interest can anyone think of ANY problems this virtual setup may
cause ? ie memory, transaction time, dns even, just anything at all so I am
trying to evaluate
I have a problem with my Website. I want to list only 25 results of a db query. When
the user klicks on Second Page he should see the next 25 results and so on.
How can I do that?
Thx for replies.
Sebastian
-
Before
Sebastian Grewe wrote:
I have a problem with my Website. I want to list only 25 results of a db query. When
the user klicks on Second Page he should see the next 25 results and so on.
How can I do that?
Thx for replies.
Sebastian
hi!
i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k
to config innodb, i edited the my.ini (with some help from heikki...thanks!)
and learned on win my.cnf and my.ini cannot co-exist.
now i'm ready to install mysqlgui to set up my admin, users, etc...
my question is: can i add the included
What do I do to get libmysqlclient.so for my binary distribution of Mysql
max 4.0.1 ?
Install bitkeeper, get the source, build it ???
It's not included in any download already ?
( Not the one I got, I just have a libmysqlclient.a )
-AEF
--
When I took off my space suit helmet, I
Hi!
I have the following script to be executed via post from a web-form; the
var. Pin, msisd and knd are given by the form but however, the script is
not working. I always get no results as if there are no matches, but
this isnt right! This is regardless which entries i submit with the
form!
Any
SELECT COUNT(DISTINCT ip), COUNT(*), CONCAT(shref,href) FROM hit
GROUP BY 3
It is work, result is table with many record.
SELECT COUNT(*), CONCAT(shref, href) FROM hit
GROUP BY 2
But this query don't work.
#
# Table structure for table 'hit'
#
Hi,
I cant connect to a MySql Database form a Windows PC, I get Host ... is
not allowed to connect to this MySQL server and in the MySql manual I
found the following solution but I dont know how to do it. I am an
novice in MySql.
If anyone can make tell me the commands I will be very happy.
I went ahead and did the Bitkeeper thing.
Again, the documentation was not very exacting:
shell bk clone bk://work.mysql.com:7001 mysql-4.0
do rather: bk clone bk://work.mysql.com:7001 mysql-max-4.0
shell cd mysql
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote:
I cant connect to a MySql Database form a Windows PC, I get Host ... is
not allowed to connect to this MySQL server and in the MySql manual I
found the following solution but I dont know how to do it. I am an
novice in MySql.
If anyone
GRANT ALL PRIVILEGES ON *.* TO tue@% IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
Ah but that doesn't work this is what worries me because I have a book
on mysql that uses syntax like this and it generates an error on my system.
This is a Red Hat 7.2 system, stock with Red Hat distributed
Put double quotes around % so that foo@%
On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote:
mysql grant all privileges on *.* to foo@% identified by 'foobar' with
grant option;
ERROR 1064: You have an error in your SQL syntax near '% identified by
'foobar' with grant option' at line
I have apache running on a windows 98 machine and I
just installed mysql on it. Also I use perl 5.6.
However this is for local testing.
I need to go online with my website soon.
I was wondering if it is possible to use this setup to
get a mysql db driven website going, then send it to a
linux
Yes it is, at $139 I think it is a supper apps, if you are not sure try the
evaluation version
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 15:37
To: Norman Khine; Stan Lester
Cc: Mysql
Subject: Re: SQL Server 2000
You can't try
Hi all
What is the maximum records can hold in a single table in mysql.
I am doing a file upload from text file to a table.
The records are seperated using year,month,date. I have 2 years of data to
be uploaded.
After I did 10mb of file (2 months) where in my single table recordcount
was
Hi all
What is the maximum records can hold in a single table in mysql.
I am doing a file upload from text file to a table.
The records are seperated using year,month,date. I have 2 years of data to
be uploaded.
After I did 2 months where in my single table recordcount was reached
Hello,
I'm back to the list after two weeks off.
I have a little problem, the email may seem long but it's clearly explained
step by step what I've done...
I have a table that have artists playing at events. It's called
eventartists. One artist can play alone, or with another artist. Because
Hello
I have a question about the REPLACE string function, not the REPLACE SQL
command.
According to the documentation, REPLACE works as follows:
==
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str
mysql
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Hi,
The below mentioned query,
select eventartists.eaDnID,djnames.dnName,eventartists.eaDn2ID from
eventartists,djnames where djnames.dnID = eventartists.eaDnID;
gives the following result.
+++-+
| eaDnID | dnName | eaDn2ID |
+++-+
| 1 | dj
Hi,
I have developed an application in PHP/MySQL in Linux
environment. I need to burn it in a CD and give it to
the client. I need to do one thing - that is when the
client insert that CD automatically my setup should
run. How to do that...?
what sort of coding i need to do ..? is it that i
At Sun, 06 Jan 2002 14:55:53 +0200, [EMAIL PROTECTED] wrote...
:
: Hi!
:
: fil == fil krohnengold [EMAIL PROTECTED] writes:
:
: fil [gcc version 2.95.2; mysql 3.23.47]
: cut
:
: fil ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
: fil rm -fr .libs/libmysqlclient.la
Hi Heikki,
There is 4.xx version available. why upgrade to 3.xx version?
-- Prabhu
On Fri, 4 Jan 2002, Heikki Tuuri wrote:
Date: Fri, 4 Jan 2002 16:55:29 +0200
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Mysql, innodb, linux problems
Bernard,
please
Hi,
mysqld is single-process/multi-thread.
What you see are 4 threads, ps on Linux doen not differenciate between
threads and processes.
For more details on these threads, you can look at the manual:
http://www.mysql.com/doc/M/y/MySQL_threads.html
when i ps on freebsd 4.4 i saw only one
Hi,
Wondering if anyone might be able to help me with a
slight problem. I downloaded the static version of
the mysqlgui and I can't seem to get it working.
I gunzip and try to execute and it complains that it
can't find a library of some sort. I looked at the
readme file in the source
HI!
Thanks for your Help! I´ve tried this, but when inserting the % now all
my selections seem to be valid or successful, even if there is no match!
What is wrong? My table for testing has the following entries:
Pin: 123456789123 msisdn:+491231234567knd:test
PIN: 123456789012
I would suggest turning logging on ('log' entry in my.cnf under mysqld)
do a search and look to see what the actual SELECT parsed by the mysqld
server was. My hunch is that it is only seeing '%' and not '123456789123%'
as expected.
OK, so I now look at your code. It will be looking for
46 matches
Mail list logo
