: Wednesday, September 02, 2009 1:43 PM
To: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: Problem w/ mysqldump
I checked my own backup script from earlier years and
everything was good.
You know, if I could simply figure out where the data was
actually stored,
in what file, I could copy
for a mysql dump tool ;-)
Mysql dump is the better way to go in either situation.
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: Wednesday, September 02, 2009 1:43 PM
To: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: Problem w/ mysqldump
I
Dear All
Can you please do me favor and let me know what is wrong with my MySql db
installed on Linux server that causes to get the following error message :
Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)
Your reply is highly appreciated
Regards
H.Motamedi
In the last episode (Aug 20), hadi motamedi said:
Can you please do me favor and let me know what is wrong with my MySql db
installed on Linux server that causes to get the following error message :
Fail to insert cdr:Can't open file: 'cdrFromMSC_06.MYD'. (errno: 145)
$ perror 145
MySQL error
Maybe I'm wrong :)
On Tuesday, July 21, 2009, John Daisley john.dais...@mypostoffice.co.uk wrote:
On Tue, 2009-07-21 at 19:42 +0200, Morten Primdahl wrote:
On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote:
MySQL is unable to use your index when you use IN and/or OR on yoru
column.
Hi, I have a table orders with the columns
item_id INT FK items(id)
customer_id INT FK customers(id)
status_id TINYINT -- Between 1 and 4 always
ordered_at DATETIME
delivered_at DATETIME
There are indexes:
index_a: (item_id, customer_id, status_id)
index_b: (item_id, status_id,
MySQL is unable to use your index when you use IN and/or OR on yoru column.
If the query is slow, you should switch to a union:
SELECT * FROM orders WHERE item_id = 9602 AND customer_id = 5531 AND
status_id =1
UNION
SELECT * FROM orders WHERE item_id = 9602 AND customer_id = 5531 AND
status_id
Try doing a SHOW INDEX FROM orders and look at the cardinality
column. These are the stats MySQL uses to determine which index to
use. Sometimes they aren't always update properly and you may need to
run ANALYZE on the table.
But, you can also tell MySQL to use the index you want.
SELECT * FROM
On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote:
MySQL is unable to use your index when you use IN and/or OR on yoru
column.
Is this really true?
I'm reading High Performance MySQL 2nd ed. these days and
specifically got the impression that using IN will allow usage of the
index. The
The other index does have a way higher cardinality, but the query is
for 3 columns all of which are in the first index. I guess this is
just one of the situations where MySQL makes a wrong assessment.
On Jul 21, 2009, at 3:54 PM, Brent Baisley wrote:
Try doing a SHOW INDEX FROM orders
On Tue, 2009-07-21 at 19:42 +0200, Morten Primdahl wrote:
On Jul 21, 2009, at 3:27 PM, Johnny Withers wrote:
MySQL is unable to use your index when you use IN and/or OR on yoru
column.
Is this really true?
No its not true! Try running OPTIMIZE TABLE on the affected table, then
run
'@'localhost' [using password: YES]'
I have never changed the password from the previous 64-bit version I
installed and then uninstalled and the 32-bit version I installed.
Any ideas of solving this problem ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
]'
I have never changed the password from the previous 64-bit version I
installed and then uninstalled and the 32-bit version I installed.
Any ideas of solving this problem ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working
though the tables are qualified.
Can anyone confirm this?
Gary
From: Gary Smith [g...@primeexalia.com]
Sent: Friday, July 10, 2009 5:12 PM
To: mysql@lists.mysql.com
Subject: Crazy replication problem
Here is steps take to get to the problem. Version
-Original Message-
From: Gary Smith
Sent: Friday, July 10, 2009 5:26 PM
To: Gary Smith; mysql@lists.mysql.com
Subject: RE: Crazy replication problem
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever
I have been getting this error on a database: Incorrect key file for table
'/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table is causing
this error?
TIA,
ZK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On Thursday 09 July 2009 01:56:37 pm Zakai Kinan wrote:
I have been getting this error on a database: Incorrect key file for
table '/tmp/#sql_a99_0.MYI'; try to repair it. How do I know which table
is causing this error?
TIA,
ZK
You could be running out of space on your temp
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
From: li...@voidship.net
To: mysql@lists.mysql.com
Subject: Re: Table problem
Date: Thu, 9 Jul 2009 14:07:08
two servers were having the same problem and they each have 1GB of space in the
temp dir. I was able to fix the problem by recreating the biggest table in the
database. The total space in each database is 350MB. The deleted table's size
was 500kb. The mysql version is 5.0.51a. I am afraid
Memory Ever Allocated : 1 G
Configured Max Per-thread Buffers : 2 G
Configured Max Global Buffers : 554 M
Configured Max Memory Limit : 2 G
Physical Memory : 1.96 G
Max memory limit exceeds 90% of physical memory
How can I define the problem of performance?
Best Regards,
OKAN
-Original Message-
From: OKAN ARI [mailto:okan...@aribem.com]
Sent: Monday, July 06, 2009 10:54 AM
To: mysql@lists.mysql.com
Subject: Dramatic performance problem
Hi to every body, I am newbie for mysql lists. I have a mysql server
with 2GB of ram and Core2Duo cpu. Until today mysql
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(select count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I am querying the sites table and I want to
Marco Bartz wrote:
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
I am querying the
Marco, all,
Marco Bartz wrote:
I accidentally sent it before finishing...
I am looking for a way to do the following with a single query:
SELECT `ID`, `Name`, `Interface`,
(SELECT count(*) FROM CONCAT('listings_', `ID`) WHERE `Status`='Active') as
`activeListings`
FROM `sites`
There is
have 100 records on master, but some of these tables on the
slave only have thousands
of record. The tables on the slave are not the same as those on master.
When i use 'show slave status', i find that Last_Errno equals to 0.
How to solve this problem.
--
David Yeung,
MySQL Senior
on the slave are not the same as those on master.
When i use 'show slave status', i find that Last_Errno equals to 0.
How to solve this problem.
I have configured 2 MySQL server to do master-master replication. Below
is my config:
Node A
server-id = 1
log_bin = mysql-bin
expire_logs_days= 10
max_binlog_size = 100M
binlog_do_db= clustertest
binlog_do_db= gateway
Is there any record limitation in ndbcluster? Because I can't insert
more records after it reached 108 records. How to solve this?
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
- Original Message -
From: sangprabv sangpr...@gmail.com
To: mysql@lists.mysql.com
Sent: Thursday, June 18, 2009 1:10 PM
Subject: ndbcluster problem
Is there any record limitation in ndbcluster? Because I can't insert
more records after it reached 108 records. How to solve
: Thursday, June 18, 2009 1:10 PM
Subject: ndbcluster problem
Is there any record limitation in ndbcluster? Because I can't insert
more records after it reached 108 records. How to solve this?
Willy
--
MySQL General Mailing List
For list archives: http
Dave,
do you really consider it helpful to do reply all to a release
announcement, trying to send it to the announce and packagers list,
including a full quote of the announcement text, and using the original
subject line,
when you are asking for help about a compile problem?
Dave Shariff
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
using MySQL 5.1.30.
In the MySQL reference manual it says:
As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be
removed (along with the
log_slow_queries system variable) in MySQL 7.0. Instead
Try putting in a full existing pathname the server has write access to
as opposed to just a file name.
Walter Heck
On Sun, May 17, 2009 at 12:13 PM, mos mo...@fastmail.fm wrote:
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
using MySQL 5.1.30.
In the MySQL
wrote:
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm
using MySQL 5.1.30.
In the MySQL reference manual it says:
As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be
removed (along with the
log_slow_queries system variable) in MySQL 7.0. Instead
Hi Bruce,
SELECT ... INTO OUTFILE always creates the file local to the database server.
If you want to dump results where your perl script is running you'll have to
use another method such as receiving the results of the query normally and
writing the file in the perl script.
Regards,
Thanks all who replied.
After I posted I kept looking and found it... Also had folks point it
out to me.
Your suggestion is what I ended up doing.
Bruce
Gavin Towey wrote:
Hi Bruce,
SELECT … INTO OUTFILE always creates the file local to the database
server. If you want to dump
I have a bit of perl code that ends with an error:
$sql=SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\'
LINES TERMINATED BY '\n'
FROM alerts a
Hi,
I'm having a strange problem with table locking. I have written a stored
procedure that only accesses a single table. Before executing the
procedure, I'm trying to lock the table in question for writing. The
LOCK TABLE command succeeds, but when I execute the stored procedure it
tells me
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24 mysupp...@asuma.com
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze mysql.li...@gmail.com wrote:
From: zhu dingze mysql.li...@gmail.com
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql
the structureMy problem is that I run a
query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN
logical_app_role_link l ON x.application_id = l.application_id AND y.role_id =
l.role_id WHERE l.logical_id = 15;
It works for the old mysql version but for the new
to be there including the structureMy problem is that I run a query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN logical_app_role_link l ON x.application_id = l.application_id AND y.role_id = l.role_id WHERE l.logical_id = 15;
It works for the old mysql version
to be there including the structureMy problem is that I run a query like this :
SELECT x.application_name, y.role_name FROM application x, role y JOIN logical_app_role_link l ON x.application_id = l.application_id AND y.role_id = l.role_id WHERE l.logical_id = 15;
It works for the old
, ándré, .
Just to add Ive tried
select nome from usuarios where nome like _utf8 %andré% collate
utf8_general_ci;
and occurs the same as search without accentuation, and I tried to change
character set to latin1 and nothing changed... I'm really lost in this
problem
Do anybody have some idea
Hi,
Is there someone who is able to connect to an MySQL instance
connection via ssl,
from a client located on a different server than where is the MySQL
instance,
using the only option --ssl-ca ?
I'm not able, I can only connect if I use the options --ssl-ca, --ssl-
cert and --ssl-key
this be part of a transaction that is rolled-back instead of
committed?
There are too many unknowns about your situation to make a clear judgement
on this particular problem.
--
Shawn Green, MySQL Senior Support Engineer
Sun Microsystems, Inc.
Office: Blountville, TN
--
sibasha
the condition is true.
please tell me why.
thank you
How do you know your condition is true?
Could this be part of a transaction that is rolled-back instead of
committed?
There are too many unknowns about your situation to make a clear
judgement on this particular problem.
--
Shawn Green, MySQL
actively using unless we get a burst of email, at which time
they will increase by a few. The problem is that Postfix has been receiving a
higher level than normal of emails as we have taken 50% of our servers offline
at this location (setting them up at a new location). We're also have
of email,
at which time they will increase by a few. The problem is that Postfix has
been receiving a higher level than normal of emails as we have taken 50% of
our servers offline at this location (setting them up at a new location).
We're also have this bouncing across a couple different
delimiter //
create procedure sample1(in p_item varchar(30),
in p_size varchar(6),
in p_quantity decimal(10,3),
in p_unit varchar(3),
in p_autoincrement varchar(30),
out v_mess varchar(50)
)
begin
declare done int default 0;
declare v_bhqty decimal(10,3);
declare v_bhunit
most likely a missing include it should have at least:
#include sys/time.h
#include sys/resource.h
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
schrieb:
make all-am
Making all in mysql-test
Making all in lib/My/SafeProcess
g++ -DHAVE_CONFIG_H -I. -I
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve them
(connectivity and load issue on the client). The question is, how can I tweak
mysql to tolerate a higher level than normal of bad connections
At 10:39 AM 4/7/2009, Gary Smith wrote:
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve
them (connectivity and load issue on the client). The question is, how
can I tweak mysql to tolerate a
a burst of email, at which time
they will increase by a few. The problem is that Postfix has been receiving a
higher level than normal of emails as we have taken 50% of our servers offline
at this location (setting them up at a new location). We're also have this
bouncing across a couple
make all-am
Making all in mysql-test
Making all in lib/My/SafeProcess
g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3
-fno-implicit-templates -fno-exceptions -fno-rtti -MT safe_process.o -MD -MP
-MF .deps/safe_process.Tpo -c -o safe_process.o safe_process.cc
In file included from
15:57
To: mysql@lists.mysql.com
Subject: Annoying .mysql_history problem
Using MySQL 5.0.67 on OpenSolaris 2008.11, whenever I hit Ctrl-C to
terminate a long-running test query, it hangs while it kills the thread.
No problem here. If I accidentally (or impatiently) hit Ctrl-C again
Using MySQL 5.0.67 on OpenSolaris 2008.11, whenever I hit Ctrl-C to
terminate a long-running test query, it hangs while it kills the thread.
No problem here. If I accidentally (or impatiently) hit Ctrl-C again,
it terminates the MySQL CLI. Again, no problem here. What's getting me
Hello! First of all sorry for my terrible english.
Well I've a big problem with ibdata1, this damn file increase its size
constantly.
I tryed to use innodb_file_per_table... but:
- MySQL create a lot of ibd files for all DB (correct)
- ibdata1 is however created and increase its size
minute is it growing?
How many inserts do you have on the tables per second/minute/hour?
Ciao!
Claudio
2009/3/26 Riccardo Michele Filippone ethern...@gmail.com
Hello! First of all sorry for my terrible english.
Well I've a big problem with ibdata1, this damn file increase its size
constantly
of queries...
however do you know if there is an engine that support/manage foreign key?
I use innodb for this reason.. but the size of ibdata1 is a problem :'(
Thanks for ur reply
Il giorno 26/mar/09, alle ore 12:30, Claudio Nanni ha scritto:
You can't!
it is part of the datafiles
forgot the list, sorry :)
Walter Heck
-- Forwarded message --
From: Walter Heck - OlinData.com li...@olindata.com
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone ethern...@gmail.com
Riccardo,
if you're ibdata1 file
In the last episode (Mar 26), Riccardo Michele Filippone said:
Hello! First of all sorry for my terrible english.
Well I've a big problem with ibdata1, this damn file increase its size
constantly.
I tryed to use innodb_file_per_table... but:
- MySQL create a lot of ibd files for all
Hello there guys,
Latelly our database server is going into a very big problem, our current
configuration (is in an attachment file), is having huge load of leak memory
and a variable *innodb_log_file_size *is off cause when i up it the mysqld
doesn't start, our server is having this status
zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h
192.168.0.224 -u root -p alba2
Cheers
Claudio
2009/3/11 Rob Wultsch wult...@gmail.com
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com
wrote:
OK, I've managed to do the same thing with just the
Thanks. That works great.
On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote:
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com
wrote:
OK, I've managed to do the same thing with just the mysql command
line
program:
mysql -h 192.168.0.224 -u root -p alba2
I'm writing script that, each night, copies a small database to my
laptop on the local network. I'm having trouble getting it to work.
Here's my syntax so far (run on the server):
mysqlimport --host=192.168.0.224 --user=root --password alba2
alba2_2009-03-10_00h45m.Tuesday.sql
Which
OK, I've managed to do the same thing with just the mysql command line
program:
mysql -h 192.168.0.224 -u root -p alba2 /Backup/Latest/
alba2_2009-03-10_00h45m.Tuesday.sql
Works great. However, the sql file is normally gzipped, so Can I
ungzip the file on the fly (and without
Hi Rene,
Just a head's up. You might want to keep your username/password
credentials private.
On Tue, Mar 10, 2009 at 10:16 PM, René Fournier m...@renefournier.com wrote:
OK, I've managed to do the same thing with just the mysql command line
program:
mysql -h 192.168.0.224 -u root
info if we had
ill intents.
Sent from my Verizon Wireless BlackBerry
-Original Message-
From: Darryle Steplight dstepli...@gmail.com
Date: Tue, 10 Mar 2009 22:20:26
To: René Fournierm...@renefournier.com
Cc: mysqlmysql@lists.mysql.com
Subject: Re: mysqlimport remote host problem
Hi
On Tue, Mar 10, 2009 at 7:16 PM, René Fournier m...@renefournier.com wrote:
OK, I've managed to do the same thing with just the mysql command line
program:
mysql -h 192.168.0.224 -u root -p alba2
/Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql
Works great. However, the sql file
Hi,
I am using MySQL 5.0.51a. I've got a problem with a stored function. It
reads as follows:
CREATE FUNCTION `_contractRoot`(temp INT) RETURNS int(11)
READS SQL DATA
BEGIN
DECLARE _parent_id INT;
REPEAT
SET _parent_id = temp
On Feb 12, 2009, at 6:28 PM, csego...@gmail.com wrote:
Andy, Michael, and Walter - thank you!
Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails. The good thing is that the failure is no longer due to
the
inability to write the log file. The [mysqld_safe]
In the process of installing MySQL 5.1.31, I receive the following error
when I attempt to start mysqld_safe:
090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'.
090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
/app/mysql/bin/mysqld_safe: line 96:
Colin,
hi, so I think your mysql account doesn't have access /var/log/
directory Permission.
Yours,
fire9
在 2009-2-13,上午1:02, csego...@gmail.com 写道:
In the process of installing MySQL 5.1.31, I receive the following
error
when I attempt to start mysqld_safe:
090212 10:57:40 mysqld_safe
That is intentional. I want to write the log to a non-standard location.
Thanks!
C
fire9 wrote:
Colin,
hi, so I think your mysql account doesn't have access /var/log/
directory Permission.
Yours,
fire9
ÔÚ 2009-2-13£¬ÉÏÎç1:02£¬ csego...@gmail.com
mailto:csego...@gmail.com дµÀ£º
In
It could be that your my.cnf isn't being read (permissions or in the
wrong directory), or that you have multiple my.cnf files.
Quoting csego...@gmail.com csego...@gmail.com:
That is intentional. I want to write the log to a non-standard location.
Andy,
Thanks for the suggestion. my_print_defaults mysqld indicates that it
is reading my my.cnf. Furthermore, I have tried both the log and
log-output variables in my.cnf with no success. Any other ideas?
Thanks!
C
Andy Smith wrote:
It could be that your my.cnf isn't being read
I haven't looked into it in detail an don't have time right nw, but it
is also hardcoded in mysqld_safe. I have seen a case where it had to
be changed there to make it work. try that and please report back :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
Andy, Michael, and Walter - thank you!
Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails. The good thing is that the failure is no longer due to the
inability to write the log file. The [mysqld_safe] section of my.cnf reads:
[mysqld_safe]
port= 3306
I am trying to install mysql in a non-standard directory - specifically
/app/mysql
Subsequently, I ran the following configure command:
./configure --prefix=/app/mysql --with-plugins=innobase,myisam
There were no problems with the compile, but mysql failed to start.
Furthermore, the following
/var/lib/mysql is the standard loation for the data_file_path, the
data directory. change it in my.cnf.
var/log is the default location for log files, also changeable in the
config file.
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
:
Just install the server, run mysql_install_db, start the server and run
mysql_secure_installation.
Fix:
Submitter-Id: ?
Originator:Steve Holmes
Organization:
Purdue University Computing Center
MySQL support: none, at the moment
Synopsis: Problem with mysql_secure_installation
Hello,
I have to code a compatibility layer under PHP5 for PostgreSQl and
MySQL, which mean, I have to code something like db_query() which then
can be used with mysql_query() and pg_query().
But now I have hit an weird error, since in PostgreSQL it is wotking but
in MySQL it get the
OK, Now I have gotten something...
[ '~/.tdphp-vserver/includes/10_electronica_admin.inc' ]
snip
# while ($DB_list=db_fetch_array($DB_result)) {
#$output .= lia href=\/?what=adminwhere= . $VAL2 . action=edit
#if ($_COOKIE[$VAL2 . '_desc_short'] == 'show') {
#
Hi Krishna,
thanks for the your answer !!!
I have three different my.cnf for my three instances but one general
my.cnf to manage all instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
Hi Stefano,
I have tested. It's working fine without any issue.
Open mysql configuration(.cnf) file referencing to 1st mysql instance. Add
the below entires and restart the mysql server.
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
Hi Krishna,
the problem is that you use --default-file on the command line and in
this mode it's working fine,
I also tried,
but I have the configuration of the variable default-file in the
general my.cnf and I enter in MySQL
in this way:
mysql --socket=/tmp/mysql50_SIA_SVILUPPO.sock
to it.
Thanks,
Krishna Chandra Prajapati
On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi
stefano.elm...@sociale.itwrote:
Hi Krishna,
the problem is that you use --default-file on the command line and in this
mode it's working fine,
I also tried,
but I have the configuration of the variable
socket is not reading
the configuration file. i mean to say the it's using default
available to it.
Thanks,
Krishna Chandra Prajapati
On Tue, Dec 23, 2008 at 5:14 PM, Stefano Elmopi stefano.elm...@sociale.it
wrote:
Hi Krishna,
the problem is that you use --default-file on the command line
each
supplier. This is link using the LookupTB.
Let me know what other information you require.
Thanks
Neil
On Tue, Dec 23, 2008 at 4:19 AM, Raghani, Sonal (IE10)
sonal.ragh...@honeywell.com wrote:
Hi,
The problem statement needs to be elaborated. Please give the exact
columns interms
Hi
I'm having trouble trying to figure this out. Any help/example would be
grateful.
Thanks
Neil
On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz ba...@xaprb.com wrote:
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
of products for all suppliers for a
I need advice.
I have three instances of MySQL on a single server.
How can I change the MySQL prompt depending of the instance on which
connecting ?
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf
Ciao Stefano,
how do you connect to the different instances?
if you use different operating system users or different mysql home
directories
just put in the home directory of each user a .my.cnf file (or my.cnf in the
mysql home)
with just the prompt setting in the [mysql] section.
NOTE: in the
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf
Hi Stefano,
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
On Mon, Dec 22, 2008 at 3:46 PM, Stefano Elmopi
401 - 500 of 8646 matches
Mail list logo