Details required in cnf files

2007-12-06 Thread John Dba
Hi all, I have a advanced servers 4 with 30 gb of ram please let me know the exact details how much i have to configure and use the exact variables in the cnf file and which one to be used.(innodb engine) any my database size is upto 600gb how to take up the backup, using ibbackup my system get

Re: Spfile in Mysql......

2007-11-27 Thread John Dba
Hi all The same thing mysql also uses it own defaults file if my.cnf is not found. It uses its own defaults-extra-file configurations to start the db. Yeah but only specific variables can be changed globally or session wise. Others needs recycling of db. :-) - Original Message --

How to find Free space in innodb

2007-11-13 Thread John Dba
Hi I am running 5.0.46-enterprise-gpl-log version in linux (Red Hat Enterprise Linux AS release 4 (Nahant Update 5). In my.cnf i have configured innodb as : innodb_data_file_path = datafile1:500M;datafile2:500M;datafile3:500M;datafile4:500M;datafile5:500M;datafile6:500M;datafile7:500M and da

Re: Add a replicated DB w/o rebooting the server

2007-10-31 Thread John Dba
Hi, Master to slave replication. If a database is created in master and in slave config file if i needs to add the 2nd database name to replicate, without restarting the instance in slave it is not possible. Cheers John_mysql - Original Message From: Oriol Capsada <[EMAIL PROTECTED

Re: disconection

2007-10-31 Thread John Dba
Hi Check whether u have enabled the safe_updates in the config file. - Original Message From: Mulyadi <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Wednesday, October 31, 2007 3:22:59 PM Subject: disconection - Original Message - From: Ravi Shanmugam <[EMAIL PROTECTED]>

Re: Can't find file: './mysql/(database_name).frm'

2007-10-30 Thread John Dba
Hi, If you are using binaries from mysql.com and extract the files and when u try to start the database it says in the error frm/* not found...then u might try out this option as Try to run the ./configure file which will come with binaries, It will auto create the frm and MY* files under the

Ibbackup failure

2007-10-30 Thread John Dba
Hi all, When i try to backup the database through ibbackup i am getting the following error :- Details are here. - InnoDB Backup Utility v1.3.0; Copyright 2003-2005 Innobase Oy This software is published