Dear support
I am trying to write data in the database in ISO-8859-7 character set.
My Questions are:
1) How do I configure MySQL to support this character set?
2) I am using PHP to get these infornation from the database. Do I have to
do something in my code to read teh data?
Thenks a lot
Geo
>Description:
Compile MySql with BDB installed as a system package with no build
directory. MySql configure and compile insist on building the included
BDB which is not wanted as the system BDB package contains a more
recent version of Berkeley DB. Adding BDB include and library
direct
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Date: Tue, 24 Sep 2002 12:07:14 +0200 (CEST)
From: Gabriele Carioli <[EMAIL PROTECTED]>
-- mysql, query
I wonder if you're using any RBL to avoid spam.
They're quite effective, since most of spam com
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
Cc: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 11:04:35 +0100
I thought the InnoDB doesn't support a few MyISAM features. FULLTEXT for
one.Those features it does support will not
Hey,
> 1.I have to store some images in the db. Each image size is around
800kb
> to
> 900kb(almost 1 mb). Will it affect the performance. I am using
mediumblob
> for this.
I'm not sure about this as I've never really tried, but my intuition
tells me: no, it won't affect performance (noticeably
filter;sql;query
Hello folks
Can anyone pls give some useful tips for these questions
1.I have to store some images in the db. Each image size is around 800kb to
900kb(almost 1 mb). Will it affect the performance. I am using mediumblob
for this.
2.Secondly, if I am storing for eg.
this is my_ta
So it's probably the fact that I didn't make the connection persistent
that screwed me up
sometimes I feel so stupid. hehehe
John
On Wed, 2002-09-25 at 00:34, Paul DuBois wrote:
> >hi all
> >I',m wondering if temporary tables stay around longer then the page you
> >use to create them if you crea
>hi all
>I',m wondering if temporary tables stay around longer then the page you
>use to create them if you create them with a php page. my thoughts were
>they do but mine doesn't for some reason. I've made a temporary table to
>query on a page that draws a pie chart out of the data in the tempora
hi all
I',m wondering if temporary tables stay around longer then the page you
use to create them if you create them with a php page. my thoughts were
they do but mine doesn't for some reason. I've made a temporary table to
query on a page that draws a pie chart out of the data in the temporary
ta
if you want a way to quickly experiment with sql
joins, try corereader. it's a free download from
http://www.corereader.com/
after you make a data connection, you press the load
button to load the metadata. after that, everything
is point and click to select from drop-down lists.
that ma
if your users need queries only, you might check out
corereader. it's a free download from
http:/www.corereader.com/ .
it's a point and click solution for any data source,
so the only hard part is the initial data connection.
it has built-in security to prevent updates, so if
your people n
I know it is a bad problem description, but that's all I can tell right
now -- 3.23.52 sometimes goes into deadlock under heavy load.
Heavy load means approximately 400 queries/second, for extended periods
of time. This is a web application backend.
There is nothing special about the database, e
The subject pretty much says it all... is there a limit to the number of
datafiles you can specify with the innodb_data_file_path parameter, and
if so, what is it?
I looked through the docs, didn't find anything, but with my boss
looking over my shoulder I may have missed it. ;)
(filterbait
At 12:23 +0200 9/24/02, Harald Fuchs wrote:
>In article <[EMAIL PROTECTED]>,
>Daniel Kiss <[EMAIL PROTECTED]> writes:
>
>>> Question is, will this
>>> require any SQL code changes to our application? We make heavy use of
>>> features like temporary tables, autoincrement columns etc. Would if be
At 1:58 + 9/25/02, Jessica Thomale wrote:
>On Wednesday, Sep 25, 2002, at 01:00 Etc/GMT, Paul DuBois wrote:
>
>>At 0:39 + 9/25/02, Jessica Thomale wrote:
>>>Hi,
>>>
>>>Is it possible to use InnoDB tables that have transaction support
>>>without using InnoDB for server logs?
>>
>>The InnoDB
On Wednesday, Sep 25, 2002, at 01:00 Etc/GMT, Paul DuBois wrote:
> At 0:39 + 9/25/02, Jessica Thomale wrote:
>> Hi,
>>
>> Is it possible to use InnoDB tables that have transaction support
>> without using InnoDB for server logs?
>
> The InnoDB handler maintains its own logs, and it uses thes
"Peter Goggin" <[EMAIL PROTECTED]> writes:
> I have installed all of the RPMs for MYSql from the 7.3 distribution from
> the Next handbooks, but now need to get mysql started.
> As far as I can tell the manual only talks about binary (not RPM) and
> sourceinstallations. Is there a set of instruct
Hi David, Adam,
On Wed, 2002-09-25 at 10:37, David Lloyd wrote:
> > Obviously MySQL would have advantages if I intended to use it as a server
> > database with concurrent users. But is it faster than Access in the
> > single-user environment, when dealing with large databases?
I'd think so, yes.
Looks to me like your mysql_connect or the command php uses to
Make a connection to the database has incorrect values.
The database is there but php can not connect to it
-
Chris Kay
Techex Communications
Website: www.techex.com.au Email:
That really depends on what you're doing. I use a Windows front-end to
MySQL (ursql from http://www.urbanresearch.com/ursql) every day all day to
get at several databases. It's not MS Access, but urSQL allows me to use
the same interface to query data on my MySQL database and my MSSQL
database a
Sounds like you have a script an generally you run "mysql < script.sql"
and the database and tables get created.
Make sure that the script creates your database and tables.
Nestor :-)
-Original Message-
From: lin ad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 5:56 PM
To
On Fri, Sep 20, 2002 at 01:12:48PM +0600, Asaf Maruf Ali wrote:
> Hello Everyone
>
> I have been using MySQL on Linux for over two years and am a devoted fan. I
> have been using MySQL for very ordinary applications till now.
>
>
> Now there may be a requirement that we need to build an enterpr
At 0:39 + 9/25/02, Jessica Thomale wrote:
>Hi,
>
>Is it possible to use InnoDB tables that have transaction support
>without using InnoDB for server logs?
The InnoDB handler maintains its own logs, and it uses these for
transaction support and crash recovery. You can't turn them off.
Howeve
first, when i installed rh 7.3 i chose mysql and php
and apache, i have tested apache and php independently
and they work fine. next i can login into mysql with
mysql -utest fine,
basically, i have the mysql server running but never
had a database. now i have a database but i don't know
where t
On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote:
> Joseph,
>
> Thanks for the quick answer.
>
> Very nice to know that adding an index forces a rebuild of all indices!
> (Side note -- I was going to configure the database with a minimal set
> of indices, and then watch to see
On Tue, Sep 24, 2002 at 10:36:31AM +0200, David Bordas wrote:
> > DB>I still have performance problem with my big MyISAM table.
> > DB>In fact, mysql keep locking my table, even for doing select :(
>
> PDB> That's how MyISAM works -- it uses table locks for everything.
> PDB> Given that fact, if
Hi,
Is it possible to use InnoDB tables that have transaction support
without using InnoDB for server logs?
What are the benefits of using InnoDB for MySQL server logs?
Jessica
Jessica Thomale
Infrastructure Programmer
Oklahoma Climatolo
On Tue, Sep 24, 2002 at 05:08:30PM +0200, José Fernández wrote:
>
> Do you know if is a frequent problem that the mysql database damages
> suddenly?
It is not.
> Have you experience with this type of problems?
Never. Even running alpha MySQL code I don't see anything that nasty
happening.
Jer
Adam,
> Obviously MySQL would have advantages if I intended to use it as a server
> database with concurrent users. But is it faster than Access in the
> single-user environment, when dealing with large databases?
MySQL in a single user environment is a pain in the arse because of its
lack of a
Hi, Lars,
Thanks. I have cracked down this problem.
It is very easy in C/C++, as follows:
int main(...)
{
max_allowed_packet = 1024 * 1024 * 32; /* 32M communication buffer needed */
.
}
Lin Kui
-邮件原件-
发件人: lars [mailto:lars] 代表 Lars Heidieker
发送时间: 2002年9月24日 22:47
收件人:
> Hi all,
>
> I am writing an application that requires my application to possibly
> update the length of a char field while data is being imported into the
> db. First, can I update the size/type of a column using UPDATE? Would
> someone be willing to give me an example?
You will want to lo
Ah, yes you are correct. Thank you for pointing me in the right direction.
I will endevour to prevent my ID10T errors from showing up here in the
future. Thank you again.
- Original Message -
From: "Brian Reichert" <[EMAIL PROTECTED]>
To: "Shaun Bramley" <[EMAIL PROTECTED]>
Cc: <[EMAIL
On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote:
> Hi all,
>
> I am writing an application that requires my application to possibly update
> the length of a char field while data is being imported into the db. First,
> can I update the size/type of a column using UPDATE? Would so
On Tue, Sep 24, 2002 at 10:41:26PM +0100, Adam Parker wrote:
> I currently use MS Access as a single-user desktop database. The database is
> getting quite large. The largest table has 300,000 rows.
>
> I am considering upgrading the database. How suitable is MySQL as a
> single-user desktop data
Hi all,
I am writing an application that requires my application to possibly update
the length of a char field while data is being imported into the db. First,
can I update the size/type of a column using UPDATE? Would someone be
willing to give me an example?
thank you
Shaun
filter: mysql
I currently use MS Access as a single-user desktop database. The database is
getting quite large. The largest table has 300,000 rows.
I am considering upgrading the database. How suitable is MySQL as a
single-user desktop database? How does it compare to Access when it is used
like this?
Obvious
Dear List,
One of our MySQL db's containing BDB tables is exhibiting a strange
behavior.
A query consisting of an ORDER BY clause is returning wrong result set.
The
same query when used without an ORDER BY clause returns the correct
result
set.
Environment: Sun Solaris 2.7, MySQL 3.23.51, Table
Hi all,
I'm new to the list. I looked a bit through the archives and couldn't
find an answer to my problem that addressed it in a way that helped me,
so I'm going to phrase it here.
I'm working on a PHP script that will take input and create several
table rows in mySQL based on this input.
B
Hi Everyone,
I don't know if it makes a difference to anyone, but mysql client
libraries are no longer LGPL. see
http://www.mysql.com/doc/en/Copyright.html. (original licenses can be
found in old source tar files documentation). I think this means, if
you have an application that uses mysql as
At 15:26 -0500 9/24/02, Michael Boudreau wrote:
>I am getting odd (to me) behavior from fetchrow and wonder if
>anybody else is aware of this problem. Apologies in advance if I've
>overlooked something really obvious, or if this is a long-squashed
>bug and I just need to update our Perl modules
I have installed Mysql and php on my rh 7.3 while
installing o/s. I have tested php server and is
working. I have been sent a database to use
(file.sql) but am having difficulties figuring out
where to put this file. When I try to connect to
127.0.0.1 get error " unable to connect to database. I
If i need to create / drop indexes from MyISAM tables how does the blocking
work?
I need to mess with some indexes on a production database, and dont want
downtime.
Should i do this in the middle of the night, when hardly anyone is using the
system, or will the blocking be negligable?
thanks
sea
I am getting odd (to me) behavior from fetchrow and wonder if anybody else
is aware of this problem. Apologies in advance if I've overlooked something
really obvious, or if this is a long-squashed bug and I just need to update
our Perl modules.
Using Perl 5.6.0, DBI 1.14, DBD::mysql 2.0414, an
> Is this an error in Mysql?
> I do the follwing command from a shell
>"grant insert on mydb.* to username@localhost identified by user
> 'pwd';"
> When I check the permissions the insert_priv field on user table of mysql
db
> is set to 'N'.
>
> Why is that? I can change the privileges by
stat-box201
-*message began on php mailing list...no answer. Forwarding to mysql list
13:55-9-24
I'm running apache-1.3.23-14 on a redhat 7.3 system.
I have installed the php-rpm and the php_mysql.rpm from Redhat.
installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4.
Cannot connect to my mysql-3.
Hi Gurus,
I'm relatively new to MySQL - been studying it for the past 2 months. So
far, so good (or Great).
I recently moved from MySQL 3.23.22 to 4.0.2-alpha-debug-log on our
4.6.1-RELEASE-p10 FreeBSD server. Using the mysql client, I noticed an
annoying message immediately after every query
Nestor:
You might not have entered the SQL > FLUSH PRIVILEGES;
command after you changed the password. Without it, the old
data can remain in effect.
Cheers,
Kent Hoover
-
Before posting, please check:
http://www.mysql.com
Hi everybody. I just joined since
[EMAIL PROTECTED] had the
closest hits for my question via google
(entries from Oct. 2000). That list seems
to no longer exist and this seems to be the
most specific applicable list.
My problem:
I get the following MySQL error using Perl DBI.
Error:
Duplic
> After I do make
> I get an error:
>
>
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHA
>
REDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./..
> /include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c
> libmysql.c -fPIC -DPIC -o .libs/libmysql
Oops! Quite right -- ON is necessary after the word JOIN. That was written
in the email compiler :-) Sorry I should have proofread it before hitting
Send.
Arthur
- Original Message -
From: "Josh Trutwin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 24, 2002 12:46
Independent table permissions are stored in the 'db' table. Base user permissions are
stored in the 'user' table.
> -Original Message-
> From: Nestor Florez [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 24, 2002 12:52 PM
> To: [EMAIL PROTECTED]
> Subject: granting does not give t
After I do make
I get an error:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHA
REDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./..
/include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c
libmysql.c -fPIC -DPIC -o .libs/libmysql.lo
libmysql.
> Is this an error in Mysql?
> I do the follwing command from a shell
>"grant insert on mydb.* to username@localhost identified by user
> 'pwd';"
> When I check the permissions the insert_priv field on user table of
> mysql db is set to 'N'.
This always gave me a lot of confusion at firs
At 9:52 -0700 9/24/02, Nestor Florez wrote:
>Is this an error in Mysql?
>I do the follwing command from a shell
>"grant insert on mydb.* to username@localhost identified by user
>'pwd';"
>When I check the permissions the insert_priv field on user table of mysql db
>is set to 'N'.
>
>Why is
At 16:53 -0700 9/24/02, Tom Emerson wrote:
>Being new to MySQL, it took a while to grok how "security" works. Now that
>I have a bit of a better understanding, a mental "revalation" is coming to
>the surface of my mind: since "mysql" users are NOT unix/windows-domain
>"users", is the "root" user
I dont know what exactly happened but suddenly one tables just went back 10 days.. it
only has 10 days back information.. please help me.. what happened with mysql ?? how
can i retrieve those information...
thanks a million..
SOSS
---
This e
On 24 Sep 2002, at 16:23, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
> For example I would like to select the
> password and then the first 6 characters of the
> username in the username field (which is of type
> varchar).
Check the string functions in the documentation:
http://www.m
I have a db and a user with a pwd is allowed to access it.
If my user and pwd is incorrect my php scripts can not
access the db, which is what I expect.
I colleague of mine just went into Mysql db using OBDC connection
using microsoft Data source tool(I do not know much about microsoft)
and he w
Being new to MySQL, it took a while to grok how "security" works. Now that
I have a bit of a better understanding, a mental "revalation" is coming to
the surface of my mind: since "mysql" users are NOT unix/windows-domain
"users", is the "root" user truly needed for a functional mysql environment
Is this an error in Mysql?
I do the follwing command from a shell
"grant insert on mydb.* to username@localhost identified by user
'pwd';"
When I check the permissions the insert_priv field on user table of mysql db
is set to 'N'.
Why is that? I can change the privileges by giving an upda
>>> AW> Have been trying to connect to a remote MySQL server from Matlab through
>>> an
>>> AW> ODBC connection, however the error is receive is
>>>
>>> AW> [TCX][MyODBC]Can't connect to MySQL server on
>>> AW> '' (10060)
>>>
>>> AW> I have searched the docs and archives and google... But can't
> SELECT *
> FROM Projects
> INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid
> INNER JOIN Keywords KeywordLink.Kid = Keywords.Id
> WHERE Keyword LIKE '%historical%' AND
> Keyword like '%scenic%';
Out of curiousity, does the order matter?
I have a JOIN with about 6 tables, some are very s
At 07:59 AM 9/24/2002, you wrote:
>The developer in my software house put this message...
>
>
>
>Hi,
>
>I had been using mySql for a long time in lots of different
>computers, but now I had a strange problem and I would like to know
>if anyone can send me a message to help me solving
Hello all, is it possible to select only a certain
number of characters from a field when running a query
in MySQL? For example I would like to select the
password and then the first 6 characters of the
username in the username field (which is of type
varchar). Thanks in advance!
---
Adding a new discovery to this topic:
The replication error only occurs on one of the 2 slave servers. There
is no difference between the two in configuration. Hardware-wise, there
is only one difference: the server which has the problem has 1 gig of
RAM, and the one that does not experience the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
| I would like to use MySQL in a production environment
| (now I am using it in a development environment). Do
| you know if is a frequent problem that the mysql
| database damages suddenly? Have you experience with
| this type of problems?
I've
Greetings,
I am currently working on a table that has a column called state and a
column called stateid. All 42,000 records in this table have a 2 Letter
abbreviation for that state (NY, CA, NV, etc) however. To eliminate
redundancy, I have move the states to another table that contains an
AU
since your are already using Perl, check out DBI at www.cpan.org
- hcir
On Monday, Sep 23, 2002, at 17:52 America/Anchorage, William Martell
wrote:
> Hello All,
>
> I am building a web robot in perl that will find equipment from various
> manufacturers and will get information about that equip
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi SanTa,
I think i may have an idea, have just tested this on my server. Granting
'USAGE' on all databases allows my 'testuser' account to connect to the
server through the mysql cli.
HOWEVER, if i try and issue a 'USE {database}' c
On 24 Sep 2002 at 9:16, Tobias Eriksson wrote:
> Hi
> How do I file a bug for mysql for Windows NT/2000/XP.
>
> Problem:
> Can not handle spaces in paths for the arguments given on the
> commandline to the mysqld-nt command.
> e.g. mysqld-nt --datadir=c:\Program Files\mysql\data
>
SELECT *
FROM Projects
INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid
INNER JOIN Keywords KeywordLink.Kid = Keywords.Id
WHERE Keyword LIKE '%historical%' AND
Keyword like '%scenic%';
1. Note the single quotes.
2. You can place the join logic in the WHERE clause but I prefer the clarity
o
Teh,
Tuesday, September 24, 2002, 8:31:54 AM, you wrote:
TCP> Does anyone has any idea to improve this situation?
TCP> When I show my processlist, there is inner join query that having "Copying
TCP> to tmp Table" state, and it takes quite long time to finish the query. Any
TCP> idea to avoid Copy
David,
Monday, September 23, 2002, 6:03:58 PM, you wrote:
DP> We are having a problem which seems to have appeared recently with
DP> replication on our mysql servers.
DP> - We have 3 servers set up with mysql 3.23.52 (they were running .49 but
DP> we upgraded in an attempt to fix this problem,
William,
Tuesday, September 24, 2002, 4:52:54 AM, you wrote:
WM> I am building a web robot in perl that will find equipment from various
WM> manufacturers and will get information about that equipments specifications.
WM> Can you build tables in MySQL 4.0 dynamically with some type of script.
W
Adam,
Tuesday, September 24, 2002, 2:57:04 PM, you wrote:
>> Subject: re: Connecting to remote database using MyODBC
>> From: Egor Egorov
>> Date: Fri, 20 Sep 2002 16:33:01 +0300
>>
>> Adam,
>> Thursday, September 19, 2002, 8:33:17 PM, you wrote:
>>
>> AW> Have been trying to connect to a remot
William,
Tuesday, September 24, 2002, 4:48:51 AM, you wrote:
WM> Can anyone tell me if I can make dynamic links between tables. Example.
WM> std_price in main_table = std_price in table2.
WM> So that if I change the price in the main table, It will be reflected
WM> throughout the database.
For
Fifield,
Tuesday, September 24, 2002, 5:48:47 PM, you wrote:
FM> I need a way to tell if a column value is set, I don't care if it is text or
FM> a number I just need a way to tell if there is a value set. Is there a way
FM> to do this?
If column can contain NULL values, you can do it with IS N
José,
Tuesday, September 24, 2002, 4:29:05 PM, you wrote:
JF> I think that in Windows NT the privilege tables are
JF> built during installation
Correct.
JF> I think that I have not
JF> changed anythink. How can I find if there are problems
JF> to MySQL see the privilege tables?
Check if files
DANIEL,
Monday, September 23, 2002, 10:43:15 PM, you wrote:
DG> I downloaded MySQL 4.0.3beta on my XP system. I didn't find
DG> mysql_fix_privilege_tables after installing. Am I suppose to pull it
DG> from the unix download and do by hand?
There is no mysql_fix_privilege_tables script in Win di
Eric,
Monday, September 23, 2002, 6:55:57 PM, you wrote:
EL> Well what if you have a user that you want to give permission to from any
EL> computer in the domain.
EL> Such as user: mysqluser with READ|SELECT|UPDATE from anywhere
EL> in: mydomain.com
EL> But not from any other domain.
Did
Hi,
I am trying to get mySQL set up and am having problems. I am using Win2000.
I am using the Apache server and believe I have that set up properly as the
server is in the running state. When I type "mysql" in the DOS prompt, the
following error is returned:
Can't connect to mySQL server on 'lo
Recently I have had some problems to start mysqld and
finally I have found that this was due to the mysql
database has disappear from the hard disk. I have
solved this problem, but I do not remember to delete
this database. Now, I have a question and I would like
that experimented MySQL users help
if you run more than one binary it will NOT use the same
physical memory, even if it is the same binary.
every programm you run uses its own memory for most parts.
Thomas
sql, query
On Tue, 24 Sep 2002 16:35:21 +0200 Magnus Sundberg <[EMAIL PROTECTED]> wrote:
> > Dear sirs,
> > I have a smal
>Description:
Running a specific query makes the mysqld goeing away...
>How-To-Repeat:
Under the following URL you find a partial mysqldump to repeat the error:
http://1net.ch/mysqlerr/err.sql
>Fix:
>Submitter-Id: Jene
>Originator:Jene Novakovic
>Organization
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 10:43 AM
To: Fifield, Mike
Subject: Re: Value
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must inc
>I'm experiencing very strange innodb behavior.
>
> What version of mysqld?
>
About test system. FreeBSD 4.2, MySQL 3.23.49, my.cnf innodb settings:
===
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = ibdata1:2M
innodb_data_home_dir = /db/m
[EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the entire text
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Perez wrote:
| Can I use MySQL to store pictures as part of a record?
| Should I just try to store the name of the picture?
Yep but it depends on the size of the pictures. We produce certificates
here and we hold images of engineer signatures
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
filter: mysql sql query
Hi!
|I installed mySql 3.23.49 on a Dell PowerEdge 2400 with 1Gb RAM,
|dual processor, RAID 3 and Windows 2000 Server. Unfortunately, the
|machine was freezing every day, and some times twice a day. Some
|tim
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "gbu" <[EMAIL PROTECTED]>
I'm experiencing very strange innodb behavior.
What version of mysqld?
-
Before posting, please check:
ht
> +1
>
> For medical imaging, at least in radiology (PACS), you usually see the
> terabytes of images being stored on a NAS somewhere, and the database
> itself is actually pretty small just pointing to filenames of where the
> pictures are located. This keeps the database small and fast, and le
Hello All,
I am building a web robot in perl that will find equipment from various
manufacturers and will get information about that equipments specifications.
Can you build tables in MySQL 4.0 dynamically with some type of script.
Example. If if have 10 parts in my database and my robot check
Hello All,
Can anyone tell me if I can make dynamic links between tables. Example.
std_price in main_table = std_price in table2.
So that if I change the price in the main table, It will be reflected
throughout the database.
Thank you in advance for your help.
William
(Filter: MySQL, SQL, Que
Hi, all,
when I use mysql_fetch_row(myRes) and there is a very large field (~30M
long),
my program crashed. How can I solve the problem?
For less than 5M long string/text, it works well. thanks.
My machine is Linux 7.3 & MySQL is 4.0.3-beta.
Best regards.
~~
Lin Kui
College of Life Scie
Dear all
I had a source file which containing rate figures, what i want to do is to
insert these rate to a specific field of an existing table using "Load Data
Infile" query!
here is the example
existing table data:
ABC
01AUD#rate
02HKD#rate
03JPY#rate
04
> Can I use MySQL to store pictures as part of a record?
You CAN.
> Should I just try to store the name of the picture?
Yes. If you have FTP Access or similiar, I would prefere this!
Some remarks from the manual :
-- Insert a File located locally on MySQL-Serverinto a blob-column
INSERT INTO m
+1
For medical imaging, at least in radiology (PACS), you usually see the
terabytes of images being stored on a NAS somewhere, and the database
itself is actually pretty small just pointing to filenames of where the
pictures are located. This keeps the database small and fast, and lets
you a
Please, can you give me more information about this?
I think that in Windows NT the privilege tables are
built during installation I think that I have not
changed anythink. How can I find if there are problems
to MySQL see the privilege tables?
Many Thanks.
José
--- Egor Egorov <[EMAIL PROTE
Files never get smaller. They can only grow.
Deleteing a record marks the area used as available, but does not remove it
from the file.
I believe you will have to optimize the table to pack out the unused
records.
This is another good argument for storing images in the filesystem, and
only thei
Hi all,
I seem to be running into a stability problem with our current mySQL
server. I'm at a loss as to where to begin looking. We first noticed a
problem with large files being created in the /tmp directory. That
hasn't happened since, but yesterday the server bogged down twice.
The
1 - 100 of 128 matches
Mail list logo
