Thanks for suggestions, just downgrading now.
Alexander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Description:
I started replication from UNIX_server(Distrib 3.23.33) to
windows_server(3.23.35a for win95/98). When I creating a table JJJ on a
master host, i see table jjj on slave instead of JJJ.
And more - any created locally on slave side in upper case table appearing
as lower case
Hi,
I have to run my application under Solaris-2.6 (we cannot upgrade our
web server) and I need some 3.23.x functionality. I tried to compile the
3.23.35 sources but "configure" complained about the compiler.
Could somebody provide me a binary version of 3.23.x (the best would be
of course 35)
Hi everybody. I got a complexe question well according to me. I am working with PHP
and i am making some queries to some database. here is a description of the tables.
provider book video music
provider_id title title title
name provider_id provider_id provider_id
Hi,
WHAT DO I WANT TO DO:
I want to have the binary value of a part of a decimal value.
1)I have a decimal value in column called intag : 262204
2)From this value I'am only interested in the last two bits of the HEX value of
this decimal
HEX value = 4003C
My interest 3C
what are the basic differences in the CREATE TABLE command for the following
keywords?
I checked the MySQL manual but couldnt make much sense outa it.
KEY
INDEX
PRIMARY KEY
UNIQUE
plz. could anyone ellaborate more on UNIQUE AND PRIMARY KEY.? it seems that
both are doing the same job?...
duke.
Hi
Just a question. What about performance when storing audio files in a blob.
What effect does it have on the database(load, space requirements compared to
audio files,...) I will be confronted with this question in the near future
where I will have to decide to store on disk or in blob. I you
Dear Sir, Re:MySQL Database - DSN
How to create a DSN for MYSQL DATABSE on online LINUX
server.
Pl provide me the syntax.
And also I need the syntax for FOREIGN KEY with references
to access two tables in MYSQL.
for eg. (A) Table name : Parent (column name is PARTY varchar(10)
To Whom It May Concern:
I have set up a mySQL server on a Windows NT Server and use the mySQL Gui
client on a Window 98 workstation to connect to the server. But the client
reports that Access is denied for user [EMAIL PROTECTED] (my
workstations DNS on the network). I am using the right
Dear Sir,
I have created the following table:
create table test(name varchar(10) NOT NULL);
query is ok
I HAVE TRIED THE FOLLOWING QUERY :
insert into test values("");
MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL
CONSTRAINTS.
PLEASE CHECK THE ABOVE QUERY
KINDLY
Hello.
I have installed the source of RPM 3.23.35 (Mysql,client and devel) without
problems.
But when I execute a makefile of a easy program this error appears:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0x97): undefined
- Original Message -
From: "Samantha Savvakis" [EMAIL PROTECTED]
To: "MySQL" [EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 12:39 AM
Subject: ADO problem with MYSQL datetime column
I have a table that I'm querying that has 'datetime' columns. If these
columns are null or 0 -
Hubert Feyrer writes:
Well, subject says it pretty much all - I'm trying to build mysqlgui
1.7.4 on NetBSD 1.5/i386, and get linker warnings:
single.o: In function `EditorEngine::LoadSQL(char const *)':
Hi,
i have a big problem ... why this doesnt work?:
INSERT INTO mytable (login, heslo) VALUES ('login', Password('heslo'));
SELECT * FROM mytable WHERE login='login' AND heslo=Password('heslo');
the second line gives me no result ... i have spent a lot of
time looking at that, but i cant find,
How do i put in an integrity constraint?
ie. say i have 2 tables
Person (PersonID[pk], PersonName)
School (SchoolID[pk], SchoolName, PersonID[fk])
as you can see PersonID is the foreign key in School.
So how do keep update and delete restricted constraints etc,?
could anyone tell me the SQL
(I think) most people figure that the disadvantages of having images and
most other binary files stored within the DBMS far outweigh any
advantages. From the top of my head...
Advantages
--
- tidiness
- ease of backup - all data is in one respository.
Disadvantages
-
-
Sir,
please tell me how to stop mysql from accepting empty string values.
it accepts empty string values even when i enclosed in single quotes.
pl inform me with the syntax.
rgds
palani
From: "Dennis Salguero" [EMAIL PROTECTED]
To: "Ramasamy Palaniappan" [EMAIL PROTECTED],
[EMAIL
Hello all.
I was wondering if anyone could help me out with a little project I have to do.
I have a win98 machine with a access database.
I would like to transfer everything into mysql on a red hat 7 linux box.
How would I do this?
Plus how would I be able to connect once it transfer to mysql
http://www.mysql.com/doc/S/t/String_functions.html
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to
the current character set mapping (the default is ISO-8859-1 Latin1):
mysql select UCASE('Hej');
- 'HEJ'
This function is multi-byte
Tha instructions on mysql web pages ,
downloaded documents and
relelased product versions are not the same for Windows.
I still could not understand did 3.23.35a or 3.23.36
support bdb on windows and if
supports how can i implement this.
Regards.
Hi Folks!!
I have a question, How may set another location for my productions db,
so, for instance if i want put my db in /mydb filesystem in my Linux
Redhat???
because when i create a db, this is in /var/lib/mysql/data
Please , help me
Thanks !!
Pablo
At 7:49 PM +0200 3/27/01, Dacian Herbei wrote:
Hi,
I wonder if anyone had a problem like this one.
I have created a table with one field autoincrement. The field is
tinyint(4).
whenever I try to introduce more then 127 records it refuses to
introduce them.
I tried with
In the last episode (Mar 27), Dacian Herbei said:
I wonder if anyone had a problem like this one. I have created a
table with one field autoincrement. The field is tinyint(4).
whenever I try to introduce more then 127 records it refuses to
introduce them. I tried with
At 12:56 PM -0500 3/27/01, Marglobal - Pablo Salazar (Jefe de Sistemas) wrote:
Hi Folks!!
I have a question, How may set another location for my productions db,
so, for instance if i want put my db in /mydb filesystem in my Linux
Redhat???
because when i create a db, this is in
3.23.35-log reports it correctly.
Cal
http://www.calevans.com
-Original Message-
From: Gordon Werner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: mySQL INSTR function problem
Hi there ...
I am running mySQL Ver. 9.33 Distrib.
On 3/27/01 10:08 AM, "Cal Evans" [EMAIL PROTECTED] wrote:
yep. That's the point of a tinyint, it only holds numbers 0-127. if you
need more then try smallint, int or bigint. (and please read the manual
regarding data types. It's clearly explained there.)
Cal
http://www.calevans.com
When I attempt to launch mysql server with command safe_mysqld, the console
return this:
"starting mysqld daemon with databases from /var/lib/mysql"
"010327 19:33:37 mysqld ended"
I use RedHat 7.0 Linux on Intel
--
Stphane Pinel
39, Rue du Docteur Heulin
75017
Doesn't MySQL on NT support networking? You should be able to install the
mysql client on the workstation and give it the IP address, port number and
database name on the server to connect. You don't have to install telnet.
I don't use NT, so if there really is some reason MySQL on NT won't work
-Original Message-
From: Rafael Martinez [mailto:[EMAIL PROTECTED]]
Sent: martes, 27 de marzo de 2001 15:28
To: [EMAIL PROTECTED]
Subject: Mysql in a 4-way / 2 GByte server / raid 5
Hello
I am thinking to install our DB server in a 4-way machine with
Intel Xeon
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: martes, 27 de marzo de 2001 10:00
To: Nemholt, Jesper Frank
Cc: '[EMAIL PROTECTED]'
Subject: Re: How to index this properly (to make it go faster) ?
[clip]
Why that, usertime systemtime are data
Is it the only way to get mysql to work on d: is to install on c: then move
to d: ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi,
I entered netstat and saw among other conections
this one:
tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)
But could i use something like a subselect ... I know they are not supported
by mysql but i see in my book that there is a substitute for it.
Also i am not to familiar with LEFT JOIN ... and all those ... can you give
me explanation ?
So really would it make what would be the real answer to my
Go back to version 3.22. It works very well. The most current vertion
hasn't been ported yet.
Brady...
Original Message Follows
From: "Esteban Cazarez" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mySQL for Sun Intel
Date: Mon, 26 Mar 2001 18:16:00 -0800
Has anyone found the
Hi All,
Does any one know where I can find one?
Thanks.
Yours cheerfully,
Andrew bush
http://www.bushpro.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi Chad
You do not need a Telnet client. Just install Myodbc and the mysql client.
To connect to your server, type "mysql -h yourhostname -u userID"
If you defined a password for the userID, add -p at the end of the line. The
system will prompt you for the password. See manual for more
Hi Rick,
You absolutely right, you are not required to specify field names in an
Insert. But it's a good idea to do so. 1) It makes you code more readable
for those following you. 2) If your table ever changes structure, your
Insert will still work. (Assuming you didn't remove one or more of
Esteban Cazarez wrote:
Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a
SPARC binary for 3.23 but what about an Intel binary?
I was able to compile it fine on Solaris x86 2.6.
-- Josh
_
On Tue, Mar 27, 2001 at 01:45:16PM -0600, Brady Orand wrote:
Go back to version 3.22. It works very well. The most current
vertion hasn't been ported yet.
I could build a Solaris Intel 2.6 binary if needed. It'll probably
work on Solaris 7.
Lemme know if there is interest...
Jeremy
--
Thanks Jean - Claude,
NT Workstation comes with a built-in client. but from what I can tell, NT
Server does not come with a built-in Telnet Server. The NT book I have says
:
"The Telnet program requires TCP/IP on both the client and server, and
requires an account set up on the server being
You do not need telnet to access a mysql server - mysql has it's own
client-server protocol, accessible via the means described by Jean-Claude.
regards,
P
On Tue, 27
Mar 2001, Chad Nielsen wrote:
Thanks Jean - Claude,
NT Workstation comes with a built-in client. but from what I can
Hey guys,
Most of the accounts I have read about MySQL was that it was one of the fastest
databases around. Now, for development purposes I created a FreeBSD system with JUST
MySQL (no other major processes). Then I created a separate Windows 2000 ASP server to
server as our development
I have a problem getting the mysql started. I am running
slackware linux version 7.xx. Apparently mysql is installed.
I downloaded the linux binary package of mysql and installed it.
the mysql is installed in /usr/local/mysql. The problem is that
mysql ** immediately ends **. Here is one of the
On Tue, Mar 27, 2001 at 02:12:36PM -0800, Steve Quezadas wrote:
Anyways, a period of time elapsed and we decided to move to MS-SQL
server for feature reasons, and when we had the MS-SQL ODBC driver
point to the newly created MS-SQL server (roughly same specs), it
was like 50% faster! What
Hi.
On Tue, Mar 27, 2001 at 08:22:39PM +0100, [EMAIL PROTECTED] wrote:
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
[...]
Aha, I'll have to test more with the individual order of
combined indexes to
see what I can get from it.
Well, normally
I've looked through the manual and about 9000 posts from multiple mailing lists..
Is there a way to have mysqlbinlog take a log file and dump just the sql statements to
a file? Am I using the wrong program to do that? Any help would be most appreciated.
Mat
on 27/03/01 21:42, Rick Emery at [EMAIL PROTECTED] wrote:
I had the same problem.
Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set
to: drwxr-xr-x
/var/lib/mysql hasn't these permissions but now, it's OK. But I still have
the same answer:
"starting mysqld daemon with
Just use mysqldump!
At 03:59 PM 3/27/2001 -0700, Mat Murdock wrote:
I've looked through the manual and about 9000 posts from multiple
mailing lists.. Is there a way to have mysqlbinlog take a log file and
dump just the sql statements to a file? Am I using the wrong program to
do that?
Hi again Folks !!
How may create a view in mysql, o make some seem to the queiries in
access !!!
THanks
Pablo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi there,
I was looking for the master and client source code but I was unable to
find, I found the rpm but not source in tar format.
I ma tiring to configure 2 linux server one master and one slave, can you
tell me what's the best way to accomplish this and what settings I have to
change.
any
Hi,
How may create a view in mysql, o make some seem to the queiries in
access !!!
As discussed already many times over and over again and as it can be read
in the mySQL documentation (http://www.mysql.com) views are (not yet)
implemented in the current 3.23.36 version.
Regards
... Ralph ...
Mike,
Excuse me if I'm wrong, but isn't using persistent connections more
server resource intensive? I'm trying to optimize the database on
a heavy site, and I decided not to use persistent connections.
Chris
-Original Message-
From: Michael Betts [mailto:[EMAIL PROTECTED]]
Sent:
On the subject of RPMs, do they contain Innobase and BDB yet, or are those
still only in the source releases?
- Original Message -
From: Scott Baker [EMAIL PROTECTED]
To: Jack Lauman [EMAIL PROTECTED]; MySQL Mailing List
[EMAIL PROTECTED]
Sent: Tuesday, March 27, 2001 4:52 PM
Subject:
How to reindex fulltext index? Thanks
==
xiewer
Emailto:[EMAIL PROTECTED]
CAD Garden -- http://xyzcad.yeah.net
==
-
Before posting, please check:
On 3/27/01 4:54 PM, "WeAreUs" [EMAIL PROTECTED] wrote:
Hi!
I enter some .wav encoded (windows) data into a MySql table as follows:
$data = addslashes(fread(fopen($form_data, "r"),
filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO
Hello, I'm new here ...
I'm trying to use MySQL qith ASP, so I use ODBC .., but when I'm trying to
connect to the server, it always respons:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Access denied for user:
'[EMAIL PROTECTED]@mbtpc20.bau-verm.uni-karlsruhe.de'
Yes, your grant tables are not set up correctly.
For full information, see the manual.
For now try this:
Choose a userid and password just for your db connection. It can be
different from every other userid password you have.
With the mysql client issue the following to SQL statements
GRANT
Has anyone seen any tool that would connect to
a Progress DB and dump out a .sql (DB structure data)
so I can then load it into MySQL.
I know very little about Progress, but...
I have managed to get PHP http://www.php.net talking to both MySQL and Progress 8.3
using the openlink drivers
What process do you guys usually follow when upgrading your version of
MySQL? I have yet to perform an upgrade, but my first thought would be to
dump the databases, uninstall the old version (remove all the files),
install the new version, and import the dump file. Is this a good plan, or
is
59 matches
Mail list logo