Please solve the problem :
# uname -a
SunOS mail.chiangmai.ac.th 5.7 Generic_106541-02 sun4m sparc
SUNW,SPARCstation-10
# make -v
GNU Make version 3.78.1, by Richard Stallman and Roland McGrath.
Built for sparc-sun-solaris2.7
# pwd
/export/home0/mysql-3.23.33
# make
# make install
Making install
Hi Benjamin, Andre,
> > i have a mysql server on a dual xenon with 2GB ram
> > with 300 Databases (for each customer one)
> > but in the meantime a simple query takes ages to complete >10s
Generally, slow queries are caused by inadequate configuration of the server
and/or badly formed queries (s
Hi.
On Tue, Oct 02, 2001 at 03:14:33PM -0500, [EMAIL PROTECTED] wrote:
> Hello All,
>
> I have several queries that generate various financial reports, by date ranges.
> I've been trying to figure out a way to combine all these queries into one query
> , if it's at all possible or if it's practi
Hi.
My first guess would be that somehow the slave got out of sync. I
would try to update the slave by hand and see what happens after
restart.
Sorry, I don't see what could be the cause.
Bye,
Benjamin.
On Tue, Oct 02, 2001 at 06:07:29PM +0200, [EMAIL PROTECTED] wrote:
[...]
> I have
Hi.
On Tue, Oct 02, 2001 at 04:44:08PM +0100, [EMAIL PROTECTED] wrote:
[...]
> I would like to use Subselects with mySQL but they are not supported
> until 3.24.
Sub-selects are scheduled for 4.1, as far as I know (also see end of
page http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html)
Hi.
On Tue, Oct 02, 2001 at 05:23:51PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> i have a simple question:
> how many databases is mysql able to handle.
There is no hard limit by MySQL. There are limits brought in by your
operating system, though.
> i have a mysql server on a dual xenon with 2
Hi.
On Tue, Oct 02, 2001 at 01:02:19PM +0100, [EMAIL PROTECTED] wrote:
> >Hi there. I have problems with mySQL
>
> >What I would like to do is:
>
> >I have a statement
>
> >SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena,
> >ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=oce
Hi.
On Tue, Oct 02, 2001 at 11:30:46AM +0200, [EMAIL PROTECTED] wrote:
> hello,
>
> sorry for my english,
>
> I have a compaq bi PII 400 Mhz with 512 Mo of ram.
> Linux mandrake 8 kernel 2.4.6
> MySQL 3.23.36, apache 1.3.19 with php 4.0.4pl1
Please upgrade MySQL to a recent version (3.23.42 is
Hi.
On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote:
[...]
> I've seen rumors about bool being an alias for tinyint(1), but it's
> not in the manual and I haven't tested it.
Actually, it's in the manual (but just recently ;), but it tells
otherwise: http://www.mysql.com/doc/C/o
Hi.
I think we should let this thread die, as the original problem is
solved, and the user already can choose the behaviour via "-r".
Bye,
Benjamin.
On Thu, Oct 04, 2001 at 11:52:11AM +0800, [EMAIL PROTECTED] wrote:
> > > > "batch mode" doesn't necessarily mean "raw mode". You want to
Currently I am using a standard field for information
input to the MySQL database. When I display the allready information in the
text fields to allow the user to manipulte the information, the formatting
includes any carrige returns that have been entered. However when I display
the text usi
Hello,
I have some queries related to MySQL
a.. The Default table_cache = 64 . what its mean? If i increase the
table_cache to 600 whats happened with my mysqladmin processlist (related to
speed) and what is max_tmp_tables.
b.. If in our database we have 20 tables. how many tables open wh
We're in the process of rewritting our internal systems in java, using
MySQL. Moving away from VB and MSSQL. We are adopting standard java naming
conventions, ie:
candId
addressLine1
addressLine2
etc...
So only real advice is to stick to a standard.
-medge
> -Original Message-
> From: Ja
> > > "batch mode" doesn't necessarily mean "raw mode". You want to ask
for
> > > "raw mode", but ask for "batch mode".
> >
> > Luckily this led me to look up the letter "r" in command line
options
> > and I happened to find the "-r" option. Which is exactly what I
need.
>
> Fine.
>
> > My questio
> database,sql,query,table
> Is there a reason why I can't use Mixed_Case column names? Or is there a
> reason why I should use lower_case names?
>
> TIA
>
> Barry
No
jason
-
Before posting, please check:
http:
I'm putting together my first MySQL database and I've noticed in the book
I'm reading all of the entity names (table & column names) are in lower case.
Other database vendors use UPPERCASE for all of their entity names because
they are case sensitive.
Is there a reason why I can't use Mixed_Cas
venu:> If you can make use of MS Access and ODBC in the middle layer in
venu:> the conversion,
venu:> from MSSQL-->MySQL, then probably you don't need any editing.
venu:> Here is the simple
venu:> procedure:
Yes this is true and probably a superior method for small databases (say,
less than 300Mb
It appears (without verifying it myself), these are the approximate
meanings:
IdThe process or thread ID of this particular job or process in the
database
UserUsername of this job or process or connection
HostFrom which host is the User connected
dbWhat is the "default" database o
One only needs to specify the column names if and only if there are not
values, in the correct order, for all of the columns in the table.
That is:
Create Table foo (
aid intnot nullprimary key,
last varchar(30),
firstvarchar(30),
emailvarchar(60)
);
Righ
I did not see the full schema so I can't give you a definite answer.
However, your syntax is wrong:
INSERT INTO email_addresses (last_name, first_name, email_address) VALUES
("$lastname", "$firstname", "$email_address");
For each value you specify, you also have to specify a column name.
Did yo
This is my first script, so I am sorry it is so newbie-ish.
I think I have the correct script to open the connection, open the database
and the table. However, I cannot get the "insert into" to work. I have read
several online sources and books, all of which are slightly different. It is
not a par
Hello all,
Can anyone tell me how to read the output of the 'mysqladmin
processlist' command? I cannot find any documentation on what each
column really means.
Thank you.
-
Before posting, please check:
http://www.mysql.com
Hi.
On Thu, Oct 04, 2001 at 07:53:15AM +0800, [EMAIL PROTECTED] wrote:
> > "batch mode" doesn't necessarily mean "raw mode". You want to ask for
> > "raw mode", but ask for "batch mode".
>
> Luckily this led me to look up the letter "r" in command line options
> and I happened to find the "-r" o
> "batch mode" doesn't necessarily mean "raw mode". You want to ask for
> "raw mode", but ask for "batch mode".
Luckily this led me to look up the letter "r" in command line options
and I happened to find the "-r" option. Which is exactly what I need.
My question was so clear. I have to wonder w
I don't know anything about MySQL, Ive just been trying(with no luck)to
install a forum(Snitz forum from www.snitz.com) on my website. My website is
Linux/MySQL/Chilisoft!
I open my setup.asp in my browser like: www.dvox.com/forum/setup.asp I get
the prompt to login. Once I login I get this:
hey
If the text is supposed to be parsed from a mySQL to a HTML webpage, using
€ or € should display a € sign.
A simple replace would then do the trick.
Doc
- Original Message -
From: "Haapanen, Tom" <[EMAIL PROTECTED]>
To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]>
Sent: Wednesday,
Can someone help me decipher this make error?
Making all in client
CC -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I..
-I..-O3 -DDBUG_OFF -DHAVE_BROKEN_PREAD
-DDONT_USE_FINITE
-D_INCLUDE_LONGLONG -DNO_FCNTL_NONBLOCK -c mysql.cc
aCC: warning 901: unknown o
In order to install PHP with mysql, when mysql is installed from
RPM's:
Make sure you have all the MySQL RPM's, specially the devel package
then the PHP ./configure command is:
--with-mysql=/usr
and not the default --with-mysql=/usr/local
I just posted this so others can find the answer to th
Hi,
I wanted to know if you can allow certain users to edit certain rows.
Please, if anyone knows how to do it, then please tell me, thanks.
I am having trouble porting MySQLGUI to Mac OS X. Any plans to make a
package?
-chris
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
On Wed, Oct 03, 2001 at 05:02:27PM +, Carl Troein wrote:
>
> Hugo Koji Kobayashi writes:
>
> > I'm making some tests with mysql and I got the errors below when I
> > run these selects:
> >
> > SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10;
> > ERROR 1034: Incorrect
Hi,
I just got finished creating a database schema. I tried to follow all the
rules and Normal Forms and all of that stuff, and I think I got it right,
but as this is my first time creating a production schema I'm not sure. I
was wondering if someone would be willing to take a look over my sche
Hi.
On Wed, Oct 03, 2001 at 11:26:30AM +0800, [EMAIL PROTECTED] wrote:
> > It may not intuitive at first, but it is really what one
> > wants for default. For example, how would you else know, whether
> >
> > test
> > asdf
> >
> > was originally one row ("test\nasdf") or two rows ("test"+"asdf")?
Depending on weather or not it uses standard SQL, you couuld simply
run:
mysql -u user -ppassword < file.sql
however, I doubt mysql will understand the SQL generated from
your other SQL DB. Might be a better idea to recreate all the
tables/fields in mySQL manually, then dumping to .csv files
(co
Alex,
you are using MyISAM type tables which do not support
rollback. Use BDB or InnoDB tables.
Regards,
Heikki
http://www.innodb.com/ibman.html
> My big problem is the rollback, every time when I try to use a rollback
> command I get this error:
> ERROR 1196: warning: some non-transaction cha
I've checked the mailing archive and did not find what I am looking for.
How can I import data dumped from sybase into .sql files into MySql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
hello all,
i am interested in determining whether there are performance issues of which
i should be aware related to the usage of a table which takes up ones or
tens of gigabytes. i am planning to use an index of some kind.
i'd appreciate hearing about any experience which you'd relate, or
any t
I did install all RPM's exept the benchmark. What is the name of the
header files?
On 3 Oct 2001, at 14:20, Carl Troein wrote:
>
> Ralf R. Kotowski writes:
>
> > I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed,
> > when I try to compile PHP with MySQL it tells me that it can't f
Hi !!!
> -Original Message-
> From: Will French [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 12:28 PM
> To: Pavel Hant; [EMAIL PROTECTED]
> Subject: RE: Migration to mysql from MS SQL Server
>
>
> I just did this with a rather large database. Here are the steps that I
>
Either way, DON'T FORGET to edit the table right if you use any, etc.
Or you will not access it at all.
Just a quick friendly reminder!
> -Original Message-
> From: Ravi Raman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 03, 2001 18:04
> To: Carsten H. Pedersen; Brandon Lewis;
I am working on a project for a client that got roped into MsSQL7 by her
last hosting company. I am looking for a good way to convert a MsSQL7
Database to MySQL. Anyone know of a piece of software that will convert the
Database files or atleast suck from one database to the another.
Thanks in adv
It's the only way with InnoDB short of renaming each table in the
format:
RENAME TABLE olddb.table1 TO newdb.table1
Ken
>
> That's sort of taking the long way around the barn, isn't it?
>
> Will
>
-
Before posting, please check
> I'm hoping someone can point me in the right direction. I'm
> trying to find
> this perl script that is a link on the MySQL.com site but I get this
> message:
>
>
> 550 /mirrors/mysql/Downloads/Contrib/excel2mysql.pl: No such file or
> directory
>
>
> Anyone know where this perl script is?
I just did this with a rather large database. Here are the steps that I
followed:
1. In MSSQL Enterprise Manager, use "generate scripts" to, well, generate
your SQL scripts. (right click on any table and select All|Generate
Scripts). I decided to break save the index builds until after the dat
I'm hoping someone can point me in the right direction. I'm trying to find
this perl script that is a link on the MySQL.com site but I get this
message:
550 /mirrors/mysql/Downloads/Contrib/excel2mysql.pl: No such file or
directory
Anyone know where this perl script is? I've got a lot of exc
"Carsten H. Pedersen" wrote:
> > We are looking to convert all ISAM tables to the new type MYISAM
> >
> > Has anyone else converted all tables in all their databases in one fell
> > swoop to
> > a new type? using the alter table command.
> >
> > Thanks for any gotchas, hints or suggestions.
>
ravi:> Or, use mysqldump to dump the entire database, edit the CREATE
ravi:> DATABASE line
ravi:> at the top to the new name and pipe it all back into mysql, then drop
the
ravi:> old one?
That's sort of taking the long way around the barn, isn't it?
Will
> -Original Message-
> From: Rav
Cool! Now I add the Powered by MySQL to my site. At leaste thats what I
think I remember after a half hour of reading
M;)
>
> Hi!
>
> Sorry for the REAL long response to this thread. It took just a long
> time for our lawyers to understand what we really want to do with the
> MySQL AB trademar
> We are looking to convert all ISAM tables to the new type MYISAM
>
> Has anyone else converted all tables in all their databases in one fell
> swoop to
> a new type? using the alter table command.
>
> Thanks for any gotchas, hints or suggestions.
A somewhat unconventional method which wo
Hi everybody,
I am trying to migrate a database from MS SQL Server 2000 to mysql. Does
anybody know any source of information on this matter, or can anybody share
his/her own experience of such a migration? Suggestions?
Any help would be appreciated.
Thanks,
Pavel
Or, use mysqldump to dump the entire database, edit the CREATE DATABASE line
at the top to the new name and pipe it all back into mysql, then drop the
old one?
-ravi
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: October 3, 2001 11:50 AM
To: Brandon Lewis;
> Dear Friends,
>
> I am using mysql 3.23.42. I want to execute one
> query to get specific result but not getting the
> correct result.
>
> I have 2 tables named: ContactList and GroupList.
> - Now I want to get those 'nickname' from
> ContactList which do not appear in GroupList wit
> Is it possible to rename a database?
I would assume that the only way to do is is to
shut down the server, then rename the directory
of the database.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
This worked once I recompiled the distribution. Thanks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
>
> Apparently you have to compile for large file support and have glibc > 2.1.3.
> http://www.suse.de/~aj/linux_lfs.html
>
> I have not used it so I do not know the real-world limitations.
>
>
Hi!
Sorry for the REAL long response to this thread. It took just a long
time for our lawyers to understand what we really want to do with the
MySQL AB trademark. They are so used to protect all issues regarding
their clients trademark that they don't understand that some of the
restrictions t
Apparently you have to compile for large file support and have glibc > 2.1.3.
http://www.suse.de/~aj/linux_lfs.html
I have not used it so I do not know the real-world limitations.
Or (for 100MB files):
mysqldump db table |split -b 1 - table
--Bill
Mike Lucente wrote:
> I'm also unab
Hi Brandon,
It is possible if you are you are using myisam or DBD table types,
but you have to rename the directory from the Unix shell prompt.
There is not yet a RENAME DATABASE command (althought it is on the
todo list) and no way that I know of (short of renaming each table if
you only have
Hi!
On Oct 03, Mike Lucente wrote:
> I'm running out of space while creating indexes on some fairly large (1.8
> GB) tables, even though I have quite a bit of space available in the
> partition (utilization is at 30%).
>
> I know that the create process works as follows (from the manual):
>
> C
Andrey,
it is not a bug. Monty wanted to avoid some changes
in 3.23 and decided to do 'delete from a' with individual
row deletes if InnoDB is defined. In 4.0 you should
use TRUNCATE TABLE to empty a table, and it works
fast for all table types.
Regards,
Heikki
http://www.innodb.com/ibman.html
We are looking to convert all ISAM tables to the new type MYISAM
Has anyone else converted all tables in all their databases in one fell
swoop to
a new type? using the alter table command.
Thanks for any gotchas, hints or suggestions.
<<<
April S
Dear Friends,
I am using mysql 3.23.42. I want to execute one
query to get specific result but not getting the
correct result.
I have 2 tables named: ContactList and GroupList.
Their structure is as below:
+---+
ContactList
+--
Someone wrote::
<< Or, if you have moved the tables with symlinks, MySQL will put the new
file
> (most of the time?) in the configured data directory and not where the
> symlink points.>>
Really?
The Index file wont be in the same directory as the database itself if I am
using symlinks to the d
> My big problem is the rollback, every time when I try to use a rollback
> command I get this error:
> ERROR 1196: warning: some non-transaction changed tables couldn´t be
rolled
> back
>
> Do you know why ?
>
> thanks for help
-
I'm also unable to create files >2GB with mysqldump, even after a
recompile with gcc 2.96, RH 7.1 w/2.4.2 kernel, glibc 2.2.2.
hmmm ...
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
> Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
> limit on 2.2.x kernels?
>
> Or, if you
Hi all:
I have tried running the m2o.pl scrip to convert the mysql dump
into an Oracle DDL and it seems to me that it didn't do anything
at all. I ran the command the way README suggest :
m2o < mysqldump > oracledump,
but saw a number of the mysql-specific commands in the resulting
file. Has a
On Wed, Oct 03, 2001 at 06:39:45PM +0200, Carsten H. Pedersen wrote:
> > Hi,
> >
> > I'm making some tests with mysql and I got the errors below when I
> > run these selects:
> >
> > SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10;
> > ERROR 1034: Incorrect key file for t
I'm running 2.4.2 and I'm not using symlinks.
On Wed, 3 Oct 2001, Adams, Bill TQO wrote:
> Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
> limit on 2.2.x kernels?
>
> Or, if you have moved the tables with symlinks, MySQL will put the new file
> (most of the time?) in
I am getting this error in my log files from mysql
(Got timeout reading communication packets)
I'm starting safemysql with the variables
-O key_buffer=16M -O sort_buffer=1M -O back_log=200 &
mysql> show status
-> ;
+--+--+
| Variable_name| Va
Sandeep Murthy writes:
> The database I have created for storing images has a field called
> binary_junk which is of type "BLOB" but its still not working...
[snipped PHP code]
Man, I can see why you have problems getting your code to
work. Try checking for errors instead of assuming that every
Hugo Koji Kobayashi writes:
> I'm making some tests with mysql and I got the errors below when I
> run these selects:
>
> SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10;
> ERROR 1034: Incorrect key file for table: '#sql17adb_41f_4'. Try to
> repair it
If you get an err
George Eric R Contr AFSPC/CVYZ writes:
> Ok, I can see that now. If the record doesn't exist in the tracked table,
> it can't meet the window criteria.
>
> The one way I see to get around this, in the absense of subselects, is to
> retrieve the tracked data that meets the window criteria into
Is it possible to rename a database?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
Or, you could try this:
SELECT available.target, tracked.sensor
FROM available LEFT JOIN tracked ON available.target=tracked.target
AND tracked.window=137
WHERE available.window=137 AND available.sensor=8;
-Original Message-
Ok, I can see that now. If the record doesn't exist in the tracked table,
it can't meet the window criteria.
The one way I see to get around this, in the absense of subselects, is to
retrieve the tracked data that meets the window criteria into a temporary
table. Right?
-Original Message--
It looks to me as though the "tracked.window=137" condition is suppressing output of
any "available" rows which do not have a target match in "tracked" - tracked.window
would = NULL in those cases.
--Greg Johnson
-Original Message-
From: George Eric R
I'm not getting the behavior I expect from this select.
SELECT available.target, tracked.sensor
FROM available LEFT JOIN tracked ON available.target=tracked.target
WHERE available.window=137 AND tracked.window=137 AND available.sensor=8;
Now, I know for this window, that there are 25 records for
The database I have created for storing images has a field called
binary_junk which is of type "BLOB" but its still not working...
TIA,
sandeep
- Original Message -
From: "AJDIN BRANDIC" <[EMAIL PROTECTED]>
To: "Sandeep Murthy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday,
Hi,
I'm making some tests with mysql and I got the errors below when I
run these selects:
SELECT id, COUNT(*) FROM error_test WHERE info = 1 GROUP BY id LIMIT 10;
ERROR 1034: Incorrect key file for table: '#sql17adb_41f_4'. Try to
repair it
SELECT id, COUNT(*) FROM error_test WHERE info = 1 GRO
I have never done it but have seen posts on this topic. From what I
understand you need to create a BLOB field in your DB (MySQL) then upload
file to your server, read it with fopen (or ...) into a variable then
insert that variable into the BLOB field you have in your DB.
Hope I am right her
David Turner wrote:
> If this is the case. What are the steps necessary for index rebuilds? Can
> I specify where the index file is rebuilt? Any idea when we can specify
> the location of datafiles and indexfiles?
For the kernel: You either need to upgrade to a later 2.4.x series kernel which,
I
Hi all,
I created a table like this
create table t_table (
id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT ,
name TEXT NOT NULL,
description TEXT
);
the table contains some records but the description fields defaults to null
for all the records allready entered
In asp (iis5) I loop
hi all,
I have been trying to insert images into my mysql database thru PHP for the
past 2 days without any luck.. After having tried various combinations of
queries, I gave up..
Wud be grateful if anyone can post a query for inserting images in to my
database..
TIA,
Sandeep
This is what i h
If this is the case. What are the steps necessary for index rebuilds? Can
I specify where the index file is rebuilt? Any idea when we can specify
the location of datafiles and indexfiles?
Thanks, Dave
On Wed, Oct 03, 2001 at 07:57:35AM -0700, Adams, Bill TQO wrote:
> Perhaps your index file (.MY
Perhaps your index file (.MYI) is growing larger than 2GB, the file-size
limit on 2.2.x kernels?
Or, if you have moved the tables with symlinks, MySQL will put the new file
(most of the time?) in the configured data directory and not where the
symlink points.
--Bill
Mike Lucente wrote:
> I'm
I'm running out of space while creating indexes on some fairly large (1.8
GB) tables, even though I have quite a bit of space available in the
partition (utilization is at 30%).
I know that the create process works as follows (from the manual):
Create a new table named `A-xxx' with the requested
Ralf R. Kotowski writes:
> I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed,
> when I try to compile PHP with MySQL it tells me that it can't find
> the mysql header files... now where are those located? I tried
> specifying every dir that has something to do with MySQL, no lu
At 12:53 PM +0800 10/3/01, chong wee siong wrote:
>Hi DBAs:
> I want to copy TableA in DatabaseA to TableB in DatabaseB
>with changes in the attributes of the tables, what options do I have?
>
>I tried these:
>
>a) insert into TableB (id) select (id) from DatabaseA.TableA;
>this works
>b) insert
You're right, I just forgot to put it in here, as I said the query
works, however, not the way I thought it was supposed to..
>>The query I tried is:-
>>SELECT * from table1 WHERE title LIKE %keyword% ORDER BY title LIMIT 0,10;
>>
>
>The quotes are missing around the string constant.
>
--
Ashwin Kutty writes:
> The query I tried is:-
> SELECT * from table1 WHERE title LIKE %keyword% ORDER BY title LIMIT 0,10;
The quotes are missing around the string constant.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Hi,
The version of MySQL is (this could be it, I'll try upgrading this now):-
3.23.41 on Linux kernel version 2.4.7-2 on a Redhat 8 server.
The table (table1) has the following fields:-
author varchar(128)
category varchar(64)
title varchar(128)
location varchar(64)
platform varchar(40)
note va
Hi,
I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed,
when I try to compile PHP with MySQL it tells me that it can't find
the mysql header files... now where are those located? I tried
specifying every dir that has something to do with MySQL, no luck.
Thank you very much for y
I have developed my application on MS-SQL on Win' NT platform using
Powerbuilder.
Can I run this application on Linux and MYSQL.
Please respond immediately as we are trying to promote this combination
actively.
With warm regards
Anand Agarwal
e-mail: - [EMAIL PROTECTED]
Your attitude decides..
Now I'm using Mysql under Microxof system, what kind of GUI to
Administrate mysql databases is the most practique to use ?
Xoldi.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Jamie,
This is likely a client software issue. We use Perl and DBI, and we have no
trouble storing or retrieving non-USASCII characters.
What are you using to access the MySQL database?
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Jamie Smith [mailto:[EMAIL PROTECTED]]
Sent
I'm having a problem with the sending of the new euro € symbol into the
mysql database through a standard SQL stament. I have tried everything cut
and paste or ALT 0128 on the command line but all I seem to get is a ?
character stored. I know it can be done because I have managed to enter the
symb
nitin das nk writes:
> Operating system that i am using is Linux version 6.0.
There is no such thing as linux 6.0. The latest version
of the kernel is something like 2.4.10 (give or take...)
You're probably referring to the version of whatever
distribution you're using, but not knowing the vers
hi,
I tried to install MySql-3.22.32 on my computer.
Operating system that i am using is Linux version 6.0.
The installation was done from a CD ,got free with the book
"MySql/PHP Database Applications" .
I had given the commands for the installtion ,in same manner as listed below
1
Hi!
I run now mysql 3.23.42
If I run mysqld without --skip-innodb
Then query "delete from a;" run so slow (but the table is MYISAM!!!)
Why? Is it a bug or no?
> check the command line option -d (or --no-data)
>
> > -Original Message-
> > From: Barry McClure [mailto:[EMAIL PROTECTED]]
> >
Thanks for all the replies. They have all helped me solve the actual
problem, which was fairly obvious once you know it, as always.
I was starting the mysql server from a prompt as user mysql, not root. Only
root has the privileges to up the open file limit of a bash session.
This explained the
Hi
Accidently we installed MySQL twice on FreeBSD. It looks messed up.
What steps do I have to take to de-install so everything is gone (no data in
use yet), in order to do a new install?
Regards Wiebe van der Worp
--
Ben jij cool online? Mag jij buiten spelen?
Online markten -- Mensen van de A
100 matches
Mail list logo
