Some MySQL questions
1) When I select * from whatever; is there a way to have the results go by one screen at a time? 2) In reference to the above, is there a way to just display the row that shows the names of each column? I need to drop one row from a table with a few thousand rows. I guessing I want to: delete from 'users' where COLUMN_NAME = 1898; Is that right? I'm not sure if COLUMN_NAME is uid or id or maye something else, and since I can't pipe it through more or less... :-) -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Some MySQL questions
On 10/8/2009 4:19 PM, John Oliver wrote: 1) When I select * from whatever; is there a way to have the results go by one screen at a time? You can limit output by delimiting your search ie select * from users limit x,y; x=offset y=rows after the ofset 2) In reference to the above, is there a way to just display the row that shows the names of each column? I guess you are talking about describe to show table attributes describe users; I need to drop one row from a table with a few thousand rows. I guessing I want to: delete from 'users' where COLUMN_NAME = 1898; Is that right? I'm not sure if COLUMN_NAME is uid or id or maye something else, and since I can't pipe it through more or less... :-) Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Some MySQL questions
On Thu, Oct 08, 2009 at 02:33:34PM -0700, Carlos Proal wrote: On 10/8/2009 4:19 PM, John Oliver wrote: 1) When I select * from whatever; is there a way to have the results go by one screen at a time? You can limit output by delimiting your search ie select * from users limit x,y; x=offset y=rows after the ofset 2) In reference to the above, is there a way to just display the row that shows the names of each column? You can also use a pager. On my Linux system I can type 'pager less' to use the less program to page through the results. Just type 'pager' to turn go back to normal. I guess you are talking about describe to show table attributes describe users; I need to drop one row from a table with a few thousand rows. I guessing I want to: delete from 'users' where COLUMN_NAME = 1898; Is that right? I'm not sure if COLUMN_NAME is uid or id or maye something else, and since I can't pipe it through more or less... :-) Carlos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=nsulli...@cappex.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Some MySQL questions
Try the tutorial: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Regards, Gavin Towey -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Thursday, October 08, 2009 2:19 PM To: mysql@lists.mysql.com Subject: Some MySQL questions 1) When I select * from whatever; is there a way to have the results go by one screen at a time? 2) In reference to the above, is there a way to just display the row that shows the names of each column? I need to drop one row from a table with a few thousand rows. I guessing I want to: delete from 'users' where COLUMN_NAME = 1898; Is that right? I'm not sure if COLUMN_NAME is uid or id or maye something else, and since I can't pipe it through more or less... :-) -- *** * John Oliver http://www.john-oliver.net/ * * * *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: PHP, MySQL questions
Hi Chaim Contents are going to be dynamic... I will go with Apache 2.2.9 and also PHP with ACP (accelator) Any suggestions? Regards VJ On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger [EMAIL PROTECTED] wrote: VeeJay wrote: Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to show the snip... static or dynamic pages ? apache or lighttp ? -- -- Chaim Rieger -- Thanks! BR / vj
Re: PHP, MySQL questions
VeeJay wrote: Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to show the results... *Hardware: *Dell PowerEdge 2950 III having 2 x CPU 3,0 GHz Intel Xeon L5450 Quad-Core 2x6MB cache WITH 16 GB RAM. *Tools:* 1. FreeBSD 7 Production Release 2. Apache 2.2.9 3. MySQL 5.1.26 4. PHP 5.2.6 My question is, *To get the speed, performance and security*: Should I use Ports or Packages to install all these tools One by One? *OR * Should I use TAR files and compile them manually. For example giving command line arguments and commands like ./configure --prefix=/www --enable-module=so make make install cd ../php-xxx ./configure --with-mysql --with-apxs=/www/bin/apxs make make install etc I have googled but still haven't reached to solution...personally I would prefer comiling them with command line arguments but then I seek some help from you guys i.e. How should I write this ./configure..stuff in FreeBSD and what would be the best options combination, I must choose to get the speed, performane and security in Apache, MySQL and PHP? Any suggestion is very welcomed! This may provide some advice for MySQL of freebsd, looks like you just install it from ports. http://people.freebsd.org/~kris/scaling/mysql.html http://wiki.freebsd.org/MySQL Hope this provides some confidence, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP, MySQL questions
Hi there I am going to make 2 Webserver at my work going to handle 50 mil hits per month... They are using Linux already. But being a FreeBSD fan, I have proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD is more Fast and Secure solution for his needs... And now I want to show the results... *Hardware: *Dell PowerEdge 2950 III having 2 x CPU 3,0 GHz Intel Xeon L5450 Quad-Core 2x6MB cache WITH 16 GB RAM. *Tools:* 1. FreeBSD 7 Production Release 2. Apache 2.2.9 3. MySQL 5.1.26 4. PHP 5.2.6 My question is, *To get the speed, performance and security*: Should I use Ports or Packages to install all these tools One by One? *OR * Should I use TAR files and compile them manually. For example giving command line arguments and commands like ./configure --prefix=/www --enable-module=so make make install cd ../php-xxx ./configure --with-mysql --with-apxs=/www/bin/apxs make make install etc I have googled but still haven't reached to solution...personally I would prefer comiling them with command line arguments but then I seek some help from you guys i.e. How should I write this ./configure..stuff in FreeBSD and what would be the best options combination, I must choose to get the speed, performane and security in Apache, MySQL and PHP? Any suggestion is very welcomed! -- Thanks! BR / vj
Re: Data Warehouse on MySQL questions
Hey Baron, Your blog post was quite informative; your suggestion to use a combination of merged MyISAM tables and InnoDB for the live partition made a lot of sense, and it sounds like the path I'll need to follow. I appreciate the information! Baron Schwartz wrote: Hi, I'll just address the things others didn't answer. On Thu, Apr 3, 2008 at 2:28 PM, Dre [EMAIL PROTECTED] wrote: 1) Several sources seem to suggest MyISAM is a good choice for data warehousing, but due to my lack of experience in a transaction-less world, One approach you might consider is using MyISAM tables and MERGE tables together. This makes it much easier to remove old data, if that is a concern, and keeps each table a manageable size. For example, put each day's data in a new MyISAM table and then create a MERGE over them. You might also look into MySQL 5.1's partitioning, too. Brian Miezejevski gave a great session on this at last year's MySQL Conference. The slides don't seem to be available online, but I wrote up my notes on the session: http://www.xaprb.com/blog/2007/04/27/mysql-conference-and-expo-2007-day-4/ You can probably email him and get the slides as well. Regards Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data Warehouse on MySQL questions
Hi, I'll just address the things others didn't answer. On Thu, Apr 3, 2008 at 2:28 PM, Dre [EMAIL PROTECTED] wrote: 1) Several sources seem to suggest MyISAM is a good choice for data warehousing, but due to my lack of experience in a transaction-less world, One approach you might consider is using MyISAM tables and MERGE tables together. This makes it much easier to remove old data, if that is a concern, and keeps each table a manageable size. For example, put each day's data in a new MyISAM table and then create a MERGE over them. You might also look into MySQL 5.1's partitioning, too. Brian Miezejevski gave a great session on this at last year's MySQL Conference. The slides don't seem to be available online, but I wrote up my notes on the session: http://www.xaprb.com/blog/2007/04/27/mysql-conference-and-expo-2007-day-4/ You can probably email him and get the slides as well. Regards Baron -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Data Warehouse on MySQL questions
Hey folks, I'm currently deciding whether to build a decent sized (around 300-500GB, although honestly, I've got little to base that on at the moment) data warehouse in postgreSQL or MySQL. I've developed several in MS SQL and postgreSQL, but the client is comfortable with MySQL, and I'd prefer to use that as the platform since it will be less painful for them to manage when I'm gone. I'm hoping that someone with experience building a warehouse on MySQL will be able to answer two outstanding questions I have: 1) Several sources seem to suggest MyISAM is a good choice for data warehousing, but due to my lack of experience in a transaction-less world, this makes me a little nervous. How do you handle data inconsistency problems when ETL jobs fail? (For the record, I don't use a separate tool for the ETL; I usually use perl/shell scripts to interact with the file system, and pl/pgsql or transact-sql once the data is loaded into the staging database. For each file that is loaded, I'll identify steps that must be posted together, and wrap them in a transaction in the ETL job.) I can see doing something like manually cleaning out the necessary tables before you re-run, but that seems a bit messy to me. Anyone figure out a better approach? 2) Isn't the lack of bitmap indexes a problem in the warehouse? Most FKs in the fact tables will be low cardinality columns; queries that didn't use date would be very slow on large fact tables (MS SQL had this problem). Has anyone run into this with MySQL? Many thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data Warehouse on MySQL questions
I've built several datamarts using perl and MySQL. The largest ones have been up to about 30GB, so I'm not quite on your scale. for #1, I have an etl_id in the fact table so I can track back any particular ETL job. I typically make it a dimension and include date, time, software version, etc. That doesn't help so much if you're messing up your dimension tables, but I haven't typically run into that problem based on the designs I've used. For #2, I haven't built anything big enough for it to be a concern yet.. Also, LOAD DATA INFILE is your friend :) On Thu, Apr 3, 2008 at 11:28 AM, Dre [EMAIL PROTECTED] wrote: Hey folks, I'm currently deciding whether to build a decent sized (around 300-500GB, although honestly, I've got little to base that on at the moment) data warehouse in postgreSQL or MySQL. I've developed several in MS SQL and postgreSQL, but the client is comfortable with MySQL, and I'd prefer to use that as the platform since it will be less painful for them to manage when I'm gone. I'm hoping that someone with experience building a warehouse on MySQL will be able to answer two outstanding questions I have: 1) Several sources seem to suggest MyISAM is a good choice for data warehousing, but due to my lack of experience in a transaction-less world, this makes me a little nervous. How do you handle data inconsistency problems when ETL jobs fail? (For the record, I don't use a separate tool for the ETL; I usually use perl/shell scripts to interact with the file system, and pl/pgsql or transact-sql once the data is loaded into the staging database. For each file that is loaded, I'll identify steps that must be posted together, and wrap them in a transaction in the ETL job.) I can see doing something like manually cleaning out the necessary tables before you re-run, but that seems a bit messy to me. Anyone figure out a better approach? 2) Isn't the lack of bitmap indexes a problem in the warehouse? Most FKs in the fact tables will be low cardinality columns; queries that didn't use date would be very slow on large fact tables (MS SQL had this problem). Has anyone run into this with MySQL? Many thanks in advance! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data Warehouse on MySQL questions
On Thu, Apr 3, 2008 at 2:28 PM, Dre [EMAIL PROTECTED] wrote: 1) Several sources seem to suggest MyISAM is a good choice for data warehousing, but due to my lack of experience in a transaction-less world, this makes me a little nervous. MyISAM has the advantage of very fast loading. It's much faster to load than InnoDB. However, InnoDB had better query performance on the warehouse data I used. How do you handle data inconsistency problems when ETL jobs fail? Usually, with a warehouse system the answer is that you rebuild it. I have built an incrementally loading ETL system, but I was under the impression that is not the norm. I can see doing something like manually cleaning out the necessary tables before you re-run, but that seems a bit messy to me. Anyone figure out a better approach? I think it's pretty common to use a Y-loading approach, with one empty schema and then do an atomic RENAME at the end to swap the new tables into place. When I used MyISAM tables, I did it that way. 2) Isn't the lack of bitmap indexes a problem in the warehouse? Most FKs in the fact tables will be low cardinality columns; queries that didn't use date would be very slow on large fact tables (MS SQL had this problem). Has anyone run into this with MySQL? You can bundle up low-cardinality columns by using a junk dimension. It made a big difference for me. You make a table with all of the combinations of the low-cardinality fields and assign a key to each combination. There are some good presentation on data warehousing available from the website for the MySQL Users Conference. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading mysql questions
Hi, I'm currently running several Joomla websites and phpBB forums on an old FreeBSD server running mysql-server 3.23. Yesterday I upgraded the mysql installation to 4.0.27 successfully. No problems at all. First I made backups, then deinstalled mysql 3.23 and finally installed 4.0.27. I then ran the mysql_fix_privilege_tables script which gave me some warnings, but seemed OK. The test forum and databases started up fine. Soon, I'll upgrade to 4.1 and then later to version 5 of the mysql server. My question is: When upgrading mysql-server and running suggested/included update scripts etc, do they only affect the base mysql server (and associated files)? What about all the databases (Ie. phpBB/Joomla) that was created under 3.23, should I run some sort of upgrading script on these also? Need some advice here. Sounds logic to me that they also need to be updated/optimized for the new system - somehow. I hope someone will be able to assist me a little here. Thanks and best regards, Andreas
2+1 MySQL Questions
Hi all I've installed MySQL on my Ubuntu Linux system. Then I installed MySQL Query Browser on my Win XP laptop. I've created a user for the MySQL which in the host field I've put %, I guess it means access from every IP (am I right?) But I cant connect to the MySQL instance. What could be wrong? Also, I created the user using mysqlcc but it doesn't save the password. I created a user with a password but I can only login with that user when I don't pass the password. How can I create users manually? Is there any commands for this? And finally, is there a .deb package available for MySQL Query Browser and Administrator? Best Regards, -- Behrang Saeedzadeh http://www.jroller.com/page/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: 2+1 MySQL Questions
Creating users in mysql is: GRANT ALL|[CREATE|UPDATE|etc.)] PRIVILEGES ON dbname.tablename TO [EMAIL PROTECTED] IDENTIFIED BY password If you want to check the grants to see if you've created that user correctly, try: SHOW GRANTS FOR [EMAIL PROTECTED] Michael -Original Message- From: Behrang Saeedzadeh To: mysql@lists.mysql.com Sent: 2/13/2005 1:42 PM Subject: 2+1 MySQL Questions Hi all I've installed MySQL on my Ubuntu Linux system. Then I installed MySQL Query Browser on my Win XP laptop. I've created a user for the MySQL which in the host field I've put %, I guess it means access from every IP (am I right?) But I cant connect to the MySQL instance. What could be wrong? Also, I created the user using mysqlcc but it doesn't save the password. I created a user with a password but I can only login with that user when I don't pass the password. How can I create users manually? Is there any commands for this? And finally, is there a .deb package available for MySQL Query Browser and Administrator? Best Regards, -- Behrang Saeedzadeh http://www.jroller.com/page/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.h *mysql / questions
Hello, I was just going through mysql.h, in st_mysql. i found a variable my_bool free_me, what is the significance of this variable ? Another question that has been bothering me - What happens if a query has been started with mysql_real_query() and then for some reason mysql_close() is used to close the connection (of course this happens in a separate thread) What would happen to the resources the closed_query had been using ? With the normal Mysql server , with the embedded server ? Thank you Gamin
New to mySQL questions.
Hi Just a quick question. I was reading the manuals on the MySQL web regarding the initial setup of the program. I have installed the program and all is going well and have a user called root with full access and another user called mysql with limited rights (used mainly for PHPmyAdmin). There is a database called mysql which contains all the users, rights and privalages. The question I would like to ask is that there is another database called test whcih I belive from reading is a databse that users can connect to annoymously. Can I delete this database as I do not want anyone to connect without a user profile and password. Does it cause a problem deleting this database. Also while I am here can any one advise or tell me where to go in respects of accessing data to/from the database in a php form if the database users have a password. Or am I totally off track and you do not need a password or user in the php page as it is running locally. If anyone has a sample database and some php forms to interact with the databse they could let me see to learn from, it would be very much appreciated. Thanks for all your help Ray Healy - 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: New to mySQL questions.
Ray: The only database you shouldn't mess with is the mysql database ... it is the equivalent of the 'master' database found in other systems, and contains all of the rights and privileges you invoke. Get to know the 'GRANT' command in the MySQL Manual (http://www.mysql.com/manual.php) ... therein you will find the answers to questions about user rights and privileges and a whole lot more. For PHP script samples, it is hard to beat http://www.hotscripts.com/PHP. Gerald Jensen - Original Message - From: Ray Healy (Data Net Services) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 28, 2002 6:25 AM Subject: New to mySQL questions. Hi Just a quick question. I was reading the manuals on the MySQL web regarding the initial setup of the program. I have installed the program and all is going well and have a user called root with full access and another user called mysql with limited rights (used mainly for PHPmyAdmin). There is a database called mysql which contains all the users, rights and privalages. The question I would like to ask is that there is another database called test whcih I belive from reading is a databse that users can connect to annoymously. Can I delete this database as I do not want anyone to connect without a user profile and password. Does it cause a problem deleting this database. Also while I am here can any one advise or tell me where to go in respects of accessing data to/from the database in a php form if the database users have a password. Or am I totally off track and you do not need a password or user in the php page as it is running locally. If anyone has a sample database and some php forms to interact with the databse they could let me see to learn from, it would be very much appreciated. Thanks for all your help Ray Healy - 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
two mysql questions
1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best Windows based MySQL GUI out there, without regard to price? Thanks, -billb - 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: two mysql questions
As long as you need to create InnoDB table you have to use MAX binary... Check out phpmyadmin, it is totally free and operating system-independent since it runs from the server and can be used through the web browser.. Take a look at it at : http://www.phpmyadmin.net/ Gurhan - Original Message - From: Bill Bernat [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 02, 2002 6:14 PM Subject: two mysql questions 1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) 2. What's the best Windows based MySQL GUI out there, without regard to price? Thanks, -billb - 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
Re: two mysql questions
At 15:14 -0700 7/2/02, Bill Bernat wrote: 1. If all I want to do is use InnoDB tables for declarative referential integrity and nothing else, do I need mysql-max or can I just use the standard build of mysql 3.23.51? (Wondering about both Windows and Linus, though the answer should be the same in both places) If you use a binary distribution, you need -max. If you build from source, you can configure it as you like. - 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: mysql questions
Taken from an email from Mike(mickalo)Blezien [EMAIL PROTECTED] If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. - Original Message - From: Cedric Tardif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 1:49 PM Subject: mysql questions Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to deny access to this command so they can't see with database are running on this server. Regards Cédric - 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
Fw: mysql questions
Taken from an email from Mike(mickalo)Blezien [EMAIL PROTECTED] If you use the 'skip-show-database' in the [mysqld] group in the my.cnf file, this will give you the same results at start up [mysqld] skip-show-database This will then disable any user from viewing other databases they do not have access too. - Original Message - From: Cedric Tardif [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 12, 2001 1:49 PM Subject: mysql questions Hi all, 2 littles questions. 1. How can i log all connection attempt to the mysql database without logging all the query in the mysql database ? 2. It is possible to prevent user to the 'show database' command, i know they can't use it depending on the right granted but it will be pleasent to deny access to this command so they can't see with database are running on this server. Regards Cédric - 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
ERWIN, stored procedure, release date MySql questions
I am not a subscriber to this message board, please copy replies to [EMAIL PROTECTED] Greetings, A few questions - *regarding trying to determine how to use stored procedures with Mysql, 1 approach I have heard is to put all your sql in a text file -how does this compare to just embedding the SQL in your program/business logic ? *when is the release data of 4.0, and what is the release date and version for support for mysql stored procedures ? mysql.com is non specific about either. * Regarding ERWIN I see you can dump the model into the good old DBF files, but then what are the steps for mysql to use them next ? * Also, on ERWIN, it today automatically creates for example ms sqlserver stored procedures for cascade delete and copy logic within the data model. question is can it generate *generic* sql that could be used for another vendor db, say mysql ? Thanks, Steve ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ - 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
ERWIN, stored procedure, release date MySql questions
Greetings, A few questions - *regarding trying to determine how to use stored procedures with Mysql, 1 approach I have heard is to put all your sql in a text file -how does this compare to just embedding the SQL in your program/business logic ? *when is the release data of 4.0, and what is the release date and version for support for mysql stored procedures ? mysql.com is non specific about either. * Regarding ERWIN I see you can dump the model into the good old DBF files, but then what are the steps for mysql to use them next ? * Also, on ERWIN, it today automatically creates for example ms sqlserver stored procedures for cascade delete and copy logic within the data model. question is can it generate *generic* sql that could be used for another vendor db, say mysql ? Thanks, Steve ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ - 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
General MySQL Questions
Greetings! I am one of the developers of a MUD, and we have recently decided to rewrite our entire driver to C++/OOP and use MySQL to store our data, so it has become my duty to begin to learn about all the facets of MySQL. I have been going through FAQs, manuals, etc, and we are also using MySQL++ to interface to the database. Here are a few general questions that I've got at this point: 1. We would like to make saving/retrieving information from the database non-blocking, if possible. Does anyone have any suggestion for this? Our thoughts were to write an external program to fetch information and return it to our main program; is there any easier way to handle this? Is it even necessary to make calls to the database non-blocking? 2. When our driver boots and begins accepting connections, would it be more feasible to read the various tables into memory structures, rather than querying the database everytime we need information on a specific item within the game? Thanks for your help! Also, if anyone might be willing to help us in a forum other than the list, a personal reply would be great. (it would not, of course, be a paying position, but just for asking advice) --- Jon A. Nielsen Lazarus of Spear of Insanity MUD http://spear.kilnar.com/ telnet://spear.kilnar.com:1066/ - 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