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

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

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

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

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

Create temorary tables

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

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

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

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

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

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

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

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: 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(