Optimizing Project Requirements - question

e. TIA for the favor of a reply. -- Best regards, Mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Curious Error, anyone have a guess?

database comes from a call to $_SERVER['HTTP_USER_AGENT']; -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Recommended MySQLDump options

be using any others? My Database is running MYISAM. TIA -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

default storage engine

files into the data folder, many of them seem to be corrupted now for some unknown reason. When I do a diff on the my.ini file the new one looks nothing at all like the previous version so my question is what happened? If anyone knows. -- Best regards, mikesz

Can a JOIN statement do this?

optimize this query. Any suggestion greatly appreciated. -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

MediumBlob / phpMyAdmin / hex dumps Questions

always. TIA -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

ERROR 2006 (HY000): MySQL server has gone away

ion. Trying to reconnect... Connection id:14 Current database: worldrac_forum Any ideas how to troubeshoot this or what the problem might be? TIA -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysq

another INNODB vs MYISAM question

n exercise of reinstalling everything to test the theory so if someone has had some experience with this, I would appreciate hearing from them. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists

WAMP question ...

s? What are the consequences? Everything seems to work. TIA for any wisdom. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: utf8_general_ci to utf8_polish_ci?

stion? Thanks in advance for a reply. regards, mikesz This is a forwarded message From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Date: Monday, March 24, 2008, 11:30:44 AM Subject: utf8_general_ci to utf8_polish_ci? ===8<==Original message text===

utf8_general_ci to utf8_polish_ci?

on the "right" way to convert from utf8_general_ci to utf8_polish_ci? Thank you for your attention. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Date sorting problem with Date_Format?

TE_FORMAT( `Messages`.`Date`, '%D %M %Y' ) AS FmtDate, and used the FmtDate reference to display the query results and it worked fine. -- Best regards, mikeszmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

Date sorting problem with Date_Format?

in an sql window it works correctly. If I remove DATE_FORMAT function and just call `Date`, the script sorts and displays correctly. Is this a bug? -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://list

Follow Up : Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

rror stated is completely bogus relative to the cause of the problem, i.e. red herring. So, that's my story and hope it helps someone prevent premature baldness from troubleshooting obscure database problems... 8-) -- Best regards, mikeszmailto:[EMAIL PROTECTED]

Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

ed. I am using the same login credentials from the configuration files to connect to the database including username/password yet I get this apache error message. Any ideas or explanations on this greatly appreciated in advanced. -- Best regards, mikesz mailto:[

How to emulate a DATE() in MySQL 4.0?

count(SimulatedTimeSet) as count_live FROM `Simulator` WHERE DATE( `SimulatedTimeSet` ) = DATE(CURRENT_TIMESTAMP)" I appreciate in advance any clue to get me in the right directions other than upgrading the system. I don't have any control over that one... TIA -- Best r