Hi;
Can anyone tell me whether there is a version of mysql that will run on a
handheld PDA, and if so what are the hardware/software specifications?
Fraser
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Steve,
Steve Davies sagte:
> Sinisa Milivojevic wrote:
>
>>On Mon, 08 Sep 2003 19:57:25 +0100
>>Steve Davies <[EMAIL PROTECTED]> wrote:
>>
>>
>>
>>>Hi All
>>>
>>>I'm currently trying to learn C so that I can recode some php/mysql apps
>>>
>>>I've got but I've run into probs right at the start.
>>
when is it a good time to do the set auto commit=0 , while doing the update or insert
query or sometime before that in the application ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that works cheers
>>> "Roger Baklund" <[EMAIL PROTECTED]> 09/11/03 10:48am >>>
* Daniel Rossi
> Hi there i was wondering if there was anyway to determine the
> primary key field instead of explicitly setting it in an update
> sql query ?
>
> for instance i'd like to go update table *** where prima
Hi Shane,
- Original Message -
From: "Shane Allen"
Sent: Wednesday, September 10, 2003 7:16 PM
Subject: FULLTEXT feature requests
> The only reason that we are unable to use a stock build of mysql is
> because
>
> 1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB
Why is that exactly...
Well, okay I just answered part of my own solution...
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
SET FOREIGN_KEY_CHECKS=1;
Allowed that to happen.
I'm afraid to try the self referencing o
Thanks Victoria for the pointer. I should have looked there first. Duh!
Now for the help... I tried:
ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`) ON UPDATE CASCADE;
But get "ERROR 1216: Cannot add a child row: a foreign key constraint f
At 3:33 PM -0700 9/10/03, Dathan Vance Pattishall wrote:
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
states that
record_rnd_buffer_size When reading rows in sorted order after a sort,
the rows are read through this buffer to avoid a disk seeks. Can improve
ORDER BY by a lot if set to a high va
* Daniel Rossi
> Hi there i was wondering if there was anyway to determine the
> primary key field instead of explicitly setting it in an update
> sql query ?
>
> for instance i'd like to go update table *** where primarykey=1
> instead of where id=1 as the primary key is named differentrly
> for e
Comcast,
Simply order by the random function, RAND(). For example:
SELECT aff.*
FROM financial_affiliates AS aff
WHERE aff.state = 'wa'
AND aff.category = '3'
ORDER BY RAND();
Regards,
Adam
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Wednesday, Septemb
The only reason that we are unable to use a stock build of mysql is
because
1) we use GWS_FREQ as our GWS_IN_USE, not GWS_PROB
2) we have a custom stopword list
Is there any reason that these two settings, like FT_MIN_WORD_LENGTH,
cannot be moved to runtime-configurable params? Obviously, changin
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug, et al --
...and then David T-G said...
%
% ...and then Comcast said...
% %
% % I would like to ORDER BY RANDOM - is there an easy way to do that.
%
...
% I don't know if you can select random() like you can select count() but
% perhaps you d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Doug --
...and then Comcast said...
%
% I am querying a table and using the following statement:
%
% SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY
name
%
% I would like to ORDER BY RANDOM - is there an easy way
Hi there i was wondering if there was anyway to determine the primary key field
instead of explicitly setting it in an update sql query ?
for instance i'd like to go update table *** where primarykey=1 instead of where id=1
as the primary key is named differentrly for each table and i'm trying t
Hi All;
First of all, I think this will probably be a question for Heikki.
If I remember correctly, InnoDB and the MySQL external locking flag are
unrelated as InnoDB tables are unaffected by external locks.
Now the question: is it possible for two MySQL servers to access the same
tablespace in
I am querying a table and using the following statement:
SELECT * FROM financial_affiliates WHERE state = 'wa' AND category = '3' ORDER BY name
I would like to ORDER BY RANDOM - is there an easy way to do that.
Thanks.
-Doug
At 17:07 10/9/2003 -0400, [EMAIL PROTECTED] wrote:
Hi,
Notice the option syntax --log:
/usr/local/mysql/libexec/mysqld --log=/usr/local/mysql/var/mysqlquery.log
-uroot
030910 20:03:54 InnoDB: Started
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.0.15-debug-log' socket: '/t
Hi Dave,
--- "Christensen, Dave" <[EMAIL PROTECTED]>
wrote:
> Did you set up a my.ini file in your Windows
> directory? If so, what is in
> the file?
I found the problem about why I was not able to get my
WinMySQLadmin tool to start the service. My my.ini
contents are below this email the passwo
Dear list friends:
I`d like to get your help about this issue. I have a Linux box RedHat 7.3
running the MySQL v3.23.56. In this box I`m running a TACACS server for
authenticating my users to access to cisco routers. TACACS is using a
Mysql database where i configured the user accounts, however
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
states that
record_rnd_buffer_size When reading rows in sorted order after a sort,
the rows are read through this buffer to avoid a disk seeks. Can improve
ORDER BY by a lot if set to a high value. As this is a thread-specific
variable, one should n
Rafa,
I analyzed now the latest hex dumps.
The first error looks like that the peco/lincompras index ArtPrvFec tree is
broken. The child page number is 0x041d, but the parent has a pointer to
page 045d.
In the error printout below the secondary index record contains a primary
key column valu
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> I see there is a way to DELETE or NULL a cascade, but is there a way to
> UPDATE?
ON UPDATE CASCADE, ON UPDATE SET NULL.
Look at:
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
>
> Here's what I mean. Given these rough table
Hello people,
here I am, again...
I run into the next problem during the make. It runs for quite some time, when
suddenly these messages appear:
ld: fatal: library -lrt: not found
ld: fatal: library -ldl: not found
ld: fatal: library -lpthread: not found
ld: fatal: library -lthread: not found
Dear list friends:
I`d like to get your help about this issue. I have a Linux box RedHat 7.3
running the MySQL v3.23.56. In this box I`m running a TACACS server for
authenticating my users to access to cisco routers. TACACS is using a
Mysql database where i configured the user accounts, however
On Wed, 2003-09-10 at 16:36, Lenz Grimmer wrote:
> -BEGIN PGP SIGNED MESSAGE-
> > warning: user mysqldev does not exist - using root
> > warning: user mysqldev does not exist - using root
>
> This is a warning, not an error. Did the install continue? Where exactly
> did you get this messag
On Wed, Sep 10, 2003 at 11:50:43AM -0700, Bill Todd wrote:
> Using MySQL and InnoDB, are there system tables or other tools that I can
> use to see which statements that are executing have consumed the most CPU
> time and find out which user, transaction and/or connection those statements
> belong
Bill,
- Original Message -
From: ""Bill Todd"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, September 10, 2003 11:39 PM
Subject: Is the table cache used with InnoDB?
> I cannot tell from the Reference Manual whether the table cache is used
with
> the InnoDB d
Jason-
Login as root
then issue grant statements on the priveleges to assign to the new user
http://www.mysql.com/doc/en/Adding_users.html
-Martin
- Original Message -
From: "Jason Frisvold" <[EMAIL PROTECTED]>
To: "mySQL Listserv" <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003
People,
I've found the solution. It appears that the math_iso.h is a header file
provided by SUNWlibm.
Installed the package and tried again. It doesn't fail at the same point. At
this moment, the make is still running, so far so good.
Cheers,
Andy
> OK
>
> Daniel, thanks for your tips. The
not to respond with, 'read the manual', but
There is an entire section of the manual devoted to user management, I would start at
www.mysql.org
click on the documentation link on top, and start there...
(user account management is :
http://www.mysql.com/doc/en/User_Account_Management.htm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 10 Sep 2003, Jason Frisvold wrote:
> I recently updated the RPM files on my Linux box to 4.0.15 ... During
> the update, I received the following error :
>
> warning: user mysqldev does not exist - using root
> warning: user mysqldev doe
I cannot tell from the Reference Manual whether the table cache is used with
the InnoDB database engine or not? It sounds like it only applies to tables
that are stored in separate disk files. Is the table cache used by InnoDB?
Bill
--
MySQL General Mailing List
For list archives: http://lists
I have the MySQL-3.23.55 installed in my PC.
Therefore, I am the DBA without the required DBA
knowledge.
First, how do I create users in the MySQL database?
Second, how do I grant table creation privilege to
users? Is
GRANT ALL PRIVILEGES ON databasename TO someuser
IDENTIFIED BY 'somepassword';
All,
I recently updated the RPM files on my Linux box to 4.0.15 ... During
the update, I received the following error :
warning: user mysqldev does not exist - using root
warning: user mysqldev does not exist - using root
Can someone please explain to me what this user is and what it's
Dear list friends:
I`d like to get your help about this issue. I have a Linux box RedHat 7.3
running the MySQL v3.23.56. In this box I`m running a TACACS server for
authenticating my users to access to cisco routers. TACACS is using a
Mysql database where i configured the user accounts, however
Hi!
InnoDB is a MySQL table type which provides transactions, row level locking,
foreign key constraints, and a non-free hot backup tool.
InnoDB is included in all MySQL-4.0 and MySQL-4.1 downloads from
http://www.mysql.com. MySQL-4.0 is the stable version which is recommended
for production use.
Errno 13 indicates that you have some permission issues. Check the data
directories you've set up to make sure that they are owned by the user/group
mysql.
Thank you. That was the problem. The "host.frm" really threw me.
Craig
--
MySQL General Mailing List
For list archives: http://
What most data structures do is use foreign keys to the unique numerical id column, in
your case, company_id. That way, if the company code changes, the id does not, and
therefore, no issues on update...
> -Original Message-
> From: Daevid Vincent [mailto:[EMAIL PROTECTED]
> Sent: Wed
I see there is a way to DELETE or NULL a cascade, but is there a way to
UPDATE?
Here's what I mean. Given these rough table schemas. I'd like to be able to
UPDATE the company_code in the company_table, and have it update the same
rep_company_code in the rep_table. Ie. So a company has a certain c
Dear list friends:
I`d like to get your help about this issue. I have a Linux box RedHat 7.3
running the MySQL v3.23.56. In this box I`m running a TACACS server for
authenticating my users to access to cisco routers. TACACS is using a
Mysql database where i configured the user accounts, howeve
All,
I have an older installation mysql 3.22 (hpux 10.20) that I'm trying to
get to 4.0 but first I must go to 3.23.
When going to 3.23 I get an error indicating "File not found or can't
open" after a couple of queries are run.
I've looked at the documentation and determined that I must have
Craig,
Errno 13 indicates that you have some permission issues. Check the data
directories you've set up to make sure that they are owned by the user/group
mysql.
-Original Message-
From: Craig A. Finseth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 1:42 PM
To: [EMAIL
Not a bug look /etc/my.cnf
Your default sock file might be in /tmp and the client is configure to
look at /var/lib/mysql
-->-Original Message-
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, September 09, 2003 2:08 PM
-->To: [EMAIL PROTECTED]
-->Subject: Mysql bug
--
mysqladmin proc
mysqladmin kill ${Id} // The id that is causing the problem
-->-Original Message-
-->From: Bill Todd [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 10, 2003 11:51 AM
-->To: MySQL List (E-mail)
-->Subject: How identify long running query etc?
-->
-->Using MySQL and
Dear list friends:
I`d like to get your help about this issue. I have a Linux box RedHat 7.3
running the MySQL v3.23.56. In this box I`m running a TACACS server for
authenticating my users to access to cisco routers. TACACS is using a
Mysql database where i configured the user accounts, howeve
Hello,
I can't connect to mysql, the message is :
"can't connect problem with /var/lib/mysql.sock" or something like that
(sorry i forgot to write it and actually also have problems to connect with
ADSL to internet under Linux so i send you this from windows).
Can you help me ? Thanks.
SE
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
If I identify a user that is causing a problem is there a way
I am trying to install:
mysql-standard-4.0.14-sun-solaris2.8-sparc.tar
on a Solaris 8 system. I am getting this message in the .err file:
030910 11:05:41 mysqld started
030910 11:05:41 InnoDB: Started
030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file:
'./mysq
On Wed, Sep 10, 2003 at 11:01:00AM -0700, Dathan Vance Pattishall wrote:
> Well I don't feel that 4.0.x is mature enough for my environment quite
> yet, although some replication features are actually needed (2 threads
> are better then one).
>
> I might do a small deploy for some search system an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.15, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
Victoria, Thanks.
--
__
Sign-up for your own personalized E-mail at Mail.com
http://www.mail.com/?sr=signup
CareerBuilder.com has over 400,000 jobs. Be smarter about your job search
http://corp.mail.com/careers
--
MySQL General Mailing Li
Well I don't feel that 4.0.x is mature enough for my environment quite
yet, although some replication features are actually needed (2 threads
are better then one).
I might do a small deploy for some search system and even ratio of write
/ read systems. Yahoo uses 4.0.x right? Have any "show stoppe
I have been getting the same error every so often. It is only on a machine
that does about 900 queries per second average. I am running a 2.4.20
kernel with MySQL 4.0.14. This only happens with MYISAM tables and only
ones with high INSERTs and SELECTs. It seemed to get better after
increasing t
On Wed, Sep 10, 2003 at 10:11:15AM -0700, Dathan Vance Pattishall wrote:
>
> /usr/local/mysql/bin/perror 127
> Error code 127: Unknown error 127
> 127 = Record-file is crashed
>
> I've been getting this allot lately from mysql-3.23.54-57.
>
>
> Things that are not the cause:
> - mySQL has
OK
Daniel, thanks for your tips. They made the errors dissapear...but a new one
appeared in return :
again, the configure is going fine. Here's what I typed on the command line:
# CFLAGS=-O3 # CXX=gcc #
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" # export
CFLAGS CXX CXXFLAG
Are you running linux and is it SMP? Kernel version plz..
On Wed, 10 Sep 2003, Dathan Vance Pattishall wrote:
>
> /usr/local/mysql/bin/perror 127
> Error code 127: Unknown error 127
> 127 = Record-file is crashed
>
> I've been getting this allot lately from mysql-3.23.54-57.
>
>
> Things that
At 5:29 -0400 9/10/03, Andrew Kuebler wrote:
If I:
ADD COLUMN Text (BLOB)
And then
INDEX (Text(10))
Will that index be beneficial if I am search for 10 characters only or
anything 10 characters or less? Thanks in advance!
If those characters occur at the beginning of column values, yes.
--
Paul D
I'm running
RedHat 7.3 distro with
2.4.18-4smp #1 SMP
The table in questions is
-rw-r-1 mysqlmysql8.9k Jul 26 00:23 hasit.frm
-rw-r-1 mysqlmysql994M Sep 10 09:59 hasit.MYD
-rw-r-1 mysqlmysql681M Sep 10 09:59 hasit.MYI
my my.cnf option
What kernel are you running?
Also, try increasing the max open tables. That might help.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Tom Roos'" <[EMAIL PROTECTED]>; <[EMAIL PRO
FilesystemSize Used Avail Use% Mounted on
/dev/sda5 97G 9.0G 82G 10%
Plenty of disk space.
-->-Original Message-
-->From: Tom Roos [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, September 10, 2003 10:23 AM
-->To: Dathan Vance Pattishall; [EMAIL PROTECTED]
-->S
hows u're disk space?
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: 10 September 2003 19:11
To: [EMAIL PROTECTED]
Subject: "ERROR 1030: Got error 127 from table handler"
/usr/local/mysql/bin/perror 127
Error code 127: Unknown error 127
127 = Record-f
/usr/local/mysql/bin/perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
I've been getting this allot lately from mysql-3.23.54-57.
Things that are not the cause:
- mySQL has not been improperly shut down
- threads are not being killed off
Pattern emerged:
High
> -Original Message-
> From: Watter [mailto:[EMAIL PROTECTED]
> Sent: den 10 september 2003 17:45
> To: [EMAIL PROTECTED]
> Subject: MySQL database help
>
>
>
> Dear Sir,
> I know your email add. from mysql.com.
> If you know how to solve this problem, please teach me. your
> repl
Adam:
You create the configuration files ... the MySQL distribution has samples
(my-huge.cnf, my-large.cnf, etc.) which you should edit to make sure
settings are appropriate for your needs.
Gerald Jensen
- Original Message -
From: "Fortuno, Adam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
At 10:30 +0200 9/10/03, Håkan Medin wrote:
Hello All,
I am trying to compile a Ansi-C program using the MYSQL_STMNT*
mysql_prepare(...) function, but the function can't be found..
This function is one of those use for handling prepared statements.
They're not available until 4.1, as indicated here
Hey,
I am trying to test mysql moniter ssl connection. I've compiled ssl
support into MySQL server and client, and I am using version 4.0.14. In
my.cnf global file, I have --ssl-cert, --ssl-ca, --ssl-key set for the
server and the client. I grant some users to use "require ssl", but I am
g
Did you set up a my.ini file in your Windows directory? If so, what is in
the file?
-Original Message-
From: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 10:24 AM
To: Christensen, Dave; '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'
Subject: RE: Unable to Creat
Hi!
On Sep 10, Tobias Lind wrote:
> Hi!
> I'm running a large web application with MySQL 4.0.14.
> The application is performing searches in a large table (>500.000 rows).
> The WHERE-clause for these searches sometimes is a combination of different
> columns in the table, and I have noticed some
Have you seen the functions INET_NTOA() anf INET_ATON)?
http://www.mysql.com/doc/en/Miscellaneous_functions.html
All - We're using MySQL under Linux to store data collected d
Hi,
On Wed, Sep 10, 2003 at 09:07:30AM -0400, Mark Riehl wrote:
> All - We're using MySQL under Linux to store data collected during network
> tests. One of our columns store the integer representation (in network byte
> order) of an IP address.
>
> Is there any current support in MySQL (or futu
All - We're using MySQL under Linux to store data collected during network
tests. One of our columns store the integer representation (in network byte
order) of an IP address.
Is there any current support in MySQL (or future planned support) to convert
from the integer representation of an IP add
Hi!
I'm running a large web application with MySQL 4.0.14.
The application is performing searches in a large table (>500.000 rows).
The WHERE-clause for these searches sometimes is a combination of different
columns in the table, and I have noticed some very sub-optimal index-usage
when the search
All,
A little confused about what creates configuration (my.cnf) files. I'm
running MacOS X 10.2 (Jaguar) running MySQL 4.0.x. I was looking for the
global and server level configuration files in the following directories:
Global -> /etc/my.cnf
Server -> /mysql/data/my.cnf
I was unable to locate
Håkan-
The prepared statement capability isn't available until 4.1 (I believe).
Best of luck,
Regards,
Rick
-Original Message-
From: Håkan Medin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: MySQL C API
Hello All,
I am trying to co
Hi Rob,
i think to use REPLACE would do, if there is a unique index on myid:
REPACE mytable (myid, myname) VALUES (myid, mynewname);
The Manual say in chapter 6.4.8:
REPLACE works exactly like INSERT, except that if an old record in the table
has the same value as a new record on a UNIQUE index
See the REPLACE command: http://www.mysql.com/doc/en/REPLACE.html
---
I am trying to update/insert a record into the table depending on whether
it
exists in the table or not.
Something along the lines of...
IF (SELECT id
I am trying to update/insert a record into the table depending on whether it
exists in the table or not.
Something along the lines of...
IF (SELECT id FROM myable WHERE id="myid")
INSERT INTO mytable(id,name) VALUES ("myid", "myname")
ELSE
UPDATE mytable SET name="mynewname" WHERE
Alberto,
you are probably using an old version of InnoDB.
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
"
A deviation from SQL standards: if ON UPDATE CASCADE or ON UPDATE SET NULL
recurses to update a table for which there already is an update operation in
the stack of cascaded operation
If I:
ADD COLUMN Text (BLOB)
And then
INDEX (Text(10))
Will that index be beneficial if I am search for 10 characters only or
anything 10 characters or less? Thanks in advance!
Best Regards,
Andrew
Sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
On Tue, Sep 09, 2003 at 06:47:52AM -0700, Will Glass-Husain wrote:
>
>
> There's also
>
> # backup databases
> for dbname in `echo 'show databases;' | mysql -u$dbuser -p$dbpassword`
> do
> echo "Backing up database $dbname..." >>
> $destdir/backup.log
> mysqldum
Hi!
On Sep 10, Victoria Reznichenko wrote:
> [EMAIL PROTECTED] wrote:
> > I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it
> > doesn't work. MySQL always crashs with error 11 Segmentation fault.
> >
> > I don't know why but I try to dump database (about 200,000 lines)
> > and
whats the error u get?
-Original Message-
From: Håkan Medin [mailto:[EMAIL PROTECTED]
Sent: 10 September 2003 10:31
To: [EMAIL PROTECTED]
Subject: MySQL C API
Hello All,
I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...)
function, but the function can't b
Hello All,
I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...)
function, but the function can't be found..
I have the following MySQL rpm's installed on my Linux machine, have I missed anyone?
MySQL-client-4.0.14-0.i386.rpm
MySQL-devel-4.0.14-0.i386.rpm
MySQL-serv
In that case I have to write the foreign key checks all over again in the
new DB. Also doen't it create the a MyISAM DB when we remove the foreign key
checks. What I am looking at is an exact replica of the INNODB database. Is
it possible ?
Regards
Barry
- Original Message -
From: "Victor
[EMAIL PROTECTED] wrote:
> I upgrade try to upgrade from MySQL 4.0.12 to 4.0.14 in Linux but it doesn't work.
> MySQL always crashs with error 11 Segmentation fault.
>
> I don't know why but I try to dump database (about 200,000 lines) and install MySQL
> 4.0.14 windows version and try to import
"David B. Held" <[EMAIL PROTECTED]> wrote:
> "Egor Egorov" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> [...]
>> Do you lose all your databases and tables or tables of
>> the database 'mysql'? Do you have databases
>> directories and files of tables in these dirs?
>
> Never min
"Barry" <[EMAIL PROTECTED]> wrote:
>It seems there's a problem while the database is getting dumped coz it
> gives an error saying that it was unable to create a particular ".frm" file.
> Can't seem to figure out the reason. Any help would be really welcome. Could
> there be a possible problem
I have 2 servers: one asd master, second as a slave
1) I start master
2) start slave
3) stop slave
4)start slave
5)stop slave
6)start slave and i have errors as below.
C:\mysql4\bin>mysqld-max-nt --defaults-file=../my_slave.cnf --standalone --c
onso
le
030909 18:23:19 InnoDB: Started
030909 18:
"Scott D. Spiegler" <[EMAIL PROTECTED]> wrote:
>
> I am using the binary distribution of mySQL for
> Windows-2000 and am not able to connect to the
> DBserver. I used the Setup executable to install the
> application. I verified that the my.ini file was
> created and contained appropriate informat
Hi there
i have problem installing MySql 4.1.
i had downloaded the binaries from ur website and unzipped them to C:\workdir
now according to the manual i had to compile the files. but when i was trying to do
the same i met with an error compiling CL.exe and 4 warnings i used VC++ to build the
Hi ,
It seems there's a problem while the database is getting dumped coz it
gives an error saying that it was unable to create a particular ".frm" file.
Can't seem to figure out the reason. Any help would be really welcome. Could
there be a possible problem because of the foreign key constraint
91 matches
Mail list logo
