Martin Thoma wrote:
Hello !
I'm a database-newbee. What I need is a column that makes the record
unique. The content should be generated autoamtically and it should be
able to get a lot of records (BIGINT would be nice). But I don't know if
I should use PRIMERY KEY, KEY, INDEX or UNIQUE.
GATOR-root wrote:
Description:
We had an NFS incident and used CHMOD and CHOWN to repair it.
Shortly there after, we noticed that our MySql under WebRT did not work.
We presume that we corrupted the ownership and permissions of files and
programs within MySQL.
How-To-Repeat:
PHP handles persistent connections by leaving them open
for some other identical connection request. The next request
will check for a free connection.
see
http://www.php.net/manual/en/features.persistent-connections.php
In other words, you don't need to worry about when they are closed
php
Ann Ricchiazzi wrote:
Dear mySQL Users,
I am trying to choose between mySQL and Oracle for a Linux server. My
specific questions are:
1) Will mySQL handle 3000 hits/day well?
2) Does mySQL handle multi-media file formats? For example, if I want to
store audio clips, or Flash movie
I thought I should send this to the regular mysql list as there
are many mysql users who run DB on unix but must use windows
for a workstation and remote administration.
This is an excellent front-end.. It has the best UI of any of the
other windows front-ends I've seen, it is very fast, this
Elekes Attila wrote:
Steve Ruby wrote:
Elekes Attila wrote:
Hi!
The mysql server (version 3.22.32-4) has hanged up, and the restarting
causes a part of the
*.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
from these files :(
Is there any method
Chuck Barnett wrote:
How do I copy the data from one table to another table with a time stamp
every night?
example: table A contains x,y,z.
at midnight, I want to copy table A's contents to table B (B has same
fields, just adds a date field) and reset x,y,z to zero.
what do you
Chuck Barnett wrote:
Thanks for replying.
I know the SQL commands, I want to know how to automate the whole sequence.
I've always written php pages that do the calls. I want to write a script
to do it on the server as a cron job or something.
Ahhh, pardon my confusion, since this the
"J.M. Roth" wrote:
Hello,
I just installed the newest MySQL (3.23.32) with PHP 4.0.4pl1 (shared
module) on an Apache 1.3.12 (Linux).
Some SQL syntaxes that worked before don't anymore.
E.g.:
$query = "SELECT * FROM $userstable ORDER BY when DESC LIMIT 0, 3";
doesn't work:
Leonardo Dias wrote:
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
But if you use IP
James Ervin wrote:
Can you restore from a backup of the mysql data directory or do you need to
dump the database in order to be able to restore? I have seen some traffic
on the list that suggests that a dump is the way to go. I backup the data
directory each night, but I would hate to
Scott Baker wrote:
That's the way that I do. I setup my server to shutdown the MySQL process
at 3am, zip up my var directory, and then restart the process. Can you
copy the data with the server running?
If you are shutting down the server, why don't you just copy the files
out to the
SED wrote:
Hi,
Can I have two (or more) different SQL-databases running at the same time on
the same server (or same computer)? Does it varies between the systems?
And if I can, are they all available to PHP at the same time?
Regards,
Sumarlidi Einar Dadason
See "create database"
No, mysql cannot connect to other database servers, it can't even connect
to other mysql servers except through replication.
John Halladay wrote:
Connecting to the tables in MySQL works fine. For example I can connect to
the MySQL tables using MS Access. I would like to know if it is
Jang wrote:
Hello,
I'm new in this MySQL list. I only want to know what are the default
privileges that are required, so that a normal user (wihtout any special
priv.) can acces only to his DB, create tables, manage, insert, ..., his
tables.
I have try some differents config, but never
Sanjeev Kabra wrote:
Hi,
I installed MyODBC and even configured it. MySQL db running on Solaris is
running under the root user. While defining the DSN using MyODBC in the
username I tried putting root user and the password for the same but I keep
getting error "can't connect to MySQL
Geoff Coffey wrote:
I am new here...
I am in the process of migrating a site built with FileMaker Pro to MySQL
and PHP mostly because filemaker's web capabilities are too limiting. In one
situation, we have a database of about 20,000 rows that contains two text
columns. One is the full
Aaron Williams wrote:
Hello list,
After searching the documentation on the site, as well as the archives, I
have yet to find the answer to this question. If I have overlooked it
somewhere, just point me in the right direction.
The question:
I have two tables, set up exactly the
Henrik Lebtien Mohr wrote:
Hi there
I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
I get an error "Multiple-step error" when I try to update a recordset like
the following:
with rs
.fields("date") = null 'timestamp datatype
.fields("nOnline") =
Steve Ruby wrote:
Does anybody know what is the fastest way to run a large multiple
AND type query on a many-many table and the least memory hungry.
For example if I have
create table test (id int, value int);
which has many-to-many on id, and value
I want to do a select like
Kuokai Shyu wrote:
Hi,
Can MySQL do the queries on the databases stored in the CD-ROM?
For example, when switching data CD-ROMs, is it necessary to shutdown
mysql server, and restarting server after mounting another CD-ROM?
Thanks in advance.
Sincerely,
Kuokai
I assume if
Bob Hall wrote:
I want to do a select like
select id from test
where id in (select id from test where value in (1,2,3)
and id in (select id from test where value in (4,6,7)
and id in (select id from test where value in (1,6,25)
Even if MySQL supported subqueries, this query would
"Ung, Seng" wrote:
hi:
Here is my SQL statement to select a range of number from 0-9
Is there a short cut to this?
id like '1%' or id like '2%' or id like '3%' or id like '4%' or id like '5%' or id
like '6%' or id like '7%' or id like '8%' or id like '9%' or id like '0%'
see REGEXP
Brian Reichert wrote:
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
When I try to do a mysqldump on the localhost, I get an out-of-memory
error:
# mysqldump -uroot -proot customer audit_trail_271
mysqldump: Out of memory (Needed 8164 bytes)
mysqldump: Got
"Carsten H. Pedersen" wrote:
Does anyone know how to find duplicates in a table and deleting
them. I can't figure out how to structure the query.
Linsen
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_6_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk
If OPTIMIZE TABLE appears to be writting to a temporary file
while it works (.TMM).. Why must it lock readers out of the original
table file?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Quentin Bennett wrote:
Hi,
For an indexed column, the index is used if the start of the string is used:
LIKE 'a string of text%' may use an index
LIKE '%any old string%' will not, since the start of the string is unknown.
The index will only be used if the server decides that it
Quickling wrote:
Hi,
Question 1:
---
We've got a server app that does a lot of 'small' database reads and
writes. We were originally using MS Access via DAO (Jet Engine) and we
wanted to tighten up DB performance, so we've written a general ODBC
database wrapper object,
[EMAIL PROTECTED] wrote:
Hello,
When you create a query, how do you save it? Is there a special
command to save a query?
Thanks Mark
Query is just text... if you are in unix under mysql monitor
you can do
\e
on any line after you run the query (and before you type a new one)
You may be looking too far for your problem...
Your join_buffer and sort_buffer are probably a little large if you
have man concurrent users.
Must you use an old version of mysql?
You should analyize or post EXPLAIN of your query so that you/we
can see that it is properly indexed.. you should
Does anybody know of any commercial or opensource CRM systems that
run with MySQL on Linux (and/or FreeBSD)?
Mainly I need canned responses and ticket management and some other
standard features.
-
Before posting, please
PID is stored in a file in the datadir named
hostname.pid
[root@georgia data]# cat /usr/local/mysql/data/georgia.pid
19805
Teddy A Jasin wrote:
Hi,
wat command to type under linux to get the PID of the mysqld that is running?
i tried : 'ps aux | grep mysqld' but this will list the mysqld
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.
Richard Reina wrote:
I posted
|Boston |
| 391 | 1 |Miami |
+-------+
Steve Ruby wrote:
Your question was answered already after you posted it on Saturday
by Fred van Engen...
Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg,
"Matthew P. Marino" wrote:
So, what do you do with a "tarball" anyways. Since compiling the source is
hopless( "sql_yacc.cc"), I'm looking for a binary.
then download the binary.. Or at least do a better job of describing your
problem...
"Matthew P. Marino" wrote:
If you go to http://www.mysql.com/downloads/mysql-3.23.html, you will see the
binary(tarball) distributions. They don't end in .tar.gz but I supposed that was
a technical oversight. Of course I feel like a (_?_) (i.e dumb a**) not being
able to track down the
Jack Dempsey wrote:
Hi all,
I'm wondering if it's possible to do something like that select line in
the subject...often i want to select * but not one or two fields...i
found something about this in the to do list for mysql4.0, but i'm
guessing that's not exactly what i'm thinking...is
His balance is a running balance...
Joseph, you will have to keep the running balance in some thing
that you write to get the query.. you can't do a running sum
in SQL directly. You can only use the examples people provided
to get the net per line.
Joseph Bueno wrote:
[EMAIL PROTECTED] a
John Tsangaris wrote:
If I turn on auto increment and let it do it's thing and then later on
delete a few of the entries (let's say 1, 2, 3) and the current high entry
has an id of 45.. why does mysql continue with 46 instead of using up 1, 2,
and 3 first? Is there a way to bypass this?
Dale Frohman wrote:
Is there anyway to do a query and search for the most frequent
word that appears in a particular field in a table?
ie:
ITEM DESCRIPTION
Blue Dog
Red Dog
Yellow Cat
I would want to spit out "Dog" as being the most reoccuring word.
Thanks
Cindy wrote:
SELECT
Foster_Dogs.dog_name,
Foster_Dogs.dog_status,
Foster_Dogs.date_resolved,
Foster_Dogs.adopting_family,
Foster_Dogs.foster_paperwork,
Foster_Dogs.dog_id,
Adoption_Applications.firstname,
Cindy wrote:
SELECT
Foster_Dogs.dog_name,
Foster_Dogs.dog_status,
Foster_Dogs.date_resolved,
Foster_Dogs.adopting_family,
Foster_Dogs.foster_paperwork,
Foster_Dogs.dog_id,
Adoption_Applications.firstname,
"Todd A. Jacobs" wrote:
I downloaded and compiled the latest version of MySQLGUI and am connecting
to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
following ssh tunnel:
ssh -x -g -L 3306:localhost:3306 mysql
I get this error message from the MySQLGUI
It depends on your table type, check the manual, you will want
myisamchk or isamchk if you are using 3.23.x you can do SQL
REPAIR TABLE so long as your table is MyISAM.
Dave Loisel wrote:
I have filled my hard drive by inserting data into a table (15 gigs).
The table was then corrupted.
Jonathan Dugan wrote:
your documentation is simply wrong. NONE OF THE USER PERMISSION materal makes sense.
I am read ing here
http://www.mysql.com/doc/D/e/Default_privileges.html
and
http://www.mysql.com/doc/A/d/Adding_users.html
and I follow what is says:
shell mysql -u root mysql
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill connect num"?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without taking down the server..
Steve Ruby wrote:
If I have a connection that executes a bad query shouldn't I
ALWAYS be able to kill it with "kill connect num"?
I have a query that keeps getting stuck, (who knows what
it is doing) but that State is "statistics"
I can't ever kill it without ta
Kilian Looser wrote:
Hi,
i've the following setup:
LoadBalancer - five Webserver with Apache and mysql - Database
Now i got a problem. i've user's they insert records in the database. Now the insert
is going throu, for example, webserver1. Now i'm doing a select throu webserver2 and
Christian Hammers wrote:
Hello list
While browsing old sources by a former employee I realised that he always
did comma seperated joins and then a "where"
FROM
tablea a, tableb b, tablec c
WHERE
a.id=b.id and b.nr=c.nr
whereas I learned to do
Steve Ruby wrote:
Christian Hammers wrote:
Hello list
While browsing old sources by a former employee I realised that he always
did comma seperated joins and then a "where"
FROM
tablea a, tableb b, tablec c
WHERE
a.id=b.id and
Tom Flanagan wrote:
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Thanks,
Tom Flanagan
If you are using MyISAM tables (3.23.x) you can simply copy them from
one computer to the other. If you are using ISAM tables like in
3.22 you
Christian Hammers wrote:
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
He is doing an inner join, you are doing a left join, they (potentialy)
do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value
Christian Hammers wrote:
On Thu, Mar 08, 2001 at 10:29:20AM -0700, Steve Ruby wrote:
He is doing an inner join, you are doing a left join, they (potentialy)
do not produce the same results.
Hmm have to think about it... inner means fields where the right table has
a NULL value
Andrew Staples wrote:
New to list, and to mySQL. If there are archives available, please let me
know--I'll search them.
I have a client who is building a new win2k server, and wants to use
ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it
will work with myODBC,
Roger Westin wrote:
Hi,
Have a problem with big tables,
Cant get them over 2GB
Using mysql 3.23.33
and ReadHat Linux 6.0 Kernel: 2.2.5
Need to biuld a table atleast 70Gb so Anyone?
switch to a file system that supports very large files
The problem should be with linux no mysql.
[EMAIL PROTECTED] wrote:
On Fri, 9 Mar 2001, Jon Haworth wrote:
Not sure exactly what you're after... MySQL isn't an Apache module, it's a
separate program.
Where can I find Apache module for mySQL ??
maybe "mysql module for apache"?
regards
--
You mean mod_auth_mysql,
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
with best regards,
Keneth
Read the manual, read
"Gupta, Sanjeev" wrote:
Hi,
I have tried to create a table with two fields. One is type CHAR and other
is VARCHAR and it convert the CHAR to VARCHAR automatically. IS it a bug or
i need to do some setting to work properly.
I am working on WINNT machine.
Jordan Russell wrote:
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be
viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY
Randy Johnson wrote:
When a text with an apostrophe in it has a \' in it. How can I fix this?
example
randy's is stored in the DB as randy\'s
thanks
Randy
If you just want to fix that one instance just do
update tablename set columname = 'randy\'s' where somekey...
gnanas wrote:
Dear Sir,
We are from Chennai, India.
We are holding one site constructed using JSP pages. We couldn't connect to the
mysql database using myodbc driver! The
specified driver is not installed in the virtual server the hosting company!
Do we have any otehr alternative?
rozakdemir wrote:
Hello,
I am using MySQL on windows platform. How can I port mt datas from MySQL server on
windows to MySQl server on Linux?
Thanks for all.
You should search the sarchives and manual, this is a very FAQ...
tables extension is like .MY* you can just copy them, if
not
Pawan Kanda wrote:
Hi , i have the following method:
public Object getValueAt(int row, int column){
// in here i want to construct a SQL query which gives the object at a
certain
row and column
}
Do you know how to do it?
Thanks
Pawan
Maybe make your sql statement read
sql =
Patrick Calkins wrote:
Hello all;
Are there any known problems with storing the database files on a NAS
(network attached storage) device??
also, can you run multiple MySQL daemons pointing to one common database, so
you could have a "cluster" of database servers and one database??
"Alexey V. Litvinov" wrote:
Hello JCampell,
Friday, December 22, 2000, 11:25:51 AM, you wrote:
RTFM about SELECT and about DISTINCT option
J I want to know if it is possible to build a MySQL query which will only
J return the unique values of a specific column. Ie if I had this
How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without
Luis wrote:
Good morning all, last night I installed MyODBC on my laptop. What i dont
understand is how do i connect threw access now?
I'm a little confuse, can anyone help me understand how MyODBC works.
luis
It is an ODBC driver for Mysql.
Create a databsae in mysql
go to the ODBC
Probably should change that first line to
rpm -qa | grep -i mysql
Roel Vanhout wrote:
rpm -qa | grep mysql
if nothing found,
rm -rf /usr/local/var
rm -rf `find /usr/local/bin/ | grep mysql`
rm -rf /etc/my.cnf
This should catch about everything.
cheers,
roel
On Sun, Apr
Fabio Galarraga wrote:
Hi to all:
I have a linux script and I need it can execute some mysql commands.
Is it possible? If possible, how?
Best regards,
Fabio Galarraga
[EMAIL PROTECTED]
see
mysql --help
you probably want
mysql -e "SQL code here" dbname
Andrew Warner wrote:
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date = 20010418 AND date 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
Use now()
Matthew Hafner wrote:
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
RTFM
www.mysql.com
Hi all,
I'm looking for some pointers towards some good information on accessing
and using MySQL with Java/Javascript.
Can anyone point me towards a book you like, or some good web resources?
Thanks much,
/Rob
You'll need a servlet and/or JSP engine such as
listed here
Roger Karnouk wrote:
Is it possible in a Select query to get values from the previously read row
in order to do things like cumulative sums or other formulas which require
the previous value in order to calculate the current value.
ex.
day current sales cumu_total
-
http://www.mysql.com/doc/c/o/configure_options.html
http://www.mysql.com/doc/A/d/Adding_character_set.html
Luis Hoeks wrote:
I would be very pleased, if someone could tell me if MYSQL supports asian
character sets like big5 or thai charctersets.
If yes, what do I need to install to get
For over a year the topic of mathematical operations on date values
has been disussed. It has never been possible to perform such math
on a date value without using DATE_ADD or converting the to days or
seconds first.
Why is this now all the sudden a reasonable bug?
Aurelian:
I suggest that
Your Name wrote:
dear sir/madam
i'm currentlly doing a research on MYSQL and i would like to know more
information about it :where does MYSQL come from who created it ...
www.mysql.com
-
Before posting, please check:
Alec Solway wrote:
Hi,
In various create table statements char columns are converted to varchar..
I was wondering why this was happening. Here's an example:
CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
null, city VARCHAR(255) not null, state CHAR(2) not
VVM Ravikumar Sarma Chengalvala wrote:
Hi,
How can I have an UNIQUE key in MYSQL which
differentiates between case sensitive strings.i.e If I
want to store XYZ,XYz and xyz
differently.Currently mySQl is not accepting this type
of strings and treating them as the same.
Regards,
Ravi
when a BDB table is being written to and another thread
issues a query I sometimes get this error code. Ideas?
The table is fresh it was created by the dumpfile that another
thread is loading in while I'm running the count query.
this is mysql-max 3.23.37
mysql select count(*) from _data;
green jon wrote:
Hello,
I have recently converted my Java Servlets to run against mySQL where previously I
was using Microsoft Access. I use Tomcat and have swapped drivers etc and everything
works fine, more or less. However, I have one big problem which is as follows :-
InnoDB definately provides more features that BDB, and is probably
going to be faster, Gemini isn't available yet. BDB might be more
complete/stable.
So I'd say Gemini is out of the picture unless you are looking longer
term. I'd do some testing with both we found some bugs in the 3.23.37
Don Pro wrote:
Hi,
I'm reading in my documentation (I have a book) that MySQL allows up to
101 simultaneous connections. Gadzooks! How can MySQL claim to be at
the Enterprise level with this limit? Is there any way around this?
Thanks,
Don
Don Pro wrote:
Hi,
I'm reading in my documentation (I have a book) that MySQL allows up to
101 simultaneous connections. Gadzooks! How can MySQL claim to be at
the Enterprise level with this limit? Is there any way around this?
Thanks,
Don
I've been doing some testing to determine tradeoffs with performance
for using the Innobase or BDB tables.
The testing application contains bulk inserts which must be processed
as quickly as possible. The results I'm getting look very bad for
innobase. Am I doing something wrong?
I'm
Heikki Tuuri wrote:
Steve,
you should set autocommit=0 and only call commit after the
whole batch of inserts.
so then if I'm inserting via a mysqldump file I should
append commit; to the last line of the file?
If you use autocommit=1 and insert each row in a separate transaction,
Steve Ruby wrote:
Steve Ruby wrote:
I'm inserting 49,990 rows via file containing individual inserts
(1 insert per sql statement). The table contains 7 columns and 6
indexes.
Why is there so much difference on the time taken to insert the
files?
averages:
MyISAM45
Is there a plan to have any tablespace management tools for innobase?
I personaly dont' care if these are via a separate program or through
the mysql SQL interface but the following would be very handy.
move tables between tablespaces
list tables in a tablespace
shrink tablespace
It is
There seem to be some operations that cannot be performed on the
server whie InnoDB is doing something.
For example I inserted about 200,000 rows in to a table from
a file (mysql database file) the file starts with begin; and
contains many inserts, I cancelled (ctrl-c) in the middle of the
Heikki Tuuri wrote:
Steve,
on what operating system you are running?
linux, intel 2.2.12
Was the rollback (and the table load) disk bound? Did you configure much
memory to the InnoDB buffer pool?
I would say the rollback was processor bound, the machine was running
with almost no
Chris Wilkinson wrote:
I am attempting to upload an Access db to a remote mysql server - at
dsvr in the UK.
I get connected (I think) but receive the following error message:
Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
Can you point me in the right direction
database and click OK
Then up comes the error. I previously got a wrong user name and
password error but solved that one by correct configuration.
Hope you can follow what I am doing or doing wrong from this.
CHRIS
In message [EMAIL PROTECTED], Steve Ruby
[EMAIL PROTECTED] writes
Chris
mytextfile_fromaccess
Chris Wilkinson wrote:
Can you give me a sample command line please
CHRIS
In message [EMAIL PROTECTED], Steve Ruby
[EMAIL PROTECTED] writes
Chris Wilkinson wrote:
I am attempting to upload an Access db to a remote mysql server - at
dsvr in the UK.
I get
Cyber Monkey wrote:
I have found an isp that will leave port 3306 open for me to talk to the mysql
server, my question is
Is anything sent over this connection secure, if not is there some way of encrypting
it such as ssl?
Yes.. you ssh like here
www.ssh.com
www.openssh.org
and do
VVM Ravikumar Sarma Chengalvala wrote:
Joshua,
Comparing Oracle vs. MySQL myisam tables, MySQL will
save disk space, and provide you with much faster
queries, but you have to be aware of the table
locking issues if you are doing
updates/inserts/deletes mixed with reads.
MySql
Look up link or something in the manual. There is a way to do
virtual symbolic links in NT with mysql without installing anything,
it has to do with adding paths to the my.cnf file, see the docs
for details.
Tracy A. Mitchell wrote:
You can do this with NT Server as well. It is called
What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an
Kenneth Kopelson wrote:
So, how do we get support in MySQL so that multiple instances of the mysqld
daemon running on separate machines can all access the same database files
located on a central server? I can see how the file system of the central
database server could be exported through
There are really only two. mm.mysql (varisous version)
and the twz one.
I suggest the mm.mysql one. They are both type 4 I believe there
is no reason to choose the twz one over the mm one.
I would use the latest 2.0 version unless you have code that
would have a problem with it then you can
98 matches
Mail list logo