There absolutely is;
there is a configuration file belonging to MySQL named `my.cnf`. It can
exist in many places and there's a hierarchal order of precedense. The most
common of which is /etc/my.cnf.
Within this file you may specify the `datadir` option to identify location
you wish your data to
On Fri, May 13, 2011 at 9:21 AM, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location: /opt/mysql
>
> When creating a new database, a folder (with the name
On Fri, May 13, 2011 08:21, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a
I have a MySQL question that I'm hoping someone can help answer.
We have a linux machine which has MySQL 5.5.8 installed.
It is currently installed in this location:/opt/mysql
When creating a new database, a folder (with the name of the databas)
gets created in this location:
/opt/mysql/da
I wondered if you can get me started on selling MANY mailing list to
potential clients who are in need of millions of e-mail names and addresses.
This has collected for some time. I am needing to start a business doing this
Here in the United States and out of country yet I am not sure how to
>I cannot insert values into the tables
What is the error message? Has the smallint key run out of values?
>and I cannot alter or delete the primary key (which should not exist)
Eh? Without a PK, it ain't a table.
>or delete the foreign keys nor remove the constraint. G search doesn't
help.
On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
> I have a seemingly impossible situation. I cannot insert values into the
> tables and I cannot alter or delete the primary key (which should not
> exist) or delete the foreign keys nor remove the constraint. G search
> doesn't help.
>
> CREATE TABLE `b
I have a seemingly impossible situation. I cannot insert values into the
tables and I cannot alter or delete the primary key (which should not
exist) or delete the foreign keys nor remove the constraint. G search
doesn't help.
CREATE TABLE `book_categories` (
`bookID` smallint(6) unsigned NOT NUL
Glyn Astill wrote:
I'd back up the data directories then try and then re-install mysql (sorry, I
know little about red hat and it's package management). It shouldn't overwrite
your data if it's already present anyway.
Great. Thought that would be the case, but without sleep, I wasn't sure. :-
Decided to run up2date -u
I noticed that our website was tossing off mysql errors. Quickly
realized that mysql was down. Went to restart but it couldn't find
mysqld_safe, mysqld, mysqladmin, etc.
I used locate and it couldn't find the binaries anywhere...it appears
that up2date -u had someho
Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is anoth
Hello All,
I need to add a couple of more tables to the list of tables to be replicated
from a particular db in the salve my.cnf.
Can this be done without restarting the mysql server on the slave?
Thanks & regards,
Ratheesh
Running this statement on the master should do it:
DROP TABLE table1, table2...;
That will remove the tables.
Baron
Ratheesh K J wrote:
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a cou
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affecting the
master and slave. How is this possible?
Thanks & regards,
Ratheesh
Ratheesh K J schrieb:
Thanks,
It helped me a lot. I wanted to know
1. what are the various scenarios where my replication setup can
fail? (considering even issues like network failure and server
reboot etc). What is the normal procedure to correct the failure
when somethi
uot;Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, October 02, 2007 4:16 PM
Subject: Re: [Replication] - urgent
> Ratheesh K J schrieb:
>> Hello all,
>>
>> I issued a create table statement on the master for a table which was not
>> present on the mast
Ratheesh K J schrieb:
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows th
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows that the SQL Thread has st
Hi,
I need to track the mysql commands executed on mine system , I am running
windows with mysql 5.x
I know there is a file .mysql_history and hopes there must be a similar file on
windows too.
Pl. help me urgently,
Thanks,
--
Regards,
Abhishek Jain
se.Such that suppose the field name is ID and I want to retrieve
> data
> from another field LAT such that at a time LAT values for ID's 1,2,3 are
> taken then for 3,4,5 then for 4,5,6 so on till table ends.
> --
> View this message in context:
> http://www.nabble.com/need-help
ntext:
http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875
Sent from the MySQL - General mailing list archive at Nabble.com.
this message in context:
http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875
Sent from the MySQL - General mailing list archive at Nabble.com.
Hello all,
I have struck with a big problem with MySQL 5.0.22 server on RHEL 3.
After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries
are struggling to execute and the DB server is clogged. Below is an example of
what is happening.
This query usd to execute very fast on
D]>
To:
Sent: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
taking a lot of time to execute in the newer version. The queries which were
executing within 1
M` (`FLD_TICKET_NUM`),
KEY `FLD_MARK_AS_DELETED` (`FLD_MARK_AS_DELETED`),
KEY `FLD_ACC_ID` (`FLD_ACC_ID`),
KEY `FLD_BLOCK_STATE` (`FLD_BLOCK_STATE`),
KEY `FLD_FWD_FLAG` (`FLD_FWD_FLAG`),
KEY `FLD_ISSUE_CLOSED` (`FLD_ISSUE_CLOSED`),
KEY `FLD_REPLY_FLAG` (`FLD_REPLY_FLAG`),
KEY `FLD_SUBJECT` (`FL
: FLD_MSG_ID
key_len: 4
ref: tallydb.TFMM.FLD_MSG_ID
rows: 1
Extra: Using where
- Original Message -
*From:* Alex Arul <[EMAIL PROTECTED]>
*To:* Ratheesh K J <[EMAIL PROTECTED]>
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:*
age -
From: Alex Arul
To: Ratheesh K J
Sent: Tuesday, January 23, 2007 11:57 AM
Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently
you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versio
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are taking
a lot of time to execute in the newer version. The queries which were executing
within 10 secs are now taking more than 100 secs.
Running an expalin on the queries showed that an index_merge optimization i
Hi,
> I have the following table in mysql 5.0.20...
>
> employ
> ==
> empid
> date_time
> site
>
> I am using this table to store all the websites accessed by each
> employees. There is no primary key on that table since the same
> employee will access more than 100 sites per day. If there i
On 2006-12-19 Prem wrote:
> I am using this table to store all the websites accessed by each employees.
I hope you're aware that your country might have data privacy laws, too..
> There is no primary key on that table since the same employee will access
> more than
> 100 sites per day. If ther
Hello,
I have the following table in mysql 5.0.20...
employ
==
empid
date_time
site
I am using this table to store all the websites accessed by each employees.
There is no primary key on that table since the same employee will access more
than 100 sites per day. If there is 100 employees t
, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
MyISAM tables
http://www.innodb.com/order.php
.
From: Ratheesh K J Date: December 11 2006 10:23am
Subject: Re: Innodb log sequence error - urgent
Get Plain Text
Thanks,
I hav
h K J
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, December 11, 2006 1:25 PM
Subject: Re: Innodb log sequence error - urgent
> Ratheesh K J schrieb:
>> Hello all,
&
Ratheesh K J schrieb:
Hello all,
yesterday we seperated our app server and db server. We moved our 70GB of data from our app server to a new DB server. We installed MySQL 4.1.11 on the DB server.
Now the following happened. On the DB server the ibdata1 and all the databases
are the old ones
Hello all,
yesterday we seperated our app server and db server. We moved our 70GB of data
from our app server to a new DB server. We installed MySQL 4.1.11 on the DB
server.
Now the following happened. On the DB server the ibdata1 and all the databases
are the old ones (which were copied from
Thank you very much..excellent support
- Original Message -
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 1
l.com
Subject: Re: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I
asked...I
also knew this location mysql@lists.mysql.com
- Original Message -
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To:
Cc: "Renish" <[EMAIL PROTECTED]&
er 16, 2006 11:20 AM
Subject: Re: Urgent please..
On Wednesday 15 November 2006 18:14, Renish wrote:
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
Please read the documentation befor
@lists.mysql.com
Subject: Urgent please..
All,
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
php.exe
and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
I want to use PHP as sever side scripting.
Cheers,
Renish.
--
MySQL General Mailing List
For
On Wednesday 15 November 2006 18:14, Renish wrote:
> Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
> php.exe and nothing seems to happen.
> I have intalled
> 1) webserver-Apache2
> 2) MySql-41.1
Please read the documentation before asking questions such as these. Thanks.
All,
Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe
and nothing seems to happen.
I have intalled
1) webserver-Apache2
2) MySql-41.1
I want to use PHP as sever side scripting.
Cheers,
Renish.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Em Sat, 11 Nov 2006 16:03:41 +0100, Yannick Landry ANTONIO escreveu:
> Je viens au pres de vous solliciter une aide en ce qui concerne le
> demarrage du serveur mysql.
Eſt-ce qu’il n’y a pas de liſte francophone ?
> J'ai installe sur ma machine la version mysql suivant: mysql-4.0.20a-wi
Je viens au pres de vous solliciter une aide en ce qui
concerne le demarrage du serveur mysql. J'ai installe
sur ma machine la version mysql suivant:
mysql-4.0.20a-win
Je constate qu'il n'y a pas un racourcie pour la
source graphique. J'ai tente de demarrer le server en
ligne de commande en me met
http://firestuff.org/wordpress/wp-content/uploads/2006/03/base64.sql
On 10/17/06, abhishek jain < [EMAIL PROTECTED]> wrote:
> Hi,
> I want to decode base 64 string via mysql .
> Also i am using aspx .net .
> Pl. help me.
> Urgent reply will be appreciated
> --
> Regards,
> Abhishek jain
>
>
006/03/base64.sql
On 10/17/06, abhishek jain <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to decode base 64 string via mysql .
> Also i am using aspx .net .
> Pl. help me.
> Urgent reply will be appreciated
> --
> Regards,
> Abhishek jain
>
>
Hi,
I want to decode base 64 string via mysql .
Also i am using aspx .net .
Pl. help me.
Urgent reply will be appreciated
--
Regards,
Abhishek jain
Can anyone tell me how can I import the *.gra (oracle db file) files to
Navicat or Acess. Pls let me know in steps as I am v new to this field.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
--
MySQL General Mailing List
For lis
Hi all,
I have installed MySql 4.1 in my system. when I tried to run Mysql , I
always gets this error.
Could not start MySql service on a local computer
Error 1067: the process terminated unexpectedly.
Any help is highly appreciated.
Regards,
Renish
--
MySQL General Mailing List
For lis
Hello,
Could anyone explain me the parameter of the function my_hash_sort_simple in
MySQL 5.0.20a. Which is called under strings/ctype-simple.c.
Thanks,
Prem
The error message says to go to
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn
how to set the different recovery options for innodb.
On 9/21/06, Sayed Hadi Rastgou Haghi <[EMAIL PROTECTED]> wrote:
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/my
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/mysql/start
I get these lins in my error log
060921 13:00:14 mysqld started
060921 13:00:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ib
cache, so can can do
some things without taking MySQL down.
- Original Message -
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To:
Sent: Thursday, July 27, 2006 8:38 AM
Subject: MySQL performing too badly under heavy load - urgent hlp needed
Hello all,
Stuck up with a
t; e) any combination of the above
f) not enough memory, that forces major swapping activity
-Stathis
>
> Ratheesh K J wrote:
> > Hello all,
> >
> > Stuck up with a major problem. Urgent hlp required
> >
> > MySQL seems to be performing too bad during heavy load o
At 09:38 AM 7/27/2006, Ratheesh K J wrote:
Hello all,
Stuck up with a major problem. Urgent hlp required
MySQL seems to be performing too bad during heavy load on the server.
Queries which normally take around 5 secs to complete are taking more than
1000 secs to complete during load.
What
(use explain to check)
c) non-optimized configuration of the server (have you tuned the server
parameters to the way you use the server?)
d) insufficient hardware for your needs
e) any combination of the above
Ratheesh K J wrote:
Hello all,
Stuck up with a major problem. Urgent hlp required
MyS
Hello all,
Stuck up with a major problem. Urgent hlp required
MySQL seems to be performing too bad during heavy load on the server. Queries
which normally take around 5 secs to complete are taking more than 1000 secs to
complete during load.
What could be the reason. Show processlist shows
This is a text part of the message.
It is shown for the users of old-style e-mail clients
Hi!
> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:
Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter> I have all C: working, and can acces
It was just to copy the files from the DATA folder in the installation
directory. That was easier then I thought.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:52 AM
To: mysql@lists.mysql.com
Subject: Urgent problem
Best group member,
My
Best group member,
My computer stopped working. And I was able to install Windows on another
partition and now I face one problem. I was running Windows with MySQL 4.1.
I have all C: working, and can access all files.
The first question: Can I recover that data from MySQL?
The second question:
If u need this in urgent, i think my suggestion may help you.
try to do replication in this way
Branch-A will be update in Branch-B and Branch-B will update in Branch-C
. Branch-E(which got total data of A,B,C,D) will update in Main Office.
On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote:
> Dear Expert,
>
> I am very new to MySQL replication, I need to replicate my DB on 5 branches
into 1 DB at Head Office.
>
> eg.
>
> MyDB at Branch A need to be replicated to MyDB at Head Office
> MyDB at Branch B need to be replicated to MyD
Only with MySQL 5.0 is multi-master replication possible. Guiseppe
Maxia has a wonderful article about it at:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
-Sheeri
On 5/22/06, Winanjaya - CBN <[EMAIL PROTECTED]> wrote:
Dear Expert,
I am very new to MySQL repli
Dear Expert,
I am very new to MySQL replication, I need to replicate my DB on 5 branches
into 1 DB at Head Office.
eg.
MyDB at Branch A need to be replicated to MyDB at Head Office
MyDB at Branch B need to be replicated to MyDB at Head Office
MyDB at Branch C need to be replicated to MyDB at H
WEBBEE . BIZ wrote:
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
Hmm should work with PROCEDURE in
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
--
Regards
Abhishek Jain
On 4/20/06, abhishek jain <[EMA
C K wrote:
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any record in any linked table then it gives me
error as follows:
Reserved Error (-7776); there is no message for this error.
What will be the problem? Please help.
Is this error from
[EMAIL PROTECTED]
> Sent: Friday, April 07, 2006 1:50 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Re: Reserevd Error -7776 -- Urgent
>
> I also tried folloing and got results as below:
> 1) I updated the
I also tried folloing and got results as below:
1) I updated the default for timestamp filed as CURRENT TIMESTAMP as
mentioned in MySQL 5.1 manual.
But this not worked.
2) I dropped timestamp fiield from that table and refreshed link, then
I can ork properly. Now I can insert and update reocrds wit
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:59:39 PM:
> On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> > "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
> >
> >
> > > Dear Friends,
> > > I have linked tables from MySQL through ODBC DSN in Access 2003.
> > > wh
On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
>
>
> > Dear Friends,
> > I have linked tables from MySQL through ODBC DSN in Access 2003.
> > when I go for updating any record in any linked table then it gives me
> > erro
"C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
> Dear Friends,
> I have linked tables from MySQL through ODBC DSN in Access 2003.
> when I go for updating any record in any linked table then it gives me
> error as follows:
> Reserved Error (-7776); there is no message for this error.
>
Dear Friends,
I have linked tables from MySQL through ODBC DSN in Access 2003.
when I go for updating any record in any linked table then it gives me
error as follows:
Reserved Error (-7776); there is no message for this error.
What will be the problem? Please help.
Is this error from MS ACCESS or
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
WHERE col_1 = (SELECT max(col_1) FROM table_1)
See the docs for Update at
http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to
the update table in a subquery.
PB
-
Veerabhad
On Monday 20 February 2006 03:27, Veerabhadrarao Narra wrote:
> Hi
>
> i ahve one table table_1 and columns like col_1,col_2,col_3
>
> col_1 col_2 col_3
> 1 aa aaa
> 2 bb
>
> Now i want to update my table table_1 SET col_3 as bbb where max of col_1
>
> I wrote thi
Hi
i ahve one table table_1 and columns like col_1,col_2,col_3
col_1 col_2 col_3
1 aa aaa
2 bb
Now i want to update my table table_1 SET col_3 as bbb where max of col_1
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
To:
Sent: Sunday, January 15, 2006 10:21 AM
Subject: A difficult query- urgent for me
Dear Friends,
I have a problm, try to solve that.
Actually there is a table with columns a and b .
So i want if a contains a particular word than a's value should return else
'b' value should re
On 1/15/06, [EMAIL PROTECTED] wrote:
>
> Actually there is a table with columns a and b .
> So i want if a contains a particular word than a's value should return else
> 'b' value should return.
SELECT
CASE
WHEN a = 'Good' THEN a
ELSE b
END
FROM
table
Jochem
Dear Friends,
I have a problm, try to solve that.
Actually there is a table with columns a and b .
So i want if a contains a particular word than a's value should return else
'b' value should return. And there must be one and only one column
returning. I have mysql 4.x and i think the logic will be
Aftab Khan <[EMAIL PROTECTED]> wrote on 12/28/2005 02:15:33 PM:
> Can some one please tell me what I am doing wrong here I have
installed
> and configured users in the database. I am using ODBC driver to logon.
> When I use the password, it does not work but surprisingly the logon is
> allow
Can some one please tell me what I am doing wrong here I have installed
and configured users in the database. I am using ODBC driver to logon.
When I use the password, it does not work but surprisingly the logon is
allowed without a password. I have tried to use MySQL Administrator to
logon r
o: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the "source" command within the MySQL
CLI?
mysql -uroot -pmypa
Terence <[EMAIL PROTECTED]> wrote on 11/23/2005 08:22:30 PM:
> Hi All,
>
> We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
> working. It works fine on 4.1 but 5.0.16 gives us an error:
>
>
> How to reproduce:
>
> CREATE TABLE `user_master` (
>`user_id` int(5) unsigned
t;myback1.sql
>
> it now restore the tables but not the views or sp’s
>
> here is the backup file
>
> thanks
> Barak
>
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 23, 2005 9:30 PM
> To: Barak Mery
> Cc: mysql@lists.m
Terence,
>SELECT um.username,rm.role_name,dm.department_name
>FROM user_master um, role_master rm
>LEFT JOIN department_master dm ON um.department_id = dm.department_id
>WHERE um.role_id = rm.role_id;
>J
Your query joins rm to dm on a um column = a dm column. Recent 5.0 releases
rightly object t
On 24/11/2005 2:22 p.m., Terence wrote:
SELECT um.username,rm.role_name,dm.department_name
FROM user_master um, role_master rm
LEFT JOIN department_master dm ON um.department_id = dm.department_id
WHERE um.role_id = rm.role_id;
1054 - Unknown column 'um.department_id' in 'on clause'
Query:
S
Hi All,
We have upgraded from 4.1.0 to 5.0.16 and notice all left joins not
working. It works fine on 4.1 but 5.0.16 gives us an error:
How to reproduce:
CREATE TABLE `user_master` (
`user_id` int(5) unsigned NOT NULL auto_increment,
`department_id` int(5) default NULL,
`role_id` int(5
Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There
MAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 23, 2005 9:07 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: Re: urgent : PLEASE HELP - problems with back up and restore
>
>
>
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> Hi,
>
>
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> Hi,
>
>
>
> I'm really desperate on this on.
>
> After struggling with some really weird bugs I finally finished my
project.
>
>
>
> Buut I can't perform a good backup and restore.
>
>
>
> I'm using :
>
>
Hi,
I'm really desperate on this on.
After struggling with some really weird bugs I finally finished my project.
Buut I can't perform a good backup and restore.
I'm using :
MySql 5.0.16-nt (essentials version)
Windows xp
The DB contains tables, vw's and sp's.
It is a v
ssage-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 12:53 AM
To: mysql@lists.mysql.com
Subject: Re: Killing a thread -- Urgent
Hello.
Do you have other queries which are running at this moment on the server?
The show-processlist.html says that thread could
Hello.
Do you have other queries which are running at this moment
on the server? The show-processlist.html says that thread
could be in Killed state if it is locked by another thread.
What version of MySQL do you use? What storage engine does your
table have?
Sujay Koduri <[EMAIL PRO
hi all..
I started a select count(1) command on a table in mysql, assuming it will
end soon within the off peak time..
But now the peak load time is about to start, so i tried to kill that
query..
logged into mysql as root.
show processlist for getting the thread id.
kill 85300 (thrad_id)
Aft
it was reopened, max
OSX and other applications are not effected etc. etc."
its version : 3.51.11-1
so this ODBC driver will not work on the 10.4 machine? as right next to the
download it states OSX v10.3
(installing on 10.3 works no problem)
Sorry, I can't help here, but noted t
Kane Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 07, 2005 1:40 AM
To: mysql
Subject: please help .very urgent
hi ,
I wanted to check the following condition and if it is success i wanted to
display a massage.I tried as follows. but no luck. nothing displayed.
$dbQuery = resu
1 - 100 of 487 matches
Mail list logo
