Re: convert week of the year into a date string

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 of the year) makedate(

mysqldump -T - Insert headers?

Hi: Using mysql 5.0.45 on linux 2.6.22-15 (ubuntu). I can create tab-deliminated text files using mysqldump -T, but I haven't found a way to include a header with column names. Any ideas? It's any easy task for me to extract them with a script, but if mysqldump can do it, so much for the better. TI

Re: Lost connection

Mad Unix wrote: During the update of the MySQL DB (delete/insert), I keep getting the following message Lost connection to MySQL server during query... By default, the MySQL server drops a connection after 8 hours of receiving no queries on that connection. This can happen in an application

Retrieve insert_id on an insert ignore?

I have a table like this: unique_serial - Auto Increment field_1 field_2 field_3 The Primary key is a combination of field_1, field_2, and field_3. I want to do: INSERT IGNORE INTO table_name (field_1,field_2,field_3) VALUES ('xx','xx','xx') Sometimes this will be an existing record, someti

Lost connection

Hi all During the update of the MySQL DB (delete/insert), I keep getting the following message Lost connection to MySQL server during query... Any thoughts about this issue, could it be a network, code or tunning problem ... Thanks

MySQL 6.0.6 Alpha has been released

Dear MySQL users, MySQL 6.0.6-alpha, a new version of the MySQL database system has been released. The main page for MySQL 6.0 release is at http://www.mysql.com/mysql60/ MySQL 6.0 includes two new storage engines: the transactional Falcon engine, and the crash-safe Maria engine. If you are new

Re: Replication Error

you need to be sure you have everything the server needs to be a slave defined in your my.cnf file, especially the relay logs and that the replication slave user is created properly. On Tue, Aug 19, 2008 at 2:37 AM, Krishna Chandra Prajapati < [EMAIL PROTECTED]> wrote: > Hi, > > I am setting up r

convert week of the year into a date string

HI All, I have table which stores week_of_the_year and year. For example week_of_yearYEAR 32 2008 I want to convert this into the date. That is , i need to get the date of first day of the week 32. some thing like 03-AUG-2008. Regards anandkl

Create temorary tables

Hi there, is there any possibility to create temporary tables with storage engine "ndbcluster"? Thanks in advance Günter

Program to restore incrementally

Hello List, I am searching for a program that would allow me to restore incrementally. Meaning, to be able to restore only few records from a previous backup. Is there any program available that can do this? Thanks in advance. Noor -- MySQL General Mailing List For list archives: http://li

Re: Replication Error

u need to set those parameters On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Server_id is set but not relay_log and relay_index. > > On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >> is the server_id and relay_log and relay_index parameter set in

Re: Replication Error

Server_id is set but not relay_log and relay_index. On Tue, Aug 19, 2008 at 1:20 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > is the server_id and relay_log and relay_index parameter set in my.cnf > > > On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I am setting

Re: Replication Error

is the server_id and relay_log and relay_index parameter set in my.cnf On 8/19/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi, > > I am setting up replication and got the error below > > mysql> change master to master_host='172.20.1.189', master_user='repl', > master_password='pas

Replication Error

Hi, I am setting up replication and got the error below mysql> change master to master_host='172.20.1.189', master_user='repl', master_password='pass'; Query OK, 0 rows affected (0.01 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with C