Hi,
> Does anyone know the correct syntax to connect to a mysql database
> with DBI? I tried the syntax mentioned in the Perl DBI O'Reilly
> book, but I got errors.
i'm pretty sure the syntax given in the O'Reilly book was right.
and it would really make it easier to help solve your problems, if
Hi,
> I just installed the latest version of MySQL (3.23.38 I believe) from
> an RPM on Red Hat Linux 7.0. My question is when configuring
> PHP4 I need to include the --with-mysql= ? statement. Where
> would the correct file be with the RPM install. I have tried almost
> every directo
Hi Michael,
maybe something 'off topic'...
I think a option to set 'autocommit=0' is needed.
Last week I have made some data manipulation, stupidly my 'where condition' was
not correct. After pressing 'return', mysql returns with '4576 rows affected'.
Not that was I expected...
I didn't set au
Hi,
> i am trying to import or export using MYSQL driver. that time it
> gives following error;
> "Access Denied For User '[EMAIL PROTECTED]' (Using password:YES)
did you give all the privileges manually through editing the grant
tables, or by the GRANT command (the right command should be some
hi,
I have installed mysql 3.22.29 in our RedHat 6.0 server and i give all privileges
to user, and i have installed myodbc in my window 98 machine.
i am trying to import or export using MYSQL driver. that time it gives following
error;
"Access Denied For User '[EMAIL PROTECTED]'
I just installed the latest version of MySQL (3.23.38 I believe) from
an RPM on Red Hat Linux 7.0. My question is when configuring
PHP4 I need to include the --with-mysql= ? statement. Where
would the correct file be with the RPM install. I have tried almost
every directory I can find t
Making another appeal for help Anybody have any clues to what I could do
to fix the problem below?
> I tried to configure MySQL like this:
>
> ./configure --prefix=/usr/local/mysql --with-charset=sjis
>
> After a hundred lines or so of install verifications, it quits the
> installation with
hello there,
iam new mysql ,iam right now working with jsp
so is there any way we can write funtion in java and make
mysql understand it
Regards,
manu
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Dear,
I would like to ask someone who can suggest me about upgrade or re-install
MySQL. If I have been install MySQL with other application (PHP, Apache,
SSL or anything) by STATIC method (use tar file in Linux-Box). When I'd
like to upgrade MySQL (or other application: PHP; Apache...
HTH mucho coolness
Steve West wrote:
>
> Bruce,
>
> Thanks for all the help so far! :)
>
> It finnally works.
>
> SW
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 16, 2001 10:20 PM
> To: [EMAIL PROTECTED]
> Subject: Re: auto startu
Bruce,
Thanks for all the help so far! :)
It finnally works.
SW
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 10:20 PM
To: [EMAIL PROTECTED]
Subject: Re: auto startup of mysql in redhat box?
Actually that's what chkconfig does...
Actually that is incorrect syntax...the following is the correct syntax
to ensure that mysqld is running at boot in the different run levels:
/sbin/chkconfig --level 345 mysqld on
as it is a daemon, you need to use 'mysqld' not mysql, and you also need
to pass to chkconfig the runlevels you desi
I was d/l mysql manual for latest version in other format in d/l
section, but i still got manual only version 3.23.33. How could I do?
Regards,
Sommai Fongnamthip
-
Before posting, please check:
http://www.mysql.com/manual
you might also need to run chkconfig to turn on the startup script.
do:
chkconfig --list |grep mysql
...if is says off off off... and no "on"'s, then it's off. So, do:
chkconfig mysql on
...then do this again:
chkconfig --list |grep mysql
There's more to it... all those numbers are init st
Bruce,
I installed mysql-3.23.39-pc-linux-gnu-i686.tar.gz . Even though I'm still a
newbie to linux I thought to stay away from the redhat rpm files! :)
Is this the correct version I should be using?
I ran some tests w/ mysql and it seems everything works fine (i.e. added a
test database, some
You'll have to force rpm to install that. Chances are, you won't be able to
find the required package unless you build it yourself. Read the rpm man
pages.
If you don't have Perl DBI installed, cpan.org. You'll likely need the
MySQL DBD also, again, cpan.org.
--
Vibol Hou
KhmerConnection, htt
Bruce,
I tried what you suggested and I get the following error message on my
redhat 7 server:
/sbin/chkconfig --list mysql
service mysql does not support chkconfig
Any ideas what I'm doing wrong?
Thanks!
SW
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sen
Hi..
I'm from seoul,korea.
Now i'm trying to install mysql 3.23.38 through source install.
I'm using Redhat 7.1 with 128M memory,Intel Pentium III 500.
I'm trying like this..
./configure --prefix=/usr/local/mysql --with-charset=euc_kr
make
so far there is no problems.
but when i try like '
Hi..
I'm from seoul,korea.
Now i'm trying to install mysql 3.23.38 through source install.
I'm using Redhat 7.1 with 128M memory,Intel Pentium III 500.
I'm trying like this..
./configure --prefix=/usr/local/mysql --with-charset=euc_kr
make
so far there is no problems.
but when i try like 'm
login as root. Use:
chkconfig --list mysql
to determin if it on, if it's not on issue:
chkconfig mysql on.
That will make sure that mysql starts at boot time. To start mysql
manually use:
service mysql start
Steve West wrote:
>
> I'm trying to figure out how to get mysql to startup au
When we can expect unicode version of mySQL for Win32 ?
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
On 16 May 2001 13:40:55 +0300, Sinisa Milivojevic wrote:
>
> Regarding the fact that 2.96 can build working binaries, that is good
> news, but before we try it ourselves, could you please run all
> mysql-test programs plus sql-bench. See if it will pass them all.
Ok, finally i installed MySQL-be
Original Message -
From: "Mark Rowlands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 3:11
Subject: create table with select syntax error problem
> CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
> unsigned DEFAULT '0' NOT NULL,PRIMARY
Changing to C++ is not likely to give you a noticable speed difference
because your bottleneck is not the code but the queries. With proper
database design you should be able to acheive those results with one query,
and it should be fast if given the right indexes.
ryan
> I am searching to spee
Hi,
Just wondering how to get through that "Can't connect to local MySQL server
through socket '' (111)" error message with MySQL GUI for Linux (RedHat
7.0). I configured mysqlgui through ~/.my.cnf and client configuration file.
I tried the static and semi-static binary versions. If I put a "soc
Even though I'm not one of the creators, thinking through it logically, I
would say it wouldn't work. A select * statement would retrieve the data,
so yes, you could add columns to the permission tables but you need to be
able to use the retrieved data in someway, usually programmatically.
...
I'm trying to figure out how to get mysql to startup automatically after
rebooting the server?
I have a Redhat 7.0 box and I placed a file to call up the mysql.server auto
startup script as follows:
/etc/rc.d/init.d/mysql
which has the following code:
/bin/sh -c 'cd /usr/local/mysql ; ./bin/s
On 16 May 2001 13:40:55 +0300, Sinisa Milivojevic wrote:
> Regarding the fact that 2.96 can build working binaries, that is good
> news, but before we try it ourselves, could you please run all
> mysql-test programs plus sql-bench. See if it will pass them all.
I tried to install MySQL-bench, but
I have a query that works fine until my date range goes one day over some kind of data
size threshold & then it mysteriously goes from 0.34 seconds to 30 seconds. My DBA
pointed out that my SQL syntax was loose & that Oracle would've flagged it as an error.
I did a GROUP BY based on an numeric
Coincidentally, I used perl DBI for the very first time last night, and this
worked for me fine:
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect('DBI:mysql:mysql','username','mypassword')
or die "couldn't connect to database: ".DBI->errstr;
$dbh->disconnect();
Regards,
Gary "SuperID"
On Wed, May 16, 2001 at 03:12:42PM -0700, Brian Warn wrote:
> I'm looking at different ways to backup a database from a solaris
> 2.8 box to a solaris 2.7 one. In addition to the standard system
> backups that our sysadmins do during the week, I want to do a full
> backup of the database to a bo
Unfortunately I don't have an ordinary disk on that box. I'm thinking that
InnoDB is having a major problem with LVM not ReiserFS. I tried it on an
e2fs portion of the server and it still had problems.
Do you know of anyone successfully using InnoDB with just LVM?
Jamie
-Original Message---
I'm looking at different ways to backup a database from a solaris 2.8 box to a solaris
2.7 one. In addition to the standard system backups that our sysadmins do during the
week, I want to do a full backup of the database to a box where I have much more disk
space than the one where the product
Does anyone know the correct syntax to connect to a mysql database with DBI?
I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got errors.
thanks
=
#
Simon K. Chan
"Great spirits have always encountered violent opposition from medioc
Hi!
Thanks!
Mine is the redhat distribution v7
I solved it by removing and installing php and mysql downloaded from the rh
updates.
Now it works.
Thanks again. :)
Regards
Annie
"I should always thank Him." -- Unknown
>This error message indicates that the version of PHP that you are using does
On Wed, May 16, 2001 at 10:58:18PM +0200, Frank Schroeder wrote:
>
> Is there a way of turning the transactional logging off during the
> load of a table? I know that I'm out on my own then but this table
> is loaded only every once in a while.
>
> Am I running out of space on the log/or data fi
Put parentheses around the ..OR.. part (between WHERE and AND) - AND precedes
OR so
Also, use 'IN' instead of a series of 'OR' - this will make the query a lot
faster.
e.g. listings.Area IN ('19','24','25',...)
Vadim.
JD Daniels wrote:
>
> I have this query built from a web form. The for
Does the mysql user have write-permission in the directory where core
would be
written?
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
This error message indicates that the version of PHP that you are using does
not have MySQL support built into it.
See http://www.php.net/manual/en/ref.mysql.php
and http://www.php.net/manual/en/installation.php
--zak
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Hi,
I'm trying to load a large table with 7 million records, 50 columns and
27 indexes into an innodb table. Works fine for MyISAM. Compressed size
of the data file is about 280MB (830MB uncompressed) and 1.5 GB for the
index file. Platform is RedHat Linux 6.2 with kernel 2.2.16-3 and MySQL
is 3.
Hi all!
I need to know how to solve this.
I keep on having this error whenever my scripts using mysql_connect()...
Fatal error: Call to undefined function: mysql_connect() in
/www/html/phpMyAdmin/lib.inc.php on line 255
TIA!!!
Regards
Annie
Hi!
> "Steve" == Steve Ruby <[EMAIL PROTECTED]> writes:
Steve> Due to the fact that piping a table from mysqldump to an INNODB table
Steve> can be as much as 30X slower if the insert is not done with
Steve> transactions,
Steve> would it make sense to add some option to mysqldump to make eve
Thanks for the speedy replies to my query problem, after I buy some new
glasses I'll be going back to the books.
Thanks again
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://list
MySQL WebClient 0.0.1 Features
==
Web-based access to any MySQL server on the Internet.
Easy access to database tables, allowing structural configuration and data
input/output.
Client-side form validation, minimizing unnecessary interaction with server.
Command line
In Addation,
Print ("OK 3") line is also missed ':'.
^^
magic words sql database
- Original Message -
From: "MTF" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2001 12:13 PM
Subject: Parse error?
> I am new to MySQL and am using Paul DuBois's book to MySQL g
You should be using echo in place of print.
echo "OK 2";
>Robert Henkel
>Shouldn't you have on line 7
>print ("OK 2 ");
>and not
>print ("OK 2 ")
>Im not a PHP person but thats what I noticed in your code. And if ;
>terminates a command that can't be helping
>
>
>
>
>
>magic words sql database
Shouldn't you have on line 7
print ("OK 2 ");
and not
print ("OK 2 ")
Im not a PHP person but thats what I noticed in your code. And if ;
terminates a command that can't be helping
magic words sql database
-Original Message-
From: MTF [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May
I am new to MySQL and am using Paul DuBois's book to MySQL guide me. (Great
Book!)
I am attempting to use PHP, My scripts always connect to the MySQL server OK,
and the Databases to, but my queries always fail with the following message:
OK 1 OK 2
Parse error: parse error in /home/httpd/html/
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select
log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon =
5 group by log.sajtid;
the create table on its own works, the select statement works,
Hi!
Note MySQL version: 3.23.33
I need to sort sql query results in a complex way. If you could please help
it would
be much appreciated. Thanks in advance!
I have 7 tables: 1 is a base table then 3 pairs of list and joiner tables
2,3; 4,5; and 6,7 where 2,4 and 6 are joiners between 1 and
>Dear,
> I have an table which like to use recursive join but I wonder
>how to use it. Please see the table struc below.
> emp.id,emp name, emp salary, emp head-id
> 001,mr. a,1,001
> 002,mr. b,5000,001
> 003,mr. c,5000,003
> 004,mr. d,5000,003
> Whe
>We are performing some rather extensive data collection (measurements) and
>are attempting to come up with the most sane storage mechanism to
>facilitate offline (Igor, MatLab, Custom Apps) and online (less complex
>web based solutions) analysis tools. The problem resides in the amount of
>data
I have encountered many problems during the downloading, unpacking and
installating of MySQL, some of my own making and some that I can't
determine. After two days of searching in the Documentation at mysql.com
and reading of the Archival files, I turn to you, since I cannot find an
answer to my p
Jamie,
really strange. Now I start to suspect the file system. InnoDB should create
and write a file of size 2000 MB like you specified in my.cnf.
InnoDB does the initial file write in 1 MB chunks using pwrite,
calling fsync in between.
When you restart MySQL, InnoDB checks if the data file is
On Wed, May 16, 2001 at 03:01:26PM +0300, Heikki Tuuri wrote:
> Andreas,
>
> sorry, it is the default MySQL behavior to create a MyISAM table if
> another handler is not present.
>
> There was a long thread of emails between MySQL developers if MySQL
> should give an error message if a table can
Dear Sir,
Thanks for your valuable answer. But I am maintaining some connection pool
and I am querying DB in regular interval. Now also this problem occurs.
Even if we assume that this problem occurs due to the reason as suggested by
you, why this error happens when there is no data ba
hi.
add the directory where 'ar' is to your path.
PATH=$PATH:/path/to/ar; export PATH
if i remember correctly, it should be in usr/ccs/bin.
hth.
-ravi
-Original Message-
From: Dana Sharvit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: in
Check the attrib of the file, maybe is read only.
most times, when files has been copy to CD the attrib of files is automatic
changed to read only, and when the copy is back to hard drive the read only
remains, so, acces is denied.
check too, the attributes of the table created and the user ri
Hello,
I am trying to install mysql(mysql-3.23.8-alpha) on Solaris2.8 with a prefix
of the installation directory.
the configure is ok but when I try to run make I get the following errors:
sh: ar: not found
*** Error code 1
make: Fatal error: Command failed for target `libreadline.a'
Current wor
ouch, no idea what I was thinking.
Thanks
On Wed, 16 May 2001, David Simmons - EliteUKServe.Net wrote:
> dont you mean:
>
> create database gnudip2;
>
> create table table1 (id int(10),some_colum varchar(255));
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Ana Elisa Ma
So, when MySQL goes to its own permisions table, it does a "select *", not a
"select user, host" etc.? Why is that? It seems that for flexibility it
would name the fields it was selecting so it would know the order would
always be the same.
Anyway, if I don't change the order of columns (i.e
Hi,
We've got a situation happening on a server, and have no idea why.
The server is a PII/600 with 1G memory, running BSDI 4.0.1 .
The Mysql is "mysql-3.22.32", and was compiled with :
gmake distclean
PATH=/usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/bin:/
Your filter really makes having a discussion difficult. I think I'll
just go away.
> "m" == mysql <[EMAIL PROTECTED]> writes:
m> Your message cannot be posted because it appears to be either spam or
m> simply off topic to our filter. To bypass the filter you must include
m> one of the fol
7 or so. I have indexes on most of the columns being used..
Enrique Vizcarra wrote:
> 1) How large the data base is it? how many records?
> 2) Are you using index?
>
> I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
> operating System and with one table consisting of
1) How large the data base is it? how many records?
2) Are you using index?
I has tested MySql serving with Pentium II 266 with Windows 98 2da. Ed.
operating System and with one table consisting of 762000 records. Even
before I indexed the database, speed of MySql was great. Of course, after
t
One of the tables of my database suddently became read-only; when I try
to add a line, I get:
ERROR 1036: Table 'Requests' is read only
I'm alone working on this table, and didn't lock it. Does anyone know
how I can unlock this table?
TIA
Greg
---
I have this query built from a web form. The form will add to the query
depending on what search criteria has been chosen. what happens is if they
choose the criteria in the query below, it stops comparing the other
criteria such as listed date and price range. Also the = operator does not
return
No, by multiple queries I mean that I have to querie for every title. The
query is:
Select if(Year<>'"+y+"','1','0') as quest,MM,Archive,record_num from inv where
((REPLACE(Title,'#','')='"+t+"' or REPLACE(Title,'#','')='"+s+"' or
REPLACE(Title,'#','')='"+u+"' or REPLACE(Title,'#','')='"+v+"' or
R
Compiled with -D_REENTRANT -D_PTHREADS -fPIC -DPIC -Wall
Linked with -pthread
but its not mysql. For mysql I just did ./configure; make; make install
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 17:11
> To: Sander Pilon
> Cc: 'Sinisa Mil
Vivek Khera wrote:
>
> > "DF" == David Favor <[EMAIL PROTECTED]> writes:
>
> DF> The problem is the Web hosting service I use does not have this
> DF> package installed. In other words, there is no libpthreads.* in
> DF> any of the library directories.
>
> But FreeBSD native threads do not
Vivek Khera wrote:
>
> > "DF" == David Favor <[EMAIL PROTECTED]> writes:
>
> DF> The problem is the Web hosting service I use does not have this
> DF> package installed. In other words, there is no libpthreads.* in
> DF> any of the library directories.
>
> But FreeBSD native threads do not
Hi!
At 05:04 PM 5/16/01 +0200, you wrote:
>>>4) Ok, datafiles created overnight. Now trying alter table ...
>>type=innodb
>>on a
>>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>>files
>>this
>>>size is going to be problematic. Machine pegs with load of around 12! I
>
Hi!
I already found an easy solution. Write to the file in 16 MB chunks
instead of 1 MB chunks. Then I got 5 MB/s on our Linux Xeon.
I do not think MyISAM uses fsync at all. I need fsync because in
recovery I must know that some database pages have been cleanly written
on disk.
These fsync thin
> "DF" == David Favor <[EMAIL PROTECTED]> writes:
DF> The problem is the Web hosting service I use does not have this
DF> package installed. In other words, there is no libpthreads.* in
DF> any of the library directories.
But FreeBSD native threads do not need any libpthreads.* files. Your
I am searching to speed up an operation I have, which works - it just
takes minutes to finish. The current script is written in pike (a C like
scripting language). I believe that most of the overhead is the multiple
queries. Would using C++ be significantly faster? (I'd have to learn
some C before
Hi list members!
I have a doubt regarding how can I INSERT and SELECT an IMAGE from a MYSQL
database. I'm using , in the DB, the BLOB field, so, I will be able to
receive binary data. Thnaks for any help!
Best Regards,
Felipe Moreno
-
>>4) Ok, datafiles created overnight. Now trying alter table ...
>type=innodb
>on a
>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>files
>this
>>size is going to be problematic. Machine pegs with load of around 12! I
>suggest
>>LOTS more testing on BIG tables. Small
WA> thank you !
WA> i get it into the database but
WA> with a select i get
WA> select * from table;
WA> [..skip..]
WA> Can i read the data out and put in a file ?
WA> you understand ?
It probably just means that mysql client is confused by binary
data. It usually doesn't handle it well. It do
You can compile from source on OS X. I personally built 3.23.36 on 10.0
when it came out; right now it requires a couple of edits to the source
code prior to compilation. The edit can be found here:
http://www.mysql.com/doc/M/a/Mac_OS_X_Public_Data.html
in the "Comments" section. Once you p
Freebsd does not have a libpthreads file.
Just compile with -pthread(s) and it'll work. Well, it does for me.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 16:18
> To: Sinisa Milivojevic
> Cc: [EMAIL PROTECTED]
> Subject: Re: Help with Fr
Hi,
we've got a customer with a large ms sql database but want to replicate a
smaller dataset to our own mysql server. Is this possible, and does anybody
have experiences with it,
regards,
Sander
Andre,
try the following put on the line 330 in mysql/innobase/log/log0log.c
lsn = log_reserve_and_open(OS_FILE_LOG_BLOCK_SIZE);
Maybe gcc will compile in a different way then and not crash. Please
report to me if you succeed. I will change the source then.
Regards,
Heikki
http://www.in
"David Simmons - EliteUKServe.Net" wrote:
> what I had to do was download and install:
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-client-3.23.38-1.i386.rpm
http://www.mysql.com/Downloads/MySQL-3.23/MySQL-devel-3.23.38-1.i386.rpm
>
> as well.
>
> removing the originals via yast
>
> if i rem
The problem is the Web hosting service I use does not have this
package installed. In other words, there is no libpthreads.* in
any of the library directories.
___
Sinisa Milivojevic wrote:
>
> David Favor writes:
> > Sinisa Milivojevic wrote:
> >
> > The Web hosting service I am using doe
WA> how can in insert i.e. a tar-archive in a blob ?
WA> i want to do it with perl. i read allready about the quote function but i
WA> wount work
Try to use placholders. I'm under impression that quote is not
reliable. At least man DBI says:
Quote will probably not be able to deal wi
System Sun Fire 280R with dual USIII @ 750Mhz and 8G RAM. Solaris 01/01
media kit installed
Can anyone point me to the reason this is happening?
[ paul@tbd /usr/src/mysql-3.23.38 ] $ sudo
./configure --prefix=/usr/local/mysql
loading cache ./config.cache
checking host system type... sparc-sun-so
Hi,
Yes, you can install MySQL in Win95 but keep in mind because of bugs in
Win95 MySQL may not perform as expected.
Win95 leaks memory each time a client connect to MySQL.
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL
At 2:36 PM +0200 5/16/01, Robert Goeres wrote:
>I am looking for MySQL for Apple's Mac OS X (10.0.3).
>Up to now I have only found some old versions for Mac OS X Server or OS X
>Beta
>Any tips or hints?
Try this ...
http://www.versiontracker.com/moreinfo.fcgi?id=10425
--
%~
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
David Favor writes:
> Sinisa Milivojevic wrote:
>
> The Web hosting service I am using does not have Native Threads installed.
> When I requested they install the package, they seemed clueless about how
> to do this.
>
> What is the exact command I need to tell them to issue to install the
> Nat
I am looking for MySQL for Apple's Mac OS X (10.0.3).
Up to now I have only found some old versions for Mac OS X Server or OS X
Beta
Any tips or hints?
Regards
Robert Goeres
-
Before posting, please check:
http://www.mysql.co
how can in insert i.e. a tar-archive in a blob ?
i want to do it with perl. i read allready about the quote function but i
wount work
#!/usr/bin/perl
use DBI;
# DB-Vars
$host = "ux4";
$database = "db_webera";
$user = "webera";
$pass = "webera";
$port = 3306;
$driver = "mysql";
$dsn = "DBI:$dr
Hello,
My mySQL server runs on Windows NT. I use the default character set
Latin1. I connect to the database with myODBC from a Visual Basic
program using ADO. The problem is that the French accented characters are
not displayed correctly.
I found in the documentation a paragraph describing
Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
o
Hi,
1.
What is the default memory allocated by mysql to a
newly created database?
2.
If I make any changes to a database(either by adding a
new table or by adding or deleting a column of a
table) is there a way ,I can have a version control of
my database and retain the old tables and new tables
o
Hello Heikki,
Wednesday, May 16, 2001, 4:01:26 PM, you wrote:
HT> Andreas,
HT> sorry, it is the default MySQL behavior to create a MyISAM table if
HT> another handler is not present.
HT> There was a long thread of emails between MySQL developers if MySQL
HT> should give an error message if a t
Andreas,
sorry, it is the default MySQL behavior to create a MyISAM table if
another handler is not present.
There was a long thread of emails between MySQL developers if MySQL
should give an error message if a table cannot be created to be of
type BDB or InnoDB because the handler is not presen
Jamie,
I do not think it is the Reiser file system. Could you show what parameters
you have in my.cnf and what is the size of the file ibdata1 (when looked
with ls -l)?
Regards,
Heikki
http://www.innobase.fi
>I complied MySQL as a max binary. However when I gave all the variables for
>InnoDB i
I've set up a database containing 10.000 main records.
However, there are LOTs of n:m-relationship tables surrounding the main
table.
Now I want to set up an efficient search through the whole datamodel.
==> I've got lots of SELECT id, title from main LEFT JOIN subtable1 ...
LEFT JOIN WHER
Hi,
I got the following error during compilation of MySQL-3.23.38 on my
HPUX-11 box witg gcc-2.95.2.
log0log.c: In function ´log_pad_current_log_block´:
log0log.c:330: Internal compiler error at expr.c:2829
After upgrading to gcc-2.95.3 I got the same error???
No problem compiling MySQL .37 on
1 - 100 of 116 matches
Mail list logo
