Hi All,
I am using version 5 of mysql on lunix. I have place my log files in the
same disk of datafiles, can you please let me know how i can move log files
into a different disk.
regards
anandkl
Hi!
I tried to run the perl scripts in the windows platform yesterday,but
an error occured as following output info:
" C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl
mysql-test-run: *** ERROR: Could not find
C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables "
I
hi all,
i have a mysql which only localhost can be logged in. if i have created
an account [EMAIL PROTECTED], then, i cant login in as that host.
mysql -u user -h mymachine.com -p
ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111)
please advise. thanks
--
MySQL General Ma
Hi.
Where can I find a good explanation/description of the configuration
directives for mysql as they appear in my.cnf?
I've downloaded the 4.1 manual but can't seem to find a description of
the directives.
BTW. Is there a manual for 4.0.18 or 4.0 version?
Thanks.
Kind regards.
--
Luke
-
My bad. I was renaming some columns in a table. I incorrectly set the
type to decimal(4,2) and the data was truncated/hosed. Is there a way to
recover the data. I tried a system backup from yesterday. That changed
nothing. I have already set the column type back to the correct
settings. I am runnin
Is that stable if i started mysql server by defining default_table_type
= INNODB at the my.cnf file? from which by default my.cnf is defining
MYISAM table to be the defaulted.
Richard Dale wrote:
this is my error log file.
InnoDB: Error: log file ./ib_logfile0 is of different size
The statement remained in the killed state for 2 hrs and then got out of the
processlist. Great sigh of relief then :).
Sorry for the late reply. But one thing I still couldn't understand is why
it took so long to move out of the processlist from the killed state.
sujay
-Original Message
Hi,
I have problems calling mysql_stmt_prepare in the C-API after
mysql_stmt_execute. I want to loop through a resultset by using a prepared
statement. I call mysql_stmt_init, mysql_stmt_prepare and mysql_stmt_execute.
Next I would loop with mysql_stmt_fetch_row. But before I would like to
pre
Another thing is that table2 might not have a match.
C.F. Scheidecker Antunes wrote:
I actually forgot something. I need a two statements into one. The
reason is that table_two has multiple values, so I need the minimal ID
from table 2.Thanks.
Maybe I am working too much here and tired to se
I actually forgot something. I need a two statements into one. The
reason is that table_two has multiple values, so I need the minimal ID
from table 2.Thanks.
Maybe I am working too much here and tired to see the right statement.
J.R. Bullington wrote:
I am not the smartest on the list, but
I am not the smartest on the list, but I think this would do it for you.
UPDATE table_one t1, table_two t2 SET t1.ID = t2.ID WHERE t2.num = t1.num
AND t1.ID = 0
J.R.
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 16, 2005 1:45 PM
To: my
Hello All,
I have two MySQL 4.1 tables. The first table has an ID field which is
set to zero. The second one has ID fields and filenames.
I need a single SQL statement to set the ID from table 1 to the ID from
table 2 ONLY IF the ID on one is zero.
That is, if the ID on table one is not set (
Hi,
Is there a command for renaming a MySQL database?
Thank you.
Teddy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi again,
This is intresting, the documentation indeed mentions that mysql_ping
indicates "Zero if the connection to the server is alive" and not that
"zero if the server is alive", as I *naturally expected* also, so it
is kind of tricky this one. I would expect the same behavior with Unix
socket
Hello.
I've found that mysql_ping doesn't work properly with TCP connection (in
your test case you put the hostname to "127.0.0.1"). My program was
working with "localhost" - connection through the Unix socket. You may
want to add you comments to my bug report at:
http://bugs.mysql.com/bug
Hello.
Please, send to the list your queries and CREATE statements for tables
which are used by you queries. Include the output of SHOW PROCESSLIST.
> 2. When writng in my.cnf the skip-bdb option still the server
> reserves memmory for berklyDB aswell with innoDB. But writing
> somthing wr
Hi,
The previous subject made me wonder about mysql_ping () in a multithread
environment. Since it implements restoring connectivity, should it also
be protected by a mutex?
Regards and thnx,
Lefteris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I did some extensive testing and it looks like that only the first
mysql_ping () fails to reconnect or very possibly returns the wrong
result. I am currently using v4.1.14.
Regards,
Lefteris
Begin
MySQL is up and running
Restart MySQL and hit
Hi,
I have searched and tried and have no clue why the db on
4.1.11-Debian_4sarge2 behaves like this.
I have no TABLE LOCK query anywhere in my code!
About the server (LAMP/ 2x3Mhz, 4GB RAM)
1. prob.
the mysql> show processlist gives me a list of 25 threads
waiting for there work.
even on heavy l
Jon,
your hardware/OS combination is quite new and unusual. It might indeed be an
OS problem. We observed from a 64-bit RHEL 4 that when the file cache of the
OS grew bigger than 4 GB, then the file I/O performance dropped to one tenth
of the normal. You would not expect that kind of behavior
> this is my error log file.
> InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
> InnoDB: than specified in the .cnf file 0 268435456 bytes!
Your problem here is that you must have started MySQL when you had a 5MB
transaction log file specified, but you then put a new c
21 matches
Mail list logo