Re: convert week of the year into a date string

Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of days from the start

Install MySQL on Windows XP

Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0 Now i do not know what

Re: Install MySQL on Windows XP

Hi there Yuan, Hopefully this article can be of some help to you: http://schalkneethling.alliedbridge.com/php/php-mysql-apache-set-up-how-to/ Regards, Schalk yuan edit wrote: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server

Re: convert week of the year into a date string

Pintér Tibor wrote: Ananda Kumar írta: Hi All, I think i worked on this and found the results. I did the below. 1. Multiplied the week_of_the_year with 7 (7 days per week), to get the total number of days from begning of the year. 2. used mysql function makedate makedate(year,number of

Re: Install MySQL on Windows XP

yuan edit schrieb: Hi all. I am trying install mysql-essential-5.0.67-win32.msi on windows xp. But i can not configure the mysql server successful. I stoped the firewall and anti-virus programs when i install mysql server. there is mysql message: Could not start the service MySQL5.Error:0

Re: convert week of the year into a date string

I did something similar to this recently. I ended up using the following select date_sub(curdate(), interval(dayofweek(curdate()) + (($week - week) * 7) - 1) DAY) as mydate. This was in php and ahead of time I set $week as select week(curdate()). It could easily be extended with year. Phil On

mysql-migration-toolkit

Am trying to install the following pack: [EMAIL PROTECTED] download]# rpm -Uvh mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm error: Failed dependencies: libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386 [EMAIL PROTECTED] download]# java -version java

Re: mysql-migration-toolkit

I did the following to resolve this issue [EMAIL PROTECTED] download]# rpm -Uvh mysql-migration-toolkit-5.0r12-1rhel4.i386.rpm error: Failed dependencies: libjvm.so(SUNWprivate_1.1) is needed by mysql-migration-toolkit-5.0r12-1rhel4.i386 [EMAIL PROTECTED] download]# rpm -ivh --nodeps

Re: mysql-migration-toolkit

Am using the following packages -rw-r--r-- 1 root root 4117403 May 3 2007 mysql-administrator-5.0r12-1rhel4.i386.rpm -rw-r--r-- 1 root root310923 Aug 20 17:53 mysql-gui-tools-5.0r12-195.1.x86_64.rpm -rw-r--r-- 1 root root 6265000 May 3 2007 mysql-gui-tools-5.0r12-1rhel4.i386.rpm

quick question on innodb_log_file_size

Hi, According to the reference manual, it was said that the combined lnnodb log file size is less than 4G on 32-bit system. But I'm running on my 64-bit solaris, I still got the error complaining the innodb log file 4G for my 64-bit MySQL. So I'm wondering is this 4G limit apply on 64-bit system

MySQL performance

Hi, If you would like to improve the performance of your MySQL environment, you may consider the following information tobe of interest: The latest series of Dolphin Express drivers for Linux now also includes support for accelerated intra-node socket communications. Through the combination