Quoting [EMAIL PROTECTED]:
Also, I used this command:
CC="cc -pthread" CXX="cxx -pthread -O" \
./configure --with-named-thread-libs="-lpthread -lmach -lexc -lc"
> Quoting [EMAIL PROTECTED]:
>
> By the way, I did use pthread:
>
> ./configure --prefix=/usr/local/mysql --with-pthread
>
> >
>
Quoting [EMAIL PROTECTED]:
By the way, I did use pthread:
./configure --prefix=/usr/local/mysql --with-pthread
>
>
> I'm running Tru64 5.1a and I downloaded mysql-3.23.51.tar. I was able to
> compile it successfully but when id did a GNU Make, I recieved the
> following:
>
> cc: Warning: /us
How-To-Repeat:
create table teste ( id integer auto_increment unique,imagem LONGBLOB not null);
insert into teste (id) values (1);
update teste set image = (IMG OF 300K) where id = 1;
select if(imagem is null, "ERRO", "OK") from escriba2.teste where id = 1;
* My System is Linux 2.4.18
* Table tab
I'm running Tru64 5.1a and I downloaded mysql-3.23.51.tar. I was able to
compile it successfully but when id did a GNU Make, I recieved the following:
cc: Warning: /usr/include/pthread.h, line 1256: In this declaration, there is
no declarator. (nodcl)
extern int pthread_mutex_lock (pthread_mut
Hi,
Already work (very well) on Win98.
You can download it from http://www.mysql.com/downloads/mysql-4.0.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PR
it should
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: Smita Marda [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 5:25 AM
To: [EMAIL PROTECTED]
Subject: question
technical question-
The MySQL-4.0-mysql-4.0
Hi all
please help
19:36:59[p0]talmuth@smtp:~>cat /etc/my.cnf
[client]
host=localhost
user=root
[mysqld]
max_connections = 5000
19:37:58[p0]talmuth@smtp:~>cat /usr/local/etc/rc.d/mysql.sh
#!/bin/sh
cd /usr/local/mysql
./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect
ions
Grover,
I am carbon copying this to [EMAIL PROTECTED]
- Original Message -
From: "Grover Cussi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 01, 2003 2:16 AM
Subject: Problems with innodb
> Hello!
>
> I have various databases, one has a table with more than 3 mi
Hi all
please help
19:36:59[p0]talmuth@smtp:~>cat /etc/my.cnf
[client]
host=localhost
user=root
[mysqld]
max_connections = 5000
19:37:58[p0]talmuth@smtp:~>cat /usr/local/etc/rc.d/mysql.sh
#!/bin/sh
cd /usr/local/mysql
./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect
ions
Peter,
MySQL stores all updates that modify, insert or delete the database in a
transaction log file, as long as the option is turned on, it is by
default in some cases. The newer versions of MySQL use a binary log,
often stored in the the data directory and named like "hostname".001,
.002, e
Hi,
I am sorry this is a bit off topic.
I am looking for recommendations of MySQL / PHP / HTML / Javascript development
companies.
Companies which you have previously worked and found to be very good at what
they do and good value.
They need to be English speaking. I am especially looking fo
i have a problem with my project :-)
i created two functions, base64_encode, and base64_decode, to insert a
binary file in a LONGBLOB field. When i use theses functions without a
buffer i don't get errors.
by example : OUTPUT = base64_decode(base64_encode(INPUT)); <--> i don't
have errors, i can c
Hi,
I am sorry this is a bit off topic.
I am looking for recommendations of MySQL / PHP / HTML / Javascript development
companies.
Companies which you have previously worked and found to be very good at what
they do and good value.
They need to be English speaking. I am especially looking fo
In the last episode (Feb 03), Prasanth Krishna said:
> Is there any concept of Tablespace for MyISAM tables in MySQL? Even
> if it is not present, is there any concept in MySQL which is
> equivalent to Tablespace in Oracle?
MyISAM tables are stored as separate files in the filesystem, so you
coul
Yes, setting up MAX_ROWS parameter is the right solution i think. I have
tried it with "alter table" command and it seems to work.
Thanks all.
[EMAIL PROTECTED] wrote:
Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih
Hi.
First of all, do all of us, including yourself, a favor and upgrade to
4.0.9 (or 4.0.10 which should come out this week). Reporting problems
against a 7 months old alpha version is not very, well, productive, if
the current release is gamma quality.
On Mon 2003-02-03 at 10:04:58 +0100, [EMAIL
On Monday 03 February 2003 01:08, Jianping Zhu wrote:
> I have rehat 7.3 linux server with apache server running, when i try to
> install mod_auth_mysql, i
> got followine error msg,
>
> [root@mango mysqlsrc]# rpm -i mod_auth_mysql-1.11-1.
On Monday 03 February 2003 01:18, Michelle de Beer wrote:
> This question might be a little OT.
>
> My question is, what is the smallest working install
> of mySQL?
> Can you install it in a PDA, like the Yopy, that uses
> linux as OS?
MySQL is portable. The questions is: if it is possible to (cr
On Monday 03 February 2003 06:44, wiley wrote:
> Easy question for beginner. Why am I getting this error ? I just
> installed Mysql and I'm trying to create a database. Beginner stuff...
> E:\>mysqladmin create TestDB
> mysqladmin: CREATE DATABASE failed; error: 'Can't create database
> 'testdb'.
On Monday 03 February 2003 11:49, Veysel Harun Sahin wrote:
> I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G
> file size and now I can no longer insert records into table. My mysql
> data partition is not full (%24 used). I have read that mysql 3.23
> supports up to 2 terabyt
Hi,
Even if you have large file support you must tell mysql to use long
pointers when creating the table. The way to accomplih this is to add
the MAX_ROWS table option when creating the table, just make it a
really large number like 50. You can verify this effect by
BEFORE makeing the c
In the last episode (Feb 03), Grigor, Peter said:
> This is not so...Mysql will write out the data for MyIsam tables
> without calling the operating system to do an fsync()...it's up to
> the OS to flush dirty pages to disk.
He specifically asked for MySQL-only write activity:
> > I am just tryin
Hi everyone.
Does anybody know if it is possible to commit only partially ?
example:
query: select ... from A ... for update;
// update fields locked in A
query: select ... from B ... for update;
then I would like to commit all changes I did in the locked records from
table A, wi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 2 Feb 2003, Andy Smith wrote:
> Where have the links to MySQL SRPM packages gone from
> http://www.mysql.com/downloads/mysql-4.0.html ??
>
> I found being able to build binary RPMs from your SRPMS to be
> useful, please could you make the
Hi,
I am new to this list so I apologise if this is not the place to post this
message.
I am in the final stages of completing a project and I have one query that
is causing problems.
I need the query to get a story or stories from the story table and
journalists from the journalist table whe
This is not so...Mysql will write out the data for MyIsam tables without
calling the operating system to do an fsync()...it's up to the OS to flush
dirty pages to disk.
See http://www.mysql.com/doc/en/Command-line_options.html under the --flush
command line parameter.
Peter
<^_^>
> -Original
We had an issue the other day where we could not access the myslq database
we have on our redhat linux 7.2 box.
when I did a
ps -ef |grep mysql
I got the following.
root 645 1 0 2002 ?00:00:00 [safe_mysqld]
root 688 645 0 2002 ?00:01:31
/us
>From manual:
LONGBLOB
A BLOB or TEXT column with a maximum length of
4294967295 (2^32 - 1) characters
If I insert a 400k file into a longblob, will it
occupy 400k in actual space on the harddrive, or will
it occupy the maximum for a longblob?
Is there any difference here between innoDB an MyISA
Peter,
sorry to say, but I guess your data have gone to Nirvana.
> Is there any logs of the database commmands
There is. It's called binlog (binäre update log), and you can turn it on
by starting the server like mysqld --log-bin (or put log-bin in the
[myslqd] section of your my.cnf / my.ini). T
If it's lost, it's lost. But that's not the end of the matter. When
making a table for use, make a backup tablee and have update operati
operations like closing make a backup of data in original table.
Interestingly, msaccess 2000 has a problem with subquerydatasheets that
makes such an approach
Hello!
When I run mysql with default-charset = estonia, it makes difference
between upper and lower case. With latin1 charset no such distinction are
made. Could someone clarify for me, is it bug?
--
Lauri Anton
( [EMAIL PROTECTED] )
( +3727302126 )
- estonia -
Server version:
Daniel,
(you posted this question twice, but I will only answer it once ;-)
> have a month string January from a get query string like so
?month=January ,
> and i need >to check a range of results within an endate so i need
WHERE end_date
> $_GET['month'] ,
You could use the DATE_FORMAT() functi
Inbal,
a "snapshot" is simply a backup of the database at a well defined point
in time. A snapshot is essential for replication to work. Master and
slave are supposed to start with exactly the same set of data
("snapshot") in the beginning.
There are several ways to create a snapshot on the maste
Alex,
> If I put a copy of my.cnf to would that be any help? Any
what
> is ? Sorry I am kind of newbie for in-depth knowledge
> of MySQL.
Nope. You don't have three "copies" of my.cnf (one of them actually
called .my.cnf, note the dot) to make things more complicated, but to
give you more flexib
Hi
Error 13 is Permission denied. Check you have write permissions on the mysql database
directory (you might not if you copied from a CD for instance).
Hope this helps
iolaire
On Sun, Feb 02, 2003 at 08:44:23PM -0800, wiley wrote:
> Easy question for beginner. Why am I getting this error ? I
Does anybody know what this means?
Script started on Mon Feb 3 07:17:16 2003
dashielljt@athame:~$ mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (111)
dashielljt@athame:~$ exit
exit
Script done on Mon Feb 3 07:17:31 2003
--
Jude
--
> perror 13
returns
Error code 13: Permission denied
You do not have permission to create databases as the default user.
As installed. there is already a test database called 'test' and a test
user called 'test' with no password to do the kind of inital trying out you
probably want.
May I sug
Hi and thanks for the reply.
After I read all about replication, I have a little question.
In section 4.10.3 How To Set Up Replication, in step 3 it is written "and
then take a snapshot of the data on your master server".
I am working on windows 2000 and I don't understand, how do I do the
snapshot
technical question-
The MySQL-4.0-mysql-4.0.6-gamma-win works on winNT
will it work on win98?
Plz reply me immediately..
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yaho
I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
I have the following DB's:
# Host : localhost
# Database : test
CREATE DATABASE test;
USE test;
# Structure for table users :
CREATE TABLE `users` (
`id` smallint(4) NOT NULL auto_increment,
`user` varchar(8) NOT NULL default '',
PR
Hi all
Is there any concept of Tablespace for MyISAM tables in MySQL?
Even if it is not present, is there any concept in MySQL which is
equivalent to Tablespace in Oracle?
Where could i get the information about it?
Thanks in advance
Prasanth
-
Put the error number in to perror in ../mysql/bin
It will then tell you what the error is about.
<---snip--->
/usr/local/mysql/bin$ ./perror 13
Error code 13: Permission denied
<---snip--->
This is an operating system error.
Simon
-Original Message-
From: wiley [mailto:[EMAIL PROTECTED
>Description:
If I run a query like "UPDATE questions, q_list SET questions.point =
60, q_list.point = questions.point WHERE q_list.qid = questions.qid AND
questions.qid = 311677" InnoDB will crash, and cause damage to some of my
MyISAM tables.
>How-To-Repeat:
Run the above query.
>Fix:
Hi,
On Sun, 2003-02-02 at 00:25, B. van Ouwerkerk wrote:
> >If it gives errors about creating/writing mysql.sock, check the
> >permissions/ownership of directory /var/lib/mysql.. Check the manual for
> >the right permissions...
>
> Might depend on your distro, AFAIK mysql.sock would normally live
Hello,
I am using mysql3.23.49 on openbsd3.2. I have a myisam table with 4G
file size and now I can no longer insert records into table. My mysql
data partition is not full (%24 used). I have read that mysql 3.23
supports up to 2 terabytes table size. Not so sure but I know openbsd's
file size
Do you have an application with a sort of upgrade functionallity that
when started checks the database for incosistency and when it finds some
updates the database? (ie compares the structure of the table in the
database to some "template" stored in the application or as
datafiles/scripts)
Or do y
Hi list,
I have a create table command in which the check statement does
not seem to do anything. I know it was just there for compatibility
in older mySQL versions, but I thought it should be working in
version 4.0.2. Isn't it?
Rinke
--
First of all, I'd try optimizing your app before writing a whole new
back-end. As such, I'd keep to the normal mysql list.
For example, even if the indexes are big, try to index all the columns that
might be searched. Heck, start by indexing all of them. If the data is
read-only, try myisampack.
> Is there any way to partition MyISAM tables in mysql? i have a huge
> table and want to partition it.
> Do InnoDB tables support partitioning?
Like Oracle? No. You can do your own partitioning on the application side,
of course. And/Or you can use MERGE type tables which have some basic
partiti
OK, I'm coming back to this problem after not touching it for a while.
Sorry about the indentation, it's a dynamically generated query and I just
cut and pasted into the email.
I tried your suggestion, and it is showing the correct number of displays
for most ads, but it is not limiting the cl
Hi Mr. Bueno,
thnak you for you're response.
I knows the way you described how determine if replication is finished.
But doing this I need to make a connection to the slave and a connection to
the master and compare the results of this two queries.
I'm looking for a way of deciding this with on
this may seem as a desperate questions, but is there anway to restore
deleted data from a table? Is there any logs of the database commmands
that for example sql-servere has, that can be used to rollback to the a
specific time and in that way restore the old content of a database.
I was pretty s
NOBODY has an idea???
it's a redhat linux box with downgraded gcc 2.95.4 - glibc 2.2.4
> hi list,
>
> getting this with mysql-3.23.55 on 2 machines (on other it compiled):
>
>
> make all-am
> make[3]: Entering directory `/usr/src/mysql-3.23.55/include'
> make[3]: Nothing to be done for `all-am'.
sorry if you may get this twice, my work is persistant to not give me
newsgroup access and their email server is shitty and slow , i think being on
novell heh anyway here is the message.
hi there i am having an issue formatting a date string back to mysql for a
query, say i have a month string
Easy question for beginner. Why am I getting this error ? I just
installed Mysql and I'm trying to create a database. Beginner stuff...
E:\>mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
thanks in advance for anything...
-
Easy question for beginner. Why am I getting this error ? I just
installed
Mysql and I'm trying to create a database. Beginner stuff...
E:\>mysqladmin create TestDB
mysqladmin: CREATE DATABASE failed; error: 'Can't create database
'testdb'. (err
no: 13)'
thanks in advance for anything...
-
> There are three my.cnf you should look for:
>
> 1) /etc/my.cnf = global options
> 2) /my.cnf = server options, overriding global options
> 3) /.my.cnf = user specific options, overriding server
> options
Thanks for your reply! The information does make sense.
However, I searched the whole file s
hi there i am having an issue formatting a date string back to mysql for a query, say
i have a month string January from a get query string like so ?month=January , and i
need to check a range of results within an endate so i need WHERE end_date >
$_GET['month'] , how can i format the month stri
Well, like others, I reccomend MySQL by Paul Dubois. It is my only MySQL
book besides the copy of the MySQL reference manual provided by work. I have
an associate that has PHP and MySQL web development by Sams, and it gives my
any references I need for PHP. Looks like it is being updated on the 13t
This question might be a little OT.
My question is, what is the smallest working install
of mySQL?
Can you install it in a PDA, like the Yopy, that uses
linux as OS?
http://www.yopy.com/english/products/specification.htm
// Michelle
sql, query
__
60 matches
Mail list logo
