Hi all,
I want to enable UTF8 support for mysql.Thats why I have installed mysql 4.1
on a Win2K server and set the appropriate character set parameter at my.ini
file. As the mysql service starts, I get the error that mysql can not find
the utf8.xml file.
mysqld-opt: File 'D:\mysql\share\charsets\
Hi all,
First of all , the version of mysql is 3.23.52. I am using When I do a
truncate table on a MyIsam table, the show table command shows thatt there
are no records but the table size is about 100 MBs.
Afterwards, I run an optimize table command and the table size decreases to
2KB's. Everythi
Hi all,
First of all , the version of mysql is 3.23.52. I am using When I do a
truncate table on a MyIsam table, the show table command shows thatt there
are no records but the table size is about 100 MBs.
Afterwards, I run an optimize table command and the table size decreases to
2KB's. Everythi
Hi all,
I have succesfully formed a one-way replication both running on win2k. I
have stopped the master server before replication and started both of the
mysql servers at the same time.
When I do a `show status` at the both servers, there is a big difference at
the number of update queries - lik
Hello,
At the mysql documentation it says that;
Windows NT disk i/o may benefit from a larger number of
innodb_file_io_threads . Does anybody have any idea about the maximum value
of
innodb_file_io_threads? (Default value is 4)
Cheers
Okan
Hi there,
I am working on the replication feature of MySQL. I am managed to replicate
the servers(both versions are 3.23.52 on Win 2K). Ay yhe my.ini file, the
bin-log files are declared as log-bin=c:\mysql\log_files.bin and as I FLUSH
LOGS the new log file's name is increased by 1, like log_files
Hello,
I am planning to install 2 mysql servers on the same box whish runs Win2K.
Has anyone experianced this before?
Regards
Okan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Hi all,
We are using MySQL v. 3.23.49 on both Windows 2K and Solaris 8 with InnoDB
support. We have created many relational tables since InnoDB supports
foreign keys.
After some unidentified time, the foreign keys relating only one table
corrupts but the other foreign keys remain valid. At the c
Hello,
When I execute mysqladmin drop database database_name it drops the database
without asking for a user or password. How are the security features are set
about mysqsladmin?
Regards
Okan
-
Before posting, please check:
TO 'username'@'%' WITH GRANT OPTION
|
+---
--+
And when I run the mysqldump, it creates the table structure files on my
box, not at the server.
Thanks for your answer
Okan
2 rows in set (0.00 sec)
- Original Message -
From: "Paul D
Hello,
When I try to get the remote dump of a database, I get the table structure
without any failure but it is not able to get the table data. Has anyone of
you came over to this problem before?
Here is what I have tried:
H:\>c:\mysql\bin\mysqldump -T "c:\mysql\batch\dump\new_dump" -f -l -v -u
Hello,
I am trying to write a script that creates tables via a cronjob but I want
to name these tables including the current date as a suffix -like
transections_20020324- . Does anybody know the SQL statement that entegrates
the table name with the current date?
I tried to do it by storing the c
Hello,
I am running 3.23.49-nt on Win2K advanced server w/ 2GB of RAM. When I try
to make a connection from our web server using JDBC, it takes about 30
seconds to connect to MySQL. There is nothing wrong with network connection
or something else.
In mu opinion the main result is the number of
Hello,
I am planning to call a scheduled (lets say 08:00 am every weekday) batch
job at MySql, but I do not want to use operating systems scheduled task nor
crontab. Is there a function that mySql supports like Oracle's jobs?
Regards
Okan
--
14 matches
Mail list logo
