Re: Is there a limit on the email size for this list?
Hi Egor, I created them according to the INSTALL-BINARY file included in the package downloadable from www.mysql.com I qoute this from the file: // 1. Pick the directory under which you want to unpack the distribution, and move into it. In the example below, we unpack the distribution under `/usr/local' and create a directory `/usr/local/mysql' into which MySQL is installed. (The following instructions therefore assume you have permission to create files in `/usr/local'. If that directory is protected, you will need to perform the installation as `root'.) // Should I not create the directory mysql in /usr/local/ and let gunzip create it for me? Sorry but my knowledge of Linux is desperatly low, I only recently started using the OS and needed a db and mysql seemed like an excellent choice. George On Saturday 23 February 2002 12:42, you wrote: George, Saturday, February 23, 2002, 1:07:38 AM, you wrote: GL Yip somebody pointed me towards the address from the returned mail ;-p. Now GL for the answers to your questions: GL 1. I did create a user and a group for mysql by using: GL shell chown -R root /usr/local/mysql GL shell chown -R mysql /usr/local/mysql/data GL shell chgrp -R mysql /usr/local/mysql GL shell chown -R root /usr/local/mysql/bin Why should you make those dirs by hands? mysql's sources make install will make the dirs for you, the same will do the RPM packages.. GL George - 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
Please help newbie with installation. (I read the manual ;-p)
Sorry to double post to the list. Is there anybody out there using SuSE7.3 with the downloadable 4.0.1 max version of mysql? I truly want to start exploring mysql but I cannot get it to run (see below for first post). Thanks in advance for any advice G Hi, I am running SuSE 7.3 Professional and i downloaded the binary files for Max 4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html I followed the installation procudure to the letter from this file: /mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive. I ran: mysql_install_db without any problems. All the setting were kept exactly as stated in the INSTALL-BINARY file. However I can not run: bin/safe_mysqld --user=mysql as linux root or as any other user on the local host. As a matter of fact the file does not even exist... The closest I have to the above file is: :/usr/local/mysql/bin/mysqld_safe Now I also tried to run this scripts with all user linux accounts and by using the -u root option as oposed to --user=mysql (I also tried --user=root from within all linux accounts. I keep on getting this error: george@linux:/usr/local/mysql ./bin/mysqld_safe --user=root [2] 4727 [1] Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied tee: /usr/local/mysql/data/linux.err: Permission denied 020221 23:17:13 mysqld ended tee: /usr/local/mysql/data/linux.err: Permission denied [2]+ Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql I logged in as linux root and gave all users full access to the /usr/local/mysql directory included files and directories below it. At present I do not know what else I could try. Was the file I downloaded corrupt? My .../mysql/bin/ directory size ATM is: 15,229,278 The mysql directory is a symlink to: /usr/local/mysql-max-4.0.1-alpha-pc-linux-gnu-i686 as described in the file INSTALL-BINARY, I gave all users full access to this directory and all its subdirectories as well (obviously this did not help and I will need to change the security back to where it was). If anybody could please assist me or point me to an URL I will apreciate it. G (mysql, sql) - 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
Is there a limit on the email size for this list?
I posted a question but received a message stating the file was to large? G (mysql, query) - 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: Is there a limit on the email size for this list?
Hi Alastair, Yip somebody pointed me towards the address from the returned mail ;-p. Now for the answers to your questions: 1. I did create a user and a group for mysql by using: shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin 2. Here is the output for the permissions: ls -l /usr/local = george@linux:~ ls -l /usr/local total 9163 drwxr-xr-x2 root root 35 Sep 22 15:08 bin drwxr-xr-x2 root root 35 Sep 22 15:08 etc drwxr-xr-x2 root root 35 Sep 22 15:08 ftp drwxr-xr-x2 root root 35 Sep 22 15:08 games drwxr-xr-x4 root root 80 Feb 21 10:18 httpd drwxr-xr-x2 root root 35 Sep 22 15:08 include drwxr-xr-x2 root root 35 Feb 21 10:25 info drwxr-xr-x2 root root 35 Sep 22 15:08 lib drwxr-xr-x 12 root root 257 Feb 21 08:45 man lrwxrwxrwx1 root mysql 39 Feb 21 10:35 mysql - mysql-max-4.0.1-alpha-pc-linux-gnu-i686 drwxrwxrwx 13 505 mysql 516 Dec 23 17:45 mysql-max-4.0.1-alpha-pc-linux-gnu-i686 -rwxr-xr-x1 root root 9372593 Feb 20 22:48 mysql-max-4.0.1-alpha-pc-linux-gnu-i686.tar.gz drwxr-xr-x2 root root 35 Sep 22 15:08 sbin drwxr-xr-x2 root root 35 Sep 22 15:08 share drwxr-xr-x2 root root 35 Sep 22 15:08 src ls -l /usr/local/mysql = ls -l /usr/local/mysql lrwxrwxrwx1 root mysql 39 Feb 21 10:35 /usr/local/mysql - mysql-max-4.0.1-alpha-pc-linux-gnu-i686 ls -l /usr/local/mysql/data = ls -l /usr/local/mysql/data total 13 -rw-r--r--1 mysqlroot 9900 Feb 21 11:34 linux.err drwxrwxrwx2 mysqlmysql 506 Feb 21 10:45 mysql drwxrwxrwx2 mysqlmysql 35 Dec 23 17:44 test Thanks, George (mysql, query) On Saturday 23 February 2002 00:50, alastair wrote: On Fri, Feb 22, 2002 at 11:21:23PM +0200, George Labuschagne wrote: I posted a question but received a message stating the file was to large? Look at the message. Some idiot's mailbox is over the limit. Anytime I post to this list I get 2 return mails bounced from lusers. With regards to your problem - 1) don't yopu really want to create a mysel user/group and use that as an arg to --user? 2) what are the exact permissions to your data dir? ls -l /usr/local ls -l /usr/local/mysql ls -l /usr/local/mysql/data Cheers, - 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
Newbie needs help with installation.
Hi, I am running SuSE 7.3 Professional and i downloaded the binary files for Max 4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html I followed the installation procudure to the letter from this file: /mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive. I ran: mysql_install_db without any problems. All the setting were kept exactly as stated in the INSTALL-BINARY file. However I can not run: bin/safe_mysqld --user=mysql as linux root or as any other user on the local host. As a matter of fact the file does not even exist... The closest I have to the above file is: :/usr/local/mysql/bin/mysqld_safe Now I also tried to run this scripts with all user linux accounts and by using the -u root option as oposed to --user=mysql (I also tried --user=root from within all linux accounts. I keep on getting this error: george@linux:/usr/local/mysql ./bin/mysqld_safe --user=root [2] 4727 [1] Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql Starting mysqld daemon with databases from /usr/local/mysql/data ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied ./bin/mysqld_safe: /usr/local/mysql/data/linux.err: Permission denied tee: /usr/local/mysql/data/linux.err: Permission denied 020221 23:17:13 mysqld ended tee: /usr/local/mysql/data/linux.err: Permission denied [2]+ Exit 1 ./bin/mysqld_safe --user=root george@linux:/usr/local/mysql I logged in as linux root and gave all users full access to the /usr/local/mysql directory included files and directories below it. At present I do not know what else I could try. Was the file I downloaded corrupt? My .../mysql/bin/ directory size ATM is: 15,229,278 The mysql directory is a symlink to: /usr/local/mysql-max-4.0.1-alpha-pc-linux-gnu-i686 as described in the file INSTALL-BINARY, I gave all users full access to this directory and all its subdirectories as well (obviously this did not help and I will need to change the security back to where it was). If anybody could please assist me or point me to an URL I will apreciate it. G (mysql, sql) - 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
C API example code.
Hi list, Where can I find an online tutorial / example on how to use the C API for mysql? TIA George (mysql, query, sql) - 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: C API example code.
Thanks, I will have a look at the official site. Is anybody aware of a non-oficial site that contains an example with a real db as backend. (With real db I mean tables with a few thousand+ records per table and advanced queries with multiple joins) and then how one can optimise the c code to run optimaly with several clients connecting via the c client code to the server. Egor Egorov [EMAIL PROTECTED] 02/20 5:50 PM George, Wednesday, February 20, 2002, 4:51:32 PM, you wrote: GL Hi list, GL Where can I find an online tutorial / example on how to use the C API GL for mysql? Look in MySQL online documentation about C API: http://www.mysql.com/doc/C/C/C.html GL George GL (mysql, query, sql) -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 - 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
How compressable is a typical MySQL database?
Hi list, How compressible is a typical MySQL database? Is this more dependent on the type of columns used i.e. a lot of text columns as opposed to a lot of columns containing integer values? The uncompressed size of the database is in the region of about 800-MB. Also will it suffice to only compress the specific sub-directory pertaining to the relevant database below /mysql/ ? George mysql, sql, query - 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: How compressable is a typical MySQL database?
Sorry, I forgot to ask the folowing as well. When considering the amount by which text can be compressed as compared to other data types, would it be better to store numerical values as text or to store them as integer/float values. If the db needs to be compressed and backed up on a bi-weekly basis. George tc lewis [EMAIL PROTECTED] 02/17 2:14 AM would probably be very dependent on the data within the database. if it's a lot of text data, then very compressable, as text typically compresses nicely. if you store a bunch of binary data (images or something), then probably not as much... tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking for more compression. test it out. -tcl. On Sun, 17 Feb 2002, George Labuschagne wrote: Hi list, How compressible is a typical MySQL database? Is this more dependent on the type of columns used i.e. a lot of text columns as opposed to a lot of columns containing integer values? The uncompressed size of the database is in the region of about 800-MB. Also will it suffice to only compress the specific sub-directory pertaining to the relevant database below /mysql/ ? George mysql, sql, query - 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 - 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
When does the timestamp field gets updated?
Hi all, If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? Thanks for any info in advance, George mysql, query, sql - 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: Old Messages
Yep I have been getting lots of old messages as well. Sinisa Milivojevic [EMAIL PROTECTED] 02/12 3:43 PM Van writes: Greetings: Anyone else getting lists messages from several days, or longer ago? Phrrrp!: sql database table mysql Van -- = Linux rocks!!! http://www.dedserius.com/ = Me too !! We shall investigate this matter. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 - 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