Hello Roger;
[snip]
> * Emmanuel van der Meulen
> > I'm certain InnoDB is 100% safe. My concern is probably
> related to being
> > unfamiliar with MySQL/InnoDB. However, I take Heikki's point of
> > the access impact of DEV on PROD - never thought of that.
>
> This impact also very much appli
Dennis if you want to see if the /var/lib/mysql directory is on it's own
partition or drive look at /etc/fstab and see which /dev it is mounted on.
If you wanted to you can mount a new drive at /var/lib/mysql and have you
data on it's own drive. If you have some sort of system failure you can just
> #2 All I have read on the web/books suggests that this is what to do
> $result = mysql_query ("SELECT title, description, url, author,
> date_format(datefield, %M %D %Y') FROM documents");
>
> This just leaves out all dates.
You may want to try:
$result = mysql_query("SELECT title, descrip
Hello,
i'm new to mysql, so please bear with me...
My database has a field called datafield as datetime. I want to display just
the date
#1 this works but gives the full datetime
$result = mysql_query ("SELECT title, description, url, author, datefield
FROM documents");
#2 All I have read on
This works for me...
var connectionString = "Provider=MySqlProv;
Integrated Security='';
Password=1234abcd;
User ID=root;
Location=localhost;
Extended Properties='';
Data Source=test"
Mattias Persson wrote:
> Anyone know how to write a connectionstring for the OleDB in ASP. I get all
> differe
Try IFNULL
HTH
Dan Crawford
Integrated Network Strategies
-Original Message-
From: SankaraNarayanan Mahadevan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 30, 2001 9:52 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Null Value In a Column
Hi,
I want to select record fro
>From page 165 MySQL (New Riders):
LEFT JOIN:
SELECT t1.* FROM t1 LEFT JOIN t2
ON t1.i1 = t2.i2
WHERE t2.i2 IS NULL
-- david
> Ack - sorry - can someone remind me the SQL format for this?
>
> if you have a linked CLIENTS and INVOICES table...
>
> ...what's the query to find CLIENTS with NO
Hi,
I want to select record from a table that return empty
string or something else that i want, if a column
contains null value.
can we do that in a select statement.
I tried IsNUll function but it return wither 1 or 0.
In MS SQL Server u got a function IsNULL that accepts
2 parameter - first
Ack - sorry - can someone remind me the SQL format for this?
if you have a linked CLIENTS and INVOICES table...
...what's the query to find CLIENTS with NO INVOICES?
(say 'clientid' is the name of the field in both clients and invoices table)
I think it's some kind of join=NULL but I'm stuck.
I am using the 'C' API and would like to be able to be able to get
information on columns involved in a SELECT statement without executing the
statement. I am also using placeholders.
An example of what I would like to get info on (but not execute) is:
SELECT col1 from table1 where col2
* Emmanuel van der Meulen
> I'm certain InnoDB is 100% safe. My concern is probably related to being
> unfamiliar with MySQL/InnoDB. However, I take Heikki's point of
> the access impact of DEV on PROD - never thought of that.
This impact also very much applies to the cpu... I would highly reco
Hello Heikki,
Note, this is a duplicate posting - erroneously posted against 'General
database questions'.
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as
Hello Roger,
[snip]
> Yes, but is there really a big difference as long as the data is
> on the same
> disk & computer? I would keep PROD on a separate physical
> machine...
Yes, either on a separate physical machine or a different HDD (to curtail
costs, I'd first go for HDD).
> If the
> databa
Hello Heikki,
Thank you very much for this note and your valued assistance.
I have the different instances of MySQL running with your proposal to add
the lot to
a bat file.
And yes, if such a option as you propose exists, others would possibly get
multiple instances / my.cnf files working more
Robert,
Thanks again...
I think I am on the right track, maybe. I am trying to use the symlink
method you suggested.
Below is the command I used to create a symlink named 'amgr' in
/var/lib/mysql/ pointing to the real data directory of 'amgr' in
/home/mysql/amgr/. The database 'amgr' shows up
I have the ID column auto_incrementing and I don't want to change that.
Newbie that I am, I tried to add auto_increment to another column and
failed.
Is there any way to have a field other than the ID field increment by a
set value?
create table test (
ID mediumint(9) NOT NULL auto_i
* Oliver Heinisch
> Is there a way to supress headers and to get the datafields
> without spaces?
> (in one result there has been a TAB (0x09) between the fields).
> I just want data_field_1 (0x20) data_field_2 (\n).
You can use the --skip-column-names parameter when calling the mysql client
to a
* Curtis Gordon
> I need to create a database that is accessable by everybody but i
> can't find an "easy to use" example of this. I have seen many
> attempts at it, but none that say, do this and that, here is an
> example "TAH DAH!".
>
> That is what I need. I have setup a database and that was
Hi Folks,
I use a shell script, to get data from a mysql database.
I use the following call
mysql -ddatabase -uusername -ppassword <
file_with_sql_select >file_to_get_output
I even tried mysql -e select foo from database -uusername
-ppassword >file_to_get_output
but I always get as first line th
In the last episode (Dec 31), David Robinson (AU) said:
> Does MYSQL currently support, or has it ever supported the old
> Berkeley database version 1.8?
No. The whole reason the BDB table type exists is to support
transactions, and BDB 1.8 doesn't. If you want the BDB table type,
you'll have t
At 14:37 -0600 2001/12/30, DWilliams wrote:
>Robert,
>
>Thanks for the tips...
>
>>>1. create a symlink at /var/lib/mysql that points to your data directory<<
>
>I had read that this was not the best way prior to v4.0, something about an
>"alter table" statement might ignore the symlink?
I've use
Hi!
You could try the following: make Windows batch files where you give all
options to mysqld-max.exe on the command line:
instance1.bat:
mysqld-max --port=3306 --socket=... --datadir=... --basedir=...
--innodb_data_home_dir=... --set-variable=innodb_buffer_pool_size=30M ...
instance2.bat:
m
* Emmanuel van der Meulen
> I got this to work, I suspect a typo resulted that it did not
:)
> Well, i.r.o. the matter of risk, if different websites's data is
> in one set of files, and especially with DEV, where programs which
> still have bugs or with finger trouble, could damage the data in
Hello
Does MYSQL currently support, or has it ever supported the old Berkeley
database version 1.8?
Thanks
David Robinson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Robert,
Thanks for the tips...
>>1. create a symlink at /var/lib/mysql that points to your data directory<<
I had read that this might not be the best way prior to v4.0, something
about an
"alter table" statement might ignore the symlink?
>>2. you can change or add the 'datadir' variable in yo
Hello Tony,
Thank you for your note and assistance.
However, I'm stuck on a particular point;
I use Win2k Pro; struggling with 3rd option below, 'server-specific
options', for multiple instances; MySQL does not see the \mysql\data\my.cnf
options file, for some reason it only sees c:\winnt\my.i
Hello Roger,
[snip]
> > Roger, I attempted adding additional space with a new file under
> > innodb_data_file_path as follows;
> > Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M
> > After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M
> > Stopped and restarted MySQL, but
On Sun, 2001-12-30 at 14:12, mark priatel wrote:
> Our site has been turfed b/c of an identical problem, and despite many
> people reporting the same problem, no useful advice has yet surfaced.
>> I've decided to ask for help after 8 hours, two reinstalls, and
>> searching the mail archives...A
* Emmanuel van der Meulen
> Roger, I attempted adding additional space with a new file under
> innodb_data_file_path as follows;
> Before: innodb_data_file_path = ibdata1:50M;ibdata2:50M
> After : innodb_data_file_path = ibdata1:50M;ibdata2:50M;ibdata3:50M
> Stopped and restarted MySQL, but this d
Our site has been turfed b/c of an identical problem, and despite many
people reporting the same problem, no useful advice has yet surfaced.
Our site has been running for over a year (non-stop) with no incident.
Yesterday I logged on and noticed that mysqld was not accepting
connections. After
Anyone know how to write a connectionstring for the OleDB in ASP. I get all
different kinds of errors when i try to do this.
I write
rsDB.ActiveConnection =Provider=MySQLProv; Data
Source="server=localhost;DB=test"
but it don't work
-
Innobase allows you to specify multiple data files and will use them
automatically. So to keep under the 2gb limit just keep adding 2gb files as
needed. You can see how much space is left in the innobase data files by
doing the following query: "show table status from 'dbname' like
'tablename'".
Hi i'm a linux newbie!
I need to create a database that is accessable by everybody but i can't find
an "easy to use" example of this. I have seen many attempts at it, but none
that say, do this and that, here is an example "TAH DAH!".
That is what I need. I have setup a database and that was q
At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote:
Hi!
Below the patch made by Monty:
(/my/mysql) bk diffs sql/net_serv.cc
= sql/net_serv.cc 1.32 vs edited =
170c170
< #ifndef EXTRA_DEBUG
---
> #if !defined(EXTRA_DEBUG) && !defined(EMBEDDED_LIBRARY)
(/my/mysql) bk diffs -c sql/net_serv.c
I've been using InnoDB for the last week or so with good results & then
all of a sudden I started getting errors : table is full. I finally
tracked it down to the size of the IBD file which I had at the 400MB
default.
Does an IBD file expand out columns to their data type max size ? I hav
Hi Dennis,
There's several ways you can move the datafile location:
1. create a symlink at /var/lib/mysql that points to your data directory
2. you can change or add the 'datadir' variable in your my.cnf file (usually
/etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html
3. you
Hi all,
Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on
an HP laptop with RedHat 7.0. This will replace my already functional installation of
3.23.46.
When I go to launch, it gives me the "Starting mysqld daemon with databases..." etc.
message. It then f
Hi,
Well, it certainly seems to be pointing to MySQL.com alright.
Although the domain name registrant is still NuSphere and DNS still appears
to be handled by NuSphere's command the IPAddress it resolves to is
definitely that of MySQL.com.
Hmmm, I certainly hope this is justice and not just car
Thanks David,
I did try DBD::MYSQL but with no success. However I was using active perl's
Perl Package Manager.
I tried running PPM from the windows command prompt and then
install DBI
install DBD::mysql
Everything installed fine.
Thank you.
Clinton
- Original Message -
From: "Davi
Hi all,
I have recently installed a MySQL server and client RPM 3.23.47 on a Linux
system. The system that I am setting up is a Cobalt RAQ4, first time for me
to install MySQL on Linux.
The installed datadir turned out to be /var/lib/mysql. I get errors when
trying to move a very large MySQL d
I see the MySQL.org is now pointing to the MySQL.com site. I have not been
able to get an update anywhere on the Nusphere / MySQL lawsuit. The was no
recent news on the MySQL site and nusphere seems to be having server
problems. Can anyone shed some light on the latest?
sql, mysql
Fred Steink
I installed Embedded MySQL( compiled --with-embedded-server)
And I compiled source code from Manual.
(I did not modify the source)
compiled nicly, but I run the Embedded MySQL,
Segmentation fault occured
[wertyu@inos prog]$ ls
Makefile mysqld* mysqld.c mysqld.c~
[wertyu@inos prog]$ ./mysqld
Hi!
> "Esko" == Esko Ilola <[EMAIL PROTECTED]> writes:
Esko> The Compaq CC compiler (V6.4) has slightly different prototype for strtoll
Esko> than does the version with mysql. The difference is not that big and would
Esko> not affect to execution but the compiler thinks this as a bad thing
Happy New Year!
I'm Sorry if this question has been posted often.
but i cannot find answer.
I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio
And...
mysql> SHOW VARIABLES LIKE '%ssl%' ;
+---+---+
| Variable_name | Value |
+---+---+
| have_o
See manual section 4.1.4.
- Original Message -
From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 30, 2001 9:47 AM
Subject: Multiples instances of MySQL
> Hello all,
>
> Could someone please advise, what is the procedure to start and ru
Hello all,
Could someone please advise, what is the procedure to start and run more
than one instance of MySQL?
Kind regards
Emmanuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
46 matches
Mail list logo
