Re: operating system error number 3
Loretta, please look in the manual http://www.innodb.com/ibman.html : If InnoDB prints an operating system error in a file operation, look from section 13.2 what that error code means. Usually the problem is one of the following: You did not create InnoDB data or log directories. mysqld does not have the rights to create files in those directories. mysqld does not read the right my.cnf or my.ini file, and consequently does not see the options you specified. The disk is full or a disk quota is exceeded. You have created a subdirectory whose name is equal to a data file you specified. There is a syntax error in innodb_data_home_dir or innodb_data_file_path. If something goes wrong in an InnoDB database creation, you should delete all files created by InnoDB. This means all data files, all log files, the small archived log file, and in the case you already did create some InnoDB tables, delete also the corresponding .frm files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. It is best to start the MySQL server from a command prompt so that you see what is happening. 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND Error number 3 means you have not created the InnoDB data or log directories. Please use the MS-DOS mkdir command to create the directories. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Loretta [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Sunday, February 17, 2002 6:27 AM Subject: operating system error number 3 Hello everyone: I am hoping you can help me. I have Windows 98 SE as my operating system. I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but could not make them work together. Hopefully, someone will be able to help me. The error I am getting is InnoDB: Warning: operating system error number 3 in a file operation. InnoDB: Cannot continue operation. I have never used MySQL in my life before this. I have read the manual and done an online search to figure out how to fix this error but have had no luck. If you are able to help me please be detailed in how I am to fix this problem. Any help will be appreciated. I am trying to develop this database for a Church to use. Thank-you, Loretta - 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: WIN/Linux Compatibility
Alex, What I do is a DUMP on the table, either the schema or data or both. This will create a .sql file you can run again against whatever platform you are on -Original Message- From: Alex Charlton [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 3:55 AM To: mySQL Subject: Fw: WIN/Linux Compatibility Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? IE. If I copy windows data files to a linux server, can mySQL on the linux server read this data? I don't believe this is possible, but I couldn't find any posts and wanted to confirm. I realize that we may need to import through an SQL query. Thanks in advance. Alex Charlton [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
How to save the table content into file
Hello, I am looking for how to save into file content of table, Can you give an example of mysql query, 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
ANNOUNCE: moodss-15.8
Note: I am temporarily unsubscribed from this list, so please Cc me at [EMAIL PROTECTED] if you reply to this message. Moodss (a modular monitoring application, graphical and daemon) fully supports the MySQL database and great efforts are made in collaboration with the MySQL AB developer Sinisa Milivojevic, in order to achieve a practical and thorough monitoring of MySQL servers. No less than 7 modules, such as the new myerrorlog and myhealth modules, are available. In this new version, the myerrorlog module has been substantially improved: - can now monitor UNIX servers from a Windows client (using plink from the Windows putty software ensemble) - can now monitor Windows servers from Windows and UNIX clients using the new --file option - displays messages in all supported MySQL languages (japanese, russian, ...) - displays complete multi-line messages instead of just the first line Please refer to the http://jfontain.free.fr/moodss-15.8.CHANGES for a complete list of changes, including better Windows support, myvars module improvement, ... More examples and documentation can be found in the module help file, at http://jfontain.free.fr/myerrorlog/myerrorlog.htm, various screenshots and other modules for MySQL (myhealth, mystatus, myvars, myprocs, myquery, ...) are visible at the moodss and MySQL specific page: http://jfontain.free.fr/mysql/, whereas complete information on moodss itself can be found at http://jfontain.free.fr/moodss/. Development on moodss MySQL modules is very active, and your comments, bug reports, feature requests, ... will be greatly appreciated. Watch this space for new modules... Downloads: http://jfontain.free.fr/moodss-15.8.tar.bz2 http://jfontain.free.fr/moodss-15.8.zip http://jfontain.free.fr/moodss-15.8-1.i386.rpm http://jfontain.free.fr/moomps-1.3-1.i386.rpm http://jfontain.free.fr/moodss-15.8-1.spec Enjoy! -- Jean-Luc Fontaine mailto:[EMAIL PROTECTED] http://jfontain.free.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: How to save the table content into file
Do you mean run a query that pulls all content in a table? OR Something thats saves all content of a table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 8:52 AM To: [EMAIL PROTECTED] Subject: How to save the table content into file Hello, I am looking for how to save into file content of table, Can you give an example of mysql query, 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
Access error when trying to connect from Java
I'm trying to connect like this: Connection conn = DriverManager.getConnection(jdbc:mysql://localhost:3306/homebrew?user=homebrewpassword=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 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 | +-+--+--+-+-+-+-+-+---+-+---+--+---++-+++ -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] -- Mind what you have learned. Save you it can. - 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: Mysqld load
On Sat, Feb 16, 2002 at 02:20:56PM -, Bjorn Swift wrote: Have you optimized the settings in my.cnf and checked your slow queries? No, I haven't optimized my.cnf - looking at it now. Thanks. Well, that was pretty much what I was hoping this tool could do; go though the trace log and print out the slow queries. Is the only way to go manually though mysqld.trace ? I suspect that once you've adjusted the my.cnf settings, you won't need to worry about detailed traces. Have a read thru this: http://jeremy.zawodny.com/mysql/mysql2.pdf for my.cnf pointers. Good luck, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,048,197 queries (378/sec. avg) - 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: HA mysql DB
On Fri, Feb 15, 2002 at 09:43:28AM +0100, Wolfgang Pichler wrote: I have to set up a HA-Linux Server with Apache and mysql running on two machines over load balancing. Apache isn't a problem. But mysql. AFAIK it is impossible to cluster mysql - it only supports replication. As I've said already, we have only two machines, and two firewalls of course, for web and mysql server - but this two machines should for the best work load balanced and failsafe. So, if one machine fails because of a hardware fault - the other machine must be able to overtake the whole work. So it is necersary to install Apache and mysql on both server's. So far, so good. And, to get the best performance out of it, I've got the following idea: The whole WebApplication has an own db interface so that it should be possible to... First Server runs: apache and mysql master - all write Operations are done one the master - read operations from the first server are also done one the master. Yep. Second Server runs: apache and mysql slave - gets synchronized by the master - read operations from the second server are done on the slave - write operations are getting directed to the master - which then synchronize the slave. Makes sense. Because of dynamic load balancing this should get a nice average load. If then one machine fails - then you have on both machines everthing you need to work in standalone mode. Exactly. The only thing is, that you need some scripts which switches the databases from slave to master mode, doing synchronization after the are working again, redirecting all the read/write operations to one machine, and some additional work. If you can guarantee that writes will only ever go to a single machine, set the MySQL servers up as dual-masters and it'll simplify things quite a bit. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,139,757 queries (378/sec. avg) - 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: Replication question
On Fri, Feb 15, 2002 at 10:32:06AM +, Simon Windsor wrote: Currently, I maintain two mysql server, hosted by separate ISPs, and keep them synchronised using standard MySQL replication. Great! Server A is master+slave to server B, and likewise server B is master +slave to server A. This allows both servers to receive inserts/updates/deletes and replicate them accordingly. This has, and continues to work well. The problem I have is simple, it has been decided to have a third web site, with an associated database. Okay... The replication model I have implemented only works with TWO servers. Or so you think. :-) The only solution to this is to add to one servers my.cnf the option LOG-SLAVE-UPDATES and enable read-only replication to this new server. Right. That's one way to do it. If I do add this option, and one server logs all its 'native' transactions + 'replicated' transactions, will this confuse the second server? Nope. Will the second server try and apply the remote native transaactions only, or will I get into a loop of a machine applying its own transactions back on to itself ? It's not a problem because each server has a unique id. The server id of the server which originated each query is stored in the binary log. This helps to prevent looping problems and servers getting confused. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,170,509 queries (377/sec. avg) - 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: table type comparison (poor SELECT performance with HEAP tables ?)
On Fri, Feb 15, 2002 at 04:00:11PM +0100, Antoine wrote: Hello, Well, for my project at work, I've done some small benchmarking of different table types for relatively small sizes (some tens or hundreds of thousands rows - small enough so that key buffer size and other memory factors should not limit performance) and lots of very simple operations. I have the following observation from it : INSERTs : HEAP tables are incredibly faster than everything else. As you'd expect. Then come MYISAM tables (10 to 50 times slower than HEAP), and then the transactional tables (BDB and InnoDB). Makes sense. You can probably get InnoDB closer to MyISAM speeds by tweaking the parameters just right. However the INSERTs were not contained in a single transaction, so this may improve performance. Indeed. SELECTs using indexes : HEAP are the best again, but with quite erratic performance. On some occasions they were extremely fast (100 times faster than other tables), and with other record sets they were only twice faster than other tables (which had, on their side, very stable results) - which means even SELECT COUNT(*) FROM my_table is slower than an INSERT ! I find this quite disturbing, and wonder about the reliability of HEAP tables. Your results could have a lot to do with the fact that HEAP tables used hashed indexes rather than the B-Tree indexes of MyISAM. The set of queries for which MySQL can use a hashed index is far smaller than with B-Tree indexes. For example, with a MyISAM table, MySQL can use indexes for a range query (SELECT ... WHERE foo BETWEEN x AND y). But with HEAP tables, it'll result in a table scan. Also, for disk-based tables, setting the 'noatime' flag was a real benefit for lots of very small queries (some tens of percent faster). Yep. Endly, it seems that restarting MySQL has some positive impact on SELECTs (strangely enough, because one could think that it would have to reload the indexes and thus spend some more time), expect on HEAP tables (!) ; INSERTs weren't affected though. That's rather odd. This was done with MySQL 3.23.43 source distribution, on a bi-processor Intel Redhat box. Which kernel version? Did the machine swap during your tests? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,256,260 queries (377/sec. avg) - 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: memcpu usage (mysqld under Linux RH 7.2)
On Fri, Feb 15, 2002 at 09:17:52PM +0300, Mikhail V.Soloviev wrote: Hello, I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2, pIII-800 512K RAM). It starts and works fine until some time is passed, then it starts eating my memory and CPU. What does SHOW PROCESSLIST say at that time? I have the following config in my.cnf: [mysqld] set-variable = max_connections=200 set-variable = key_buffer=16M set-variable = table_cache=100 set-variable = sort_buffer=4M set-variable = record_buffer=1M set-variable = join_buffer=1M the usual number of connections if 70-120, maximum is 190. How much data do you have? With 512MB of RAM, you can afford to use more for your key_buffer if you have the data to justify it. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,305,254 queries (377/sec. avg) - 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: Slow Query...
On Fri, Feb 15, 2002 at 10:08:08AM +0800, [EMAIL PROTECTED] wrote: Hi, I still got stuck on a query...so slow...it took a minute or more How can I improve my server... Can you tell us what the mysterious query is? And send along the output of EXPLAIN query as well? Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,351,945 queries (377/sec. avg) - 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: Database synchronization
On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote: I'd like to connect a local sql server to a remote server and get 1 database synchronized between them. For various reasons, I need to try to run this from within the sql protocol (i.e. no ftp, etc.). Okay. Replication is not the answer Why not? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,419,246 queries (377/sec. avg) - 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: table type comparison (poor SELECT performance with HEAP tables ?)
Hi, At first thanks for the answer. I was wondering if my mail was precise enough. Your results could have a lot to do with the fact that HEAP tables used hashed indexes rather than the B-Tree indexes of MyISAM. The set No, I've really used queries that take advantage of the hash indexes : i.e. only full keys (not partial), and equality tests (not range or inequality). I've checked it by asking EXPLAIN SELECT : the indexes are used. The first tests were done with partial keys and results were really worse, by the way, but I figured this out and corrected it. Also, the queries are very simple so there is no chance that queries on MyISAM use a bigger amount of indexed columns than on HEAP. It really seems to me that SELECTs should be faster than INSERTs because everything the SELECT does (finding the right leaf in the index tree / hash), the INSERT also does, and the latter furthermore allocated and appends data. I have come to think that the overhead could come from parsing the request and optimizing it, or maybe sending the data to the client (by the way, it is connected via a Unix socket - networking is disabled in the my.cnf) ? (the test does 5000 simple SELECTs and it lasts for 2 or 3 seconds, whereas for 1 simple INSERTs it only lasts for a fraction of second - all this on HEAP tables). This was done with MySQL 3.23.43 source distribution, on a bi-processor Intel Redhat box. Which kernel version? Did the machine swap during your tests? 2.4.16, the filesystem is ext3 with noatime. The machine didn't seem to swap (top showed no change in the amount of allocated memory). Yours Antoine. - 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 fails to compile under RH Linux w/2.4.16 kernel
MySQL 3.23.49 fails to compile under RH Linux w/2.4.16 kernel. It was configure w/InnoDB support. Here's the output: c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c filesort.cc c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c handler.cc In file included from /usr/include/math.h:350, from ../include/global.h:164, from mysql_priv.h:20, from handler.cc:24: /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 URL:http://bugzilla.redhat.com/bugzilla/ for instructions. make[3]: *** [handler.o] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-3.23.49/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.49/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.49' make: *** [all-recursive-am] Error 2 - 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 save the table content into file?
Hello, I want to store my table in text file, I've tried : select * from news into outfile 'news1.txt' but doesn't work Can you help to do this with phpmyadmin or sql, 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
Case Sensitivity Question
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. 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? 2) What version of MySQL did the default of case insensitive searches begin as I'm using 3.23.31. Thanks Mike What you're doing is the opposite of help. --Shrek - 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 save the table content into file?
In phpmyadmin Choose the table from the list... Scroll down the main screen and you will see this: View Dump(schema) of table: You will have options like Structure only, Structure and data, CSV for MS Excel... Structure dumps the column names and all the field types... Structure AND data will dump all the data and the structure Data Only will dump just the data After you choose which one, near the bottom of that table, you will see :Save as File then click go -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 10:02 AM To: [EMAIL PROTECTED] Subject: How to save the table content into file? Hello, I want to store my table in text file, I've tried : select * from news into outfile 'news1.txt' but doesn't work Can you help to do this with phpmyadmin or sql, 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
mysql.sock problem
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
RE: How can you retrieve data in XML format?
Could someone please e-mail me to let me know how data can be retrieved in XML format from my mySQL database? Thank you in advance! [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
OT mysql and rpc
Please forgive the OT, but I am trying to integrate mysql db's with WIN32 clients on Linux servers. I need to use some programs (ONC RPC daemons) on the Linux box from applications written in VC++ on a WIN32 box so RPC seems the correct solution. Can anyone point me in the right direction for WIN32 to Linux C/S samples using ONC-RPC? TIA Pat... [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: mySQL Data to XML Document and the reverse....HOW???
I am still looking for a method of reading XML documents into mySQL database and also to retrieve data from the mySQL database into an XML document I found something on how to do it with PERL but would like to stick with just JAVA... MS SQL Server has this function built in...please let me know what the best method to do this using mySQL Thank you! - 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 do substraction between two tables?
Hi, On Mon, 2002-02-18 at 00:40, [EMAIL PROTECTED] wrote: I want to do substraction between tables in mysql, MINUS not yet implemented in mysql and this not work : select a.* from table_a a where a in (select * from table_b) Please post the structure of both tables. Then we can post you a readable example of how it can be done. The short answer is: use a join. 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
RE: mySQL Data to XML Document and the reverse....HOW???
Hi, On Mon, 2002-02-18 at 08:40, The Majestic Moined Mogul wrote: I am still looking for a method of reading XML documents into mySQL database and also to retrieve data from the mySQL database into an XML document I found something on how to do it with PERL but would like to stick with just JAVA... I'm sure someone will be able to help you with a piece of code. MS SQL Server has this function built in...please let me know what the best method to do this using mySQL Wouldn't you agree that this is not really a task for an RDBMS server? Aren't these typically things that a client application should sort out for itself, in whichever way it likes? 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
Warning: mysql is deprecated???
Hello everyone. I am new to MySQL and am trying to setup a shopping cart using MySQL and PHP. They are files that I found online for free from Rosenet Internet Services. The problem is that when I try to add a category for a product I get this in return: Warning: mysql is deprecated; use mysql_select_db() and mysql_query() instead in (rootPath here)\cart\admin\addcategoryresponse.php on line 7 Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\angrycamel\cart\admin\addcategoryresponse.php:7) in (rootPath here)\cart\admin\addcategoryresponse.php on line 8 What does depricated mean? I have searched the manual and the resources online but cannot find anything about it. Does it mean that the SQL commands that are used in the php script are out dated and need to be changes to...( use mysql_select_db() and mysql_query() instead ) what the warning says??? Any help would be greatly appreciated. TIA -Robbie Newton - 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: Warning: mysql is deprecated???
Hello everyone. I am new to MySQL and am trying to setup a shopping cart using MySQL and PHP. They are files that I found online for free from Rosenet Internet Services. The problem is that when I try to add a category for a product I get this in return: Warning: mysql is deprecated; use mysql_select_db() and mysql_query() instead in (rootPath here)\cart\admin\addcategoryresponse.php on line 7 Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\angrycamel\cart\admin\addcategoryresponse.php:7) in (rootPath here)\cart\admin\addcategoryresponse.php on line 8 What does depricated mean? I have searched the manual and the resources online but cannot find anything about it. Does it mean that the SQL commands that are used in the php script are out dated and need to be changes to...( use mysql_select_db() and mysql_query() instead ) what the warning says??? Depricated means it is an old command or function that is obsolete, the warning is to try to have you use the newer and better functions instead to 'phase' out usage of the old style so one day it is no longer used at all. Perhaps showing the segments of your code causing the errors would help us suggest what may be improved upon. Sincerely, Craig Vincent - 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: Warning: mysql is deprecated???
It means something is out of date...looks like you need an update of something... This is the line 7 that it is talking about How do I know what is out of date and how to fix it? Are there any utilities out there for updating scripts or do I need to manually go into each .php file and update them somehow? use mysql_select_db() and mysql_query() instead mysql($DBName,INSERT INTO Category VALUES('$Category','')); TIA -Robbie - 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: Warning: mysql is deprecated???
This is not a Mysql issue but an PHP one. The function you are using (mysql_db_query ?) is deprecated and should therefore not be used. Try modifying your PHP script to use mysql_select_db(test); mysql_query(select * from tablename); .. instead of mysql_db_query(test,select * from tablename) .. if mysql_db_query is what you're using. Hope this helps, Björn Swift - Original Message - From: Robbie Newton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 18, 2002 12:53 AM Subject: Warning: mysql is deprecated??? Hello everyone. I am new to MySQL and am trying to setup a shopping cart using MySQL and PHP. They are files that I found online for free from Rosenet Internet Services. The problem is that when I try to add a category for a product I get this in return: Warning: mysql is deprecated; use mysql_select_db() and mysql_query() instead in (rootPath here)\cart\admin\addcategoryresponse.php on line 7 Warning: Cannot add header information - headers already sent by (output started at c:\program files\apache group\apache\htdocs\angrycamel\cart\admin\addcategoryresponse.php:7) in (rootPath here)\cart\admin\addcategoryresponse.php on line 8 What does depricated mean? I have searched the manual and the resources online but cannot find anything about it. Does it mean that the SQL commands that are used in the php script are out dated and need to be changes to...( use mysql_select_db() and mysql_query() instead ) what the warning says??? Any help would be greatly appreciated. TIA -Robbie Newton - 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: Warning: mysql is deprecated???
Hi, Warning: mysql is deprecated; use mysql_select_db() and mysql_query() instead in (rootPath here)\cart\admin\addcategoryresponse.php on line 7 [snip] What does depricated mean? I have searched the manual and the resources online but cannot find anything about it. Does it mean that the SQL commands that are used in the php script are out dated and need to be changes to...( use mysql_select_db() and mysql_query() instead ) what the warning says??? Unfortunately for you, yes. The PHP function 'mysql()' is outdated, and it's been replaced with mysql_select_db() and mysql_query() as the error says. I see two possible solutions: 1. Downgrade your PHP to a version where 'mysql()' is not deprecated (version 3.* i think). or 2. Change all instances of 'mysql()' to 'mysql_query()' and make sure to use 'mysql_select_db()' to choose your database or use 'mysql_db_query()' instead. regards, //andreas http://phpwizard.dk (in Danish) - 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: Warning: mysql is deprecated???
It means something is out of date...looks like you need an update of something... This is the line 7 that it is talking about How do I know what is out of date and how to fix it? Are there any utilities out there for updating scripts or do I need to manually go into each .php file and update them somehow? That's normally done by hand. I don't know any utils capable of doing that, but as you've experienced PHP will let you know when you are using deprecated functions :) use mysql_select_db() and mysql_query() instead mysql($DBName,INSERT INTO Category VALUES('$Category','')); That would be: mysql_select_db($DBName); mysql_query(INSERT INTO Category VALUES('$Category','')); or mysql_db_query($DBName,INSERT INTO Category VALUES('$Category','')); regards, //andreas http://phpwizard.dk (in Danish) - 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: Warning: mysql is deprecated???
.. if mysql_db_query is what you're using. Actually below is waht I am using... mysql($DBName,INSERT INTO Category VALUES('$Category','')); After your response, I changed it to... mysql_select_db($DBName); mysql_query(INSERT INTO Category VALUES('$Category','')); Works like a charm... I actually got another error after I made that change, but it was just another deprecated error for another script that it looks to. Looks like I have my work cut out for me getting this updated. Thanks to everyone for the VERY quick and HELPFUL responses; I think I am gonna like it here. :O) -Robbie - 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: Warning: mysql is deprecated???
I just started going into some of the other files that will need updating and I have run into another little prob dealing with the same thing Here it is, maybe you can shed some light on it for me. $result=mysql_db_query($DBName,SELECT Date,BuyerID,OrderNumber FROM Buyers); The $Result variable is used on this SQL query. So if I was to change the query from... mysql_db_query($DBName,SELECT Date,BuyerID,OrderNumber FROM Buyers) to... mysql_select_db($DBName); mysql_query(SELECT Date,BuyerID,OrderNumber FROM Buyers) How do I assign the variable to both of those lines that make up the DB call??? TIA again, -Robbie - 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: Warning: mysql is deprecated???
mysql_select_db($DBName); mysql_query(SELECT Date,BuyerID,OrderNumber FROM Buyers) How do I assign the variable to both of those lines that make up the DB call??? Unless you're planning to use several databases, you only have to use mysql_select_db($DBName); once, normally where you connect to the database. In that way it can be cut down to: $result = mysql_query(SELECT Date,BuyerID,OrderNumber FROM Buyers); regards, //andreas http://phpwizard.dk (in Danish) - 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 up replication, cannot connect to Master
Greetings, I have spent a few hours trying to setup a replication server for testing and I cannot get the slave to connect to the master server: Here is the error: 020217 21:11:25 Slave thread: error connecting to master: Can't connect to MySQL server on '192.168.1.2' (111) (107), retry in 60 sec I noticed that I cannot telnet to the 192.168.1.2 mysql port number of 3306 on this server. I am not sure if this is the problem or if by setting things up in the my.cnf files works around this. Anyone have any tips? 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL Data to XML Document and the reverse....HOW???
MS SQL Server has this function built in...please let me know what the best method to do this using mySQL Wouldn't you agree that this is not really a task for an RDBMS server? Aren't these typically things that a client application should sort out for itself, in whichever way it likes? Typically, yes. And for more versatility, yes. But since the machine has to spit data out in SOME way, XML seems as good a choice as any. I, at least, find the native XML in SQL Server to be an incredibly handy feature. Of course, it probably has many other problems that I don't know about yet :) c -- Chris Lott http://www.chrislott.org/ - 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: Database synchronization
In Re: Database synchronization, [EMAIL PROTECTED] wrote: On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote: I'd like to connect a local sql server to a remote server and get 1 database synchronized between them. For various reasons, I need to try to run this from within the sql protocol (i.e. no ftp, etc.). Okay. Replication is not the answer Why not? Hmm, looks like I left out that it's a once a day synchronization. The remote is very very busy in the mornings, but idle in the afternoons. However, I've already solved this problem via the API. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How compressable is a typical MySQL database?
Oh. OK. Didn't know that. Thanks. j- k- On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote: On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote: In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's could give you tables in inconsistent states, UNLESS you first shut down your DB server, then run the backup. Not true at all. Try this: FLUSH TABLES WITH READ LOCK back stuff up UNLOCK TABLES It's safe and keeps the server on-line. Jeremy -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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: Selecting records with the highest value no greater than x
Hi Benjamin, The perfect answer. Thank you, Anvar. At 08:44 AM 16/02/2002 +0100, you wrote: Hi. On Fri, Feb 15, 2002 at 09:05:02PM -0800, [EMAIL PROTECTED] wrote: In Re: Selecting records with the highest value no greater than x, [EMAIL PROTECTED] wrote: Hi Brent, I cannot think of a single query doing your job. IMO, there is one, if I did understand the question correctly: SELECT * FROM NEWS WHERE RATING = 4 ORDER BY RATING DESC, RAND() LIMIT 1; This give back a random news entry of the highest score available, but smaller than 5. But it can be done with two. SELECT @maxrating := MAX(RATING) FROM NEWS WHERE RATING = 4; SELECT * FROM NEWS WHERE RATING=@maxrating ORDER BY RAND() LIMIT 1; [...] Nice, assuming that the @maxrating is the syntax for a local variable within the server. Where is that discussed in the manual? They can be found under the term user variables: http://www.mysql.com/doc/V/a/Variables.html Some simple use of an API is the probably the best answer, it's probably ~ 25 lines of perl. [...] Depends on the needs. A pure SQL solution should be noticeably faster. Bye, Benjamin. -- [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
HELP! MySQL service will not startUp
I have been working all night on something then Outlook Express crashed my machine and now after restarting, MySQL service will not start. I am running it on Win2K Pro and have had no probs until just now. I right click on it and choose WinNT::Start the service. The dialog comes up asking if I want to start the service yes, no , cancel and when I click yes the dialog disapears but the service does not start. Just noticed in the Err File: MySql: Table 'mysql.host' doesn't exist Is that it? If so, how can I fix 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
How to load data?
Hi, I am currently running mySQL with a slave...I just wondering if there's a way to replicate all data available in the master to be copied to the slave in one single command... My master server is running ahead than my slave...so my slave is only filled with user data... Is there a way to do it once? R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 - 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 load data?
I am currently running mySQL with a slave...I just wondering if there's a way to replicate all data available in the master to be copied to the slave in one single command... My master server is running ahead than my slave...so my slave is only filled with user data... Is there a way to do it once? I don't know of a way to replicate all data from master to slave with one command but you can replicate tables from the master to the slave with a command...it would mean needing to DROP all your current tables on the slave and reload them up from the master (if the user data from the slave is critical, simply run a little script to take the current data off the slave and append it into the master database(s)). Once that is done you can use the command LOAD TABLE table FROM master for each table you want to have syncronized (there may be ways of instasynching entire databases however you'd need to check the MySQL docs). You must drop the tables from the slave that you want to reload from the master, otherwise you will get an error. Sincerely, Craig Vincent - 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
Good, Free Mac GUI to mySQL?
Suggestions: Good, Free Mac GUI to mySQL? Please email directly to me at: [EMAIL PROTECTED] Thanks, Gary - 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
If Foreign Key supports mean...
Hi, I want to correct myself about Mysql-Max . I installed mysql-max and worked with java application works perfectly and could create InnoDB tables with Foreign Key references, but I need to know about is it installed perfectly and supports transaction or any other settings have to be done. Please clear me Rgds, Perumal. - 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
Warning, Found xxx parts Should be: 0 parts
Description: After inserting 1062351 records into a table I create 2 index on the table. It seems like after creating the indexs (test have shown that the error appears after creating the first index) I get the following warning when i do a CHECK TABLES mytablename or a mysisamchk -a mytablename: Found 1062351 partsShould be: 0 parts I have tried to fix with myisamchk -f mytablename but it does not correct the problem How-To-Repeat: I cannot include the data set I am loading. the basic step are: DROP mytablename IF EXISTS mytablename; CREATE TABLE mytablename ( myid1 int, title text, description text, classid int, distribution int ); LOAD DATA CONCURRENT INFILE /usr/mydataset/mydata.dat INTO TABLE mytablename FIELDS TERMINATED BY '~~'; ALTER TABLE mytablename ADD INDEX idx_myid1 (myid1); ALTER TABLE mytablename ADD INDEX idx_dist (distribution); CHECK TABLES mytablename; after the above step i get the warning: Found 1062351 parts Should be: 0 parts The number of record in mytablename is 1062351 Fix: This is a warning. I don't have a fix Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Warning: Found 1062351 parts Should be: 0 parts after creating index Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, 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 4.0.1-alpha Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 days 16 hours 14 min 1 sec Threads: 2 Questions: 1582 Slow queries: 87 Opens: 409 Flush tables: 6 Open tables: 6 Queries per second avg: 0.004 Environment: System: Linux bigbone 2.4.16 #3 SMP Thu Dec 13 21:15:14 PST 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='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 23 09:39 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 06:04 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 06:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 06:02 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --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/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beginner question: how many queries via PHP are...
At 08:33 PM 2/16/2002 , you wrote: Hello I am new to the subject. I am experimenting in mysql via PHP with a nice book (PHP and MySQL Web development). My question is how many queries to mysql, made via PHP, should considered ok for efficiency. I know it has much to do with the size of databases, but I would like to get an idea. Thanks. Nikolas Nikolas, One thing you may want to implement is adding a LIMIT clause to your queries to prevent users from returning too many rows. Mine would be set to 100 and in a lot of cases, fewer than that. The queries will run much faster. 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
Re: Warning, Found xxx parts Should be: 0 parts
I had a typo I was trying to use myisamchk -r not -f to fix it which did not fix it. myisamchk -o seems to fix the problem. The real question is why am i getting this when creating index(s). Although I'm using the Alpha version, I don't get a warm fuzzy Any responses on what could be causing this would be great. On Sun, 2002-02-17 at 20:36, [EMAIL PROTECTED] wrote: Description: After inserting 1062351 records into a table I create 2 index on the table. It seems like after creating the indexs (test have shown that the error appears after creating the first index) I get the following warning when i do a CHECK TABLES mytablename or a mysisamchk -a mytablename: Found 1062351 partsShould be: 0 parts I have tried to fix with myisamchk -f mytablename but it does not correct the problem How-To-Repeat: I cannot include the data set I am loading. the basic step are: DROP mytablename IF EXISTS mytablename; CREATE TABLE mytablename ( myid1 int, title text, description text, classid int, distribution int ); LOAD DATA CONCURRENT INFILE /usr/mydataset/mydata.dat INTO TABLE mytablename FIELDS TERMINATED BY '~~'; ALTER TABLE mytablename ADD INDEX idx_myid1 (myid1); ALTER TABLE mytablename ADD INDEX idx_dist (distribution); CHECK TABLES mytablename; after the above step i get the warning: Found 1062351 parts Should be: 0 parts The number of record in mytablename is 1062351 Fix: This is a warning. I don't have a fix Submitter-Id:submitter ID Originator: [EMAIL PROTECTED] Organization: MySQL support: none Synopsis:Warning: Found 1062351 parts Should be: 0 parts after creating index Severity:non-critical Priority:low Category:mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, 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 version4.0.1-alpha Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 days 16 hours 14 min 1 sec Threads: 2 Questions: 1582 Slow queries: 87 Opens: 409 Flush tables: 6 Open tables: 6 Queries per second avg: 0.004 Environment: System: Linux bigbone 2.4.16 #3 SMP Thu Dec 13 21:15:14 PST 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='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 23 09:39 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 06:04 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 06:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 06:02 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --with-innodb --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/info --includedir=/usr/include --mandir=/usr/man --with-embedded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - 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: Warning, Found xxx parts Should be: 0 parts
Hi, This is a bug in myisamchk. The problem is already fixed in mysql-4.0.2 : http://www.mysql.com/doc/N/e/News-4.0.2.html Fixed new bug in myisamchk where it didn't correctly update number of ``parts'' in the MyISAM index file. Best Regards, Jocelyn Fournier Presence-PC - Original Message - From: Amir Aliabadi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 18, 2002 6:58 AM Subject: Re: Warning, Found xxx parts Should be: 0 parts I had a typo I was trying to use myisamchk -r not -f to fix it which did not fix it. myisamchk -o seems to fix the problem. The real question is why am i getting this when creating index(s). Although I'm using the Alpha version, I don't get a warm fuzzy Any responses on what could be causing this would be great. On Sun, 2002-02-17 at 20:36, [EMAIL PROTECTED] wrote: Description: After inserting 1062351 records into a table I create 2 index on the table. It seems like after creating the indexs (test have shown that the error appears after creating the first index) I get the following warning when i do a CHECK TABLES mytablename or a mysisamchk -a mytablename: Found 1062351 partsShould be: 0 parts I have tried to fix with myisamchk -f mytablename but it does not correct the problem How-To-Repeat: I cannot include the data set I am loading. the basic step are: DROP mytablename IF EXISTS mytablename; CREATE TABLE mytablename ( myid1 int, title text, description text, classid int, distribution int ); LOAD DATA CONCURRENT INFILE /usr/mydataset/mydata.dat INTO TABLE mytablename FIELDS TERMINATED BY '~~'; ALTER TABLE mytablename ADD INDEX idx_myid1 (myid1); ALTER TABLE mytablename ADD INDEX idx_dist (distribution); CHECK TABLES mytablename; after the above step i get the warning: Found 1062351 parts Should be: 0 parts The number of record in mytablename is 1062351 Fix: This is a warning. I don't have a fix Submitter-Id: submitter ID Originator: [EMAIL PROTECTED] Organization: MySQL support: none Synopsis: Warning: Found 1062351 parts Should be: 0 parts after creating index Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-4.0.1-alpha (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, 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 4.0.1-alpha Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 days 16 hours 14 min 1 sec Threads: 2 Questions: 1582 Slow queries: 87 Opens: 409 Flush tables: 6 Open tables: 6 Queries per second avg: 0.004 Environment: System: Linux bigbone 2.4.16 #3 SMP Thu Dec 13 21:15:14 PST 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='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex ceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 23 09:39 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5723311 Dec 8 06:04 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314296 Dec 8 06:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Dec 8 06:02 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien t-ldflags=-all-static --without-berkeley-db --with-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/us r/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --with-embe dded-server --enable-thread-safe-client '--with-comment=Official MySQL RPM' - 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
question about duration of connection
Dear Friends, I am using MySql server in my application. My application needs MySql server to be running for 24 hours and needs to make connection with server at any time. I have heared that by default MySql server will close the connection after 8 hours. So, does it mean that after every 8 hours I need to restart MySql server? If it is true, is there any solution for it? How can I run MySql server for 24 hours without manual intervention? If anybody can provide me guidance, it would be greatly helpful to me. Thank You gaurang. - 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-Max Transaction...
Hi, Could you please correct my doubt about Mysql-Max . I installed mysql-max and worked with java application works perfectly and could create InnoDB tables with Foreign Key references but I did't set anything in My.cnf, So, I need to know is it installed perfectly and supports transaction or any other settings have to be done. Please clear me Rgds, Perumal. - 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
Access error when trying to connect from Java
Please I need some help here, I don't think I understand the rights architecture in MySQL. I'm trying to connect like this: Connection conn = DriverManager.getConnection(jdbc:mysql://localhost:3306/homebrew?user=homebrewpassword=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 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 | +-+--+--+-+-+-+-+-+---+-+---+--+---++-+++ -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] -- Mind what you have learned. Save you it can. - 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