Re: Too many connections

2008-08-05 Thread Vladislav Vorobiev
2008/8/5 Krishna Chandra Prajapati [EMAIL PROTECTED]: Hi All, I am trying to connect to mysql server. Buts, Its giving too many connections. How to increase the max_connection on mysql server. When i am giving mysql -u root -ppassword Still, its giving too many connections. How to solve

Re: debian-sys-maint

2008-01-03 Thread Vladislav Vorobiev
Hello, Mysql on debian operating system has debian-sys-maint user. What is the role of this user debian-sys-maint. After stopping mysql. If i delete all the things from mysql data directory. Executed mysql_install_db to create mysql directory with mysql data directory and start mysql

Re: debian-sys-maint

2008-01-03 Thread Vladislav Vorobiev
mysql-server (make backup of your data) dpkg -r mysql* dpkg --purge mysql* apt-get install mysql-server -- Best Regards Vladislav Vorobiev http://www.mymir.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: order by in query

2008-01-02 Thread Vladislav Vorobiev
2008/1/2, Edward Kay [EMAIL PROTECTED]: Hello i use this query: select i.item_id from orders o INNER JOIN item i ON i.nr=i.nr Should the line above not be ... ON i.nr = o.nr ? Autch. thank you! It works now. -- Best Regards Vlad Vorobiev http://www.mymir.org -- MySQL