The table 'SQLb73d_0' is full
mysql> insert into table1 select distinct field1 , MIN(field2) from table2 where field2 >="2001-12-01 00:00:00" group by field2 ; ERROR 1114: The table 'SQLb73d_0' is full mysql> please help to fix this error - 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: Newbie alert!
Rick, The error suggests that libmysqlclient is not in /usr/local/lib/mysql. the -L must refer to the directory containing libmysqlclient.a for the compile to succeed. John Lodge -Original Message- From: Rick Runowski [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 11:18 PM To: [EMAIL PROTECTED] Subject: Newbie alert! All, I am having difficulty compiling a piece of software. If I try compiling with the following: gcc dnd.cpp -o dnd3 -L /usr/local/lib/mysql -lmysqlclient as suggested in "Core MySQL by Leon Atkinson" on page 436, I get the error: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status As an experiment I tried g++ dnd.cpp -o dnd3 and my compiler belched up the following: /tmp/cco2LOOc.o: In function "mon_list(void): /tmp/cco2LOOc.o(.text+0x872): undefined reference to 'mysql_init' /tmp/cco2LOOc.o(.text+0x89e): undefined reference to 'mysql_real_connect' /tmp/cco2LOOc.o(.text+0x8b2): undefined reference to 'mysql_error' etc. I think it lists every mysql command I used. I have copied the code almost directly out of the book (changing server name, user name, and table name). I am running Red Hat 7.1 and I have checked that the header files are there. Any suggestions? Thank you, Rick - 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: Could you help me?
Hi, On Tue, 2002-02-19 at 16:25, S Aravind wrote: > My company has developed a project using Java and > Oracle. The client for whom the project has been > developed wants mySQL. As a member of the team, I've > been asked to find out the basic differences between > Oracle SQL queries and your mySQL queries. I tried my > level best on all search engines, but not in a > position to get a clear answer. > > Could you help me out solve this problem? I'm > reponsible for giving a presentation that shows the > basic and core differences. > > I shall be beholden and obliged. Honestly I'm also new > for mySQL. It's not as easy as that, I'm afraid ;-) Yes they are both RDBMS, but the number of features and options in both are so large and diverse that a simple comparison won't do justice to either. You also have to realise that it is not MySQL's objective to be an Oracle clone, MySQL has its own roadmap, priorities and strengths. And of course if you look at from the Oracle angle, then it will quickly be apparently that some features are "lacking" in MySQL. The question is though do you want or need those particular featues? You're dealing with an existing application, so what you'll want to look at is which features it uses that may be implemented differently on MySQL, or not supported. Then, point by point, you'll want to find out how difficult it would be to work around these differences. Naturally, if your application is stuffed full with views, stored procedures, triggers and subqueries, the outlook might be a bit bleak if you're in a rush. But I'll bet that your app is not like that it's quite likely to be using some subqueries (since that is what people are used to writing), but lots of those can be easily rewritten with joins in a single select, and the rest can be recoded as multiple SELECTs, possibly using MySQL's very nice support for temporary/heap tables. So what do you get with MySQL? - Low system (CPU/RAM/HD) requirements and fairly easy installation. - Low total cost of ownership. (Either or both of these may be particularly important to your clients!) - Professional support, consulting, training available. - You can get fairly direct contact with the developers, and that's something Oracle won't be offering you ;-) - Quick resolution of bugs, patches immediately available. - Very fast support, naturally depending on support contract. - Speed. Of course this depends on how you design your application. - Special features, particularly useful in for instance web applications (like the LIMIT clause, replication, the query cache, etc). - Full ACID transactional support with multi-versioning/row-level locking, using the InnoDB table handler. This is only a small excerpt... have a browse in the online manual (www.mysql.com/doc/) to get more ideas, since you know Oracle you can recognise differences and nice features when you spot them, and take notes. You may wish to contact [EMAIL PROTECTED] to talk about possible assistance for adapting your application, and maybe even for your presentation. Since you said you're new to MySQL, I might also suggest training (www.mysql.com/training/). While MySQL is not difficult to work with, naturally you won't become an instant expert just by taking a quick look at it. You can accelerate this learning curve with training. This may help you both with the decision making process, as well as possible porting. Both consulting and training could speed up either or both processes, which of course would reduce the development costs for you. Hope this helps! Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ 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
The table 'SQLb73d_0' is full
mysql> insert into table1 select distinct field1 , MIN(field2) from table2 where field2 >="2001-12-01 00:00:00" group by field2 ; ERROR 1114: The table 'SQLb73d_0' is full mysql> please help to fix this error Name : Mohamed Abd El-Samei Mohamed Title : System Administrator Comp. : Soficom Communications S.A.E Tele. : 737-1952/3 Fax : 7547415 E-mail: [EMAIL PROTECTED] - 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: row level privilages - thoughts on how to do
For reasons of the end-arounds you note it really has to be in the server. As mentioned views are a possibility, but could end up being just as messy as a middle tier. It sounds like what you want is integrated (with the OS) security (as in MS SQL); I don't know if this is on the plate, but I'm sure it could be done in a future version. :) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 10:40 PM > To: [EMAIL PROTECTED] > Subject: row level privilages - thoughts on how to do > > > Hi all, > > I'm wondering about row level privilages - being able to restrict what > people see and can update etc on a row level as well as a column/table > level. > > I know that I can implement it in my program (which is what > I'm currently > doing) but unless it's in the backend db then every program > that is written > to work with the data must also include it and it doesn't > protect against > people using a client to connect directly and make changes or > view data they > shouldn't see. > > The only other way I've thought of is to have all of the > programs go through > middleware sort of thing that implements this and then > accesses mysql using > it's own login so that no one has direct access to mysql, but > it is messy > and means that much of the built in security in mysql would need to be > duplicated by the middleware, and it would probably be slow etc etc. > > So, anyone got any ideas about how you'd best go about this? Will > triggers/ store proceedures help (or does it need to be in > the engine of the > database to really work)? > > Any thoughts appreciated, > > cheers, > > noel > > - > 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
Exceeding 4.2GB data files on Solaris8...?
By chance, is it at all possible to exceed the 4.2GB file size barrier on Solaris 8 with MySQL 3.23.47? I've got one built with both GCC and another one with the Solaris Workshop 6 compiler.. Neither can exceed that magical number for some reason.. Both were built with large-files enabled.. In fact, when using the Solaris Workshop compiler, I forced each and every compiler line to have : -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 That didn't appear to make any difference.. I've also enabled largefiles as part of mounting my UFS file system -- I ran across that somewhere on the net.. Is there something I'm missing? I'm also doing similar tests on AIX and HP-UX 11i concurrently.. Those didn't even get as far as Solaris (2.1gb for them), but I didn't have large file support enabled for the respective volume managers.. If you've got any ideas, I'm happy to try it out! Here's what I get when I try to add one more record : % ./bin/mysql capacity Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> insert into test_capacity ( id, name, description, create_time, update_time, bit_flags ) values (59708440, 'Record #59708440', 'Description for Record #59708440', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 59708440); ERROR 1114: The table 'test_capacity' is full mysql> show table status; +---+++--++- +-+--+---++- +-+++-+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++--++- +-+--+---++- +-+++-+ | test_capacity | MyISAM | Dynamic| 59708440 | 71 | 4294967272 | 4294967295 |489195520 | 0 | NULL | 2002-02-06 17:53:01 | 2002-02-07 08:30:52 | NULL || | +---+++--++- +-+--+---++- +-+++-+ 1 row in set (0.00 sec) mysql> describe test_capacity; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | id | int(11) | | PRI | 0 | | | name| varchar(65) | YES | | NULL| | | description | varchar(255) | YES | | NULL| | | create_time | timestamp(14) | YES | | NULL| | | update_time | timestamp(14) | YES | | NULL| | | bit_flags | int(11) | YES | | NULL| | +-+---+--+-+-+---+ 6 rows in set (0.00 sec) mysql> Bye - 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: Could you help me?
you can find a list of what MySQL does not yet support in the table near the bottom of this page: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.h tml#Comparisons Note that the latest stable/release version of MySQL is 3.x. Oracle is going to support a lot more of the SQL syntax than does MySQL at this point. You'll have to decide which features you need and which you don't, or can work around. > -Original Message- > From: S Aravind [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 1:26 AM > To: [EMAIL PROTECTED] > Subject: Could you help me? > > > Hi! > > My company has developed a project using Java and > Oracle. The client for whom the project has been > developed wants mySQL. As a member of the team, I've > been asked to find out the basic differences between > Oracle SQL queries and your mySQL queries. I tried my > level best on all search engines, but not in a > position to get a clear answer. > > Could you help me out solve this problem? I'm > reponsible for giving a presentation that shows the > basic and core differences. > > I shall be beholden and obliged. Honestly I'm also new > for mySQL. > > Aravind > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.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
RE: How can i acheive 'Triggers' in MySQL
Triggers are evil incarnate, and notoriously har to debug. Skip triggers entirely and use a stored procedure to do everything you need the trigger to do (again, when SP's are available :\ ) greg > -Original Message- > From: Carsten Gehling [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 19, 2002 12:18 AM > To: sreedhar; mysql > Subject: Re: How can i acheive 'Triggers' in MySQL > > > From: "sreedhar" <[EMAIL PROTECTED]> > Sent: Saturday, February 16, 2002 6:03 AM > > > > How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. > > By sitting tight and waiting, just like the rest of us :-) > > http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html > > - Carsten > > > > > - > 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
Could you help me?
Hi! My company has developed a project using Java and Oracle. The client for whom the project has been developed wants mySQL. As a member of the team, I've been asked to find out the basic differences between Oracle SQL queries and your mySQL queries. I tried my level best on all search engines, but not in a position to get a clear answer. Could you help me out solve this problem? I'm reponsible for giving a presentation that shows the basic and core differences. I shall be beholden and obliged. Honestly I'm also new for mySQL. Aravind __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.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
MySQL Timeout setting problem
Hai, MySQL server gets shutdown after 8hrs if not accessed. I added a variable in the my.cnf file which increases this default setting. set-variable=wait_timeout=86400 --for 24 hrs Even then the server is getting disconnected after 8hrs of non usage. What might be the problem do I need to add any other parameter. I am using MySQL 3.23.40-Linux version. Please let me know ASAP. Regards, Bhargav. ___ MVS. Bhargav. Project Leader (VisualSoft eSales) VisualSoft Technologies. VisualSoft Towers, 6-3-1192/2/1, Kundanbagh, Hyderabad - 500 016. Ph: 3412266 Extn: 4026. - 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
double outer joins in mysql?
hi, I'm wondering if anyone knows if it's possible to do a double-outer join in mysql. by that I mean outer-joining on two tables instead of one (both from the same original table). in other words, whereas a normal outer join might go something like this: select b.date, u.name from billing b outer join users u on b.user_id=u.user_id ...I'm trying to do something more like this: select b.date, u.name, l.city from billing b outer join users u on b.user_id = u.user_id, locations l on b.location_id = l.location_id (that syntax is bogus) but does anyone know if this is even possible? thanks, todd - 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
MySQL server gets shutdown after 8 hrs of no usage
Hai, MySQL server gets shutdown after 8hrs of non usage. I added a variable in the my.cnf file which increases this default setting. set-variable=wait_timeout=86400 --for 24 hrs Even though the server is getting disconnected after 8hrs of non usage. What might be the problem do i need add any another parameter. I am using MySQL 3.23.40-Linux version. Thanks in advance Aravind Gorthy, VisualSoft Technolgies, Hyderabad-India. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 can i acheive 'Triggers' in MySQL
Hi all, How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. Regards, sreedhar - 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 can i acheive 'Triggers' in MySQL
From: "sreedhar" <[EMAIL PROTECTED]> Sent: Saturday, February 16, 2002 6:03 AM > How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. By sitting tight and waiting, just like the rest of us :-) http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html - Carsten - 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 can i acheive 'Triggers' in MySQL
Hi all, How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. Regards, sreedhar - 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: row level privilages - thoughts on how to do
On Mon, 2002-02-18 at 21:40, [EMAIL PROTECTED] wrote: > I'm wondering about row level privilages - being able to restrict what > people see and can update etc on a row level as well as a column/table > level. > So, anyone got any ideas about how you'd best go about this? Will > triggers/ store proceedures help (or does it need to be in the engine of the > database to really work)? Having implemented something of this nature on another RDBMC, I have to say that I do not think this would easily be acomplished with MySQL's current feature-set. If you want this controlled strictly by the database (and that is not necessarily the best solution), you will either need stored procedures which implement a home-grown security model (easily side-stepped by a direct connection to the database), or views (with a custom set of views for every table for every "access level"). Someone far wiser than I may have a better idea, but if you want to be able to implement row-level security even with a direct connection to the DB (and cannot "implement" this by simply placing the tables into several databases), you need views. - 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
row level privilages - thoughts on how to do
Hi all, I'm wondering about row level privilages - being able to restrict what people see and can update etc on a row level as well as a column/table level. I know that I can implement it in my program (which is what I'm currently doing) but unless it's in the backend db then every program that is written to work with the data must also include it and it doesn't protect against people using a client to connect directly and make changes or view data they shouldn't see. The only other way I've thought of is to have all of the programs go through middleware sort of thing that implements this and then accesses mysql using it's own login so that no one has direct access to mysql, but it is messy and means that much of the built in security in mysql would need to be duplicated by the middleware, and it would probably be slow etc etc. So, anyone got any ideas about how you'd best go about this? Will triggers/ store proceedures help (or does it need to be in the engine of the database to really work)? Any thoughts appreciated, cheers, noel - 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
CAN'T DOWNLOAD mySQL.
Hello, I am very interested in mySQL but I haven't been able to download it: --> The download wndow said 11.9 Mbytes received, but the file is on;ly 3.8 MByte. It happened from 4 download sites. --> Any idea/suggestion about this ? THANKS !, Hernan _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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
Table overhead --
Anyone know what causes "overhead" on a MySQL table? I wrote a JSP application using MySQL that uses updates and Inserts and have found that a lot of "overhead" exists. Of course if the table is optimized - the overhead is cleared. Anyone had similar issues? Thanks Mark - 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: Faxing from MySQL
In Faxing from MySQL, <[EMAIL PROTECTED]> wrote: > >Hi there. Anybody know how I can fax using MySQL? I might have an >application for this. Pretty simple problem for the APIs, you would probably spend longer on a web search for a software package then writing it. Of course, one can spice it up some too. - 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
get instance variable
Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query "show variables" can do this. Thanks and regards Robert Li Computer Associates R&D Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] - 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: GetDefaultConnect
Hi, > -Original Message- > From: Massimo Colurcio [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 6:19 PM > To: [EMAIL PROTECTED] > Subject: GetDefaultConnect > > > Hi, I'm having some problems using MySQL ODBC Driver release > 3.51. When I try to call GetDefaultConnect() from an > opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' > behaviour of the driver; the return string is: > > ODBC;WeissDBMySQL ODBC 3.51 > Driver;DESC=;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PASSWOR > D=;PORT=;OPTION= > 16387;STMT=; > > ['WeissDBMySQL ODBC 3.51 Driver' should be 'DNS=WeissDB'] > This is a know issue due to invalid build of the driver from different src tree, and was fixed last week itself. To have a fix, you need collect the patch and apply it from: ftp://support.mysql.com/pub/mysql/hidden/myodbc/MyODBC-3.51.01.01.zip Or, pull the latest code from development tree, and build the driver yourself. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ 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
Re: How to restore all databases in one instance?
At 13:13 +1100 2/19/02, Li, Robert wrote: >Hi, all >As we know, we can backup all dbs in one instance >using "mysqldump --alldatabases > all_db.sql", >so can we restore all of these dbs from "all_db.sql" in one time? >Mysql client program "mysql" can only restore one database >per time---mysql sample_db < sample_db.sql. >Thanks in advance. Why do you say that? The output from mysqldump --all-databases includes the appropriate USE statements to switch databases. > >Best regards > >Robert Li >Computer Associates >R&D Centre Beijing , China >Tel:+86 10 6561 1136 ext 852 (O) >+86 10 6731 1652 (H) >Fax:+86 10 8529 8979 >E-mail: [EMAIL PROTECTED] > > >>>-Original Message- >>>From: Sammy Lau [mailto:[EMAIL PROTECTED]] >>>Sent: Saturday, December 29, 2001 6:06 PM >>>To: Li, Robert; [EMAIL PROTECTED] >>>Subject: Re: how to setup Mysql multiple instances >>> >>> >>>http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ >>>L_Database_Adm >>>inistration.html#Multiple_servers >>>- Original Message - >>>From: "Li, Robert" <[EMAIL PROTECTED]> >>>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >>>Sent: Saturday, December 29, 2001 5:58 PM >>>Subject: how to setup Mysql multiple instances >>> >>> Hi,all MySQL teams: First let me wish you all happy new year! Wish Mysql win more victories in DB area. I am a programmer in CA. I know Mysql supports multiple instances. One way is to install different servers, on each server, runs an instance. The other way is to use one server, one installation to run multi instances. Now i can setup the environment in the first way. I want to know how to setup in the second way. Would you pls kindly help me to solve this problem? Thank you very much! Regards Robert Li Computer Associates Programmer, R&D Beijing (China) Tel: +86 10 65611136 ext 852 Fax: +86 10 85298979 > >>> [EMAIL PROTECTED] - 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
GetDefaultConnect
Hi, I'm having some problems using MySQL ODBC Driver release 3.51. When I try to call GetDefaultConnect() from an opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' behaviour of the driver; the return string is: ODBC;WeissDBMySQL ODBC 3.51 Driver;DESC=;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PASSWORD=;PORT=;OPTION= 16387;STMT=; ['WeissDBMySQL ODBC 3.51 Driver' should be 'DNS=WeissDB'] Using the 2.5.3900 release of the same driver I get this result (seems correct to me): ODBC;DNS=WeissDB;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PWD=;PORT=;OPTION=0;STMT=; Is there something wrong in the driver? Am I doing something wrong? TIA, Massimo. ___ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #96413649 SONORK 100.10862 ATIC #1219 - 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
GetDefaultConnect
Hi, I'm having some problems using MySQL ODBC Driver release 3.51. When I try to call GetDefaultConnect() from an opened CRecordset object (Viual C++ 5.0, MFC), I see a 'weird' behaviour of the driver; the return string is: ODBC;WeissDBMySQL ODBC 3.51 Driver;DESC=;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PASSWORD=;PORT=;OPTION= 16387;STMT=; ['WeissDBMySQL ODBC 3.51 Driver' should be 'DNS=WeissDB'] Using the 2.5.3900 release of the same driver I get this result (seems correct to me): ODBC;DNS=WeissDB;DATABASE=WeissDB;SERVER=lovalhost;UID=weissdb;PWD=;PORT=;OPTION=0;STMT=; Is there something wrong in the driver? Am I doing something wrong? TIA, Massimo. ___ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #96413649 SONORK 100.10862 ATIC #1219 - 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 to restore all databases in one instance?
Hi, all As we know, we can backup all dbs in one instance using "mysqldump --alldatabases > all_db.sql", so can we restore all of these dbs from "all_db.sql" in one time? Mysql client program "mysql" can only restore one database per time---mysql sample_db < sample_db.sql. Thanks in advance. Best regards Robert Li Computer Associates R&D Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) +86 10 6731 1652 (H) Fax:+86 10 8529 8979 E-mail: [EMAIL PROTECTED] >>-Original Message- >>From: Sammy Lau [mailto:[EMAIL PROTECTED]] >>Sent: Saturday, December 29, 2001 6:06 PM >>To: Li, Robert; [EMAIL PROTECTED] >>Subject: Re: how to setup Mysql multiple instances >> >> >>http://www.mysql.com/documentation/mysql/bychapter/manual_MySQ >>L_Database_Adm >>inistration.html#Multiple_servers >>- Original Message - >>From: "Li, Robert" <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >>Sent: Saturday, December 29, 2001 5:58 PM >>Subject: how to setup Mysql multiple instances >> >> >>> Hi,all MySQL teams: >>> >>> First let me wish you all happy new year! >>> Wish Mysql win more victories in DB area. >>> >>> I am a programmer in CA. I know Mysql supports >>> multiple instances. One way is to install different servers, >>> on each server, runs an instance. The other way is to >>> use one server, one installation to run multi instances. >>> Now i can setup the environment in the first way. >>> I want to know how to setup in the second way. >>> >>> Would you pls kindly help me to solve this problem? >>> Thank you very much! >>> >>> Regards >>> >>> Robert Li >>> Computer Associates >>> Programmer, R&D Beijing (China) >>> Tel: +86 10 65611136 ext 852 >>> Fax: +86 10 85298979 >>> [EMAIL PROTECTED] >>> >>> >>- >>> 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 >> >> - 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
another xml thread
Hello everyone, First let me apologize if this is a taboo topic. I have been unsubbed from this list for a while, so I may be out of sync with convention. If I should take this question elsewhere, please show me the door. I'm interested in learning more about XML as a format for transporting data from one application to another. I have access to a server running MySQL, which currently stores data concerning some graphics files used by my department. I thought that it would be fun to use Python to develop a primitive client program and accompanying CGI scripts to see if I can automate some of the data entry that is normally done manually via a content-management site that I have been working on, and use XML as the transmission format. Note that the purpose of this exercise is not so much functionality as it is self-improvement, so issues such as execution speed are not concerns of mine. When I decided to look into combining MySQL with XML, I checked the archives for this list. What I found was a 30+ message thread about whether or not XML data should be stored in a relational database, and the difference between the two storage schemas. This is why I ask hesitantly: the thread was exactly a year old, and I am not sure if some of the opinions about this have changed. After reading the thread, I feel somewhat more enlightened, but not fully convinced that XML is incompatible with RDBMS. It strikes me that one is an excellent schema for storing and retrieving data, and the other is an excellent schema for structuring that data into a string or document destined for HTTP transmission. Can anyone point me in the direction of an article or essay that they found particularly informative about this topic? It is likely that I am barking up the wrong tree, but storing data in flat files doesn't seem to be the only way to use XML. I don't plan on beginning this project for a couple of weeks at least, so it's not really important. Again, if this is an inappropriate question for the list, send me packing. Thanks, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - 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: Newbie question: can't create/insert into table
Hi. On Tue, Feb 19, 2002 at 04:15:36AM +0300, [EMAIL PROTECTED] wrote: > > I am a total MySQL newbie using MySQL 3.22.32. [...] > create table temp1 > -> select field_x > -> from MyData; > > But, I get a syntax error (ERROR 1064) on line 2. > > Would somebody please point me at the right direction? The syntax you try to use does not exist in 3.22.x. According to the change history, it has been implemented in 3.23.0: http://www.mysql.com/documentation/mysql/bychapter/manual_News.html So either upgrade to a more recent version like 3.23.48 (3.22.x is quite outdated meanwhile) or use two statements. If you continue using 3.22.32, you should use the manual that came with it as future reference, because the online version of the manual always documents the most current version. Bye, Benjamin. - 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 question: can't create/insert into table
Hi, I am a total MySQL newbie using MySQL 3.22.32. I am trying to simultaneously create a table and insert some data into it as follows: create table temp1 -> select field_x -> from MyData; But, I get a syntax error (ERROR 1064) on line 2. Would somebody please point me at the right direction? A huge thanks. P.S. What would be a good book for a MySQL beginner? - 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
3.23.49 - Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
>Description: MysQL 3.23.48 works fine, but after upgrade to 3.23.49: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! >How-To-Repeat: Upgade from 3.23.48 to 3.23.49 >Fix: Downgrade to 3.23.48 >Release: mysql-3.23.48-max (Official MySQL-max binary) >Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.48, for pc-linux-gnu >on i686 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.48-max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 46 min 33 sec Threads: 2 Questions: 2378478 Slow queries: 0 Opens: 30959 Flush tables: 1 Open tables: 1 Queries per second avg: 851.585 >Environment: System: Linux gap 2.4.17 #2 SMP Mon Feb 18 18:19:44 EET 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: -rwxr-xr-x1 root root 1384040 Dec 18 18:24 /lib/libc.so.6 -rw-r--r--1 root root 25214756 Dec 18 18:07 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 18 18:07 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL-max binary' --with-extra-charsets=complex --with-server-suffix=-max --enable-thread-safe-client --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared --with-berkeley-db --with-innodb - 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: Security concerns on webserver with PHP & InnoDB
> -Original Message- > From: BD [mailto:[EMAIL PROTECTED]] > Sent: 18 February 2002 21:31 > To: [EMAIL PROTECTED] > Subject: Security concerns on webserver with PHP & InnoDB > > > I'm creating a web application with MySQL, PHP, InnoDB and I need to know > whether I should split the one large table into 3 different tables with > different user privileges defined on each table. > > As it stands now, the user logs in by entering a username & pw > and this is > checked against a membership table. If it is found, the PHP script grants > him access to certain PHP forms that allows him to insert rows to the > NewTable, browse the PublicTable, and delete/insert/update rows from the > PrivateTable. The actual MySQL username/pw for the database is > stored in an > include file which the PHP script loads when generating the page. So > currently everyone is using the same MySQL username/pw and the PHP script > controls access to the various forms depending on the security level the > person has in the membership table. > > The data I'm concerned about is stored in 1 large table (up to 1 million > rows) and there is a rcd_type field to indicate whether the record is > Public, Private, New. I currently only have 1 MySQL web related user > defined and it has Select, Insert, Update, Delete privileges to > this table. > The PHP script creates an SQL statement with the rcd_type field set to > filter the records so he can only see, insert, update records of > that type. > Access to the tables are controlled through the PHP scripts. > > Here's are the questions. > 1) Security Question > Should I split up the large table into 3 tables and assign these > privileges > to them: PublicTable (ReadOnly), PrivateTable (read/write/delete) and > NewTable (Insert). I'm concerned that even though the single username/pw > I'm using now is hidden from the user and the user has no way to > update the > SQL statements that accesses the tables, is it really necessary > to further > restrict access to prevent the user somehow updating or deleting rows in > the Public table? In other words, has anyone had their PHP website > compromised by someone finding a backdoor into the database by > circumventing their PHP scripts? Be afraid, be very afraid. Even if you are not paranoid they probably ARE out to get you :) Seriously, depends to some degree how much risk you want to/can afford to carry. You need to balance this against the extra work. Users are often the weakest link. Odds on some user will use 'john' and 'john' as username and password, or something similar. If John has delete privilages, and some script kiddie feels like trying their luck, then disaster could be close. If you want to be secure, I would suggest the following :- 1. MySql access only by localhost 2. If you are on shared hosting make sure php is in safe mode (I think that is the correct term, I am not an expert). If it is not, other php users on the host can view your config files. 3. Pass only a (complex) sessionID as identity and relate this to userID using php/mysql internally. If userid (the value the system uses to identify the user ) is passed then it may be spoofable. 4. Don't give anybody else an account on the server itself, this is the most likely source of a backdoor attack. 5. User login by SSL connection - avoids sniffers picking up usernames and passwords 6. Generate secure passwords for the users, rather than letting them set their own 7. Lock users out after 3 failed loggins 8. Put a short time out on the session 9. Verify that the user is allowed to execute the sql that they are executing before you execute it 10. Screen user input for illegal characters. php4 backslashes automatically, though this can be disabled, php3 does not. This could allow the user to add a ';' and then another sql statement on their text. 11. Don't echo errors - it can reveal table and field names which helps a hacker. 12. Use unusual table and field names 'Users' and 'username' and 'password' are guessable table and field names, 'X_1_users' is harder. 13. Encrypt passwords stored in the database - if you do have a break in it limits damage, otherwise all password would have to be reset. You may have already done all this, but thought i'd list them anyway. > > 2) Speed Question > Now if I were using MyISAM tables then I'd be forced to split it > up into 3 > tables because the table locks would hamper the read requests of > the Public > rows. But I'm using InnoDb so is there any speed advantage in producing 3 > different tables? Using 3 tables will of course mean more work > because I'll > need to manipulate the PHP code to generate the different login > username/pw > and also alter the table name in the sql statement for the 3 tables based > on the type of user. (The 3 tables will of course have the same structure > and I can probably get away with reusing the same PHP Update form for the > Priv
I cannot start my server.
Dear Sir/Madam, I install mysql on my computer but it did not work. after installing the rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't start my server, after I ran "mysql_install_db" and "safe_mysqld &" commands. I list the relevant information and I use the "mysqlbug" script to collect the relevant information . mysql's version : mysql-3.23.22-6.i386.rpm mysql-server-3.23.22-6.i386.rpm mysql-devel-3.23.22-6.i386.rpm my computer: AMD Athlon Processor cpu: 1.2GHz mem:256M operating system: red hat linux 7.0 kernel : 2.2.16-22 after intalling the above packages, I run the following command: [root@localhost rpm]# mysql_install_db Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain -p password 'new-password' See the manual for more instructions. Please report any problems with the /usr/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at http://www.mysql.com/license.htmy. then I run the following command: [root@localhost rpm]# safe_mysqld & [1] 1284 [root@localhost rpm]# Starting mysqld daemon with databases from /var/lib/mysql 020216 16:16:33 mysqld ended while I find some information from /var/lib/mysql/localhost.localdomain.err, the file localhost.localdomain.err's contents: 020215 17:31:02 mysqld started 020215 17:31:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020215 17:31:02 mysqld ended but I find the 'host.frm' file is in the directory: /var/lib/mysql/mysql in my /etc directory, there is only a configure file named: my.conf and the file's length is zero. there is no file named : my.cnf or mf.cnf. I tried to copy one of the config file my-medium.cnf to the /etc directory and renamed to both my.cnf and mf.cnf, it still did not work. mysqlbug's information SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject: [50 character or so descriptive subject here (for reference)] >Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: <[ non-critical | serious | critical ] (one line)> >Priority: <[ low | medium | high ] (one line)> >Category: mysql >Class: <[ sw-bug | doc-bug | change-request | support ] (one line)> >Release: mysql-3.23.22-beta (Source distribution) >Environment: System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 30 01:12 /lib/libc.so.6 -> libc-2.1.92.so -rwxr-xr-x1 root root 4776568 Aug 31 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 Aug 31 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 31 2000 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler --with-mysqld-user=mysql Best regards; Leon _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Re: Good, Free Mac GUI to mySQL?
[EMAIL PROTECTED] wrote: > Good, Free Mac GUI to mySQL? The only free GUI client for mySQL for the Mac that I know of would be CocoaSQL: http://homepage.mac.com/mxcantor/ which is only for Mac OS X. I have not used it so I can not tell if it is any good or not but it is open source. There are many other shareware and commercial clients for both Mac OS 9 and X that can be found by doing a search at versiontracker.com in the Mac OS or Mac OS X sections. -- David Steinbrunner mailto:[EMAIL PROTECTED] MFM Communication Software, Inc. http://www.mfm.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
Newbie alert!
All, I am having difficulty compiling a piece of software. If I try compiling with the following: gcc dnd.cpp -o dnd3 -L /usr/local/lib/mysql -lmysqlclient as suggested in "Core MySQL by Leon Atkinson" on page 436, I get the error: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status As an experiment I tried g++ dnd.cpp -o dnd3 and my compiler belched up the following: /tmp/cco2LOOc.o: In function "mon_list(void): /tmp/cco2LOOc.o(.text+0x872): undefined reference to 'mysql_init' /tmp/cco2LOOc.o(.text+0x89e): undefined reference to 'mysql_real_connect' /tmp/cco2LOOc.o(.text+0x8b2): undefined reference to 'mysql_error' etc. I think it lists every mysql command I used. I have copied the code almost directly out of the book (changing server name, user name, and table name). I am running Red Hat 7.1 and I have checked that the header files are there. Any suggestions? Thank you, Rick - 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: Perl core API
the libmysqld api is part of the 4.x development branch at the moment, I suggest checking that out. If you're interested in the development branch I suggest hopping on to the internals list. Rodney Broom wrote: > > From: Colin Faber <[EMAIL PROTECTED]> > > > With the up and coming libmysqld library this should be possible; > > "libmysqld"? Sounds interesting, do you have an URL? > > > Though I don't really see any advantages to this given the front end > > interface we have now (DBD::mysql) works like a charm. > > As a quick example, I want to be able to define my own datatypes inside the DB. I >might do something like storing an image and a bunch of metadata about that image in >a single blob() vi Storable::freeze(). Then provide some Perl code plugged into the >DB that lets me look at the data inside of blob()s in order to query over images at >the SQL level. At this point, I can access the DB from any interface I like: JDBC, >DBD::mysql, the mysql client, etc. > > > Regarding procedures, This is something that should be handled by the > > rdbms it self and not your middleware. > > Yep, you're right, but I'm not after middle-ware. I'm after a hook into the RDBMS >itself. > The problem with this, Is if you're not going through the primary engine managing the data it self you run into all sorts of ugly issues with dead locks. > --- > Rodney Broom > Programmer: Desert.Net > > - > 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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: Perl core API
From: Colin Faber <[EMAIL PROTECTED]> > With the up and coming libmysqld library this should be possible; "libmysqld"? Sounds interesting, do you have an URL? > Though I don't really see any advantages to this given the front end > interface we have now (DBD::mysql) works like a charm. As a quick example, I want to be able to define my own datatypes inside the DB. I might do something like storing an image and a bunch of metadata about that image in a single blob() vi Storable::freeze(). Then provide some Perl code plugged into the DB that lets me look at the data inside of blob()s in order to query over images at the SQL level. At this point, I can access the DB from any interface I like: JDBC, DBD::mysql, the mysql client, etc. > Regarding procedures, This is something that should be handled by the > rdbms it self and not your middleware. Yep, you're right, but I'm not after middle-ware. I'm after a hook into the RDBMS itself. --- Rodney Broom Programmer: Desert.Net - 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: Perl core API
With the up and coming libmysqld library this should be possible; assuming you want to sit down and take the time to write a module to interface it. Though I don't really see any advantages to this given the front end interface we have now (DBD::mysql) works like a charm. Regarding procedures, This is something that should be handled by the rdbms it self and not your middleware. Rodney Broom wrote: > > Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to >access all phases of the MySQL deamon with Perl in much the same way we access Apache >via mod_perl. Things like: > > - Query rewrite > - Data manipulation, pre-storage > - Data manipulation, post-query > - Prodedures > > --- > Rodney Broom > Programmer: Desert.Net > > Spam filter: sql database > > - > 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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: Perl core API
you may wish to post this to the DBI mailing list: [EMAIL PROTECTED] >>On Mon, 18 Feb 2002 15:43:59 -0700, "Rodney Broom" <[EMAIL PROTECTED]> wrote: >>Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to >access all phases of the MySQL deamon with Perl in much the same way we access Apache >via mod_perl. Things like: >> >>- Query rewrite >>- Data manipulation, pre-storage >>- Data manipulation, post-query >>- Prodedures >> >> >>--- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
Including/Excluding multiple databases from the Binary Log?
I am reading the documentation about the binary log, in particular binlog-do-db=database_name binlog-ignore-db=database_name (a) Can these be specified in the my.cnf file? (b) Can multiple databases be specified, either as a list or via multiple entries in the configuration? We're running mysql 3.23.39-log on Linux. Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - 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
Perl core API
Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to access all phases of the MySQL deamon with Perl in much the same way we access Apache via mod_perl. Things like: - Query rewrite - Data manipulation, pre-storage - Data manipulation, post-query - Prodedures --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - 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
Documentation chapter 2.2.7 not complete
>Description: If I follow the instuction in chapter 2.2.7 and chown/chgrep the symbolic link we just made to unpacked source then mysql will not start However if I use the same procedure on the source tree mysql-VERSION it starts without problems. I'm using gnu tar 1.13.19 and gunzip 1.3 on a redhat 7.2 out of the box >How-To-Repeat: Unpack the source again >Fix: Apply the chown/chgrp on the source tree as well as on the symbolic linked tree >Submitter-Id: 1 >Originator:Eward L. Schippers >Organization: devlab.cc >MySQL support: none >Synopsis: Documentation of permissions >Severity: non-critical >Priority: low >Category: mysql >Class: doc-bug >Release: mysql-3.23.49 (Official MySQL Binary) >Environment: System: Linux kelly.nt.klote.com 2.4.7-10 #1 Thu Sep 6 16:46:36 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 18 22:22 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 21:49 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 21:34 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 21:34 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpr! o -O3 -fno-omit-frame-pointer' CXX=gcc - 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: Explain this Explain ?
At 04:09 PM 2/18/02, Chris Boget wrote: > > I couldn't find anything like this in my MySQL book or in the on line help. > >Could this be what you are looking for? > >http://www.mysql.com/doc/E/X/EXPLAIN.html > >Not sure exactly what you need to know... > >Chris Sorry if I wasn't clear. I've read that page at least 4 times just today, along with the relevant chapters in Paul's MySQL book. What I can't find is any reference to the term "Select tables optimized away", which is what EXPLAIN returned with the select statement I was playing with. I'm assuming it is EXPLAIN's response to a not so useful SELECT statement, but thought I would ask just to be sure. I'm one of those anal people that sit here and try queries all day before putting them into a routine. Trying to use the EXPLAIN feature to milk the last little bit of speed I can get out of each SELECT. Cary - 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
Error 1058 on Windows 2000 Server
We are trying to install MySQL on a Windows 2000 Server, getting 'error 1058' when he tries to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. >From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - 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: Explain this Explain ?
> I couldn't find anything like this in my MySQL book or in the on line help. Could this be what you are looking for? http://www.mysql.com/doc/E/X/EXPLAIN.html Not sure exactly what you need to know... Chris - 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
Explain this Explain ?
I'm working on a routine and was optimizing queries for it when I ran across something I have never seen EXPLAIN return before. Can somebody tell me what it means when EXPLAIN returns: "Select tables optimized away" If it helps, here is the simple query I was testing. EXPLAIN SELECT COUNT(updated = 0) FROM tbl_produpdate I couldn't find anything like this in my MySQL book or in the on line help. Thanks, Cary - 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: RPMS for Development Branch
http://www.linuxmonsters.com sorry about that -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:41 PM To: 'Brian P. Austin' Cc: mysql Subject: RE: RPMS for Development Branch and the URL is??? it's not www.codemonsters.net; I just checked -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:20 PM To: [EMAIL PROTECTED] Cc: mysql Subject: RPMS for Development Branch Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin - 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 - 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: RPMS for Development Branch
and the URL is??? it's not www.codemonsters.net; I just checked -Original Message- From: Brian P. Austin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 3:20 PM To: [EMAIL PROTECTED] Cc: mysql Subject: RPMS for Development Branch Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin - 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
Security concerns on webserver with PHP & InnoDB
I'm creating a web application with MySQL, PHP, InnoDB and I need to know whether I should split the one large table into 3 different tables with different user privileges defined on each table. As it stands now, the user logs in by entering a username & pw and this is checked against a membership table. If it is found, the PHP script grants him access to certain PHP forms that allows him to insert rows to the NewTable, browse the PublicTable, and delete/insert/update rows from the PrivateTable. The actual MySQL username/pw for the database is stored in an include file which the PHP script loads when generating the page. So currently everyone is using the same MySQL username/pw and the PHP script controls access to the various forms depending on the security level the person has in the membership table. The data I'm concerned about is stored in 1 large table (up to 1 million rows) and there is a rcd_type field to indicate whether the record is Public, Private, New. I currently only have 1 MySQL web related user defined and it has Select, Insert, Update, Delete privileges to this table. The PHP script creates an SQL statement with the rcd_type field set to filter the records so he can only see, insert, update records of that type. Access to the tables are controlled through the PHP scripts. Here's are the questions. 1) Security Question Should I split up the large table into 3 tables and assign these privileges to them: PublicTable (ReadOnly), PrivateTable (read/write/delete) and NewTable (Insert). I'm concerned that even though the single username/pw I'm using now is hidden from the user and the user has no way to update the SQL statements that accesses the tables, is it really necessary to further restrict access to prevent the user somehow updating or deleting rows in the Public table? In other words, has anyone had their PHP website compromised by someone finding a backdoor into the database by circumventing their PHP scripts? 2) Speed Question Now if I were using MyISAM tables then I'd be forced to split it up into 3 tables because the table locks would hamper the read requests of the Public rows. But I'm using InnoDb so is there any speed advantage in producing 3 different tables? Using 3 tables will of course mean more work because I'll need to manipulate the PHP code to generate the different login username/pw and also alter the table name in the sql statement for the 3 tables based on the type of user. (The 3 tables will of course have the same structure and I can probably get away with reusing the same PHP Update form for the Private and New tables). So splitting the one large table into 3 tables *may* provide some additional security, but am I being overly paranoid? Do I really need the additional MySQL passwords when the security is currently handled by the PHP scripts. I don't want to make more work for myself unless it improves security or speed. Any comments? TIA Brent - 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
RPMS for Development Branch
Hello all, I have finished setting up a web page that contains RPMS for the Development Branch of MySQL-4.0. These RPMS are compiled every night at 11:00 p.m. CST and are posted to the site at 12:00 a.m. CST. They are built on a standard RedHat 6.2 install. You must use RPM version 4 to install. the Perl dependancy error is still there so --nodeps will bypass it. I have also installed them sucessfuly on RedHat 7.2. I did this myself, and MySQL is not responsible if they do not work. So do not mail the lists if there is an install error, or a specific feature that is not enabled. such requests should be sent to [EMAIL PROTECTED] I did this in hopes of making things easier for people (and myself) who want to try the new stuff out without downloading and compiling themselves. Have fun. Brian P. Austin - 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: Case Sensitivity Question
Hi.
On Sun, Feb 17, 2002 at 09:10:24AM -0700, [EMAIL PROTECTED] wrote:
> Since my first posting of this came out all screwed up,
>
> I currently have a PHP script performing the following query:
> mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1)
>
> It works great except that the search is coming out case sensitive.
> According to the MySQL Docs all searches are done without case
> sensitivity.
Well, not completely. The default is case insensitivity, but depending
on the context, you get case sensitive comparisons. See also
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#String_comparison_functions
(and the following section)
E.g. the behaviour you describe would be expected if Release has a
column type that is regarded BINARY (like BLOB).
> I just have 2 questions:
>
> 1) I think the syntax I'm using is correct but incase it's not what is
> the correct syntax for a case insensitive search?
See the next section of the above link. It suggest casting to
uppercase for forcing case insensitive compares.
>
> 2) What version of MySQL did the default of case insensitive searches
> begin as I'm using 3.23.31.
LIKE is case insensitive per default since 3.20.17 according to
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html
Bye,
Benjamin.
-
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
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysql>show databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql> show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - 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
a little configure bug
>Description: --without-bench does not seems to work, at least not for me, a minor thing but... >How-To-Repeat: I use this to compile mysql: ./configure --prefix=/usr --with-mysqld-user=mysql \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --localstatedir=/var/lib/mysql \ --with-pthread \ --enable-thread-safe-client \ --enable-assembler \ --with-raid \ --with-libwrap \ --without-bench \ $ARCH-slackware-linux make make install prefix=$PKG/usr and $PKG is /tmp/package-mysql. I get a /tmp/package-mysql/usr/mysql-bench when it told it not to do so. >Fix: >Submitter-Id: David Nordenberg >Originator: >Organization: >MySQL support: none >Synopsis: a little configure bug >Severity: non-critical >Priority: low >Category: mysql >Class: >Release: mysql-3.23.39 (Source distribution) >Environment: System: Linux ky-it 2.4.13 #1 Wed Oct 24 19:12:52 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 20 20:02 /lib/libc.so.6 -> libc-2.2.3.so -rwxr-xr-x1 root root 4783716 May 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 May 26 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 26 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with-libwrap --without-bench i386-slackware-linux - 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: Changing a query to work with MySQL
Hi. On Sat, Feb 16, 2002 at 01:46:34PM -, [EMAIL PROTECTED] wrote: > Hi, > [...] > All is fine except for one query which contains a sub select so therefore > will not work. [...] How to handle missing sub-selects is explained here: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html > CurrentDb.Execute "DELETE * FROM KeywordsForPicture WHERE > (KeywordsForPicture.PicID=" & Forms!frmPhotographs!textPicID & ") AND > (KeywordsForPicture.KeywordID IN (SELECT KeywordID FROM Keywords WHERE > Keywords.SubCatID=" & cboSubCategory & "))" In this case, this gives (don't know about VB, so keep an eye on that parts...): CurrentDb.Execute "DELETE * " & "FROM KeywordsForPicture AS kfp, Keywords AS k" & "WHERE kfp.PicID = " & Forms!frmPhotographs!textPicID & " " & "AND kfp.KeywordID = k.KeywordID " & "AND k.SubCatID = " & cboSubCategory I presume that VB takes case of proper escaping of user input values. If not, you need to use the equivalent of mysql_real_escape_string() of the C API. > While I'm here are there any other tweaks people would suggest while using > the Access Front end? The Access front end is a semi temporary arrangement, > next personal challenge is to create a php driven front end. Sorry, cannot help with that. Bye, Benjamin. - 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
Redhat 7.2 Install Problems
Have a Redhat 7.2 system. Trying to install MySQL 4.0.1 version of the server and client rpms via the KDE package manager. Am getting a dependency failure but it does not indicate which package, library etc. that I am missing. Any one have a suggestion? _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
[Setting MYSQL root password instructions are wrong?]
>Description: I've installed mysql on my trustix system. Trustix 1.5 comes with mysql 3.23.47. I installed it after the system was installed using the rpms. rpm -hivv mysql-3.23.47-1tr.i586.rpm At the end of the installation I get this: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h bulworth.joffer.net -p password 'new-password' See the manual for more instructions. Please report any problems with the /usr/bin/mysqlbug script! but the '-p' option should be removed, at least I had to. When I did this: /usr/bin/mysqladmin -u root password 'new-password' everything went ok, but with the '-p' option, I was asked for a password..??!? >How-To-Repeat: Install mysql from trustix rpm on trustix? Probably is the same on other systems. rpm -hivv mysql-3.23.47-1tr.i586.rpm >Fix: Removing '-p' option from the instruction? >Submitter-Id: >Originator:Christopher Thorjussen >Organization: >MySQL support: none >Synopsis: trouble setting mysq root passwd >Severity: non-critical >Priority: low >Category: mysql >Class: doc-bug >Release: mysql-3.23.47 (Trustix MySQL RPM) >Environment: System: Linux bulworth.joffer.net 2.4.17 #5 Mon Feb 18 18:36:59 CET 2002 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-trustix-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS=' -O3 -fomit-frame-pointer -fno-exceptions -fno-rtti -pipe -s -mpentium -mcpu=pentium -march=pentium -ffast-math -fexpensive-optimizations -malign-loops=2 -malign-jumps=2 -malign-functions=2 -mpreferred-stack-boundary=2' CXX='gcc' CXXFLAGS=' -O3 -fomit-frame-pointer -fno-exceptions -fno-rtti -pipe -s -mpentium -mcpu=pentium -march=pentium -ffast-math -fexpensive-optimizations -malign-loops=2 -malign-jumps=2 -malign-functions=2 -mpreferred-stack-boundary=2 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 7 19:56 /lib/libc.so.6 -> libc-2.1.3.so -rwxr-xr-x1 root root 5239877 Dec 19 10:46 /lib/libc-2.1.3.so -rw-r--r--1 root root 20712858 Dec 19 10:46 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 19 10:46 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man --with-berkeley-db '--with-comment=Trustix MySQL RPM' Perl: This is perl, version 5.005_03 built for i586-linux /Christopher Thorjussen [EMAIL PROTECTED] - 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: Statistical analysis query?
Hi. On Sat, Feb 16, 2002 at 09:52:18AM -0800, [EMAIL PROTECTED] wrote: > Thank you for your response. > Sorry, about the incompleteness. I'll try to fill in some of the blanks. Okay, let's see. > Benjamin Pflugmann wrote: [...] > Yes, this is correct shifts is a is exactly like a did show shifts. Fine. > >Also, you did not specify what special cases are to be taken care > >of. E.g. can there be volunteers which do not have a shift assigned > >yet? > > > Yes, there can be some volunteers in the voluteers table that can > have never been assigned a shift. Okay, that differs from my presumption, but in every query except the last (the one with LEFT JOIN) I already explained in my last mail how to handle that case. And for the last one, you only need to append AND NOT ( ISNULL(WHEN_YES) AND ISNULL(WHEN_NO) ) to the (last) WHERE clause. > Althgough there will be future shifts, there are no shifts in the > shifts table that have no voulnteers assigned to them. This I don't understand. Above you say, the tables are like "did show shift" and "no show shift". Then how can a shift be put in one of the both tables, if it's in the future? Because it's in the future you cannot say, which table would be the right one, can you? But anyhow, it's only a matter of adding something like "WHEN <= NOW()" to the appropriate WHERE clauses to ignore shifts with a date in the future. > >Can there be a shift in the future? And so on... I presume that > >the tables reflect complete recordings _after_ each shift. Here I wanted to make clear exactly this issue... that records can only be added (reasonably) after a shift has passed. > This is correct, the tables do refelet complete recordings Well, we have some misunderstanding somewhere... or do you put future shifts in the "shifts" table sometimes? If the solution(s) don't work for you, please explain where you get stuck, what result you get and what result you would expect. Bye, Benjamin. PS: I just noticed that sometimes I had the query with "SELECT @volunteer" too much. Just leave it away, if the following queries don't make use of the user variable "@volunteer". [...] > >>I have three tables: > >> > >>volunteer > >>VID | Name > >>- > >>524 | Joe Doe > >>254 | Karen Smith > >>485 | Bob Nesbit > >> > >>shifts > >>SID | DATE | VID > >>--- > >>230 | 2000-01-28 | 584 > >>231 | 2000-02-01 | 485 > >>233 | 2000-02-03 |147 > >>234 | 2000-02-04 | 584 > >> > >>no_show_shifts > >>SID | DATE| VID > >>--- > >>232 | 2000-02-01 | 259 > >>239 | 2000-02-08 | 369 > >> > >> > >>Is it possible to write a query that will solve this problem? If so, > >>can anyone tell me how I can do it? > >>If not what other data do I need? Any help is appreciated. - 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: Porting from MsSQL to MySQL (VERRY XML RELATED)
On Monday 18 February 2002 13:05, Dan Nelson wrote: > In the last episode (Feb 18), Marcelo Iturbe said: > > Hello, > > Currently I have an aplication which stores the information in an MsSQL > > database in a straight forward manner, "insert into blah blah" > > > > However, I retrieve the information in XML format using the FOR XML > > EXPLICIT statements that come with MsSQL 2000. > > You'll have to generate the XML in your application. Here are a > couple links (picked from a google search on "mysql xml select") to get > you started: > > http://www.xml.com/pub/a/2000/12/13/perlxmldb.html > http://www.nusphere.com/products/library/mysql_with_xml.pdf > http://home.online.no/~runeberg/hauler/hauler.html You might also look into the xml-dbms project, which is a good toolset for some purposes, though it may not be applicable to your needs. One of these days someone will get around to embedding a procedural language into MySQL, then stuff like this will be pretty easy... I vote for perl myself ;o). - 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: optimization of large records
On Mon, Feb 18, 2002 at 01:52:41PM -0600, Melvin wrote: > Hi: > I'm trying to create an image database of about 130,000 records. Right > now I have only the filenames in a CHAR Field (the records are of fixed > size). I read those images a lot. Is it better to leave it this way or to > move all the image data to a blob fields? > you are better off with filenames. > I already tried to use the blob field but it was up to 100 times slower. > Is there a way I can optimize this? > with some operating systems having 130 000 files in a directory might be sub-optimal. you might want to create a 'comb' of directory. i.e 1/1/,1/2/,..,1/9/,..,9/1/,..,9/9/ this will also help if you want to share your datas between several hard-drives. > I'm using mysql-max 3.23.47 on Windows XP with Athlon XP 1800+, 512 RAM > and 60Gb 5400 revs/s IDE Hard Disk > my guess is that your Athlon spends all the time waiting for the HD. You would probably get better performances with 4 400Mhz processors at about the same price, and 2 HDs, if the database is used by several users at the same time. what exactly do you want to optimize? time? space? nobody will be able to tell you anything unless you can do some profiling of your application to pinpoint where the bottlenecks are. -- Laurent Oget, Ph.D. [EMAIL PROTECTED]http://oget.net Senior Engineer Zvolve Systems Inc http://zvolve.com Chercheur Associé Liafa http://liafa.jussieu.fr - 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 and onboard ide raid
> I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra > 100 from Promise. Now I would like to connect some old 15 GB disks to > this controller. 2 or 4 disks are possible. On the raid I would like to > have a mysql database with around 5 GB. The system should operate under > linux 2.4. The board is able to run Raid level 0 with 4 or 2 disks and > raid level 1 with 2 disks. First make sure that your IDE-raid works reliably. I've had problems with ide-raid under linux in the past. Things may have changed now, but seriouslydo a thorough filesystem strain test. > It won't be a big problem if the system crashes after a few month. In > general my harddisks were running over years without Raid. > > Is it better to take Raid level 1 or 0 ? > If raid level 0, should I use 2 or 4 disks ? > Are both raid-levels running stable in the daily usage ? > Is the performance an really important point to choose a special raid > level ? > Should I use ext2, ext3 or an other filesystem ? RAID 0 is won't give you much. If you have (2) 15 GB disk, you will now have a 30 GB disk slightly faster with striping, but you won't notice the difference with ide-disks. RAID 1 is mirroring. It's expensive because for every 15 GB disk you have, you must have another 15 GB disk to mirror it (you can use a smaller disk, say 10 GB, but your capacity will be 10 GB). You could use RAID 10. It's a hybrid of RAID 0 and RAID 1. Let's say you have (4) 15 GB disks. You could use concatenate the first two (RAID 0) to make a 30 GB, concatenate the other two to make another 30 GB, then you mirror the first 30GB to the second 30GB. This setup _requires_ a minimum of 4 disks. It's the most expensive, but it offeres the best speed and reliabilty in case of a failure. If one disk fails, just replace the disk and your RAID controller should automatically do its business in the background while your database is chugging away. Whereas RAID-5 you would have to wait _forever_ for the array to be reconstructed. RAID 10 probably won't be a specific option for your RAID controller, it will just be called RAID-1 with striping or something like that. As for a filesystem. I wouldn't recommend ext2 or ext3 at all. I would _highly_ recommend a journaling filesystem such as Reiserfs (http://www.namesys.com) or XFS (http://oss.sgi.com). I've used reiserfs for a long time, but XFS is growing on me. It seems to be more stable in latest 2.4 kernels. Cheers, Andrew Crum [EMAIL PROTECTED] - 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: Faxing from MySQL
RDBMS Is not a Fax machine use middleware to do this. Rich Fortnum wrote: > > Hi there. Anybody know how I can fax using MySQL? I might have an > application for this. > > I would suspect third party software to reach in, generate reports, then fax > out. > > Cheers. > > @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) > @@@ Web Design / Databases / Internet Video / Wireless Data > @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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
optimization of large records
Hi: I'm trying to create an image database of about 130,000 records. Right now I have only the filenames in a CHAR Field (the records are of fixed size). I read those images a lot. Is it better to leave it this way or to move all the image data to a blob fields? I already tried to use the blob field but it was up to 100 times slower. Is there a way I can optimize this? I'm using mysql-max 3.23.47 on Windows XP with Athlon XP 1800+, 512 RAM and 60Gb 5400 revs/s IDE Hard Disk Gustavo Lara - 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
Faxing from MySQL
Hi there. Anybody know how I can fax using MySQL? I might have an application for this. I would suspect third party software to reach in, generate reports, then fax out. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.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
RE: Re[2]: Am I asking the wrong question?
GRANT . TO @'' IDENTIFIED BY ' ; . = *.* will give access to everything, .* will give access to all in that database, of course if you specify then it will appear in the db table of the mysql database. If you specify it will show in tables_priv. Note: On occasion I took notice that if I set up a grant, then set up another grant to a different database, with a different password, then the original permission entries password got changed too. You shouldn't have to refresh anything as far as I know. If you use insert or update to do privilege set up, then you should be calling FLUSH PRIVILEGES; -Original Message- From: Søren Neigaard [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 12:08 PM To: Henning Sprang Cc: [EMAIL PROTECTED] Subject: Re[2]: Am I asking the wrong question? Monday, February 18, 2002, 5:51:38 PM, Henning wrote: HS> sometimes you need to choose a good subject, but i don't know what your HS> original subject was... Yes maybe that actually was the reason :) HS> what exacly you don't understand? the following message is just a HS> special problem, not a question about understanding the permission system. HS> From this excerpt one cannot see if you really the right permissions, HS> at least it says that user homebrew has generally no permissions which HS> go over the full database. HS> To see if there are correct permissions check the db table ind Database HS> MySQL - there you find Database specififc persmissions for each user. Yes in db the homebrew user did not have any permissions, so I change them manually, and now it all works. But why? Should I not be able to set those permissions with GRANT? HS> Another thing that could be (but i am not sure if that applies) that you HS> need to relaod the database sometimes after granting something to a user HS> or adding a new user, i am not sure, but you can give it a try. Yes I needed that too, I stopped and started it. Can I "reload" it with some command? HS> ps: i would not send original passwords to such a list - one should HS> always black out things like that... Point taken :) -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] - 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: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Mikel King chortled: > Hi Rich, > > Just so I understand you correctly; > > 1. Are you trying to use the replication features of MySql for > this communication? > > Or > > 2. Are you talking on the client side application, like PHP, > Java, Perl...? > > How about encrypting the data itself and skipping the whole channel > issue? > > cheers, > Mikel Sorry, Mike, been busy and haven't checked the messages. Just wanted to take records in MySQL and send to SQL Server over the net. Decided a vpn would be best implementation. Cheers @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.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
RE: Copying the structure of DBs
On Mon, 18 Feb 2002, Rick Emery wrote: > CREATE TABLE newtable SELECT * FROM oldtable LIMIT 0; Will that create indexes in newtable that were in oldtable? Also, you'd have to do that for each table. Depending on exactly what you want to do, another option would be to use mysqldump -d old_db > createdefs.sql to spit out the create table statements for the tables in old_db. Then you could run mysql new_db < createdefs.sql to set up identical but empty tables in new_db. You could even save a step with a pipe: mysqldump -d old_db | mysql new_db Michael Stassen University Information Technology Services Indiana University Bloomington [EMAIL PROTECTED] > > -Original Message- > From: Todd Ellner [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 18, 2002 12:58 PM > To: [EMAIL PROTECTED] > Subject: sql: Copying the structure of DBs > > > I need to create multiple databases from time to time. This isn't a problem. > The thing that seems tricky is creating databases with the same table names > and structures, but none of the data, of old ones. I thought chapter 4 of > the documentation covered this, but it doesn't quite seem to. Any > suggestions? Is there a quick way to do this in MySQL? Or will I have to do > something kludgy like parsing the output of a mysql "DESCRIBE" statement and > making a create statement out of it? > > Todd - 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: Copying the structure of DBs
CREATE TABLE newtable SELECT * FROM oldtable LIMIT 0; -Original Message- From: Todd Ellner [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: sql: Copying the structure of DBs I need to create multiple databases from time to time. This isn't a problem. The thing that seems tricky is creating databases with the same table names and structures, but none of the data, of old ones. I thought chapter 4 of the documentation covered this, but it doesn't quite seem to. Any suggestions? Is there a quick way to do this in MySQL? Or will I have to do something kludgy like parsing the output of a mysql "DESCRIBE" statement and making a create statement out of it? Todd - 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
sql: Copying the structure of DBs
I need to create multiple databases from time to time. This isn't a problem. The thing that seems tricky is creating databases with the same table names and structures, but none of the data, of old ones. I thought chapter 4 of the documentation covered this, but it doesn't quite seem to. Any suggestions? Is there a quick way to do this in MySQL? Or will I have to do something kludgy like parsing the output of a mysql "DESCRIBE" statement and making a create statement out of it? Todd - 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
mysql and onboard ide raid
Hello, I am using a Gigabyte GA7DXR board with an onboard raid controller Ultra 100 from Promise. Now I would like to connect some old 15 GB disks to this controller. 2 or 4 disks are possible. On the raid I would like to have a mysql database with around 5 GB. The system should operate under linux 2.4. The board is able to run Raid level 0 with 4 or 2 disks and raid level 1 with 2 disks. It won't be a big problem if the system crashes after a few month. In general my harddisks were running over years without Raid. Is it better to take Raid level 1 or 0 ? If raid level 0, should I use 2 or 4 disks ? Are both raid-levels running stable in the daily usage ? Is the performance an really important point to choose a special raid level ? Should I use ext2, ext3 or an other filesystem ? Many thanks for your tips Matthias Jaekle - 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: running mysqlhotcopy error
mysqlhotcopy uses the DBI to connect to the mysql database, Perl's API for accessing the database. >>On Mon, 18 Feb 2002 18:44:24 +0100, [EMAIL PROTECTED] wrote: >>I'm trying to run mysqlhotcopy for the first time. I get an error that looks >>like this >> >>$ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup >>Can't locate DBI.pm in @INC (@INC contains: >>/usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 >>/usr/local/lib/perl5/site_perl/5.005/sun4-solaris >>/usr/local/lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. >>BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. >> >> >>What is DBI? >> >>I got perl installed at ... >> >>$ which perl >>/usr/local/bin/perl Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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: 3.23.49 fails to compile under RH Linux w/2.4.16 kernel
Robert La Ferla wrote: > /usr/include/bits/mathinline.h: In function `float log1pf (float)': > /usr/include/bits/mathinline.h:540: Internal error: Segmentation fault. > Please submit a full bug report. > See http://bugzilla.redhat.com/bugzilla/> for instructions. So? Do what that says: go to http://bugzilla.redhat.com/bugzilla, and file a bug report with the details you posted here. Oh, you should also attach to the report exactly what kernel version you have (was it Red Hat's 2.4.16 RPM, or one you built on your own?), what gcc version, how they can get the test case (the mysql-3.23.49 source download pointer), and let them investigate.. -- Shankar. - 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: Porting from MsSQL to MySQL (VERRY XML RELATED)
In the last episode (Feb 18), Marcelo Iturbe said: > Hello, > Currently I have an aplication which stores the information in an MsSQL > database in a straight forward manner, "insert into blah blah" > > However, I retrieve the information in XML format using the FOR XML EXPLICIT > statements that come with MsSQL 2000. You'll have to generate the XML in your application. Here are a couple links (picked from a google search on "mysql xml select") to get you started: http://www.xml.com/pub/a/2000/12/13/perlxmldb.html http://www.nusphere.com/products/library/mysql_with_xml.pdf http://home.online.no/~runeberg/hauler/hauler.html -- Dan Nelson [EMAIL PROTECTED] - 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 Query at the same time
Hi, I'm having some trouble with MySQL and Vb. I'm doing an app with a Do While and I open / close a Recordset in this Do While. I think that it's the problem... When I start the Program, after 30 seconds in the Do While, I get this error : "Can't connect to MySQL Server ON 192.168.1.34". Does I need to modify a connect_timeout or a variable like this to solve my problem and if so, how can I do it ? I'm on Win 98... Thanks ! --- Pascal Richer [EMAIL PROTECTED] Étudiant en Informatique et Génie Logiciel Université du Québec à Montréal - 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
running mysqlhotcopy error
Hello, I'm trying to run mysqlhotcopy for the first time. I get an error that looks like this $ ./mysqlhotcopy X /opt/mysql-3.23.32-sun-solaris2.7-sparc/backup Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503 /usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. What is DBI? I got perl installed at ... $ which perl /usr/local/bin/perl And mysqlhotcopy looks like this... $ head mysqlhotcopy #!/usr/local/bin/perl -w use strict; use Getopt::Long; use Data::Dumper; use File::Basename; use File::Path; use DBI; =head1 NAME Can't really understand what i'm doing wrong here. Anybody have any ideas? Best regards Jari Marikainen - 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 4.0 released
Hi! First, please don't email things directly to me or to the announce list. The best way to get help for a problem, is to write an email only to [EMAIL PROTECTED]; In the future, please also change the subject line to something that is appropriate and don't respond to an email that has nothing to do with the problem! > "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes: Huang-Ming> Hello, Huang-Ming> I'm encountering a serious program fault at using MySQL Win32 client library Huang-Ming> LIBMYSQL.DLL. Huang-Ming> I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run Huang-Ming> the following two blocks of C statements, very quickly a program fault Huang-Ming> window pops up to LIBMYSQL.DLL. Huang-Ming> block #1 - Huang-Ming> EnterCriticalSection(&dcs); Huang-Ming> mysql_real_query(db,stmt,strlen(stmt)); Huang-Ming> res=mysql_store_result(db); Huang-Ming> LeaveCriticalSection(&dcs); Huang-Ming> block #1 - (in another C function) Huang-Ming> EnterCriticalSection(&dcs); Huang-Ming> row=mysql_fetch_row(res); Huang-Ming> nfld=mysql_num_fields(res); Huang-Ming> flds=mysql_fetch_fields(res); Huang-Ming> LeaveCriticalSection(&dcs); If this block is done by another thread that did the original query, you will get a problem if you didn't initialize the thread for MySQL usage. Please read the MySQL manual section 'Threaded clients' and the documentation for the MySQL API 'mysql_thread_init()' or more information about this Regards, Monty - 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 retrieve a hierarchical structure
(for filter: query,sql,mysql,table)
I've done this a few times, I mostly do category systems and there
is no reason to list all the categories at one time, so I usually
have a "parent id" to work with in order to get all the sub
categoreis from the DB. However, I have done one where I did want
something like a "Windows Explorer" view.
The following is the table structure and the PHP function I use
to display the information.
The output is something like this:
Folder One
-Sub Folder One
--Sub Folder One-One
Folder Two
-Sub Folder Two
My mail client will wrap the php function, so it may be malformed by
the time you get it.
CREATE TABLE `folders` (
`id` int(10) unsigned NOT NULL auto_increment,
`owner_id` int(10) unsigned NOT NULL default '0',
`parent_id` int(10) unsigned NOT NULL default '0',
`root_id` int(10) unsigned NOT NULL default '0',
`name` varchar(254) default NULL,
PRIMARY KEY (`id`),
KEY `owner_key`(`owner_id`),
KEY `parent_key`(`parent_id`),
KEY `root_key`(`root_id`)
) TYPE=MyISAM
function listFolders($aslink=0,$userid) {
$query="SELECT DISTINCTROW t.id,t.name "
."FROM folders AS t, folders AS r "
."WHERE ((t.id=r.root_id) AND (t.owner_id=".$userid."))
"
."ORDER BY t.name ASC;"
;
if($result=mysql_query($query)) {
if(mysql_num_rows($result)) {
while($row=mysql_fetch_row($result)) {
list($id,$name)=$row;
if($aslink) {
printf("%s\n",$id,$name);
} else {
printf("%s\n",$id,$name);
}
$query="SELECT t.id,t.parent_id,t.name "
."FROM folders AS t,folders AS
p, folders AS r "
."WHERE ((t.parent_id=p.id) AND
(t.root_id=r.id) AND (t.root_id=$id) AND (t.owner_id=".$userid.")) "
."ORDER BY t.parent_id
ASC,t.name ASC;"
;
if($sub_result=mysql_query($query)) {
if(mysql_num_rows($sub_result))
{
while($row=mysql_fetch_row($sub_result)) {
list($sub_id,$sub_pid,$sub_name)=$row;
if($tmp_id!=$sub_pid) {
$tmp_id=$sub_pid;
$leadin.="-";
}
if($aslink) {
printf("%s%s\n",$leadin,$sub_id,$sub_name);
} else {
printf("%s%s\n",$sub_id,$leadin,$sub_name);
}
}
$leadin="";
mysql_free_result($sub_result);
}
}
}
}
}
}
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Wakan [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: how to retrieve a hierarchical structure
Hi,
can someone suggest the best way to perform a query that
extract from a category table all the structure, like a filesystem?
For example, I've a table of categorie like this:
ID namedescr ID_parent
and I've assigned -1 to the root category.
I'd like to draw a directory-like structure (like windows explorer), but
I don't know how to extract a directory name, and all sub-directory
recursively.
Thaks.
Carlo
-
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: Problem with mysql 3.23.49 rpm install
"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes: > Hi. > I want upgrade mysql from 3.23.48 to 3.23.49 but i see that. > > first. shared > ># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm > UPGRADE > Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm" > error: failed dependencies: > libc.so.6(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 > libpthread.so.0(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 > Press any key to continue... > > second. mysql server but ocurrs some strange errors. > > My system is RH 6.2 The rpm needs glibc 2.2. RHL 6.2 is glibc 2.1. Upgrade Red Hat Linux (upgrade of glibc on its own is highly discouraged) or rebuild the SRPM on your system. -- Trond Eivind Glomsrød Red Hat, Inc. - 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 retrieve a hierarchical structure
Hi, A simple way is to make a recursive search by starting from the root, and collecting all ID's from each layer. You need only one query per layer, not one per node. It looks like this : -> start from the desired "directory" : SELECT * FROM table WHERE id_parent IN (8) -> say it returns children ids 4,5,12, then : SELECT * FROM table WHERE id_parent IN (4,5,12) and so on until the query returns an empty result set, which simply means the search has ended. If you really have a big tree, though, there is another way, less intuitive, which is described here : http://www.mip.berkeley.edu/mip/related/thesaurus/thesaurus.pdf Yours > Hi, > can someone suggest the best way to perform a query that > extract from a category table all the structure, like a filesystem? For > example, I've a table of categorie like this: > IDnamedescr ID_parent > and I've assigned -1 to the root category. > I'd like to draw a directory-like structure (like windows explorer), > but I don't know how to extract a directory name, and all sub-directory > recursively. - 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
Query in Access with connected MySQL table
Hi all, I'm currently trying to construct a query in Access that references to a temporary table I'm creating and populating on the fly. All is going well until I try to create the query. Although I'm opening the connection to the table etc Access is claiming not to recognise the table, any ideas what I need to do to get the Jet Engine to recognise the table? Am I looking along the lines of creating some form of link like the permanently connected tables I have? TIA Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 - 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.sock problem
I should have mentioned that I did a 'find / -name my.cnf' and there is only one such file--/etc/my.cnf Perhaps I should try creating a local version of my.cnf, but I really want to know why it's getting the wrong .sock file in the first place. Brad Gerald Clark wrote: > check for a .my.cnf file in the user's home directory. It may have > conflicting entries. > > Brad Emerson wrote: > >> >> When I am logged in to my Linux system as root mysqladmin works >> correctly. i.e. finds mysql.sock in the correct location. >> >> When I am logged in as a normal user I get this error: >> >> Can't connect to local MySQL server through socket >> /var/lib/mysql/mysql.sock. blah blah... (This is *not* the correct >> mysql.sock) >> >> >> The issue is that my.cnf indicates /var/tmp/mysql.sock for both >> client and mysqld. And... it works fine when I am logged in as >> root. As a user it's trying to use the wrong mysql.sock file. Any >> idea how to fix this? How I achieved the screwed up state? >> >> BTW, if I use --socket=/var/tmp/mysql.sock it works. I hesitate to >> consider it a longtem solution. >> >> Brad Emerson >> >> >> >> >> - >> 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 - 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
Porting from MsSQL to MySQL (VERRY XML RELATED)
Hello, Currently I have an aplication which stores the information in an MsSQL database in a straight forward manner, "insert into blah blah" However, I retrieve the information in XML format using the FOR XML EXPLICIT statements that come with MsSQL 2000. The select stament looks something like select 1 as tag, null as parent, login as [info!1!first_name!element] from user_info FOR XML EXPLICIT Without the FOR XML EXPLICIT statement this returns a the following recordset: TAG PARENT info!1!first_name!element 1 NULL Marcelo 1 NULL Pablo WITH the FOR XML EXPLICIT statement, this query returns the following STRING marcelopablo I then i just throw that XML STRING to the XSL pages and voila! I have an html page. I have been reading alot about XML support in this mailing list. But this XML support has NOTHING to do with how the information is being stored, just how the information is being delivered to the client. Any idea if something like this will ever be implemented in MySQL? If so when? If not I am afraid that if we decide to switch from MsSQL 2000 to MySQL will be a painfull one. Thanks. Marcelo PS. I do realize that the "FOR XML EXPLICIT " statement is NOT SQL Standard and that I made a pact with the devil when I decided to use it. - 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: 3.23.49-1.rpm on RH 7.2 probs?
On Mon, Feb 18, 2002 at 11:59:29AM -0500, Trond Eivind Glomsrød wrote: > "S. William Schulz" <[EMAIL PROTECTED]> writes: > > > Hello, > > > > I just upgraded mysql to 3.23.49 using the rpm's. I had been running > > 3.23.45 for many months now without a problem on a RH 7.2 box logging > > snort data (so it had moderate load). > > Which rpms? RPMs from RH (not supported, it's just the Rawhide package > built on a RHL 7.2 environment) can be found at > http://people.redhat.com/teg/mysql/ These were the RPMs from mysql.com (actually, from the valueclick ftp mirror). Those were the ones I had installed when I installed .45. S - 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[2]: Am I asking the wrong question?
Monday, February 18, 2002, 5:51:38 PM, Henning wrote: HS> sometimes you need to choose a good subject, but i don't know what your HS> original subject was... Yes maybe that actually was the reason :) HS> what exacly you don't understand? the following message is just a HS> special problem, not a question about understanding the permission system. HS> From this excerpt one cannot see if you really the right permissions, HS> at least it says that user homebrew has generally no permissions which HS> go over the full database. HS> To see if there are correct permissions check the db table ind Database HS> MySQL - there you find Database specififc persmissions for each user. Yes in db the homebrew user did not have any permissions, so I change them manually, and now it all works. But why? Should I not be able to set those permissions with GRANT? HS> Another thing that could be (but i am not sure if that applies) that you HS> need to relaod the database sometimes after granting something to a user HS> or adding a new user, i am not sure, but you can give it a try. Yes I needed that too, I stopped and started it. Can I "reload" it with some command? HS> ps: i would not send original passwords to such a list - one should HS> always black out things like that... Point taken :) -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] - 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
InnoDM or ISAM??
I have run MySQL for the last 2 years using the default database tables. Has anyone made the migration to InnoDB? Is it stable? What are the drawbacks of using InnoDB? David McInnis 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: 3.23.49-1.rpm on RH 7.2 probs?
"S. William Schulz" <[EMAIL PROTECTED]> writes: > Hello, > > I just upgraded mysql to 3.23.49 using the rpm's. I had been running > 3.23.45 for many months now without a problem on a RH 7.2 box logging > snort data (so it had moderate load). Which rpms? RPMs from RH (not supported, it's just the Rawhide package built on a RHL 7.2 environment) can be found at http://people.redhat.com/teg/mysql/ -- Trond Eivind Glomsrød Red Hat, Inc. - 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: Am I asking the wrong question?
Hy Soren,
Søren Neigaard wrote:
> I have tried to get through with this question two ties before, and
> since I'm not getting any replies, I'm starting to think that I must be
> asking the wrong question. What am I doing wrong then?
sometimes you need to choose a good subject, but i don't know what your
original subject was...
>
> Heres my "old" question.
>
> Please I need some help here, I don't think I understand the "rights"
> architecture in MySQL.
what exacly you don't understand? the following message is just a
special problem, not a question about understanding the permission system.
>
> I'm trying to connect like this:
>
> Connection conn =
>DriverManager.getConnection("jdbc:mysql://localhost:3306/homebrew?user=homebrew&password=maaler");
>
> But I get the following error:
>
> SQLException: Cannot load connection class 'java.sql.SQLException: Server
>configuration denies access to data source'.
> SQLState: 08001
> VendorError: 0
i don't know anything about jdbc and java.
did you try to connect via the mysql client to database and fire the
same query this way?
if that works you could be more sure that your java code is somehow
wrong, otherwise you could be more sure that it's really a permission
problem...
>
> I have created a database and executed the following grants:
>
> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX ON homebrew.* TO homebrew@localhost
>identified by 'maaler' WITH GRANT OPTION;
>
> But I'm not so sure I understand this grant stuff. If I make a "SELECT
> * FROM USER" in the MYSQL database I get the following:
>
>
>+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
> | Host| User | Password | Select_priv | Insert_priv |
>Update_priv | Delete_priv | Create_priv |
> Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv |
>References_priv | Index_priv | Alter_priv |
>
>+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
> | localhost | root | 4d940be86f94e167 | Y | Y | Y
> | Y | Y | Y
> | Y | Y | Y| Y | Y | Y
> | Y | Y |
> | neigaard1 | root | 4d940be86f94e167 | Y | Y | Y
> | Y | Y | Y
> | Y | Y | Y| Y | Y | Y
> | Y | Y |
> | localhost | | | N | N | N
> | N | N | N
> | N | N | N| N | N | N
> | N | N |
> | neigaard1 | | | N | N | N
> | N | N | N
> | N | N | N| N | N | N
> | N | N |
> | 192.168.1.3 | root | 4d940be86f94e167 | Y | Y | Y
> | Y | Y | Y
> | Y | Y | Y| Y | N | Y
> | Y | Y |
> | localhost | homebrew | 7cef02e455de0f96 | N | N | N
> | N | N | N
> | N | N | N| N | N | N
> | N | N |
>
>+-+--+--+-+-+-+-+-+---+-+---+--+---++-+++
>
From this excerpt one cannot see if you really the right permissions,
at least it says that user homebrew has generally no permissions which
go over the full database.
To see if there are correct permissions check the db table ind Database
MySQL - there you find Database specififc persmissions for each user.
Another thing that could be (but i am not sure if that applies) that you
need to relaod the database sometimes after granting something to a user
or adding a new user, i am not sure, but you can give it a try.
ps: i would not send original passwords to such a list - one should
always black out things like that...
hth,
henning
-
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 unsu
how to retrieve a hierarchical structure
Hi, can someone suggest the best way to perform a query that extract from a category table all the structure, like a filesystem? For example, I've a table of categorie like this: ID namedescr ID_parent and I've assigned -1 to the root category. I'd like to draw a directory-like structure (like windows explorer), but I don't know how to extract a directory name, and all sub-directory recursively. Thaks. Carlo - 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
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysql>show databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** a show variables; mysql> show variables like 'have%'; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:15 Current database: *** NONE *** +---+---+ | Variable_name | Value | +---+---+ | have_bdb | NO| | have_innodb | YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | YES | +---+---+ 6 rows in set (0.14 sec) I can see that ipenssl is running, but the server keeps loosing the connection. If I buld mysql without the --with-vio --with-openssl options all works ok, except of course I have no ssl. Has anyone gotten 4.0.1 to run with openssl? If so, please let me know what you did to make it work. Should I use an older version of openssl? Maybe 0.9.6b or 0.9.6a? Thanks, Jorge - 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
problem with mySQL using SSL
Hello all. I downloaded the mysql v4.0.1 source and openssl 0.9.6c source. I built openssl OK I built mysql as follows: ./configure --with-vio --with-openssl make make install The build went well all the way. The mysql server seem to start ok. When I try to connect with mysql client after a few seconds I get the following error message mysql>show databases; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: *** NONE *** when I do a show status I get the following. mysql> show status; ++---+ | Variable_name | Value | ++---+ | Aborted_clients| 8 | | Aborted_connects | 0 | | Bytes_received | 529 | | Bytes_sent | 1049 | | Com_admin_commands | 0 | | Com_alter_table| 0 | | Com_analyze| 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function| 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_drop_db| 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush | 0 | | Com_grant | 2 | | Com_ha_close | 0 | | Com_ha_open| 0 | | Com_ha_read| 0 | | Com_insert | 0 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables| 0 | | Com_optimize | 0 | | Com_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace| 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 0 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create| 0 | | Com_show_databases | 10| | Com_show_fields| 0 | | Com_show_grants| 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_stat | 0 | | Com_show_new_master| 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_stat| 0 | | Com_show_status| 2 | | Com_show_tables| 0 | | Com_show_variables | 0 | | Com_slave_start| 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Connections| 10| | Created_tmp_disk_tables| 0 | | Created_tmp_tables | 0 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 0 | | Handler_read_first | 1 | | Handler_read_key | 1 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_next | 11| | Handler_update | 0 | | Handler_write | 1 | | Key_blocks_used| 1 | | Key_read_requests | 2 | | Key_reads | 1 | | Key_write_requests | 1 | | Key_writes | 1 | | Max_used_connections | 0 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables| 2 | | Open_files | 6 | | Open_streams | 0 | | Opened_tables | 8 | | Questions | 8 | | Qcache_queries_in_cache| 0 | | Qcache_
AIX 4.3.3-9 and mysql
Hi, We are having problems installing MySQL3.23.9 and below on our AIX 4.3.3-9 servers. We keep getting the shr.o error. Has anybody over come this problem yet? ThanX, Greg -- Greg D. ISC-SEO Systems Programmer, Linux Admin, HP-UX Admin, TSM Admin University of Pennsylvania ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~ Our OS who art in CPU, LINUX be thy name. Thy programs run, thy syscalls done, In kernel as it is in user! - 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: Existing file cannot be found
This problem appears to be similar to one I have when I create MySQL databases on my Windows machine and then transfer them at a later date to RedHat. MySQL looks for tables with the extensions MYD and MYI but they sometimes get converted to lowercase and thus MySQL complains (Linux is case-sesitive remember). Not sure what you can do to stop this happening but if you find a 'cure' could you let me know. Cheers, Neil "Mikhail V.Soloviev" wrote: > Hello, > > sometimes my mysqld tells me that it cannot open the file table.MYD. > So script doensn't work, although the file exists in the > mysql/database/ folder. When I overwrite this file with backuped one, > problem disappears, and then appears again in several days. > What's the matter? > > p.s. Mysql 3.23.48 on RH 7.2, default config except wait_timeout=60 > > Best regards, > Mikhail Soloviev > > - > 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 > > *** > This message was virus checked with: SAVI 3.53 Jan 2002 > last updated 30th January 2002 > *** -- Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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
Problem with mysql 3.23.49 rpm install
Hi. I want upgrade mysql from 3.23.48 to 3.23.49 but i see that. first. shared ># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm UPGRADE Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm" error: failed dependencies: libc.so.6(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 libpthread.so.0(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 Press any key to continue... second. mysql server but ocurrs some strange errors. My system is RH 6.2 regards, i. Piasecki. -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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: **Backing Up A Database**
- create a file in /etc/logrotate.d, filename does not matter, take this as a
template, fill in connection parameters in mysqldump call (""):
/home/backup/sqlback/mybackup.sql {
daily
nomissingok
nocreate
compress
rotate 14
errors [EMAIL PROTECTED]
prerotate
mysqldump --opt --full >/home/backup/sqlback/mybackup.sql
endscript
}
- check syntax and options of this file: "man logrotate"
- you're set: cron will call logrotate each night. logrotate processes each file in
the dir, executes the prerotate script and then compresses the "log"file (i.e.
SQL-Dump), renames older ones and keeps at max 14 of them ("rotate 14"). "nomissingok"
will let you know if the mysqldump failed
Felix
-
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 unsubscribe from this list?
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php It's at the bottom of every message sent to this list. Tyler - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 9:19 AM Subject: how to unsubscribe from this list? > Hello, > I have found the solution of my sql quueris, > I want to unsubscribe from this list > > can u help? > thanx > > > > > - > 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: mysql.sock problem
check for a .my.cnf file in the user's home directory. It may have conflicting entries. Brad Emerson wrote: > > When I am logged in to my Linux system as root mysqladmin works > correctly. i.e. finds mysql.sock in the correct location. > > When I am logged in as a normal user I get this error: > > Can't connect to local MySQL server through socket > /var/lib/mysql/mysql.sock. blah blah... (This is *not* the correct > mysql.sock) > > > The issue is that my.cnf indicates /var/tmp/mysql.sock for both client > and mysqld. And... it works fine when I am logged in as root. As a > user it's trying to use the wrong mysql.sock file. Any idea how to > fix this? How I achieved the screwed up state? > > BTW, if I use --socket=/var/tmp/mysql.sock it works. I hesitate to > consider it a longtem solution. > > Brad Emerson > > > > > - > 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
3.23.49-1.rpm on RH 7.2 probs?
Hello, I just upgraded mysql to 3.23.49 using the rpm's. I had been running 3.23.45 for many months now without a problem on a RH 7.2 box logging snort data (so it had moderate load). Now, when I try to start mysql, I get this in the log (other lines snipped). I'm hoping someone might recognize this problem. I've looked at the Crashing page and run myisamchk on the data tables, etc. Any ideas? 020218 10:06:06 mysqld started mysqld got signal 4; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail SWS - 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 to unsubscribe from this list?
Hello, I have found the solution of my sql quueris, I want to unsubscribe from this list can u help? thanx - 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/InnoDB-3.23.49 is released
Hi. Thanks for this version. Thanks. This wersion not work on my linux RH 6.2 zoot. Version 3.23.48 runs fine, but with wersion 2.23.49 not (this version is bigger than previous server's version). Why ? I make upgrade from MC on my linux box and i cannot start mysql server. What a chek. So for who is this version ?? I see, not for me. What should i do ? Mysql server from rpm -> 3.23.49-1.i386.rpm don't go. I have some errors. Agrrh. Regrads. I. Piasecki. - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 12:25 PM Subject: MySQL/InnoDB-3.23.49 is released > Hi! > > InnoDB is a MySQL table type which adds transactions, row level locking, and > foreign key constraints to MySQL. > > InnoDB is included in the MySQL-Max-3.23, MySQL-4.0, and MySQL-Max-4.0 > distributions of MySQL. These can be downloaded from http://www.mysql.com. > For more information about InnoDB see the online refererence manual at > http://www.innodb.com. > > MySQL AB decided to release 3.23.49 so quickly after .48 because the Linux > binary of .48 was linked against a wrong glibc, and it did not work properly > in some computers. > > There are the following bug fixes in InnoDB: > > * Fixed a bug: if you called DROP DATABASE for a database on which there > simultaneously were running queries, the MySQL server could crash or hang. > Crashes fixed, but a full fix has to wait some changes in the MySQL layer of > code. > > * Fixed a bug: on Windows one had to put the database name in lower case for > DROP DATABASE to work. Fixed in 3.23.49: case no longer matters on Windows. > On Unix the database name remains case-sensitive. > > * Fixed a bug: if one defined a non-latin1 character set as the default > character set, then definition of foreign key constraints could fail in an > assertion failure in dict0crea.c, reporting an internal error 17. > > In the MySQL part of code the changelog is the following: > > http://www.mysql.com/doc/N/e/News-3.23.49.html : > > * Don't give warning for statement that is only a comment; This is needed > for mysqldump --disable-keys to work. > > * Fixed unlikely caching bug when doing a join without keys. In this case > the last used field for a table always returned NULL. > > * Added options to make LOAD DATA LOCAL INFILE more secure. > > * MySQL binary release 3.23.48 for Linux contained a new glibc library, > which has serious problems under high load and RedHat 7.2. The 3.23.49 > binary release doesn't have this problem. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, row level locking, and foreign key support for MySQL > See http://www.innodb.com, download MySQL-Max from http://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 > -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - 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: **Backing Up A Database**
How did u do exactly ? It's not documented. Does it take a long. Do u have to flush and lock tables before, that can be critical for 24/24 server. what conf for logrotate ? a+. >I personally issue "mysqldump"s via cron and maintain the files using "logrotate" (Redhat Linux), which >automatically zips and rotates them. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
Re: Setting up replication, cannot connect to Master
Hi Victoria, Vic> Are you sure that your MySQL server (master) is running? mysql> show master status; +-+--+--+--+ | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | bin.005 | 51925| zorka| | +-+--+--+--+ 1 row in set (0.03 sec) Keith ### Keith Elder Email: [EMAIL PROTECTED] AIM: ZZorKKa YIM: keitheld Phone: 1-734-507-1438 Text Messaging (145 characters): [EMAIL PROTECTED] Web: http://www.zorka.com (Howto's, News, and hosting!) "With enough memory and hard drive space anything in life is possible!" ### - 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 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP! MySQL service will not startUp
Robbie,
Monday, February 18, 2002, 4:34:34 AM, you wrote:
RN> I have been working all night on something then Outlook Express crashed my
RN> machine and now after restarting, MySQL service will not start. I am running
RN> it on Win2K Pro and have had no probs until just now. I right click on it
RN> and choose WinNT::Start the service. The dialog comes up asking if I want to
RN> start the service yes, no , cancel and when I click yes the dialog disapears
RN> but the service does not start.
RN> Just noticed in the Err File:
RN> MySql: Table 'mysql.host' doesn't exist
RN> Is that it? If so, how can I fix it?
Start MySQL server with --skip-grant-tables and create table
'mysql.host' by yourself:
CREATE TABLE `host` (
`Host` char(60) binary NOT NULL default '',
`Db` char(64) binary NOT NULL default '',
`Select_priv` enum('N','Y') NOT NULL default 'N',
`Insert_priv` enum('N','Y') NOT NULL default 'N',
`Update_priv` enum('N','Y') NOT NULL default 'N',
`Delete_priv` enum('N','Y') NOT NULL default 'N',
`Create_priv` enum('N','Y') NOT NULL default 'N',
`Drop_priv` enum('N','Y') NOT NULL default 'N',
`Grant_priv` enum('N','Y') NOT NULL default 'N',
`References_priv` enum('N','Y') NOT NULL default 'N',
`Index_priv` enum('N','Y') NOT NULL default 'N',
`Alter_priv` enum('N','Y') NOT NULL default 'N',
PRIMARY KEY (`Host`,`Db`)
) TYPE=MyISAM COMMENT='Host privileges; Merged with database privileges'
--
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
