Heikki,
After a good 6-8 hours of runnning, the server just restarted itself
(running the most recent build from the 3.23.xx tree, as you
suggested). I got this message:
InnoDB: Assertion failure in thread 42527756 in file ha_innobase.cc
line 316
InnoDB: We intentionally generate a memory
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:MySQL server
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Thanks Luciano.
It works.
Iago.
-Mensaje original-
De: Luciano Barcaro [mailto:[EMAIL PROTECTED]]
Enviado el: martes 28 de mayo de 2002 19:21
Para: Iago Sineiro
CC: MySql Mail List
Asunto: Re: Error 1114 when import mysqldump in InnoDB table
Hi,
the internal space for innodb is
MySQL Version: 3.23.48-log
OS/RedHat 7.2 / gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Hi, this are the versions of my mysql and OS, i compiled them thru source.
I am aware of the problem that exists on mysql ver 3.23.49 and w/ gcc
version 2.96.
So i de-graded by only 1 version of
Hi to all,
I am new in MYSQL.I use powerbuilder 6.5.1 with Mysql (v.4.01 with Innodb
tables) and I am not sure if the compatiblility is good enough. No rows are
returned during retrieve of a datawindow with retrieval arguments.
Can anyone help me?
Hi all.
When is released mysql 3.23.50?
I received in the announce mail list an announce of a pre-release of mysql
3.23.50 one month ago.
This release has some enhancements on InnoDB table type (specially the
autoexten capability).
The announcement mail says than this prerelease it will moved
Hi all,
I'm developing financial analysis app in MySQL. Since I want it to be
portable and purely client-server I'm coding (nearly) all calculations in
SQL, and came across weird optimization issue. The following query
calculates one of my ratios using financial data from TQRPE table (some 5K
On Wed, May 29, 2002 at 12:13:49AM -0700, Jeremy Zawodny wrote:
Heikki,
After a good 6-8 hours of runnning, the server just restarted itself
(running the most recent build from the 3.23.xx tree, as you
suggested).
Just for the record, it happened again. So it's reproducable to a
dregree.
Does anyone have a way to export data from a table into a tab delimited text
file? Can't seem to see the option in mysqldump.
For bonus points - how could I achieve this via PHP?(!)
TIA,
ollie
or-media.com | design
http://phpmyadmin.sourceforge.net/
/Peter
- Original Message -
From: ollie [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 11:57 AM
Subject: Tab delimited dump?
Does anyone have a way to export data from a table into a tab delimited
text
file? Can't seem
Hi All
i am running MySql 3.23.49 Max on Win 2K
Does this version of MySQL supports subqueries.
Also does this support transaction..
Where can i get the details reg this..
Regards,
Arul
-
Before posting, please check:
Jeremy,
I think this happens because the InnoDB transaction handle has already been
freed in end_thread when MySQL still writes one log item for the connection.
Please test the following patch. Replace the function
innobase_close_connection with the one below. I forgot to set innobase_tid
to
Hi all.
Anybody knows how to see innodb messages at startup or shutdown of mysql
server?
Is there any log of messages?
Thanks in advance.
Iago.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello!
specifying a column as unique or primary in MySQL
creates indices automatically or do we need to do it
explicitly using INDEX(unique/primary_colname) in
CREATE TABLE command of MySQL??
Thanx in advance..
Ritu Singla
u can see the InnoDB messages in 'hostname.err' file in the data dir.
On Wed, 29 May 2002, Iago Sineiro wrote:
Hi all.
Anybody knows how to see innodb messages at startup or shutdown of mysql
server?
Is there any log of messages?
Thanks in advance.
Iago.
Hello,
i could not understand what is the content of log
files in InnoDB in MySQL...is it the log of the
database,i
mean, the data, or the transaction log??
Thanx in advance..
Ritu Singla
Everything you always
On Wed, 29 May 2002 11:24:36 +0100 (BST)
ritu singla [EMAIL PROTECTED] wrote:
Hello!
specifying a column as unique or primary in MySQL
creates indices automatically or do we need to do it
explicitly using INDEX(unique/primary_colname) in
CREATE TABLE command of MySQL??
yes, you have to
Jeremy,
it looks like this crash can happen if you use MySQL 'user level locks'
which are kind of semaphores. In that case MySQL will write a binlog entry
even after THD::cleanup where the transaction handle is freed.
From the manual:
You can also solve some cases by using the user-level lock
Ed,
Wednesday, May 29, 2002, 2:24:40 AM, you wrote:
EL I'm not sure how to phrase this. Please excuse the crudeness of my description.
EL I'm storing calendar data in a MySQL database and I'm wondering, is there a
EL way to specify a day, such as the 28th, and fourth Tuesday as search
EL
Trevor,
Wednesday, May 29, 2002, 3:29:43 AM, you wrote:
TF Running MYSQL 3.23 can the date mmdd be reversed when using Access or VB
TF frontend so that users can enter it as they are used to eg. ddmm.
MySQL stores data in mmdd format, but you can use DATE_FORMAT()
function to
Arul,
Wednesday, May 29, 2002, 1:05:02 PM, you wrote:
A i am running MySql 3.23.49 Max on Win 2K
A Does this version of MySQL supports subqueries.
Nope. How to re-write queries read in our manual:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
A Also does this support
weng,
Wednesday, May 29, 2002, 2:15:11 AM, you wrote:
wc Thanks for your prompt reply!
wc Egor Egorov
wc actually i alrdy followed the manual..the error is
wc whenever i type in the command prompt - mysqld-nt
wc -install FAILURE TO START SERVICE is the error i
wc encounter.. but if i run type
ritu,
Wednesday, May 29, 2002, 1:24:36 PM, you wrote:
rs specifying a column as unique or primary in MySQL
rs creates indices automatically or do we need to do it
rs explicitly using INDEX(unique/primary_colname) in
rs CREATE TABLE command of MySQL??
PRIMARY and UNIQUE are indexes. Look at:
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: ritu singla [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
Ritu,
the ib log files contain records of every change to database pages in the
ibdata
Hello Outthere!
Maybe this is a very simple question, but I'm a Rookie so lets see. I've tried to load
BLOBs into my MySQL-DB, but I could not find a documentation how to do this. How can I
load a BLOB, for example a PDF-File from my local filesystem into the database (which
SQL-commands do I
Christian,
It's pretty easy, you can do it with a normal INSERT statement, all
you've got to remember is that NUL (ascii 0) needs to be escaped as
\0, and that double quotes and single quotes should also be escaped
(i.e. \ and \').
Getting the data back again is even easier, because it'll
Hello
I have a question,
is possible to search on mysql 4.0 in fulltext index
the exact phrase ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote:
I have a question, is possible to search on mysql 4.0 in fulltext
index the exact phrase ?
http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is
possible. Here is the relevant excerpt:
The boolean full-text search capability
ddd,
Thursday, May 30, 2002, 12:10:07 AM, you wrote:
d I have a question,
d is possible to search on mysql 4.0 in fulltext index
d the exact phrase ?
Phrase search will come in 4.0.2...
d thanks
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Peter,
Wednesday, May 29, 2002, 4:39:52 AM, you wrote:
PM I have just installed mysql 3.23.49 onto my Mandrake installation using the RPMs.
PM How can I get the mysql server to start as the PC is booting ??
If you installed MySQL server from RPMs mysqld should automatically
run at the boot
Victor,
Wednesday, May 29, 2002, 12:01:31 AM, you wrote:
VSA Tells a great deal about how confused I am...
VSA I've a database with three tables, one with image data, one with
VSA categories and one table which helps me to have several categories per
VSA image...
VSA The following SQL gives
I deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
-
Before posting, please check:
Hi Chris,
See the code how load BLOB into a MySQl
String saveSql = INSERT INTO Table (DataCol) VALUES (?)
try {
bos = new ByteArrayOutputStream();
oos = new ObjectOutputStream(new BufferedOutputStream(bos));
fileObj.writeObjectData(oos);
You should be able to do this:
mysql backup.txt
-Original Message-
From: Hathaway, Scott L [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:49 AM
To: Mysql (E-mail)
Subject: database restore - please help
I deleted my database today by mistake and I have a backup from
You wrote::
deleted my database today by mistake and I have a backup from yesterday
made as follows:
mysqldump -A backup.txt
How can I restore this database?
Thanks for your help in advance.
Scott
Do get the backup write the command
mysql databasename backup.txt
Regards
Daya Krishan
Hallo
I cant use phpMyAdmin, or any of my other (php) pages as I get the error
cannot connect to MySQL via 110 (111)
I had this in the past and what I did then was to check if mysql.sock
was in the temp directory (or a link to it)
I do see it there now but I cant seem to get any connection to
Hi,
I am about to set up a network which has a central main server, and
several (up to 30) shop servers (it is for a retail chain). I'm intending
to link install mysql on all of them and link them up using the method
described below. What I'd like to know is (a.) Can anyone see a fatal flaw
in
ok. my admin guy installed the linux rpm of mysql. however, i can't locate
the mysqladmin and mysql bins. do i have to install an additional rpm that
include those?
Luke
-
Before posting, please check:
Peter,
Tuesday, May 28, 2002, 7:10:28 PM, you wrote:
PE How can I do a fulltext search on several tables
PE with just one SQL query?
You can use full-text search in boolean mode on several tables without
full-text index.
SELECT * FROM table1, table2 WHERE MATCH(table1.column1,
Christopher,
Wednesday, May 29, 2002, 5:18:25 PM, you wrote:
CLW ok. my admin guy installed the linux rpm of mysql. however, i can't locate
CLW the mysqladmin and mysql bins. do i have to install an additional rpm that
CLW include those?
Yes, you should install MySQL-client package. You can
Hi,,
I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
generated automatically...
The only probleme is that i cannot use a AUTO_INCREMENT field because I have
thousand of lines added each day (and all lines older than a week are
deleted)With AUTO_INCREMENT, one day or
Since I did the backup with a |, it appended. I had to go through the file
and remove the older instances of the backups and then it worked ok.
Thanks for the help! You all saved me.
Scott
-Original Message-
From: D.K.Dubey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002
- Original Message -
From: Anton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 3:51 PM
Subject: MySQL not connecting over 110
Hallo
I cant use phpMyAdmin, or any of my other (php) pages as I get the
error cannot connect to MySQL via 110 (111)
Well, that 110
Hi list!
I have a problem when trying to read data into tables with LOAD DATA LOCAL
INFILE.
I get this error:
ERROR 2013: Lost connection to MySQL server during query
When looking at the MySQL site it says that I should increase the
max_allowed_packet=# option (default 1M). However, my file is
This query seems to be quite easy, but I still cannot figure
out how to do it.
I have a randomly ordered table. And I want to SELECT that table
by ORDERing it in specific row, and when I'm done I want to
find out numeric position of a raw where the first raw is 1, second is 2
etc.
Of course
Michael Flora wrote:
Hello all, I posted this question yesterday but received no feedback
so I decided to ask again.
I am new to MySQL and I am trying to access binary data stored in a
MySQL table using a C program. The table looks like this:
date date
double firstfield
double
I'm looking for a way to create a table with a ID columns (PRIMARY KEY)
generated automatically...
The only probleme is that i cannot use a AUTO_INCREMENT field because I
have
thousand of lines added each day (and all lines older than a week are
deleted)With AUTO_INCREMENT, one day
Hi,
mysql_fetch_row returns a MYSQL_ROW, that is an array of byte strings.
look at
http://www.mysql.com/doc/C/_/C_API_datatypes.html
Frederic
- Original Message -
From: Michael Flora [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 5:32 PM
Subject: Problem with
I am trying to compile MySQL 3.23.49 on the following system:
Compaq Tru64 Version 5.1 1885 alpha
gnu gcc 3.1
make 3.79
I keep getting the error shown below. Any trouble shooting insight will be
greatly appreciated.
Thanks
Dean
mv -f .libs/mf_cache.lo mf_cache.o
(cd . ln -s mf_cache.o
Hi,
I am trying to learn about indexing and have a few questions.
1. Does index only apply to query that use = operator in the where clause?
2. Does operators such as , like and between will result to full table
scan?
3. For example, In the following table:
tbl_A
id int primary
Hi,
I am new to this list and new to mySQL and PHP so please excuse the
simplicty of my questions.
Is it possible to create your own shopping cart program with just mySQL and
PHP?
Right now I am building a database for my companies new web page. I am
looking to build an e-commerce site, but I
I have an application database that I'm unable to drop after a period of running
several applications against that are using the MySQL++ api.
Wondering if anyone has seen this, if it's a known bug and/or if there is a fix.
mysqladmin -uroot -p drop db and rm -rf /var/lib/mysql/dbname do
[snip]
Is it possible to create your own shopping cart program with just mySQL and
PHP?
[/snip]
Yep.
[snip]
1) I am trying to build my own shopping cart. When building an orders
database, is it possible to make room for an infinite number of items in the
order?
[/snip]
Ideally you should have
Hi all.
In the innodb directory I have these files (prototipo is the name of the
computer):
-rw-rw 1 mysql mysql 86 May 28 09:56 prototipo-bin.001
-rw-rw 1 mysql mysql 86 May 28 10:00 prototipo-bin.002
-rw-rw 1 mysql mysql 86 May 28 10:13
Hello,
Can someone tell me what is the difference between MyODBC and iODBC?
My understanding is that in order for an application to be able to talk to
a database it needs a protocol, and that protocol would be ODBC.
What I'm trying to do is have the Tango2000 application server
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
autoextend feature on v.4.
Thanks,
--Walt Weaver
Bozeman, Montana
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I've been trying to solve this problem for a couple of days now.
I've only started with DB's a month ago so I am no expert in SQL.
So, I present this problem to you guys in hopes of getting a solution.
Thanks in advance,
Mike
=
Question:
=
Using the query below I get the result
Hello,
I created a blank table in MS Access 2000 for recieving data from mysql
and tried to compile importsql.txt in Access module but I still got the
error saying user defined-type not defined. I copy pasted exportsql.txt
to the module and got the same error.
I have a coworker who told me she
Hi,
This error make reference to a variable which is not correctly defined.I
suppose that you have in routine which make import a variable like :
Dim myvar as lon
insted
Dim myvar as long
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent
SELECT cols FROM tbl INTO OUTFILE '/someflie';
ollie wrote:
Does anyone have a way to export data from a table into a tab delimited text
file? Can't seem to see the option in mysqldump.
For bonus points - how could I achieve this via PHP?(!)
TIA,
ollie
Hello,
I'm using InnoDB tables, is there a way to know which foreign key constraint
was violated? Oracle gives me the constraint name in the error message, so
that I can seek in the data dictionary. I'm porting an web application
developed for Oracle to MySQL, so I need a solution with the
I was hoping for some help with this -- I'm not sure if I can use just
one SQL statement to pull this data out, I think I need to use two
separate statements. Can someone clarify for me?
My tables:
+-+ +---+
| people | | projects |
+-+
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
(Insert.. ) is not
I have the following table;
++--+++
| id | wtn | dueDate| ageAmt |
++--+++
| 1 | 210-212-3871 | 2001-12-01 | 0.51 |
| 2 | 210-212-3871 | 2001-12-01 | 0.49 |
| 3 | 210-212-3871 | 2001-12-01 | 0.50 |
| 4
Hello,
We currently have two MySQL server/clients running on a RH/Linux 6.2 box,
3.23.40(production) and 3.23.49(development) We would like to setup the .49 with
a TCP/IP host instead of a socket. The .49 is using the port 3307, the default
server hostname is
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the Query.Execute
(Insert.. ) is not
hitesh_mittal@itginc.com wrote:
Hi All,
I am new to MySQL ( using on Solaris )
I wrote my first program to do the insertions in a table. If a row is already
there then the program crashes instead of just throwing an exception.
I have a catch (... ) handler also so I am sure that the
sql reset master;
Ric
- Original Message -
From: Iago Sineiro [EMAIL PROTECTED]
To: MySql Mail List [EMAIL PROTECTED]
Sent: Wednesday, May 29, 2002 6:14 PM
Subject: Can I remove innobd binarie files?
Hi all.
In the innodb directory I have these files (prototipo is the name of the
Hey there,
I know this might sound like a stupid question to a lot of you guys out
there but please keep in mind I come from an oracle background and am new to
this:
I am accessing MySql from PHP, I have two questions regarding Auto_Increment
1) how to create an auto_increment?
create table
Hi
I am using
-mysql 3.23.59,
- Solaris 2.6
the program is in C++, using gnu C 2.95.3 .
The table does have primary key constraint and the program should throw an
exception when I try to insert and the the row aready exists, But instead It
crashes.
Any suggestions ??
Thanks
Hitesh
Hi guys,
Does anyone have any thoughts on using MySQL for a datawarehousing application?
Problems I've run in to are with mining data from a data warehouse because of the lack
of sub-selects, stored procs, and views.
Should I be looking more at InnoDB or MyISAM table types?
any thoughts are
Hi list, can someone here give me a quick and dirty example of how there
connecting to a database via sockets? I see the data in the man page
but I'm uncertain as to implementation. Thanks, justin
Sql,query
-
Before posting,
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have been
getting Time-out requesting db connectionUnable to connect to database
server where url was jdbc:z1MySQL://localhost:3306 error whenever the JHTML
is initialized for the first time. It works fine when i click on the
manual_Reference.html#CREATE_TABLE
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
create table MyTestTable(cno int AUTO_INCREMENT, name varchar(20));
can't seem to find the ref right now, but
I don't know if this is just weirdness on my system but I thought I would
pass this on in case anyone runs into this problem. I'm converting some
Java/JDBC code from a commercial DBMS to MySQL. The existing code executed
the SQL statement Select @@identity after an INSERT to retrieve the
Has anyone architected an oltp database using mysql where downtime is
virtually eliminated? I understand it's fairly simple to set up a readonly system
using mysql replication or another type of replication to maintain the
uptime, but I have yet to see how to do this with a heavy transaction
hitesh_mittal@itginc.com wrote:
Hi
I am using
-mysql 3.23.59,
- Solaris 2.6
the program is in C++, using gnu C 2.95.3 .
The table does have primary key constraint and the program should throw an
exception when I try to insert and the the row aready exists, But instead It
crashes.
Any suggestions
Greetings guys,
Special greetings to all of you who helped me in the last question, one
last
one
in a timestamp field, do I have to provide the values?
eg
create table ryan(t_imestamp timestamp(8), name varchar(30));
how do I insert? do I have to specify the value? if so how do I
-Original Message-
From: Richard Davidson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 1:31 PM
To: MySql List; [EMAIL PROTECTED]
Subject: FYI: @@IDENTITY
I don't know if this is just weirdness on my system but I
thought I would
pass this on in case anyone runs
I dont think the types of tables will really help you, because as I understand it
mySQL doesnt yet have stored procs, views, and sub-selects, regardless of table type...
I may be wrong though...
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER BY.
An examples:
this doesn't work
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE ABC =
'abc' ORDER BY ABC
this works
SELECT field1 AS ABC, field2 AS XXX, field3 AS QQQ FROM mytable WHERE
field1
hitesh_mittal@itginc.com wrote:
I am using MYSQL ++.
Hitesh
Then, I would suggest posting your question over on the plusplus list
(see http://www.mysql.com/documentation/lists.html), as the developers
for MySQL++ hang out over there.
-Mark
The thing is I'm looking for a solution with guaranteed transaction success. I have
thought about building a layer that would guarantee transaction success. Say I had
two duplicate databases and if a transaction failed on one it would still succeed
on the other. Once the transaction failed it
Hi,
It's more comfortable(and sure) if you use C API of MySQL.Order of (few of
the main) functions to be executed is :
mysql_init-initialise MYSQL struct
mysql_options-set options for connection
mysql_real_connect-this function make all for you, from connection
On Wed, May 29, 2002 at 02:06:19PM +0300, Heikki Tuuri wrote:
Jeremy,
it looks like this crash can happen if you use MySQL 'user level locks'
which are kind of semaphores. In that case MySQL will write a binlog entry
even after THD::cleanup where the transaction handle is freed.
From the
See:
http://www.mysql.com/doc/P/r/Problems_with_alias.html
Gurhan
-Original Message-
From: Massimo Colurcio [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:09 PM
To: mySQL List
Subject: Alias WHERE
It seems I cannot use an alias in WHERE clause, but I can use it in ORDER
Hi,
I am evaluating InnoDB's Foreign Keys and am stuck.
Using the sample tables I want to add records in the Child table with a NULL
parent_id (this being referenced to the Parent table) as follows:
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT,
INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES parent(id)
ON DELETE CASCADE) TYPE=INNODB;
OI!!! I'm going to
Hi all,
I apologise if this question has been asked recently; I have checked the
list archives and could not see anything. This is my problem:
I am trying to convert and import a fairly convoluted Filemaker Pro 5
database to MySQL. I have exported the filemaker records as tab delimited
files
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have
been getting Time-out requesting db connectionUnable to connect to
database server where url was jdbc:z1MySQL://localhost:3306 error whenever
the JHTML is initialized for the first time. It works fine when i click on
the
snip tables
OI!!! I'm going to sound like a complete ass now (I know) But since
when does MySQL support FOREIGN keys?? *gasp* MAN this is going to
make my life S much easier *curses at phpMyAdmin for not having the
option*
Do remember that this is only valid for mysql
If you start MySQL server from MS DOS prompt as:
C:\mysql\binmysqld-nt --standalone --debug
mysqld shows you warning message.
hi! i tried this already.. but whenever i type
mysqld-nt -install to install mysql as a service.. an
error messge Failed to install service occurs..
using Windows
Description:
`./configure --with-mit-threads` fails to compile vio/ and innodb/ due to
missing -I directives for pthread.h.
How-To-Repeat:
in my particular case:
./configure --prefix=/usr/local/mysql/ --with-named-z-libs=z --without-libwrap
--with-mit-threads
gcc -DHAVE_CONFIG_H -I.
Hello -
I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on
a DELL Latitude C600 Laptop developing a project. However every time i try
to use mysql_num_rows it tells me that this is not a valid mysql result
resource. I've tried all kinds of differnt tricks to try to fix the
You should try echoing out mysql_error() to see what error is being returned from
MySQL or run mysql from the command line on your laptop and run the same query that
your script is running.
HTH
--Sam Masiello
On Wed, 29 May 2002 20:35:33 -0400 (EDT) Eric P. McDonough [EMAIL
On Wed, May 29, 2002 at 11:58:06AM -0600, Weaver, Walt wrote:
when MySQL 4.0.2 will be out? We'd like to play around with InnoDB's
autoextend feature on v.4.
On what platform? If you're on FreeBSD or Linux, I can send you one
of my daily builds. Sice you're just looking to play around, you
At 23:45 +0100 5/29/02, Cameron Murdoch wrote:
Hi all,
I apologise if this question has been asked recently; I have checked the
list archives and could not see anything. This is my problem:
I am trying to convert and import a fairly convoluted Filemaker Pro 5
database to MySQL. I have
I considered perl but it is quite some time since I used it so I had been
wondering if there was a way do what I wanted from within MySQL. Having
said that it has taken about an hour for me to relearn some perl tricks and
get the problem sorted so perhaps I should have just tried straight off
Hi,
I have been using MySql very successfully on Linux for the past 1.5 years.
(a lethal combination)
This morning when I tried to login using MySqlFront, it seems that my
password has been changed. I was able to login to the server and restore it,
using the root password.
Upon further
If you can load the data into MySQL, put the date field into a CHAR(10)
field. After the data load, add a date field using ALTER TABLE. You
should then be able to run something like
UPDATE TABLE tablename SET NewDate
= CONCAT(
1 - 100 of 109 matches
Mail list logo