Re: To extend InnoDB table size

2005-03-16 Thread Naveen C Joshi
Many many thanks... I was in confusion. But how can I exten the table size. Regards Naveen - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Naveen C Joshi" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, March 15, 2005 7:52 PM Subject:

To extend InnoDB table size

2005-03-15 Thread Naveen C Joshi
is my production server so I am restricted to do any exercise. Thanks Naveen

Mysql taking 100% Mem utilisation

2004-11-15 Thread Naveen C Joshi
ort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout Please advise me where I have to made changes in config file for the best performence of mysql server. Regards Naveen

Replication is being break

2004-09-21 Thread Naveen C Joshi
behind the down/up of replication? Due to this up/down I got some of the data merged. My MySQL version is 4.0.5a beta. I am looking for the solution of this up/down if the network is well established. Regards Naveen

Re: replication config without stopping master server

2004-09-14 Thread Naveen C Joshi
o put the mysql-bin.xxx and offset value? Thanks in advance. Regards Naveen - Original Message - From: "Thomas Spahni" <[EMAIL PROTECTED]> To: "Naveen C Joshi" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, August 31, 2004 9:48 PM Su

Re: replication config without stopping master server

2004-08-31 Thread Naveen C Joshi
replicate data on slave than I will do the same. As my database is being update in every minute and if I lock it for write, than is there any side effect or it will recover all after unlock. Please provide me help in this situation. Thanks & Regards Naveen - Original Message - From: &qu

Re: replication config without stopping master server

2004-08-31 Thread Naveen C Joshi
Hi All : I am still waiting for the response. Thanks in advance. Regards Naveen - Original Message - From: "Naveen C Joshi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 4:17 PM Subject: Re: replication config without stopping

Re: replication config without stopping master server

2004-08-27 Thread Naveen C Joshi
= write_buffer=2M [mysqlhotcopy] interactive-timeout Regards Naveen - Original Message - From: "Naveen C Joshi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 27, 2004 2:04 PM Subject: replication config without stopping master server Hi, I have MySQL

replication config without stopping master server

2004-08-27 Thread Naveen C Joshi
ot to stop the master replication server. Please suggest me the solution. Regards Naveen

Mysql4.0 installation problems.

2004-03-23 Thread Naveen Babu
m /usr/ports/databases/mysql40-server i gave "make reinstall". This has worsten the situation. The installation process was going on going on and going on.. and i had to give ctrl-C to stop it. I guess it went on to some kind of loop. Now I am totally lost. Any help is greatly appre

Join the group

2004-03-23 Thread Naveen Babu
I would like to join the group. Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time.

Re: ERROR 1005 at line 12: Can't create table

2004-02-11 Thread naveen
thanks Victoria Reznichenko for your help where will i put this parameter SET FOREIGN_KEY_CHECKS = 0; in the dump file or under mysql pormpt.I added through mysql but still the same error comes. can you please help me in that with regards Naveen - Original Message - From: "Vic

ERROR 1005 at line 12: Can't create table

2004-02-11 Thread naveen
Hi when i try to put the data(xyz.sql) taken using mysqldump commant bin/mysql --user=root --password=secret xyz < xyz.sql ERROR 1005 at line 12: Can't create table './XYZ/Bcl.frm' (errno: 150) what is this comming,why is it comming. with regards naveen

migrating data from 4.0.16 to 4.0.17

2004-02-11 Thread naveen
abase and try to run the command bin/mysql -e "source path/xyz.sql" xyz then error says cannot create table etc.with ERROR number 1005. what could be the reason for it with regards Naveen

migrate data from mysql 4.0.16 to 4.0.17 ?

2004-02-10 Thread naveen
Hi i am using mysql 4.0.16 for my applications and it has around 10 records .if i move the data from mysql 4.0.16 to 4.0.17 will that create any inconsistancy . in my database. does mysql provide anytool to migrate data from mysql4.0.16 to 4.0.17 - Original Message - From: <[EMAIL

Increase space for /var/db

2003-12-17 Thread Naveen Babu
Hello, I have a 4.5 FreeBSD server with mysql database. only 250MB was allocated to /var/db. Our database is increasing so fast that now i need to expand the memory for /var/db. I guess one way to do is to install a new hard drive and then mount it to /var/db. But i would like to know if there i