MySQL Forums
Forum List  »  Install & Repo

Re: second instance installation
Posted by: Tom Clancy
Date: May 09, 2011 02:49PM

Now the problem No 2

This time i want to start the server with these option

/opt/mysql2/mysql2/bin/mysqld_safe --basedir=/opt/mysql2/mysql2 --datadir=/var/lib/mysql2 --pid-file=/var/run/mysqld2/mysqld.pid --socket=/tmp/mysql2/mysql.sock --defaults-file=/etc/mysql2/my2.cnf --log-error=/var/log/mysql_log/mysqld.log --port=3307 --user=mysql &

the option --defaults-file can also be used while starting the server using the mysqld_safe


My ERROR LOG

110509 15:15:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql2
110509 15:15:34 [Note] Plugin 'FEDERATED' is disabled.
110509 15:15:34 InnoDB: The InnoDB memory heap is disabled
110509 15:15:34 InnoDB: Mutexes and rw_locks use Solaris atomic functions
110509 15:15:34 InnoDB: Compressed tables use zlib 1.2.3
110509 15:15:34 InnoDB: Initializing buffer pool, size = 128.0M
110509 15:15:34 InnoDB: Completed initialization of buffer pool
110509 15:15:34 InnoDB: highest supported file format is Barracuda.
110509 15:15:35 InnoDB: 1.2.2 started; log sequence number 1595675
110509 15:15:35 [ERROR] /opt/mysql2/mysql2/bin/mysqld: unknown variable 'defaults-file=/etc/mysql2/my2.cnf'
110509 15:15:35 [ERROR] Aborting

110509 15:15:35 [Note] Binlog end
110509 15:15:35 [Note] Shutting down plugin 'partition'
110509 15:15:35 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
110509 15:15:35 [Note] Shutting down plugin 'BLACKHOLE'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_METRICS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_CMPMEM'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_CMP_RESET'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_CMP'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_LOCKS'
110509 15:15:35 [Note] Shutting down plugin 'INNODB_TRX'
110509 15:15:35 [Note] Shutting down plugin 'InnoDB'
110509 15:15:35 InnoDB: Starting shutdown...
110509 15:15:36 InnoDB: Shutdown completed; log sequence number 1595675
110509 15:15:36 [Note] Shutting down plugin 'ARCHIVE'
110509 15:15:36 [Note] Shutting down plugin 'MyISAM'
110509 15:15:36 [Note] Shutting down plugin 'CSV'
110509 15:15:36 [Note] Shutting down plugin 'MRG_MYISAM'
110509 15:15:36 [Note] Shutting down plugin 'MEMORY'
110509 15:15:36 [Note] Shutting down plugin 'mysql_old_password'
110509 15:15:36 [Note] Shutting down plugin 'mysql_native_password'
110509 15:15:36 [Note] Shutting down plugin 'binlog'
110509 15:15:36 [Note] /opt/mysql2/mysql2/bin/mysqld: Shutdown complete

110509 15:15:37 mysqld_safe mysqld from pid file /var/run/mysqld2/mysqld.pid ended



The server is aborting as the unknown variable defaults-file

without defaults-file i can start the server but my option file is /etc/my.cnf
which i dont want it to be

any solution for this

CNF file
# more /etc/mysql2/my2.cnf
[mysqld]
datadir=/var/lib/mysql2
pid-file=/var/run/mysqld2/mysqld.pid
log-bin=/var/log/mysql2/mysql-bin.log
log-error=/var/log/mysql_log/mysqld.log
port = 3307
socket = /tmp/mysql2/mysql.sock


Thanks



Edited 1 time(s). Last edit at 05/09/2011 02:54PM by Tom Clancy.

Options: ReplyQuote


Subject
Written By
Posted
Re: second instance installation
May 09, 2011 02:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.