Re: runnning my sql with windows98 and pws
lipp maimone wrote: is someone abble to tell me how can i do for running an sql database with windows98 without crashing my systeme? Also, using asp ( activex server page ), is it possible with mysql version3,23? Its most likely that you don't have enough memory on your system. If you want to run pws and MySQL on Win 98, I would recommend at least 128MB of RAM. Using ASP can be done through MyODBC. Seung-woo Nam - 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: mysqldump on large database..
Wow! What kind of database would have 10,000 tables? Wouldn't you think the database design had a serious flaw in the first place? Seung-woo Nam SDiZ Cheng wrote: When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a Too much opened file error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Can anyone suggest an alternative for mysqldump? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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: Procedures
Hi: There is a perl module for MySQL you can download from cpan. It provides the interface to MySQL database you can use to connect, execute SQL statements from perl programs. Seung-woo Nam John Tsangaris wrote: From the docs, it doesn't look like too much has been done in the area of stored procedures. Are there any resources which would teach me or point me in the right direction to writing procedures for mysql? The manual mentions that it has facility for c++ procedures, but if you want to learn how to write them, you have to look at the code. Also, I have seen reference to Mylua which is a scripting language which allows the writing of procedures. Is there anything perlish? If not, how do I go about writing a perl interface for procedures? jvt - 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: RPM dependency on MySQL-DBI-perl-bin
Hi: I believe MySQL-bench uses Perl program to benchmark databases so that it requires Perl-DBI. DBI is a Perl module that provides API for database connection. I have never installed Perl modules in RPM format but you should be able to find it on RedHat ftp server. And I think the name 'MySQL-DBI-perl-bin' is somewhat misleading because DBI is not tied to any specific databse. DBI module provides general API for databse handling and for MySQL, you also need DBD-MySQL module. Anyway, unless you have a real need of benchmarking MySQL, why bother installing it? Seung-woo Nam Jason Feingold wrote: Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or Perl Mod?), and where i can find it?Ive been looking, but no luck yet. Thanks!jason _ - 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: Query Copying to Temp Table
I don't think you can avoid having those temporary tables in executing any kind of SELECT queries since the retrieved information should be stored somewhere (whether you have ORDER BY or not). I would suggest that if you have a large database, you should considering putting the temporary space on a separate hard drive. Seung-woo Nam Scott wrote: That ORDER by a calculated_field DESC is killing you. It needs to go to a temporary table for sorting. The problem, though, is that even if I leave the ORDER clause out, or ORDER BY any other field, the same thing happens. I initially thought the same thing, but it happens with or without the ORDER BY clause. Scott snip - 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: Population a database
Hi: There are several scripts available at mysql download site that convert access database to an sql dump which you can import into mysql. the sql dump should contain sql for creating tables so you don't have to create tables by yourself. You need to create a database if you want to import the tables into a separate database, though. Seung-woo Nam Luis wrote: Hello all I have a simple question. I have a database in (ms) accesss that I would like to transport into mysql database. First of all ,do i have to create the database plus tables. then import the data . or could i just grab the whole database and tables with all the data inside and import it. is there a how to or a sample of this method Im sorry but I'm new to all this... Thank you very much Luis - 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: starting MySql on redhat 7
bobit wrote: Hi - here's my prob and background info. Tried the fix - it didn't work. MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Any thoughts...? Is MySQL actually running on your system? Even if you installed it, it's not started automatically on RedHat by default. snip My linux book isn't very good on dir permissions. Will chmod change these even if the directory is not empty. You don't use chmod to change permission for directories. Instead you can use chown to change the owner of directories. And how do u list permissions to a directory? ls -l only seems to work for files. ls -l does work for directories. In the error log in the same directory I also get: mysql.host doesn't exist - but this may be a susequent error. I'm a complete newbie so any help would be greatly appreciated. TIA - 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: howto: telnet shell
Why not just telnet into the server where mysql is running and log into mysql from there? That way, there is no need to install mysql client. It look like he already has a telnet client on the computer... Seung-woo Nam [EMAIL PROTECTED] wrote: as someone else has mentioned, you would need to install mysql client into your computer and then use the command mysql -uuserid -hhosename -p to access your remote database. Alan. yes, that is what i am wanting to do. i have found a way around by using uSOFT Query, but would like to get to a command line type connection (remotely). thanks -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 6:53 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: howto: telnet shell do you mean that you want to go into the database console directly from your office? Alan. i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. thanks - 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: reinstall mysql
Hi Have tried to start it manually instead of reinstalling it? Seung-woo Nam Rashid Zolqarnain wrote: Hello, I installed MySql serevr version 3.23.33 on Red Hat Linux 7.0. Sometimes when I reboot the system, MySql do not work. I have to uninstall and then reinstall MySql server. What could be the problem? Rashid - 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: Junk e-mails
Well, this is a public, international mailing list. I wouldn't be surprised if there were more. Seung-woo Nam Quentin Bennett wrote: How come the list is receiving some today? (Raid de Himalaya, Summer of 2001, African American History Minute). Normally we don't get bothered with these. Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 - 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: A newbie question
Hi By saying "mysql -u root mysql" you are telling mysql that you are going to use the database mysql which you have to use to add new users. Another way of doing it is type "mysql -u root" to log in and type "use mysql" in mysql command line. "test" is a database created by mysql by default when you install it so that you can test creating tables and running quieries on it. Seung-woo Nam anil kumar wrote: hello All, I am new to mysql database. I downloaded mysql and running on my system. For adminiatrative purpose the command i run as written in manual is "mysql -u root mysql" I am unable to understand why i have to write mysql after "-u root" why not any other database name "test". I tried to run the command like this "mysql -u root test" and when i tried to add a user i ghot Error Table db.user does not exist. I am unable to understand the meaning of above Error. Please help me to understand the problem. Thanks in advance anil - 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 to change the lib path ...
Hi The config file you are looking for is /etc/my.cnf, I believe. The paths for all mysql related files and dirs are there. Seung-woo Nam "Didier Desmet (RSCA)" wrote: Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help, Didier - 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: Redhat 7 newbie.....
Hi: Make sure MySQL is started when your system boots up. Run 'setup' as root and go to 'System Services' and make sure mysqld is checked. If you want to start the daemon without restarting run '/etc/init.d/mysqld start' as root. Seung-woo Nam Thomas O'Neill wrote: I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not running. I get the ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to use the client. Could someone please clue me in as to home I get this baby going... Thanks! Tom - 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