Hi Rudy, How about changing the port number in my.cnf and restarting the server ? All clients will look on the wrong port number and not be able to connect. That should do it while you take your backup.
When finished change the port number back to 3306. Best regards Nils Valentin Tokyo/Japan 2003年 7月 9日 水曜日 02:07、Rudy Metzger さんは書きました: > Dear all, > > > > Is there a way to start mysqld in a way, that say only a superuser can > connect. I would need this e.g. for restoring a backup, because I do not > want users to connect to the server while I restore the binary log. > > > > I already check the options for mysqld but could not find anything > (except changing the port and using this port for backup, hoping noone > connects to the new port or to switch off tcp/ip at all and only connect > through unix sockets). > > > > Thanx for any hint!!! > > > > Cheers > > /rudy -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
