Hi,
Thx for all your help, I can export the tables in exportSQL scripts.
But how to make the procedure of inserting data more easy instead of
using mysql daemon od MySQL GUI?? Both of them need to use Sql language to
insert data. Any software or tools like Microsoft Access or Lotus Approach
> As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would
> _highly_ recommend a journaling filesystem such as Reiserfs
> (http://www.namesys.com) or XFS (http://oss.sgi.com). I've used
reiserfs for
> a long time, but XFS is growing on me. It seems to be more stable in
latest
> 2.4
On Mon, Feb 25, 2002 at 11:21:26PM -0800, Steven Roussey wrote:
> > Are RAID tables supposed to be enabled in the -MAX binaries? They
> > appear not to be (in 4.0.1), and that surprises me a bit.
>
> I thought RAID tables were retired in MySQL 4.
Hmm. The "have_raid" variable is still there in
If I create a merge table:
---snip---
CREATE TABLE mytable0 (
aINTEGER NOT NULL PRIMARY KEY,
bCHAR(18) NOT NULL
);
CREATE TABLE mytable1 (
aINTEGER NOT NULL PRIMARY KEY,
bCHAR(18) NOT NULL
);
CREATE TABLE mytable2 (
aINTEGER NOT NULL PRIMARY KEY,
bCHAR(18
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 11:21 pm
> To: [EMAIL PROTECTED]
> Subject: Re: Re: recover lost index
>
> To: [EMAIL PROTECTED]
>
> Your message cannot be
> Are RAID tables supposed to be enabled in the -MAX binaries? They
> appear not to be (in 4.0.1), and that surprises me a bit.
I thought RAID tables were retired in MySQL 4. It was only a split for
the data files anyhow, not the index files, so it was incomplete at best
for getting around the l
Are RAID tables supposed to be enabled in the -MAX binaries? They
appear not to be (in 4.0.1), and that surprises me a bit. It thought
that the point of the -MAX binaries was to enable all the bells and
whistles by default.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yah
Sure. Use ALTER TABLE to change the structure of your table and add the
datetime field:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Then, use something like:
UPDATE myTable SET [datetime field] = [timestamp field];
Keep in mind that this will automatically update all the timestamp fields to
>From: [EMAIL PROTECTED]
>Description: Fresh install of Red Hat 7.1 - no patches or updates of
any kind. Unable to install MySQL 3.23.49. Following the
installation instructions provided. The following steps
were completed successfully:
>
what about
RENAME current_table temp_table
CREATE TABLE current_table (identical create_definition to current_table
except adding the datetime column type) select * from temp_table
checking here
DROP TABLE temp_table
Regards,
Dan
> -Original Message-
> From: Laszlo G. Szijarto [
Hi !
Fivewin +Mysql ODBC EOF() with similiar error as BOF() behavor debuged
last Sep.:
A table test :
1 user1
2 user2
3 user3
Standard Mysql ODBC
go bottom
?eof().f. .f.
?nameuser3 user3
skip 1
?eof().t. .t.
?
Thank you in advance for your help.
I have a table which has a timestamp column. Now, I want to add a column of
type datetime and transfer the original timestamp (date or original
insertion) into the new datetime column (so as to preserve this information
for all posterity in case an new update
Hi Peter,
On Tue, 2002-02-26 at 12:21, Peter Jennings wrote:
> We have been trying to solve a replication issue related to TEMPORARY
> tables.
>
> Here's the issue
>
> Every three hours we run a processX (C++ compiled program) on the Master
> mysql that goes something like this:
>
> CREATE TEM
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java p
I've never heard of this in a recent kernel/e2fsprogs. Nor have I
experienced it (thankfully). Do you any further information?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -Original Message-
> From: David Turner [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 4:01
This is the 3rd incorrect answer out of 6 replies to this question. It
sure is a good thing we have a manual! Yes, you can insert multiple
rows with one INSERT statement. You just have to get the correct
syntax. It's
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_nam
We have been trying to solve a replication issue related to TEMPORARY
tables.
Here's the issue
Every three hours we run a processX (C++ compiled program) on the Master
mysql that goes something like this:
CREATE TEMPORARY TABLE tempTableA
INSERT INTO tempTableA
INSERT INTO normalTableB SELECT
Greets Folks,
Does anyone know if it is possible to get an SSI to work in conjunction with
a database, like MySQL?
I'd like to have a script that will insert a new text file each day along
with a timestamp, and I was wondering if it would be possible to use an SSI
to draw the info out of that
Hello
Has anyone got replicate-rewrite-db (a my.cnf entry) to work. I have replication
running fine, however the rewrite doesn't work.
I just want to know whether I should persist or if there is something special people
had to do to get it working. I have heard / read a few people saying that t
Hi,
It appears fulltext has the potential for my particular problem.
However, after altering my table to contain FULLTEXT, it did not
help much:
#1:
SELECT * FROM eventlog WHERE detail like '%keyword%'
ORDER BY id DESC LIMIT 20;
#2:
SELECT * FROM eventlog WHERE MATCH(description)
AGAINST ('key
Hi,
I am trying to make a database-neutral application.
What is the MySQL idiom to replace the Postgres EXISTS function?
I have two tables:
mysql> select * from groupcapability;
++--++
| id | melati_group | capability |
++--++
| 0 |
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java p
o
i don't think you can
you'd just have to post two separate insert statments
you can run them both at the same time if you like though
INSERT INTO table (booknum, isbn, title) values ('001', '1-56592-434-7',
'MySQL & mSQL');
INSERT INTO table (booknum, isbn, title) values ('002', '1-56592-257-3'
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java p
SQL statement are:
> What is proper way to define a variable to include all dates newer than
> 1995-01-01?
> $query = "???"
select * from table where date > '1995-01-01'
> What is proper way to define a variable to include all dates older than
> 1995-01-01?
> $query = "???"
select * from table
Hi there,
I have a postgreSQL query like
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...) INTERSECT
(SELECT ... FROM... WHERE...)
and I'd like to have an equivalent MySQL query. Your
help would be greatly appreciated.
The reason is that we were running Java p
Hi All,
I'm trying to connect ms access to a mysql server that I installed on my
Linux machine. I already downloaded the MyODBC 2.50 which is required to
connect to mysql using ms access. My problem is when I try to connect the
database in ms access to the mysql server I get the error "Host not a
I'm trying to port some stuff to OpenOffice.org from MS-Office.
Currently we store a lot of stuff in MS-Access 2000.
I figured out how to connect OO to a MySQL DB via MyODBC 3.51. But there
are a few problems.
1) I need filtering by date-fileds. Many of our tables have the fields
validFrom
Thanks for the assistance!
> Seems hard to answer without asking more questions, but some
> basic questions first:
>
> Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Yes, they are:
mysql> SHOW INDEX FROM aptreviews;
+++--+--+--
>>>Is there any electronic version of this book (e-book)?
>>
>>One of the chapters (the C API chapter) is online at the publisher's
>>site, and there are some other pages available at Amazon. All of these
>>are PDF format. There are pointers to this material at the book's
>>companion site:
>>
>>
Paul,
At 23:09 2002-02-25, you wrote:
>One of the chapters (the C API chapter) is online at the publisher's
>site, and there are some other pages available at Amazon. All of these
>are PDF format. There are pointers to this material at the book's
>companion site:
>
>http://www.mysql.com/mysql-b
Hello,
I'm running the same code in 2 different environments, but both access
the same MySQL database (3.23.47 Max, running on Solaris) and both use
mm.mysql-2.0.7.
Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a
Windows machine
Environment 2: JDK 1.3.1 running on Red Hat
I thought there was a problem with the datafile corruption if the cache was
lost when you chattr a file. That the file would become corrupt.
Dave
On Mon, Feb 25, 2002 at 03:55:23PM -0800, Steven Roussey wrote:
> I assume you are talking about bdflush only at 100% (I'm actually trying
> 90%). Thin
I assume you are talking about bdflush only at 100% (I'm actually trying
90%). Thing is, all our tables are constantly changing. Unless the
server crashes just after a flush tables command, the tables are likely
to get corrupt anyhow. The data altering flow of queries is over 1000/s
at the moment.
The problem is that the DB resides on a Unix box and he access it
through a cgi program
-Original Message-
From: Luis Gonzalez [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 5:18 PM
To: [EMAIL PROTECTED]
Subject: Dumping a MySQL DB Out to Access
Hi,
First of all, I'm not a
Bob,
This is just a guess, but looking at
http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way
to do multiple inserts looks like:
INSERT INTO a VALUES (1,23),(2,34),(4,33);
a(col1, col2).. Perhaps multiple inserts requires that you specify all
columns in the order that the t
Seems hard to answer without asking more questions, but some
basic questions first:
Is complex_id indexed in both tables? (SHOW INDEX FROM aptreviews)
Have you tried EXPLAIN'ing the query to see if maybe the index
isn't being used?
Questions:
That the queries are stuck on 'Send
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:nick hoffman
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Relea
Change it to
INSERT into book(
isbn,
title,
authlname,
authfname,
publisher,
pubdate,
dewey,
lcnum
)
values (
'1-56592-434-7',
'MySQL & mSQL',
'Yarger',
'Randy Jay',
"O'Reilly",
null,
null,
null
),
Get rid of the second "values".
mysql> INSERT into book(
-> isbn,
-> title,
-> authlname,
-> authfname,
-> publisher,
-> pubdate,
-> dewey,
-> lcnum
-> )
-> values (
-> '1-56592-434-7',
-> 'MySQL & mSQL',
-> 'Yarger',
-> 'Randy Jay',
->
On Tuesday, 26. February 2002 00:33, Bob Rea wrote:
> I'm getting a syntax error when I try to insert more two
> sets of values into a table.
>
> I have looked at the manual on the insert statement, and
> don't see what is wrong.
>
> ERROR 1064: You have an error in your SQL syntax near
> 'values
i'm trying to keep my code nice and clean
and one of the ways i'm doing this is keeping all the sql request code in
one module
the problem is: it's not working.
basically, all i really want is a subroutine call in my cgi that looks like
this:
my $dbh = DBI->connect('DBI:mysql:xx', 'xx
At 15:33 -0800 2/25/02, Bob Rea wrote:
>I'm getting a syntax error when I try to insert more two
>sets of values into a table.
>
>I have looked at the manual on the insert statement, and
>don't see what is wrong.
The error message indicates that the problem is at the word "values".
The problem wi
On Tuesday, 26. February 2002 00:18, Craig Westerman wrote:
> What is proper way to define a variable to include all dates newer than
> 1995-01-01?
> What is proper way to define a variable to include all dates older than
> 1995-01-01?
> What is proper way to define a variable to include all
SQL statement are:
> What is proper way to define a variable to include all dates newer than
> 1995-01-01?
> $query = "???"
select * from table where date > '1995-01-01'
> What is proper way to define a variable to include all dates older than
> 1995-01-01?
> $query = "???"
select * from table
I'm getting a syntax error when I try to insert more two
sets of values into a table.
I have looked at the manual on the insert statement, and
don't see what is wrong.
Can someone tell me.
Here's the info.
mysql> describe book;
+---+-+--+-+-+-
I am hosting websites that use the mysql database. One of my customers has
a query that they run occasionally that really bogs down the entire server.
The load sometimes jumps up into the double digits (on a Red Hat 6.2
server).
Here is their query:
select count(*) from aptreviews, aptcomplexes
On Mon, Feb 25, 2002 at 02:44:45PM -0800, Eric Mayers wrote:
> Oganes,
>
> It sounds like what you want is row-level-locking. This is a
> feature of InnoDB tables. It allows users to write to a table while
> other users are reading from the same table. Of course, they cannot
> read and write
Hi,
First of all, I'm not an expert at all, I'm just a newby who started a week
ago,,,
But I guess that the answer is very simple: Why don't you link your MySQL
database to Access thru MyODBC?
This way your customers could use Access as the front-end, while MySQL is
the back-end where the data
$query = ""
mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'");
// returns all items in database
$query = "2001-01-01"
mysql_query("SELECT * FROM table WHERE date LIKE '%". $query ."%'");
// returns all rows that have 2001-01-01 as the date
What is proper way to define a varia
Hi,
I'm new to MySQL and this list. ^_^
My question is: "What's the best and fastest way to convert an Informix
database to MySQL?"
Thanks,
Jessica
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hello,
I'm running MySQL on a Windows 2000 box. I was running 3.23.47 until
3.23.49 was released. After upgrading to 3.23.49, queries like this don't
work:
UPDATE test_table SET board_posts=board_posts+1 WHERE username='blah' AND
password='blah';
Normally, that would increment the value in boa
At 16:09 -0600 2/25/02, Paul DuBois wrote:
>At 21:35 +0200 2/25/02, savaidis wrote:
>>Is there any electronic version of this book (e-book)?
>
>One of the chapters (the C API chapter) is online at the publisher's
>site, and there are some other pages available at Amazon. All of these
>are PDF for
Oganes,
It sounds like what you want is row-level-locking. This is a feature of
InnoDB tables. It allows users to write to a table while other users
are reading from the same table. Of course, they cannot read and write
the same rows simultaniously. Have you tried to do this and had some
pro
Hello everyone,
I have this database, I'm using InnoDB type tables. I wanted to know the
following:
How can I manipulate the tables, so that db supports multiple users trying
to access the same table for writing or reading purposes at the same time.
Thanks,
Oganes Demirchyan
Motorola Life Sc
At 21:35 +0200 2/25/02, savaidis wrote:
>Is there any electronic version of this book (e-book)?
One of the chapters (the C API chapter) is online at the publisher's
site, and there are some other pages available at Amazon. All of these
are PDF format. There are pointers to this material at the
If you do that don't you run a greater risk of corruption of the datafiles
if the host unexpectedly goes down?
Dave
On Mon, Feb 25, 2002 at 01:07:06PM -0800, Steven Roussey wrote:
> I was reading an article on speeding up Oracle on Linux(1) and thought
> their two optimizations for Linux would wo
Thanx all,
I am new to this and still learning, when I installed Linux, I did not have
to do anything to PHP however I did just get the mysql rpm and install
without any special configuration, Does anyone have an idea of any article
that will help me recompile my php with my apache.
Thanx
sql,query
Does anyone know how / if it's possible to recover a lost .MYI file if I
still have the .MYD and .frm files? It seems like it should be possible
but I haven't found any documentation on it yet.
Thanks,
- bdf
-
Befor
sql,query
Is it possible to setup a system DSN with myodbc? We have several databases
that need to be linked together for Crystal Reports to use. So far I have
not figured out how to do this.
TIA!
Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282
---
On Mon, 25 Feb 2002, Oladejo, Tokunboh wrote:
> Does anyone have an idea why I am getting an error "Fatal error: Call to
> undefined function: mysql_connect() in /var/www"
That's the error you get if you try to call mysql_connect() but don't have
the MySQL support compiled in to the PHP module.
I don't take work out of office, NEVER! :)
Is not possible to copy e-book either, I think!
(PS: You're so sick to read work books at home ? :)
Makis
> -Original Message-
> From: Georg Richter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 9:52 PM
> To: savaidis; 'MyS
Hi.
On Mon, Feb 25, 2002 at 04:08:56PM +0100, [EMAIL PROTECTED] wrote:
> Hi guys.
> I made system. it is based on php+apache+mysql.
> This system i would like to sell a Company.
> Must i or this Company buy any licence from mySQL AB to legally use mysql
> with apache+PHP in this system ?
This i
Hi All,
Does anyone have an idea why I am getting an error "Fatal error: Call to
undefined function: mysql_connect() in /var/www"
in this PHP function
"mysql_connect("localhost","root","password");"
Thanx All
-
Before pos
Okay, this is clearly not what I want. I'm looking for a method to see
how much space a table is using compared to the total amount of space
available. Is there a way to do this (with innodb tables)?
Eric Mayers
> -Original Message-
> From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
> Se
From: Chetan Lavti <[EMAIL PROTECTED]>
> 1. When I am inserting the values and the Query fails, the increment
> should not took place and
It doesn't.
> 2. When I delete a particular row from the table there should not be any
> gap in the auto increment sequence.
This doesn't work. Although y
At 0:44 +0530 2/26/02, Chetan Lavti wrote:
>hi,
>I creating a table where I am using one field as Auto Increment. I want
>to know two things or rather I want to do to thinks for the same column
>
>1. When I am inserting the values and the Query fails, the increment
>should not took place and
>2. W
1. The auto_increment will not occur on failure. Try it yourself to
verify; I did.
2. When you delete a row, you DO NOT WANT the auto-increment to re-number.
You SHOULD have gaps. Why?
Because if the auto_incremented field is a primary key, and there are other
tables who fields refer to that
Is there any electronic version of this book (e-book)?
Because it will be very helpfull if it has an index-content like PDF docs.
And why pay for paper? We live on 2000 no?
Makis
> -Original Message-
> From: Craig Westerman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 25, 2002 8
Hi.
On Mon, Feb 25, 2002 at 11:22:22AM -0700, [EMAIL PROTECTED] wrote:
> From: Ari Kahn <[EMAIL PROTECTED]>
>
>
> > However, whatever method I try mysql tell me that the user table
> > is read only.
>
> It sounds to me like "root" doesn't have sufficient permissions
> granted to write to that
On 25 Feb 2002, at 10:03, Eric Mayers wrote:
> Why is the max_data_length portion of "Show table status ..." for innodb
> tables null? Is there a way to get this value? I want to use this and
> data_length to display a % of space used statistic.
I think you're misunderstanding what the max_dat
Compiled MySQL 3.23.49 from source and I still can't kill the server
without -9 in OS X 10.1.3
sigh...
--
John McCauley
CTGi, Oakton, VA USA
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
- Create a dir in /Library/StartupItems called mysql
- make a shell file called mysql containing (and make it executable)(this
assumes that user-id stuff is in /etc/my.cnf):
#!/bin/sh
. /etc/rc.common
if [ "${mysql:=-NO-}" = "-YES-" ]; then
ConsoleMessage "Starting MySQL Server"
cd /usr/local/
hi,
I creating a table where I am using one field as Auto Increment. I want
to know two things or rather I want to do to thinks for the same column
1. When I am inserting the values and the Query fails, the increment
should not took place and
2. When I delete a particular row from the table ther
sql,query
At 11:56 -0600 2/25/02, Craig Westerman wrote:
>for the EXCELLENT index in your book. I developed several questions this
>morning and was able to find answers to all easily using the index in your
>book.
>
>Much appreciated.
>
>Craig ><>
>[EMAIL PROTECTED]
Thanks, I'm glad it was usefu
From: Ari Kahn <[EMAIL PROTECTED]>
> However, whatever method I try mysql tell me that the user table
> is read only.
It sounds to me like "root" doesn't have sufficient permissions granted to write to
that table, but I could be wrong. There's something in the docs about accessing after
you'v
for the EXCELLENT index in your MySQL book. I developed several questions
this morning and was able to find answers to all easily using the index in
your book.
Much appreciated.
Craig ><>
[EMAIL PROTECTED]
-
Before posting, pl
Let me try again. I recently installed mysql. I need to change the root
password. However, whatever method I try mysql tell me that the user table
is read only.
> mysqladmin -u root password 'mynewpassword'
mysqladmin: unable to change password; error: 'Table 'user' is read only'
Or
mysql> U
Why is the max_data_length portion of "Show table status ..." for innodb
tables null? Is there a way to get this value? I want to use this and
data_length to display a % of space used statistic.
Eric Mayers
Software Engineer I
Captus Networks
sql,query
Steve Traver writes:
> FYI-
>
> My Environment:
> - Windows NT 4.00.1381
> - MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32)
>
> Program will not allow me to create or edit tables. Also, bombs when I
> try to create a database.
>
> sT
>
Table creation and editing is not done ...
FYI-
My Environment:
- Windows NT 4.00.1381
- MySQL Ver 11.15 Distrib 3.23.43, for Win95/Win98 (i32)
Program will not allow me to create or edit tables. Also, bombs when I
try to create a database.
sT
-
Before posting,
Also, check permissions on the mysql directories to make sure that MySql can
actually write into it and that other people can read the mysql.sock file.
-Original Message-
From: Steve Suehring [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 8:42 AM
To: Ricardo Javier Aranibar Le
On Monday, 25. February 2002 17:47, Miretsky, Anya wrote:
> How do I restore a Mysqldump of a database? I've found documentation on how
> to backup a db and have done but I can't figure out how to create a new db
> from my dump file? Please help.
1) Create an empty db "yourdb"
2) mysql -uuser -pp
Ricardo,
Monday, February 25, 2002, 6:38:59 PM, you wrote:
RJAL> I have a problem, when I try to connect to the Data Base
RJAL> [root@hvserver_tja bin]# mysql
RJAL> bash: mysql:command not found
RJAL> [root@hvserver_tja bin]# ./mysql
RJAL> ERROR 2002: Can't connect to local MySQL server through
How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.
thanks
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY 11225
Hi,
Are you sure that the MySQL server is running?
If so, maybe look for the mysql.sock file (find / -name "mysql.sock")
./mysql -u -p --socket=/location/of/socket.sock
Steve
On Mon, Feb 25, 2002 at 04:38:59PM +, Ricardo Javier Aranibar Le?n wrote:
>
>
> I have a problem, when I try to
I have a problem, when I try to connect to the Data Base
[root@hvserver_tja bin]# mysql
bash: mysql:command not found
[root@hvserver_tja bin]# ./mysql
ERROR 2002: Can't connect to local MySQL server through '/tmp/mysql.sock'
(2)
[root@hvserver_tja bin]# ./mysql -h hvserver_tja -u -p
Enter pass
Ireneusz,
Monday, February 25, 2002, 5:08:56 PM, you wrote:
IP> Hi guys.
IP> I made system. it is based on php+apache+mysql.
IP> This system i would like to sell a Company.
IP> Must i or this Company buy any licence from mySQL AB to legally use mysql
IP> with apache+PHP in this system ?
IP> I ne
Richard,
Monday, February 25, 2002, 6:08:53 PM, you wrote:
RR> I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
RR> ver. 3.23.41 on a new server which I will eventually use to replace my
RR> old server that's running 3.22.32. I have tar'ed and ftp'ed the
RR> datbases files
[EMAIL PROTECTED] writes:
> The latest rpms for mysql 3.23.49 produce a signal 4 error when
> attempting to run the installed mysql server.
> on all our servers running redhat 7 thru 7.2.
>
> Obviously this can't be a kernel 2.2.x issue, since 7.2 is on 2.4.x.
>
> I've tried multiple installs
Hello,
You'd probably want JDBC.
http://www.mysql.com/downloads/api-jdbc.html
Steve
On Tue, Feb 19, 2002 at 03:17:49PM +, Bill Fogarty wrote:
> Hi,
>
> Does anyoone know how to connect to mysql from a Java application in windows 2k?
> Any help would be greatly apppreciated. I may be writi
Hi ,
I'm trying to perform a SQL query containing several calls to mySQL replace
functions.
On the same basis that this :
" SELECT replace(message, "@TITLE@", title) FROM ** "
in this case, message and title are 2 fiels of the the same table
I want to do something like this :
SELECT replace(
Hi,
Does anyoone know how to connect to mysql from a Java application in windows 2k?
Any help would be greatly apppreciated. I may be writing to the wrong list, anyone got
any suggestions of where i could get help with this online.
Cheers,
Bill
Hi guys.
I made system. it is based on php+apache+mysql.
This system i would like to sell a Company.
Must i or this Company buy any licence from mySQL AB to legally use mysql
with apache+PHP in this system ?
I need quickly an answer.
Regards.
I. Piasecki
--
Okresl Swoje potrzeby - my z
On Saturday 23 February 2002 05:34 pm, you wrote:
> (gdb) thread 1
> [Switching to thread 1 (process 31905, thread 1)]
> #0 ?0x82011ce in memcpy ()
> (gdb) bt
> #0 ?0x82011ce in memcpy ()
> #1 ?0x82a33c0 in mysql_bin_log ()
> #2 ?0x80b7cd8 in ha_commit_trans ()
> #3 ?0x8076e24 in mysql_execute_com
I am upgrading from MySQL ver. 3.22.32 to 3.23.41. I have installed
ver. 3.23.41 on a new server which I will eventually use to replace my
old server that's running 3.22.32. I have tar'ed and ftp'ed the
datbases files over to the new server. When I copy them over to the
table directory ( on
Dear all.
Have anyone practice in www-mysql package ?
I've installed apache, www-mysql. And so ? What next.
Marek Wysmulek.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Hello all forgive me for posting off topic (again - that's only two!)
I need to install the QT 2.2.2 client libraries on a Linux Mandrake 7.1
machine. I have created this app using Borland's delphi/kylix combo and
it runs fine on my LM 8.1 machine (it must have qt installed by default
maybe). B
Rex Yuan writes:
> Hello,
>
> When I tried to run mysqlgui, this is the error message that I received:
> "can't connect to local MySQL server trough socket (111)"
>
> I've checked and created all the client files. What does it mean? How can
> I correct it? MySQL server is up and running.
>
>
1 - 100 of 125 matches
Mail list logo
