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 The
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
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
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
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.
Any
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!
We
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
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
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
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\G
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
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 start.
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
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
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
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..
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
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:
Thanks
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
after
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
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 same
21 matches
Mail list logo
