Formatting timestamp in MySQL outfile

hi everybody, i would like to know, if there exists a method for getting a format like '2003-12-31 12:00:00' for the time stamp in the text file generated using the outfile command. the normal format is '2003123112' any help would be greatly appreciated. Thanks in advance anirudh Filter

Replication from DB2 to Mysql

hi everyone, well this question has been asked before but was long time ago. Since i could not locate an answer i am posting this question once again. I want to replicate my database which exists on DB2 to my MySQL machine across the network I am using db2 version 7and mysql version 4.0.2 Thanks

MyISAM Database on multiple partitons

hi, i have MyISAM database on my root pattition which is now getting full, however i have an empty 5Gb partion, how configure MySQL to now start storing my DB on to the new partition. In nut shell my question is how can we have a MyIsam database on multiple partions? thanks anirudh mysql, query

Managing replication logs

hi all i have established a two way replication setup my problem is that my hard disk gets occupied by the log files; i tried purging the files but after some time again my hard disk gets filled with the log files could any one please tell me how to manage the log files. thanks anirudh mysql,

mysql.sock gets deleted when i reboot

hi i am using mysql version 4.0.1 alpha my problem is that whenever i update my my.cnf to enable innodb support and restart the system the mysql.sock file gets deleted and i cannot start mysql. and then again i have to re install mysql i have even tried by changing the file persission for my.cnf

problem starting innodb support

i am new to mysql, my problem is that i cannot create tables with type innodb i have made the entry innodb_data_file_path in my.cnf i am using mysql 4.0.2 alpha on red hat 7.1 could anybody plese help me? thanks anirudh -

comparision of performance b/w mysql and db2

i am planning to shift my database from mysql to db2 could anybody please send me some details showing the performance of the mysql server usder varying loads as compared to db2 server thanks! - Before posting, please check: