Hi,
I want to save image files into BLOB fields?? How do i do
it?? And how to retrieve it back from database??
___
Click below to experience Sooraj R Barjatya's latest offering
'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek
& Kareena http
Jim McAtee wrote:
> David Lloyd wrote:
>
> > > What would be the ideal RAID configuration for a dedicated MySQL db
> > > server running on FreeBSD?
> > >
> > > We're also running some MySQL databases on Windows 2000 Servers. What
> > > about the best configuration for a dedicated W2k server runni
David Lloyd wrote:
> > What would be the ideal RAID configuration for a dedicated MySQL db
> > server running on FreeBSD?
> >
> > We're also running some MySQL databases on Windows 2000 Servers. What
> > about the best configuration for a dedicated W2k server running MySQL?
>
> That depends on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
> What would be the ideal RAID configuration for a dedicated MySQL db
> server running on FreeBSD?
>
> We're also running some MySQL databases on Windows 2000 Servers. What
> about the best configuration for a dedicated W2k server running MySQ
Hi Kevin,
There is a way to sop the server on OS level. However I am not sure if you
want to do it this way. You can use the kill command, but be aware that it
might damage a data file if the database is accessing it in just this moment.
Having said this warning, here is what you can do:
1) ps
Hi, Nils
I can't get the mysql server to stop! If I try "service mysqld stop" I
get a "FAILED" error. If I try mysqladmin -u root -p shutdown, I get:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
[EMAIL PROTECTED]
Post the code
Martin
- Original Message -
From: "marvc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 05, 2003 7:08 PM
Subject: RE: Possible OT: ADONewConnection Error
> I take it no one is familiar with particular error? Didn't get anything
> on google.
>
> -Ori
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of space? (maybe this is true as
well
2003年 7月 7日 月曜日 10:28、Nils Valentin さんは書きました:
> Hi Kevin,
>
> try this:
>
> 1) stop the mysql server
> 2) mysqld_safe --skip-grant-tables
> 3) mysql -u root
> 4) mysql> SHOW GRANTS FOR root;
> 5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTI
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
6) restart the server (without --skip-grant-table option) and try to login
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 5日 土
Hi Vince,
I assume you want to print to your printer from the mysql client (command
line) here is what I do:
0) set up a lp queue (line printer) and make sure it works then proceed to 1)
1a) mysql> pager /usr/bin/less
mysql> \P lp;
PAGER set to lp;
mysql> SHOW INNO
> Is there any way to seed a column set to autoincrement? Say I wanted it to
> begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: "Greg Donald" <[EMAIL PROTECTED]>
To: "wael fareed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
>
> > my cou
> my coulmn (id) is an auto_increment coulmn and lets say that i have 100
> entries, so the problem is that when i delete all entries on my table, the
> column (id) starts from 101 ,shouldn't is starts from 1 again!
> please i need help with this
Use truncate table, it will reset the auto_incemen
I am new to SQL and was wondering if there was a query that would allow
me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr,
and others, but get the syntax error. I am running MySQL on a WIndows XP
Home system. My company has asked me to transfer a clients file to forms
for pr
The IP address CAN change, but doesn't change on such a basis that it would
cause a problem. You see the issue also appears whether I am [EMAIL PROTECTED]
or [EMAIL PROTECTED] it doesn't matter where I am coming from.
Thx
- Original Message -
From: "Stephen March" <[EMAIL PROTECTED]>
To
my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so
the problem is that when i delete all entries on my table, the column (id) starts from
101 ,shouldn't is starts from 1 again!
please i need help with this
you mean the primary key (also called primary index), do you?
just query 'SHOW INDEX FROM yourtable' and read all rows with Key_name = 'PRIMARY'.
you can play around with this in the mysql commandline. you'll get all column names
that belong to the primary key in the Column_name field of the ret
I just assumed your question was for mysql data only..
If you want total I use:
OS - raid 1 (2 X 18.2gb - 10kRPM)
DATA - raid 0+1 (# X 18.2gb - 15kRPM)
usually a dataset is comprised of 6-10 disks.. you could go larger with
the drive size.. but more spindles = more thruput
Swap isn't much of
Hello,
I apologize if this is a very simple question but I have spent the last half hour
searching for an answer to it and have thus far been unable to find one. I am pretty
new to mysql so please be easy on me if this is painfully obvious :)
I am trying to determine the primary field in a tabl
I'm running this query to get a count of categories I have in a field that contains
aircraft categories.
SELECT substring(category,10), count(*)
FROM `links` where category like 'Aircraft/Sales%'
group by category order by category
and getting these results:
---
Sales/D
Another option is to have another table with the item name and number
using that as a lookup table.
IMHO it all depends on the data if the select is static (or rarely
changes) an enum would be best. If is changes a lot then I would use
another table to store it in.
-Michael
"I protect you,
I'm new, too, so someone correct me if I'm wrong, but...
if you make it an ENUM field in a table you can store it using the
value in the selection, retrieve it as the same value, and still get
all the advantages of numeric storage.
Todd
On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote:
He
Hello list,
I'm really new to mysql and databases in general. I have a select form
that contains a very long list of options, and what I want to do is
store the selected item as a number instead of the items name in order
to speed up searches. My problem comes when a search is done and I can't
figu
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP should have a grant something to the effect of:
grant all on database.* to [EMAIL PROTECTED] identified by 'password';
This would allow your client to be a
25 matches
Mail list logo
