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)
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 run more
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 |
+---+---+
|
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 and
Esko
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]$
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
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
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
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
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
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.cc
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
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'.
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
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.
* 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 did
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...ARGH!!
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 this did
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
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 your
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)
* 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
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:
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 used symlinks a
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 to
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 the
* 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 quite
* 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
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
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
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
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
databases
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
* 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
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
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.
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 -
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
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
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
different
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
#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, description,
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
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 applies to the
44 matches
Mail list logo