Shane,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, August 03, 2002 2:21 AM
Subject: Re: Crashing under high load
> On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote:
> >
> > The gentleman on PHPBuilder
(htt
On Saturday, 3. August 2002 06:44, Lord Loh wrote:
Hi,
> I have a database of mysql with 3 million records. No query is
> performed in
> less than 10 seconds!(With Index and all that)
Some more information like your table structure, indexes and a sample query
and an explain could help to give
Hello everybody!
I am new to mysql and am totally confused as how to proceed? Is it installed
automatically like perl or do I have to install and configure? in the docs
its often referred as "shell> mysql" but when I type it on c: prompt it says
access denied. can anybody help?
Thanks
Abdul Shei
I'm new to the list trying to run Php & Mysql on the Apache server
built-in Mac OSX.
I'm running with the following error :
[localhost:/usr/local/mysql] pierreva% mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
[localhost:/usr/local/mysql] pierreva%
Can
Hi Aaron,
| Is there anyway to take my outlook contacts from the .pst
| file and put thme into a mysql database so I can view
| them on the net?
Among the various ways you could approach this:
1. Use CDO from MS to read records from Outlook and output them into a
MySQL database
I have a database of mysql with 3 million records. No query is
performed in
less than 10 seconds!(With Index and all that)
Any way to speed this up ?
How on earth does US Social Security dept. maintain so many
records ?
Google has 1 billion pages and qurys in a few milliseconds...
I am not sa
Is there anyway to take my outlook contacts from the .pst file and put
thme into a mysql database so I can view them on the net?
---
Aaron Axelsen
AIM: AAAK2
Email: [EMAIL PROTECTED]
URL: www.amadmax.com
"It said, ""Insert disk #3,"" but only two will fit!"
"One picture is worth 128K words."
You need the mysql daemon running before you can connect to it. To me it
looks like need to start the daemon as a user with the right permissions
and then connect to it.
Is mysql configured at all on your box? If you haven't read the docs--you
probably should.
-mj
On Fri, 2 Aug 2002, Bill Leona
SELECT * from hwu_articles WHERE id = '$id' and price is not null and name
is not null and ratings is not null;
Bhavin.
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 4:49 PM
Subject: help with a simple query..
Here's the console report... Anyone have any idea what might be the cause? I
checked and the .sock file exists, and of course there is no mysqld service
running (because it can't start!)
Any pointers would be greatly appreciated...!
2002-08-02 21:02:55.755 MySQLInfoTool[1464] attempting to star
Hi Guys,
I'm still new to this and I'm trying to get back into and I need help with a
simple query. I have a list of info about a product for an article on my
website and I'm pulling all this info from a mysql db and displaying it
byway of php but don't know how to do the query. Right now I have
Hi Guys,
I'm still new to this and I'm trying to get back into and I need help with a
simple query. I have a list of info about a product for an article on my
website and I'm pulling all this info from a mysql db and displaying it
byway of php but don't know how to do the query. Right now I have
Hi all,
Is there a way to setup 2 linux servers with only mysql for an redundant
solution ?
All mysql data is being realtime copied from the master to the slave.
If the master fails with any reason what ever, the slave takes it over.
If the master is back, the slave first updates the data and th
Hi There;
I have some template tables in my SQL database that I was hoping to copy to
make
the production tables, but I have noticed that the constraints do not copy
when I create the production table using a select statement. Dows anyone
know of a way to copy the table and have the constraints c
I've written a C program which inserts new entries into a table
with an auto_incremented column. In testing it I created several entries,
which I then deleted by connecting to mysql from the unix command line.
The problem is, when I reset the last_insert_id from the mysql prompt, it
doe
To Whom It May Concern:
Environment:
Operating System Windows XP Home Edition
Using MySQL 3.23
Using Apache 1.3.12
Initially it started working suddenly after trying all of the commands
below... : )
The next day I started the computer and it does not work : (
Tried to intall from the C:
Thanks Jeremy :)
>From: Jeremy Zawodny <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Desmond Lee <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: exporting data
>Date: Fri, 2 Aug 2002 15:59:01 -0700
>
>On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
> > Hi guys
> >
>
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote:
>
> The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3)
>(again, I acknowledge this is an old article) says flat out that MySQL tends to die
>under high load. Also, when I say high load, I am talking 15-30
Do you mean like 'mysqldump'? You can use mysqldump to dump tables +/-
data and then upload it to a database later--or 'import' it, e.g.,
mysqldump -u
all the tables from that database.
mysqldump takes a variety of arguments. see 'man mysqldump' for more
info.
-mj
Desmond Lee wrote:
>
To Whom It May Concern:
Environment:
Operating System Windows XP Home Edition
Using MySQL 3.23
Using Apache 1.3.12
Initially it started working suddenly after trying all of the commands
below... : )
The next day I started the computer and it does not work : (
Tried to intall from the C:\
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
> Hi guys
>
> I know that you can import data into a table by using 'load data infile' or
> 'mysql' import.
>
> however, is there something that allows you to export the create statemtns
> for the table schema and the data of a data
Hi guys
I know that you can import data into a table by using 'load data infile' or
'mysql' import.
however, is there something that allows you to export the create statemtns
for the table schema and the data of a database for backup. SO that if we
reinstall the whole thing from scratch all
> Well, most programs, in my experience, will keep running, even if load
> is 200, they just run slowly since they aren't getting processor load.
How's the memory? Typically things (especially Mysql) croak if they
bonk on memory - if you're into the swap on high load, you're screwed.
--
--
On Fri, Aug 02, 2002 at 10:59:18PM +0200, Georg Richter wrote:
> On Friday, 2. August 2002 20:48, Shane Allen wrote:
> > I digress... at this point, the question that plagues me is: Is it normal
> > for MySQL to die under high load?
>
> you have a lot of programs, which prefer to die under heavy
Brent
> Don't know if that's what you are trying to do. But I can't think of any
> reason to permanently replicate a table in the same database.
Maybe the other person is duplicating the data to do test stuff to it...
mysql,query
[I hope the spam thing lets this through]
DSL
--
We are not
I should clarify that you could have a cluster of MySQL servers using our
replication. However for clustering you should consider the following:
Maybe the most powerful project in this area is Beowulf (not Linux only)
http://www.beowulf.org, but there are many such projects like:
Cplant http://ww
Replication, however, is no good for scaling update load. What happens when
you're update load is too much for the box? Are you just meant to buy a
bigger box? What happens if you already have the biggest box and the update
load is too high? Is there no way to scale the update load wide in MySQL?
Since CHECK cannot be used in CREATE TABLE in any way, shape or form, remove
it from the documentation for CREATE TABLE.
Lary Irwin
CCA Medical
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (th
On Friday, 2. August 2002 20:48, Shane Allen wrote:
Hi,
> I digress... at this point, the question that plagues me is: Is it normal
> for MySQL to die under high load?
you have a lot of programs, which prefer to die under heavy load. The main
question is not why they die, the question is why is
You could set up a clustering configuration using our replication. Just
take a look at the replication section of our online docs:
http://www.mysql.com/documentation/index.html
Kerry
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 01
hello,
i've faced very long execution of a query.
query is based on 2 temporary tables, because contains subselects,
unsupported by mysql.
problem: i try to get the good's statuses in my warehouse, by analyzing
all orders made for these goods.
tables are as following:
At 14:53 -0400 8/2/02, Mihail Manolov wrote:
>Thanks Paul,
>
>I am confused with these two variables in the server status:
>
>Connections: 114577
>Threads_created: 12759
>
>Could you explain the difference between these two variables?
Threads get reused. When you disconnect, the thread that the
On Fri, Aug 02, 2002 at 02:53:38PM -0400, Mihail Manolov wrote:
> Thanks Paul,
>
> I am confused with these two variables in the server status:
>
> Connections: 114577
> Threads_created: 12759
>
> Could you explain the difference between these two variables?
Thread caching. MySQL doesn't alwa
> MySQL really wasn't designed for this sort of useage. Your selects are going
> to be brute force searches on unidexed data, which is exactly why they are so
> slow...
>
> I would advise you to look into using an XML or XML Enabled RDBMS. There are
> a lot of possible considerations here as to wh
Thanks Paul,
I am confused with these two variables in the server status:
Connections: 114577
Threads_created: 12759
Could you explain the difference between these two variables?
"Connections" should be the number of connection attemplts to the MySQL
server. Does this counts slave connections?
On Friday 02 August 2002 12:47 pm, [EMAIL PROTECTED] wrote:
Lars: I think what you are trying to do is pound a square peg into a round
hole...
MySQL really wasn't designed for this sort of useage. Your selects are going
to be brute force searches on unidexed data, which is exactly why they are
I recently read an article (on PHPBuilder; it's fairly old) that spoke of MySQL dying
under high load.
Recently (since I built 3.23.51 and on my test build of 4.0.2) I have had problems
with MySQL dying (got signal 11, et al.) under extreme high load. For example, if I
set up a 60-thread spide
At 10:07 2/8/2002 -0500, Aaron Boxer wrote:
Hi,
>Dear Users,
>
> I just downloaded the "mysql-4.0.2-alpha-win.zip" file, and installed
> it on my machine. When I try to build the project in the "Embedded"
> folder, I find that "my_alloc.h" is not in the /include directory.
>
> I tried dow
Hi Florian,
If you want to connect remotely to the server, you
have to grant permission to that user. Try this:
GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'%'
IDENTIFIED BY 'thepassword';
With this command you are telling MySQL to accept
calls from any computer if the user name is 'theuser'
and t
On Wednesday 31 July 2002 01:41 pm, Richard Baskett wrote:
> Ok here is the EXPLAIN query:
OK, 1st thing this is telling you is that you aren't using any index on your
master table, Employers. Probably this just means there isn't any field in
that table that is part of the search (I can't be 10
At 13:29 -0400 8/2/02, Mihail Manolov wrote:
>Could someone explain to me what is the difference between thread and
>connection?
No difference.
>
>I guess one connection can have many threads? Am I right?
The server is multi-threaded. It associates a thread with each
connection. Connection ID
Could someone explain to me what is the difference between thread and
connection?
I guess one connection can have many threads? Am I right?
Thanks,
Mihail Manolov
sql,query
-
Before posting, please check:
http://www.my
Heyho folks,
I hope I am in the correct mailing list here.
We do have a performance problem with mySQL.
In the database we have :
INSERT INTO art_xml VALUES ('0', 'english
product nr 0 and went away, and two technicians remained
with instrument and started to\r and deutsches product
nr 0 an
I downloaded a copy of MySQL-3.23.51-1.src.rpm to my /home/steve
directory.
I executed rpm --rebuild MySQL-3.23.51-1.src.rpm
When it was finished it performed several "wrote" commands...
according to the quick installation Overview...doc at
www.mysql.com/doc/Q/u/Quick_install...para 2.
> On 2 Aug 2002, at 11:43, Luc Foisy wrote:
>
> > FROM EVENTATTENDANCE
> > LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID
> > LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID
> > LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID
> > LEFT JOIN ORGANIZATION ON CONTAC
> Luc Foisy wrote:
>
> >Since the below select query blew up on me, then I must be
> doing something wrong, perhaps it is because I am using the
> wrong type of join, dunno
> >I would like to join the same table twice, with different
> criteria as below
> >
> >Anyone got a solution to this?
>
On 2 Aug 2002, at 11:43, Luc Foisy wrote:
> FROM EVENTATTENDANCE
> LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID
> LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID
> LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID
> LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZAT
Since the below select query blew up on me, then I must be doing something wrong,
perhaps it is because I am using the wrong type of join, dunno
I would like to join the same table twice, with different criteria as below
Anyone got a solution to this?
SELECT EVENTATTENDANCE.ID,
CONCAT
> Run MySQL server from the command prompt:
> path_to_the_mysqld_max_nt> mysqld-max-nt --console
Many thanks, I have found the error : when installing MySQL I choose
MySQLd-nt and when I changed it to MySQLd-max-nt teh registry wasn't updated
(key imagepath).
Phil
From: "Andis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>,
"Victoria Reznichenko" <[EMAIL PROTECTED]>
References: <001d01c2394e$85803740$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <003601c239ea$f0f7d720$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <001001c23a13$5ba93280$[EMAIL PROTECTED]> "Victoria Rezni
Why would you want to replicate your data in the same location on the
same machine?
You can use an alias name if you need to join a table multiple times in
a select. Something like this:
select table1.column1,tableA.columnA,tableB.columnA
from table1,table2 as TableA, table2 asTableB
where tab
To reply to my own problem, my confusion stems from the change from
my_thread_init() in MySQL version 3.x to mysql_thread_init() in
version 4.x. Fair enough, but my_thread_init is still supported
in version 4.x. So, should developers who wish to write the most
portable code use my_thread_init(
On Fri, 02 Aug 2002 16:35:11 +0300
adi <[EMAIL PROTECTED]> wrote:
> How to make a table(table2) with same content of existing table(table1) in
> same database(database1) with mysql?
> tx in adv for any help
> adi
create table table2 as select * from table1;
You will have to create indexes manual
Original-Message-ID: <[EMAIL PROTECTED]>
Original-Sender: "Chai Wutiwiwatchai" <[EMAIL PROTECTED]>
Original-Subject: problem of using API in embedded server mode
Original-Date: Fri, 02 Aug 2002 20:52:45 +0700
-
Dear Users,
I just downloaded the "mysql-4.0.2-alpha-win.zip" file, and installed
it on my machine. When I try to build the project in the "Embedded"
folder, I find that "my_alloc.h" is not in the /include directory.
I tried downloading from another mirror site, but the file is still
n
I use blob columns. One thing I do though is store them in there own table
and not in a table with other data. I just link through primary key.
That way when you are not looking for an image the database does not have to
deal with it. Also it's easier for disaster recovery since you do not hav
can i test without my connection java?
the user are in the table user in mysql ? and what do you put on host?
sorry it's the first time i use mysql
At 16:04 02/08/02, you wrote:
>Hi,
>I 've tested the stated version both on Linux and Windows and have not
>encountered
>any problem of this type. I
I am able very well to connect me to the base of data on my computer
(locally) but if I want that somebody connects himself since another
computer it cannot it tries to be connected by the intermediary of an
interface java and thus by link JDBC and if we install the ihm java on the
local compu
To use MySQL API on Linux RH7.3 in embedded-server mode,
I have compiled my source by
gcc -o test test.c -L/usr/local/mysql/lib -lmysqlclient
It appeared an error message
undefined reference to 'mysql_server_init'
undefined reference to 'mysql_server_end'
The manual suggests to link libmy
Hello Jerry,
Friday, August 02, 2002, 3:48:03 PM, you wrote:
JA> Victoria,
JA> Thanks for your response. Possibly you can clarify something for me. You
JA> say that LOAD DATA LOCAL means that data file is read from client host.
JA> What exactly is the client host in this case?
Host fro
Research,
Friday, August 02, 2002, 12:11:42 PM, you wrote:
R> I'm trying to install innodb on my mysql server, i'm under windows 2000, I
R> have chosen mysqld-max-nt option and here are my ini settings :
[skip]
R> But the service doesn't start, when I delete everything concerning innodb,
R> the
How to make a table(table2) with same content of existing table(table1) in
same database(database1) with mysql?
tx in adv for any help
adi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hi,
It depends how you want to treat those images. One of
the advantages of putting the images in separate files
is that you can modified them directly.
If the images are small, I think that a blob field is
a good idea but if the images are big, can make the
database grow to much.
Hope it helps
Hi,
Could you put more detail in the description of the
problem?
Bye.
--- Florian Litot <[EMAIL PROTECTED]>
wrote:
> Hi,
> i use mysql v4.0 i have got a problem with the
> connection to database i can
> connect if i have localhost but if i want to connect
> to database i can't.
> There is a li
Hello i am kinda new to this list, and to mysql...
I am trying to link 2 tables, but there seems to be an catch i havent
for seen...
i made this table first like this:
create table kunder(KundeID int NOT NULL PRIMARY KEY auto_increment,
Fornavn varchar(25) NOT NULL,
Etternavn varchar(25) NOT NU
George Perolli wrote:
>I used the Query Designer in Access to create the following query:
>
>SELECT Docs214.BOL, Docs214Dates.Date
>FROM Docs214Dates
>INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID =
>Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID
>WHERE Docs214
I think it's good but how i can look because i begin to use mysql and i am
not very good
What i must put on 'Host'?
thanks
At 13:09 02/08/02, you wrote:
>Hello Florian,
>Friday, August 02, 2002, 1:41:51 PM, you wrote:
>
>FL> i have got access denied
>
>Check permissions for your user. Seems, you
Andis,
Friday, August 02, 2002, 1:57:12 PM, you wrote:
A> I created character-set myself. Here, in Latvia, we use windows-1257.
A> Problem is, when I use MySQL under Linux, conversation occurs better. Under
A> windows98 I have problems as I wrote before. Cheracter-set I created myself,
A> because
Florian,
Friday, August 02, 2002, 2:38:02 PM, you wrote:
FL> I think it's good but how i can look because i begin to use mysql and i am
FL> not very good
If you have permissions to the database 'mysql' you can look on the
contents of the table 'user'. If there is a corresponding entry user_name
I used the Query Designer in Access to create the following query:
SELECT Docs214.BOL, Docs214Dates.Date
FROM Docs214Dates
INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID =
Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID
WHERE Docs214Dates.Type = 1 AND Docs214Picks.
Caron,
Thursday, August 01, 2002, 7:48:40 PM, you wrote:
C> Yes, but when I create a user with any other grants, it generates
C> automatically this "grant usage on *.*":
mysql> use Liste_MP3;
C> Reading table information for completion of table and column names
C> You can turn off this feature t
Jerry,
Thursday, August 01, 2002, 7:13:04 PM, you wrote:
JA> As a newcomer to MySql, I have struggled through the install and am working
JA> my way through the tutorial.
JA> My environment:
JA> Win2000
JA> MySql version 3.23.51-nt
JA> My.ini:
JA> [mysqld]
JA> # set based
I think it's good but how i can look because i begin to use mysql and i am
not very good
At 13:09 02/08/02, you wrote:
>Hello Florian,
>Friday, August 02, 2002, 1:41:51 PM, you wrote:
>
>Please, don't send me your answer, send it to the mailing list.
>
>FL> i have got access denied
>
>Check pe
have a look at the HAVING clause:
mysql> SELECT user,MAX(salary) AS sum FROM users
->group by user HAVING sum>10;
http://www.mysql.com/doc/S/E/SELECT.html
> Okay, I thought I'd done this before but maybe not. I can't figure it
> out now.
>
> What I want to do is:
>
> SELECT column
Hello Florian,
Friday, August 02, 2002, 1:41:51 PM, you wrote:
Please, don't send me your answer, send it to the mailing list.
FL> i have got access denied
Check permissions for your user. Seems, your user has permissions to connect only from
localhost.
FL> At 12:05 02/08/02, you wrote:
>>Flo
Ben,
Friday, August 02, 2002, 12:33:35 AM, you wrote:
BT> Not sure if this is the correct list to be sending to but I am having
BT> some very frustrating problems with mysql-3.23.51 on redhat 7.2
BT> My problem is the db starts just fine using bin/safe_mysqld --user=root
BT> & although the crt s
cliff,
Thursday, August 01, 2002, 11:46:28 PM, you wrote:
>>Description:
c> The UNION clause displays results 2 times even when not using the
c> ALL keyword with it. example: (SELECT
c>
allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_
I created character-set myself. Here, in Latvia, we use windows-1257.
Problem is, when I use MySQL under Linux, conversation occurs better. Under
windows98 I have problems as I wrote before. Cheracter-set I created myself,
because included isn't correct.
Andis
- Original Message -
From
Hi,
i use mysql v4.0 i have got a problem with the connection to database i can
connect if i have localhost but if i want to connect to database i can't.
There is a limitation with mysql v4.0 or not ? have you got an idea?
thanks
---
Hi,
i use mysql v4.0 i have got a problem with the connection to database i can
connect if i have localhost but if i want to connect to database i can't.
There is a limitation with mysql v4.0 or not ? have you got an idea?
thanks
---
speters,
Friday, August 02, 2002, 3:08:44 AM, you wrote:
s> I was wondering about the Enum and Set column types in InnoDB tables.
s> I was able to create an InnoDB table with an enum column, but i
s> get errors when trying to insert values into that column.
s> I'm thinking that InnoDB doesnt sup
Florian,
Friday, August 02, 2002, 12:29:08 PM, you wrote:
FL> i use mysql v4.0 i have got a problem with the connection to database i can
FL> connect if i have localhost but if i want to connect to database i can't.
FL> There is a limitation with mysql v4.0 or not ? have you got an idea?
FL> tha
hean,
Friday, August 02, 2002, 7:44:31 AM, you wrote:
h> Description:
h> When we join two or more tables, select distinct and order by on a
h> column, we get problems.
h> How-To-Repeat:
[skip]
h> This is the problem:
h> mysql> select distinct a1.a from test as a1, test
Andis,
Friday, August 02, 2002, 9:07:54 AM, you wrote:
A> It's just a simple example, because I don't want send latvian-specific
A> symbols. This problem occurs with latvian-specific symbols only.
A> Configuration file I cheked some 4-5 times. I'm confused now.
To convert correctly from upper ca
Hi,
i use mysql v4.0 i have got a problem with the connection to database i can
connect if i have localhost but if i want to connect to database i can't.
There is a limitation with mysql v4.0 or not ? have you got an idea?
thanks
Hi,
The last paramater of LPAD must be a string :
E.g:
select LPAD(1, 8, '0')
instead of
select LPAD(1, 8, 0)
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAI
Dean,
Friday, August 02, 2002, 3:36:44 AM, you wrote:
DH> Okay, I thought I'd done this before but maybe not. I can't figure it out
DH> now.
DH> What I want to do is:
DH> SELECT column AS something FROM table WHERE something > 5
You can use aliases and HAVING clause for them:
http://www.
Bill,
Friday, August 02, 2002, 7:27:49 AM, you wrote:
BL> Newbie alert here...! Making my first attempt at changing a variable...
BL> I am trying to add this line:
BL> set-variable= safe_show_database=ON
BL> To the my.cnf file... But when I do that and then attempt to restart MySQL,
BL> it
Hello everybody,
I'm trying to install innodb on my mysql server, i'm under windows 2000, I
have chosen mysqld-max-nt option and here are my ini settings :
=
#This File was made using the WinMySQLAdmin 1.4 Tool
#19/07/2002 17:37:06
#Uncomment or Add only the keys that you kn
Have a look at
http://www.mysql.com/doc/B/L/BLOB.html
Simon
-Original Message-
From: Khanh Pham [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2002 09:59
To: [EMAIL PROTECTED]
Subject: Save Image (GIF or JPEG) file in the database ?
Hello ladies & gents,
I am new to MySQL. I wonder if
Hello ladies & gents,
I am new to MySQL. I wonder if I can save a picture in the database,
then I can load into a JSP. The perfect example is an employee page !
Thanks in advance for your helps !
/Khanh
-
Before posting, ple
> If you've got to make copies to disk then why not just maintain copies on
> disk via replication? Stop the slave, backup the slave, restart the
slave.
In my case, replication is installed to give 24/7 service even if one of
the server dies for some reason. When both master and slave are up, I
Hello.
I have a trouble.
"select LPAD(1, 8, 0);" or
"select LPAD(int_field, 8, 0) from TABLE;" produces "" result.
The function doesn't work as expected :(
As I understand from the manul it should produce the same result as:
"select CONCAT(REPEAT(0, 8 - LENGTH(ID)), ID) from TABLE;" ->
93 matches
Mail list logo
