Hi all!
I've downloaded the binary distribution
mysql-standard-4.0.9-gamma-sun-solaris2.9-sparc-64bit.tar.gz from
www.mysql.org.
I have a couple of databases on this installation, with all tables of
type MyISAM. However, on first start of mysqld the error log contains:
030226 12:39:48 mys
I do apologies I should have said has anybody been able to connect Sage
Accounting to MySQL
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)1323 438975
Fax +44(0)1323 738355
email [EMAIL PROTECTED]
URL www.bpenet.net
Also in Dublin & Luxembour
On Thu, Mar 27, 2003 at 02:35:18PM -0600, Jeff Kilpatrick wrote:
> It's also interesting to note that it's possible to split innodb data
> between multiple files to have databases larger than the OS's max file
> size.
The theoritical maximum table size for the various storage engines is:
BDB
On Fri, Mar 28, 2003 at 10:29:30AM +1100, Daniel Rossi wrote:
>
> ooo thats sounds like something to avoid , if the compiling doesnt
> even work dont go there, painful
Not everyone's having that trouble. I've been building 4.1 binaries
daily for a few months now. There have been a few problems,
On 28-Mar-2003 Aaron Williams wrote:
> I'd like to know about any potential issues of choosing a char(32) as
> the column type of a primary key instead of BIGINT or some other numeric
> type. A little background.
>
> I would like to generate a unique identifier to use as a primary key for
> our
Of course, I'd figure it out right after sending this. For the interested:
"alter table XYZ drop key foo;"
Take care,
--Noel
- Original Message -
Given an existing table with a field defined as:
"foo" char(60) not null unique
What would be the proper syntax for an ALTER TA
Hi all,
Hopefully a simple question for anyone who cares to take a swing at it:
Given an existing table with a field defined as:
"foo" char(60) not null unique
What would be the proper syntax for an ALTER TABLE statement, to remove the unique
constraint / key on this field? A "modify" doesn'
At 15:40 +1100 3/28/03, Daniel Rossi wrote:
hi there i would like to find out how to get the table from a field
if i am joining three tables together for instance select a.id,
b.id, c.id from a, b, c
when i get the results i need to be able to get the table name a if
i get the result from a.id
Thank you all for the responses,
This information is useful in determining what direction to take in
designing the application's use of the MySQL database. I am still a bit
unsure how a log based reconsiliation works when the system crashes
(using MyISAM tables). Does a lengthy reconstruction ha
On 27-Mar-2003 Ville Mattila wrote:
> Hello everyone,
>
> I was wondering how could I make a mirror copy of a table to another
> server
> in the easiest way? I browsed through the MySQL documentation but didn't
> find any clue of a "COPY TABLE" command or a similar method. I know that
> I
> can m
On Wed, Mar 26, 2003 at 03:51:09PM -0800, thomas getty wrote:
>
> Merge databases data (including images) directly into
> Acrobat-based Forms, without programming; optionally
> auto-email/fax generated pdf. Each pdf may be
> password/encryption protected. The database can be
> d
Thanks Peter:
- Original Message -
From: "Peter L. Berghold" <[EMAIL PROTECTED]>
To: "Brian" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 4:07 PM
Subject: Re: Your professional opinion Please...
> On Tue, 2003-03-25 at 18:11, Brian wrote:
> > What me
Thanks Mark:
- Original Message -
From: "Mark C. Roduner, Jr." <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 3:45 PM
Subject: RE: Your professional opinion Please...
> Brian,
> Here's Some hints on how to accomplish an efficiant way
> to index the data
> Regular Expressions:
> ([
hello,
Is there any registry entry of mysql which would help me to check if mysql is
already installed or not.I am installing my application with an installer,along with
which i also want to install mysql,so i first want to check if it is already installed
or not?I want to make this work o
Okay, I just found out what I was doing wrong. Having looked in the docs,
but I'm sure this is documented behavior.
> MySQL 4.0.12, MSW2k. Here's what's puzzling me --
>
> I set up a new user yesterday. I'm pretty sure I was able to connect as
> the user from the command line yesterday, before I
hi there i would like to find out how to get the table from a field if i am joining
three tables together for instance select a.id, b.id, c.id from a, b, c
when i get the results i need to be able to get the table name a if i get the result
from a.id , is it possible ?
--
MySQL General Mailin
ooo thats sounds like something to avoid , if the compiling doesnt even work dont go
there, painful
>>> "Martin Gainty" <[EMAIL PROTECTED]> 03/28/03 09:38am >>>
Hej Michael-
In order to to see 4.1 mysqladmin working
I started to compiling the 4.1 source obtained from bitmaker
Originally I had
Hello,
Are there any known issues using MySQL on Localhost with WinXP Pro and a
dual processor machine? The reason I ask is that I have a friend that is
trying to run MySQL with this configuration and he seems to have a lot
of problems keeping a connection to the database. Has anyone else seen
heh i've never tried it ?? all this bloody time
>= Original Message From Paul DuBois <[EMAIL PROTECTED]> =
>At 13:34 +1100 3/28/03, Daniel Rossi wrote:
>>hi guys is this possible ? order field1 and order by field 2 ?
>
>Perhaps, depending on what you mean. Did you try
>
>... ORDER BY field
Would MyODBC do what you want? I'm using it to connect MS Access to MySQL,
and also to connect a Borland Delphi application to a MySQL database. It
works pretty well. Consult the FAQ for known glitches with specific
applications.
> -Original Message-
> From: LaBranche, Kevin [mailto:[EM
At 13:34 +1100 3/28/03, Daniel Rossi wrote:
hi guys is this possible ? order field1 and order by field 2 ?
Perhaps, depending on what you mean. Did you try
... ORDER BY field1, field2
--
Paul DuBois
http://www.kitebird.com/
sql, query
--
MySQL General Mailing List
For list archives: http://lists
hi guys is this possible ? order field1 and order by field 2 ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I use redhat8.0 and default install RPM Mysql,but I don't install php and
apache default.
After the linux setup,I compiler the php4.3.1 and apache1.3.27 tar.gz,but
the phpinfo() MYSQL_LIBS and MYSQL_LIBS "no value"!!! why? how do I fix
this problem???
thankx~~~
--
MySQL General Mailing Lis
alx wrote:
On Fri, 2003-03-28 at 01:39, Bruce Feist wrote:
Usually it's best to work with normalized tables, which would make this
trivial. tbl_reports isn't normalized, since it has a simulated array
of persons in it. Could it be split into two tables:
i'm interested on how to normaliz
-Would joins of tables with character based primary keys be slower than
-those with numeric based keys?
Yes a join on a character based key is generally slower then on an
integer key. Key lookups in general are faster on integer based keys.
Since your PRIMARY KEY storage requirement is 30 bytes
At 13:22 +0100 3/27/03, Stefan Hinz wrote:
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this sho
Hi,
When querying a largish (370,000 rows) table, a unique compound index
on its three int columns performs slower (as slow as no index at all)
than when I use the same index created without the "unique" keyword.
I've repeated it dozens of times: Create the index unique, and it's
slow, create it
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databases data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
Christian,
> It looks like 'drop table' implicitely does a 'commit', at least when
> issued by the mysql commandline utility with mysql 3.23.51. This
> happens even if it was a temporary heap table as typically used to
> emulate subselects.
> I think this should be documented. (Or better yet, n
>Description:
Some options of the slave configuration are ignored when using the
option report-host before them.
The options I used where: replicate-do-db and replicate-ignore-table.
A configuration file should not depend on the order of the options if
it's not obvious...
>How-To-Repe
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databases data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
Hello
I use the mysql command line tool quite often and always wondered why
there's no feature that lets me quickly see the syntax of a "FOREIGN
KEY" or "GRANT" command. Now while browsing the source I found the
new "syntax" command in 4.0.12 and got the idea of implementing this
syntax help of my
I need some feedback on the capability of PF-Merge
from anyone who might share their experience. It seems
very solid from their testimonies at their web sites
though.
Merge databases data (including images) directly into
Acrobat-based Forms, without programming; optionally
auto-e
On Fri, 2003-03-28 at 01:39, Bruce Feist wrote:
> Usually it's best to work with normalized tables, which would make this
> trivial. tbl_reports isn't normalized, since it has a simulated array
> of persons in it. Could it be split into two tables:
i'm interested on how to normalize a table... c
Yes it will revoke those privileges, but only after you issue a "flush
privileges".
Generally speaking, It's a good idea to get rid of those "blank" entries
anyway... Just make sure your apps aren't connecting to the DB with those
"blank uname & passwd" privs first..
Cheers,
Andrew
-Origina
If you want to mirror a single table and your DB's don't both have full
access to each other then you can "push" one table from the server on the
private IP address to the other with a cron jobby by using (in unix) the
"mysqldump --add-drop-table -h someserver_with_good_permissions dbname
tablename
I'd like to know about any potential issues of choosing a char(32) as
the column type of a primary key instead of BIGINT or some other numeric
type. A little background.
I would like to generate a unique identifier to use as a primary key for
our application instead of using an AUTOINCREMENT colu
I believe that we have both already figured out that the index was at-least
part of the problem due to the fact that the MySQL needs to make more disk
writes in that instance. I do not need fast search capability, so I didn't
feel the need for the index, so dropping it helped.
I've heard a bit fro
Usually it's best to work with normalized tables, which would make this
trivial. tbl_reports isn't normalized, since it has a simulated array
of persons in it. Could it be split into two tables:
tbl_reports, with fields:
rep_id (primary key) and other report-specific information you didn't
menti
John Griffin wrote:
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
int unsigned not null auto_increment
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 79
It appears to me that fulltext phrase searches cannot include wildcards.
For example, I would expect "app* serv*" to match "application server,"
"application services," etc. But it returns no results, so I'm having to
run each variation separately. Can anyone confirm that wildcards, indeed,
can't
Is creating a cronjob a feasible alternative?
-Original Message-
From: Ville Mattila [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:50 PM
To: MySQL Mailing List
Subject: Mirroring a table
Hello everyone,
I was wondering how could I make a mirror copy of a table to another se
Hello list i have mysql under solaris 8
my mysql version is
Ver 11.18 Distrib 3.23.55, for sun-solaris2.8
the mysql startup with follow parameters
cd /export/home/sil/usr/local/mysql;/bin/sh
/export/home/sil/usr/local/mysql/bin/safe_mysqld --user=mysql
--port=3306 --chroot=/export/home/sil
I had a very similar problem a couple weeks ago, although in that instance I
was using MySQL 3.23. But in any case, I had a perl script that was
inserting thousands of records in chunks, looking up an id based on a name
for each record. It would get progressively slower and slower the longer it
ran
I am trying to clear up our msyql by revoking privileges for users who no
longer exist on a particular server.
If I delete the users in the appropriate tables in the mysql database, will
that revoke their privileges?
I found in the user table in the mysql a few 'users' with no username or
passwo
Has anyone got a way to implement column type 'serial' in a innodb table?
-jpg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>I've tried it both as fixed (char) and variable (varchar). Interestingly
>when I set is as char when building the table, MySQL changes it to varchar
>sometimes (but not always).
It will change a char to varchar if there is another column of variable size
in the table.
--
MySQL General Mailing
I have two tables.
tbl_reports and tbl_personnel
tbl_reports has these fields:
rep_id, person1, person2, person3, person 4
tbl_personnel has these fields:
per_id, fname, lname, mname
What is the way to get each report back once, and have the fname,
mname, and lname fields available to print
On Wed, Mar 26, 2003 at 04:45:01PM -0800, Daevid Vincent wrote:
> http://www.mysql.com/doc/en/String_functions.html
>
> Your MySQL connection id is 14 to server version: 3.23.56-Max
>
> mysql> SELECT HEX("abc");
>
> ++
> | HEX("abc") |
> ++
> | 0 | << thi
Paul,
???
I see Linux x86 RPM downloads under
http://www.mysql.com/downloads/mysql-4.0.html
Regards,
Thomas
On Wed, 26 Mar 2003, Paul wrote:
> This may indicate incredible ignorance but all I can find there are
> tar.gz files which untar into the complete distribution but no rpm's are
> prese
At 16:45 -0800 3/26/03, Daevid Vincent wrote:
http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql> SELECT HEX("abc");
++
| HEX("abc") |
++
| 0 | << this should return 616263 according to th
Also you can do
mysql -u userid -p -h hostname dbname < /path/to/your/script.sql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Anderson Pereira Ataides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 5:37 AM
What does the table DDL look like. Is the table a fixed or dynamic format?
-Original Message-
From: Dan Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 11:08 AM
To: [EMAIL PROTECTED]
Subject: Slow Inserts
I've been having trouble with some large tables getting what seems
Hi,
On Thu, Mar 27, 2003 at 05:35:22PM -0500, Gary Huntress wrote:
> > >I have noticed on many occasions some extensive traffic on my internal
> > >network that I cannot explain. Below you will see two sets of tcpdump
> > >traces. I have a mysql server running on my internal host named
> > >"h
Dear Alexander,
I am running mysql 4.0.12 on both the master and slave servers. I am
facing the same problem with a slight variation. When I am trying to
import my database dump on the master the replication fails and slave
thread exits with the following error in the hostname.err file on the s
You could make the column a unique key...that would prevent duplicates from
being entered. Then if you want to be able to try inserting duplicates (like
if you don't want the query to fail on duplicate attempts), you could do
INSERT IGNORE INTO myTable ...
Check http://www.mysql.com/doc/en/CREATE_
Hi,
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" an
Dan, you can use:
mysql -e "YOUR SQL STATEMENT"
[]s
Anderson Pereira Ataides
Em Qui 27 Mar 2003 08:03, Daniel Kiss escreveu:
> Hi all,
>
> I have a question about mysql client. How can I use it in such a way that
> it just executes a script on a specified database and then exists?
>
> Thanks,
>
Has anyone used saga to connect to MySQL database? If so what tools did
they use?
Michael Johnson
Managing Director
Humphrey Consulting Limited BPEnet
Tel/Fax: 0870 922 0247
email: [EMAIL PROTECTED]
websites: www.humphreyconsulting.co.uk & www.bpenet.net
iH
i found in the ODBC faq how to link from mysql to access, can this be
done in reverse? link from access to mysql?
thanks
- hcir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:33 PM
Subject: Re: Confused about network traffic on mysql port
> >I have noticed on many occasions some extensive traffic on my internal
> >network that
At 16:21 +0100 3/27/03, lasse wrote:
Hey...
what is my_getopt.h really?
when compiling mysqlcc i get loud errors (probably) originating from that
include, wich i don't have on my system...
A system about which you supply no details, ahem. :-)
If you're on Linux, install the -devel RPM.
Otherwise,
Hej Michael-
In order to to see 4.1 mysqladmin working
I started to compiling the 4.1 source obtained from bitmaker
Originally I had 1000 errors with 1000 unresolved link errors..
I am down to about 50 on both counts
God Tur-
Martin
- Original Message -
From: "Michael Edlund" <[EMAIL P
http://www.mysql.com/doc/en/String_functions.html
Your MySQL connection id is 14 to server version: 3.23.56-Max
mysql> SELECT HEX("abc");
++
| HEX("abc") |
++
| 0 | << this should return 616263 according to the docs.
++
mysql> SELECT HEX(255
I've considered that. But there are no indications that is the case, I
sniff traffic to that box from my firewall (that could be compromised too of
course) and I see nothing suspicious. The only traffic on that box is on
the mysql port.
Since I see this traffic on the mysql port when the server
On Thu, Mar 27, 2003 at 10:41:32PM +0100, Michael Edlund wrote:
> http://www.mysql.com/downloads/mysql-4.1.html
> "Binaries will be available soon."
Yeah. I've got unsupported binaries on-line.
http://jeremy.zawodny.com/blog/archives/000605.html
Don't know if that helps you or not.
Jeremy
--
On Thu, Mar 27, 2003 at 12:54:49PM -0800, Dathan Vance Pattishall wrote:
> ISAM tables have a 4GB limit myISAM tables do not have a filesize limit.
> There is a big difference between ISAM and myISAM.
Ah, okay. I read ISAM as MyISAM. Sorry. :-(
Who's still using ISAM anyway? :-)
Jeremy
--
Jer
Somebody got control of mysql, or your rooted?
-Original Message-
From: Gary Huntress [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Confused about network traffic on mysql port
I have noticed on many occasions some extensive traffic on my
> I've tried it both as fixed (char) and variable (varchar). Interestingly
> when I set is as char when building the table, MySQL changes it to
> varchar sometimes (but not always).
>
> Here's a structure dump:
> CREATE TABLE soldierMain (
> id int(20) NOT NULL auto_increment,
> timeadded varch
Hey...
what is my_getopt.h really?
when compiling mysqlcc i get loud errors (probably) originating from that
include, wich i don't have on my system...
Any ideas?
--
-BEGIN GEEK CODE BLOCK-
Version: 3.1 (2002 update)
GCM/GCS/GMU/ d+ s++:++ a-- C++() UBLAIS+() P+ L+(-) E--- W+++
ISAM tables have a 4GB limit myISAM tables do not have a filesize limit.
There is a big difference between ISAM and myISAM.
Yes you can have multiple InnoDB tablespace files across many
filesystems this is true. For ISAM OR myISAM tables the filesystem does
come into play so it's not an irrelevant
Would you care to elaborate on that - Using PHP there is no error or return
code - it just goes along happily saying the record was inserted. If there
is a way to do this, please explain.
TIA
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "C. Reeve" <[EMAIL PROTECTED]>
Hi!
> "Wynne" == Wynne Crisman <[EMAIL PROTECTED]> writes:
Wynne> I am trying to determine what would cause my needing to rebuild an
Wynne> MyISAM table in MySQL 4.0.x?
You should not have to rebuild any tables just to upgrade to MySQL 4.0
from 3.23. The MyISAM format has not changed in an
Hi!
> "Ralf" == Ralf Hupfer <[EMAIL PROTECTED]> writes:
Ralf> Hi,
Ralf> I do face problems building MySQL 3.22.32 with gcc 3.2.2 on an Alpha-
Ralf> DEC-OSF4 workstation.
MySQL 3.22 ?
Ralf> CC="cc -pthread" CXX="cxx -pthread -O" ./configure --with-named-t
Ralf> hread-libs="-lpthread -lmach
On Thu, Mar 27, 2003 at 02:28:37PM -0500, Gary Huntress wrote:
> I have noticed on many occasions some extensive traffic on my internal
> network that I cannot explain. Below you will see two sets of tcpdump
> traces. I have a mysql server running on my internal host named
> "herzegbol" and a w
Hi all together!
Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
t
Hi all together!
Meanwhile I found out that what I am looking for is best known as
"negative testing", trying to break an application puckish, to make it
fail more or less serious by going bejond the borders. I am really
really in a hurry (and stuck at the moment) getting information on this
topic
I've tried it both as fixed (char) and variable (varchar). Interestingly
when I set is as char when building the table, MySQL changes it to varchar
sometimes (but not always).
Here's a structure dump:
CREATE TABLE soldierMain (
id int(20) NOT NULL auto_increment,
timeadded varchar(14) NOT NULL
http://www.mysql.com/downloads/mysql-4.1.html
"Binaries will be available soon."
"Soon" has in this context shown to be very relative... :-)
What milestones have yet to be reached before binaries for MySQL 4.1
are being made available?
Michael
Helloworld Media
Box 13085, 103 02 Stockholm, Swede
Hi friends,
I am using MySQL 4.0 (with Embedded Server) on a Mac OS X
(Darwin) machine. I am using the C API of MySQL in my programs. I have a
few questions regarding this.
1) When I compile my programs with the g++ 3.1 compiler, i get the
following warnings:
ld: warning multiple defini
Read about replication in the manual.
This may be what you need.
Ville Mattila wrote:
Hello everyone,
I was wondering how could I make a mirror copy of a table to another server
in the easiest way? I browsed through the MySQL documentation but didn't
find any clue of a "COPY TABLE" command or a s
On Thu, 27 Mar 2003 01:47:59 -0500
C. Reeve wrote:
> Nothing happens.
>
> mysql_query ("INSERT INTO userdata (email, passwd, firstname)
VALUES
> ('$entered_email','$entered_passwd','$name')");
mysql_query return a value. What is that value? Is the user that you
are conne
We recently installed php and Mandrake 9. Php is no recognizing any of
the mysql statements. On a working php installation the two extensions
mysql.so and gd.so are in the /usr/lib/php/extensions directory. How does
php create this directory for mysql. By unchecking the two extensions in
On 27-Mar-2003 C. Reeve wrote:
> I got it - stupid me has a unique field that I wasn't using in the test
> script I was using - so every I tried to add an entry this field was a
> duplicate and as such did not add the record. Is there a way to put
> something in so mysql would tell me this - 2 ho
Error 13 is a permissions denied problem.
Make sure the data directories and files are owned by mysql.
Bill Davies wrote:
I am having trouble getting MySQL 3.23.51 running on macOS X 10.1.5
(Darwin)
** First it won't let me assign a root password, I think because it's
not running.
Trying to ch
Try reading your return codes.
You got a duplicate key error that you were ignoring.
C. Reeve wrote:
I got it - stupid me has a unique field that I wasn't using in the test
script I was using - so every I tried to add an entry this field was a
duplicate and as such did not add the record. Is there
I've been having trouble with some large tables getting what seems to be
corrupted.
Here's the situation:
I have several tables that have 3 million to as much as 7 million records. I
have a process that I run against those tables that pulls out a record based
on specific criteria (select id,name f
Hello everyone,
I was wondering how could I make a mirror copy of a table to another server
in the easiest way? I browsed through the MySQL documentation but didn't
find any clue of a "COPY TABLE" command or a similar method. I know that I
can make a dump from a table and then run that dump file i
I have noticed on many occasions some extensive traffic on my internal
network that I cannot explain. Below you will see two sets of tcpdump
traces. I have a mysql server running on my internal host named
"herzegbol" and a windows 98 host named shelbyville
This trace is when the MySQL server i
Howdy,
Can anyone recommend a good reference book for using PHP with MySQL?
I've read and enjoyed Paul's 'DoorStop' and 'CookBook' and have a fairly good
grasp of MySQL. I've also written a bare bones database browser for Win32 using
Apache, MySQL, and PHP, so I'm not an absolute newbie. But a b
On Thu, Mar 27, 2003 at 12:17:45PM -0800, Dathan Vance Pattishall wrote:
> ISAM tables are cut off at 4gb of data
No, they aren't. I have a 9GB MyISAM table here. By using a MAX_ROWS
specifier, you can suggest that MySQL use larger row pointers (more
than 4 bytes).
> MYISAM / INNODB /BDB have a
On Thu, Mar 27, 2003 at 11:58:54AM +0500, Sohail Hasan wrote:
> Hi all,
>
> I am getting a replication failure on the slave when I run a dump import
> of my database on the master. Both servers are running mysql 4.0.12
> production release. The error displayed on the slave error log file is
> a
On Thu, Mar 27, 2003 at 11:30:19AM -0800, Nick Arnett wrote:
> I've searched and searched, but I can't find anything that describes the
> format of a custom stopword file for fulltext indexing in MySQL. Anybody
> have a pointer or a description of the format?
I'm pretty sure it's just one word pe
It's also interesting to note that it's possible to split innodb data
between multiple files to have databases larger than the OS's max file
size.
-jeff
On Thu, 2003-03-27 at 14:17, Dathan Vance Pattishall wrote:
> ISAM tables are cut off at 4gb of data
> MYISAM / INNODB /BDB have a filesystem lim
Christian,
- Original Message -
From: "Christian Jaeger" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, March 27, 2003 1:42 PM
Subject: Innodb transactions and drop table
> Hello
>
> It looks like 'drop table' implicitely does a 'commit', at least when
> issued by
ISAM tables are cut off at 4gb of data
MYISAM / INNODB /BDB have a filesystem limit.
I suggest to limit the maximum size of data file: find out if reiserfs
can set a limit on files sizes. I know that EXT3 a few revisions ago
could not go past 2GB per file. Or prune your data so it doesn't get to
bi
Mr. Zawodny is right MyISAM natively does not support Transactions, but
Transactions can be done with a set of myISAM tables and a lot of code
specific to supporting transactions w/o a race condition. Basically it's
a long a tedious process of writing code to support a "ticket server" (a
unique id
I've searched and searched, but I can't find anything that describes the
format of a custom stopword file for fulltext indexing in MySQL. Anybody
have a pointer or a description of the format?
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
Sunil-
Seems the easiest way to restrict the size of everything except
privilege tables is to use nothing but InnoDB tables. You can set the
default table type using --default-table-type=InnoDB when launching
mysqld.
If you're not keen on that, you may want to look into using a quota on
your mys
Hi all,
I have a question about mysql client. How can I use it in such a way that
it just executes a script on a specified database and then exists?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
1 - 100 of 116 matches
Mail list logo
