Thank you all, guys!!
i shall try these and respond on which worked best for me.
Regards,
Uma
On 10/6/08, Andy Shellam <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I was also going to go down this route some time back, but then when I
> looked at it, it's pretty simple how it works and you can do the
Hi Sachin,
What version of MySQL are you running? I believe --log-output was only
added in 5.1 which is why a 5.0 server would fail to start with this
option set. I think the relevant option should also be "log-output" in
my.cnf / my.ini (e.g. log-output = FILE, TABLE.)
It looks like 5.1 g
Alrite guys.
I added log=/tmp/logfile in /etc/my.cnf and removed "log = FILE,
TABLE". Now it is logging each query.
Thanks for the support.
Sachin
On Mon, Oct 6, 2008 at 3:13 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote:
> More on this:
>
> I set following in /etc/my.cnf:
>
> log = FILE, TABLE
>
More on this:
I set following in /etc/my.cnf:
log = FILE, TABLE
after this I am not able to start my mysqld, it fails with timeout
error message "Timeout error occurred trying to start MySQL Daemon."
Thanks,
Sachin
On Mon, Oct 6, 2008 at 3:01 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote:
> Tha
Thanks a bunch for the quick reply.
I will surely write a C program to read this logfile of general queries.
But before that I am not able to find this logfile for general queries.
I started my server like this:
$/etc/init.d/mysqld start --log=logfile --log-output=/tmp
Meaning log file will be i
I'm probably being a bit stupid - but I'm trying to determine (in code) the
length of the string in the schema for a given table.
So - for example :
create table a (
blah char(20)
)
I want to return '20', but I'm getting '60' when I use mysql_list_fields..
(Al
This problem is Chapter 16.6 of The MYSQL Cookbook, (second edition)
that has made my(sql) life much easier. You might want to look around
at http://artfulsoftware.com/ which has lots of examples and a great
e-book resource.
Both of these are fantastic resources for me, and they are probably my
m
Hi Sachin,
MySQL is capable of logging all queries to a log file, see
http://dev.mysql.com/doc/refman/5.0/en/query-log.html. This includes
connections, disconnections and executed SQL statements - no coding needed!
If you want this information imported into a database table, a couple of
hou
Hi,
I was also going to go down this route some time back, but then when I
looked at it, it's pretty simple how it works and you can do the same
thing yourself for free.
Take a dump of both servers (mysqldump or via MySQL Administrator) of
the databases in question, then use WinMerge (for fr
Hi all,
I am newbie using MySQL. I want to log each client request to database
server. I thought when server checks access rights of user(client)
will be good place to "log" all "access/read/update" requests.
If somebody knows where exactly this is done in source code, I will
get a real kick star
It specifies the query in the Info field.
In your case the connection is "sleeping", nothing is being executed at the
moment, therefore info is NULL
Olaf
On 10/6/08 11:38 AM, "MaBa.listas" <[EMAIL PROTECTED]> wrote:
> Hello,
> reading the MySQL documentation I've run into the " show full
Hello,
reading the MySQL documentation I've run into the " show full
processlist\G" command. In my case I've got an output similar to this:
-
mysql> show full processlist
Hi,
This Thursday, Stewart Smith will give a MySQL University session:
http://forge.mysql.com/wiki/Patch_Management_With_Quilt
(topic: Patch Management With Quilt)
*** Note that this particular session starts 9:00 BST / 10:00 CET /
18:00 Brisbane/Melbourne ***
Please register for this session b
Uma Bhat wrote:
We are in progress of *optimizing* and designing the existing mysql database
enviromnent on *linux*. And need help in comaparing schema of 50
databases from the same mysql instance.
If you can afford to spend a few dollars to get the right tool, you want
to get DB Comparer for
Armin
I did what you said, now I understand what you say that there is no
sence in what I wanted to do.But I gave these commands as follows But it did
not work.What I want is to specify a configuration file which is placed in
the WINDOWS directory.The commands I ran
C:\>NET STOP MySQL
C:\>my
In order to make your workaround less tedious you can write a shell script
that dumps the structures of all 50 databases
basically:
for db in $(mysql [opts] -e 'show databases'); do
mysqldump [opts] $db
Done
Olaf
On 10/5/08 10:15 PM, "Uma Bhat" <[EMAIL PROTECTED]> wrote:
> Hey guys!
>
>
Varuna,
obviously it doesn't make much sense, to specify the my.ini location
in my.ini itself.
The "--defaults-file" option is used as a direct start-up parameter
for mysql-server both, run as service or console-process.
It simply tells the server-process where to look for the oneandonly my.ini.
An
Varuna Seneviratna schrieb:
I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS
Could Not start the MySQL Service on
> Steve
(n)
Martin!
> if you want apache and mysql (and possibly PHP for scripting) AND you want
> all 3 to run at once
> then d/l and implement with XAMP
> there are alot of XAMP specific bells and whistles that are installed that
> get in the way of tuning your MySQL and tuning your Apache inst
I added a line to the [mysqld) group
As --defaults-file="C:\WINDOWS\my.ini" and then I restarted the
service.Everything was fine.Then I took out the my.ini file in the MySQL
instalation directory the result was an error message AS
Could Not start the MySQL Service on Local Computer
Error 1067 Th
Uma Bhat wrote:
Hey guys!
*MySQL version 5.0*
Hence before doing this, *we want to ensure that
there is ABSOLUTE *no* difference in schema between each of them. (all
datatypes, and other such database objects, engines, MUST be IDENTICAL).*
*QUESTION* - what's the *EASIET way to compare* the sche
21 matches
Mail list logo
