Re: Data Directory
Ciao! I am new to both Linux and MySQL. I used the source to compile MySQL on Linux 7.0 with the default options. It's working fine. What's Linux 7.0? :-) But can i change the data directory where all the databases are stored to something other than the default, without having to compile again? Well, you could use a symbolic link, if you don't wanna compile it. Otherwise, which is better and wiser, just put this line in the /etc/my.cnf file. [mysqld] datadir=/usr/local/mysql/var Obviously, change the path! ;-) Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data Directory
At 14.38 13/06/01 +0530, Suvarsha Walters wrote: Thanks a lot, But another problem. I did the changes in my.cnf and restarted mysql. It stops immediately, shows the following: Starting mysqld daemon with databases from /base1 010613 14:22:38 mysqld ended But when I changed the 'datadir' values in the my.cnf back to the default directory, it works fine. Any idea what the problem is? Did you move the contents of the older datadir in /base1? Let me know ... Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with tuning connections!
Ciao guys, I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run it, and had a 'too many connections' warning. So, I just set the max_connections variable to 200. And since then, no problem. Here is the /etc/my.cnf file under the [mysqld] group: set-variable=key_buffer=16777216 set-variable=max_connections=200 set-variable=table_cache=2048 I want to ask you if there's a way to keep this under control. I mean. What should I do to do this? I use to give a look at the status and extended-status with mysqladmin, but are there any attributes I should keep an eye on? And, why does max_used_connections always says: 100? Kinda weird, isn't it? Ciao and thanks! -Gabriele - Gabriele Bartolini Computer Programmer (are U sure?) U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - Zinedine Zizou Zidane. Just for soccer lovers. - - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [beginner] How to update mysql with Linux ?
At 09.42 11/06/01 +0200, Francesco Marchioni wrote: Hi all, I'd like to update my version of Mysql on linux. How can I do it so that I don't have two copies of mysql on my machine ? Do I have to clean up the folder mysql and then install the new version under it? I suggest you to dump all of the database you are interested in, first of all. That's pretty easy, just run mysqldump for every db. And what should I download -the source code or the binaries- in order to update the starting scripts under /etc/rc.d/init.d ? It depends on which version you have already installed. Do you use RPMs or source code? And, which version of MySQL do you have? However, you could also write me in italian ... but I guess personally, otherwise nobody will understand! :-) Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installation problem
/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Ciao Michela, unless you changed the 'user' table contents, you could easily connect to every db as root without providing any password. What's the command line you typed? Can you connect with 'mysql'? As root, type this: mysql mysql select * from user; and give a look at the host, user and password fields. Hope this helps! Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Compiling an PHP 4.0 module with MySQL
./configure --with-mysql=/usr/bin --with-apxs --enable-track-vars Ciao, sorry but I just joined this mailing list, so I am not aware of any previous messages. /usr/bin ? Why in that directory? Can I please get to know how did you install MySQL? By RPM? Please try these 2 find commands? find / -name mysql.h(in my system it's under /usr/include/mysql/) find / -name libmysqlclient.*(in my system it's under /usr/lib/mysql/lib/) The latest RPM version comes with this prefix: /usr (so just put --with-mysql=/usr ) Let me know! Hope this helps! -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Too many connections!
Ciao guys, I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run it, and had a 'too many connections' warning. So, I just set the max_connections variable to 200. And since then, no problem. Here is the /etc/my.cnf file under the [mysqld] group: set-variable=key_buffer=16777216 set-variable=max_connections=200 set-variable=table_cache=2048 I want to ask you if there's a way to keep this under control. I mean. What should I do to do this? I use to give a look at the status and extended-status with mysqladmin, but are there any attributes I should keep an eye on? And, why does max_used_connections always says: 100? Kinda weird, isn't it? Ciao and thanks! -Gabriele Ciao, Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php