Re: regular backup database in mysql
hi i do this on windows2000 like that first I create directory Archive on local disk and in that dir some subdirs like mon,tue ... for every weekday then you should create ms-dos batch file e.g. back0.bat in root of disk c:\ and put commands in it: rem BACKUP mysqldump -h192.168.1.1 -uroot -pxxx --opt databasename c:\Archive\%1\arch.sql arj m arch arch.sql rem END BACKUP then you call this batch file from scheduled task in control pannel with syntax c:\back0 Mon and set scheduled task to run every monday at 9:00 pm which will then create a backup of this database in dir c:\Arhive\Mon\arch.sql first line do mysqldump of database databasename into archive on local filesystem c:\Arhive\arch.sql second line (if you have utiliti ARJ) do a move of arch.sql into arj arhive with name arch.arj with this aproach you can setup backup with scheduled tasks for every day in a week or even once a month etc I do backup in this way on several PCs in my firm so I have arhive for every day for past 7 days on at least 3 different locations nice day primoz - Original Message - From: lorenzo.kh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 08, 2002 8:14 AM Subject: regular backup database in mysql I am using MySql version 4.0.0-alpha in Windows 2000. Everytime when I want to backup the database,i do it in MS-DOS. Using this command: mysqldump --opt mydatabasename mybackup.sql Now,lets say i never shut down my pc and the MySql is running all the time. How can i do a regular backup (ie.every evening 9.00 pm) automatically? - 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: Table full with InnoDB
Well, it will NOT let me add more ibdata files: Any ideas?? Thanks, Spiros Here is hostname.err (On a 2GB RAM, 2x1000 CPU, ) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 751045500 020418 0:50:33 InnoDB: Started /usr/sbin/mysqld: ready for connections InnoDB: Assertion failure in thread 40971 in file trx0trx.c line 228 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against 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. key_buffer_size=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=10 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer) *max_connections = 434131 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db7f 0x823d60a 0x8179eac 0x80d50b7 0x80cd82d 0x807798d 0x807d88a 0x8082515 0x824f1b8 0x823d383 0x823ab69 0x807d905 0x8084403 0x823baa7 0x826c1ca New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=2916 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2916 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 020418 14:01:56 mysqld restarted InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port= 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= max_connections=10 set-variable= tmp_table_size=400M set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=4 # Try number of CPU's*2 #set-variable = myisam_sort_buffer_size=64M set-variable= myisam_sort_buffer_size=4M innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata 3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata 7:2000M;ibdata8:2000M;/usr/ibdata/ibdata9:2000M;/usr/ibd ata/ibdata10:2000M #Comment works ok with: #innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdat a3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdat a7:2000M;ibdata8:2000M # Also adding ibdata9:2000M to /var/lib/mysql does not work log-bin server-id = 1 #set-variable= open-files-limit=8192 #ulimit is 1024,hard 8192 set-variable = innodb_buffer_pool_size=750M set-variable = innodb_additional_mem_pool_size=400M # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=384M #set-variable = bdb_max_lock=10 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable= max_allowed_packet=256M [mysql] no-auto-rehash #safe-updates # Remove the comment character if you are not familiar with SQL
Re: [MANY to MANY] relationship with MySQL ???
I guess You could write Your query with JOIN statements to to get all information by one single query, not having to store things in PHP arrays. a simpe one could look like this... /* depending on what criteria is beeing used */ $match = artist.name = $submitted_artist; $match = songs.name = $submitted_song; /* axs = artists_x_songs */ $SQL = SELECT artists.name, songs.name FROM artists, songs, axs WHERE ; $SQL .= artists.id=axs.artist AND songs.id=axs.song AND $match; I'm sorry but I haven't time to test this in practice but i'm 97% that it works... ofcource You have to modify the query to match Your DB layout =d0Mi= - Original Message - From: Matthew Smith [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 8:04 AM Subject: Re: [MANY to MANY] relationship with MySQL ??? Hi Robbie Reading what I wrote wasn't very clear to me either ;-) How does song_x_artist reference the other databases? Is there a way to set up a field to always be a reference to another table? I think you may be talking foreign keys here - something yet to come in MySQL AFAIK. I am not quite sure what you mean... but here is my take anyways. Is this going around my elbow? Or is this just how you do relationals in SQL? This is a standard way of doing many-to-many relationships in SQL; there may be others. (For each relationship you may want to have in a system, you must set up a table to house that relationship?) For each M2M, basically, yes. Table::song_x_artist * PrimID (can't duplicate) SongID (can duplicate) ArtistID (can duplicate) Yep - I don't use the primary key when I do it, but by using one you can obviously avoid unwanted duplications. (PHP) MySQL * $songID = (the id of the song the user selected to sample) $artistsOnSong = Select * from song_x_artist where songID = $songID while ($artistArray= mySQL_Fetch_Array ($artistsOnSong)){ $currentArtists = Select * from Artists where artistID = $artistArray[ArtistID] while ($artistInfo= mySQL_Fetch_Array ($currentArtists)){ file://start to build the html table of the related artists for the song here. } } Would that work? And if it does... I am not so sure about how to write it out, so if you have any suggestions on better syntax, please advise. 'Ang on - I'm not a PHP man so I've got to think my way through the code... Yep - if I read that correctly, should be OK. Assuming that we're starting with a song, the steps are: 1) Grab the song ID (primary key) from the songs table. 2) Select all the Artist IDs from the song_x_artist (x-reference) table and push them into an array. (This is why we want sub-selects in MySQL 4!) 3) Pop each value from the array and use it as the criterion to select all the details that you want from the artists table - what comes back is your final results. So, yes, what you've done looks right. Only one way to find out ;-) Cheers Matthew Smith - 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: Encrpt/Decrypt
Just want to add a few more things here that might spark your brain cells. All in all I agree with the suggestions presented. Use an encrypt function in your code, for something simple I've created a very basic encryption function in perl using Crypt::Blowfish modules and then I have control of the key to encrypt and decrypt it. Then you can process your request over SSL (if possible) just run the script over https if supported and then store the encrypted value in the database as a string. I think you can even run SSL on MySQL so that you can secure your connections further especially if you're replication your database etc. The MD5() function in PHP might also do the trick for you. http://www.php.net/manual/en/function.md5.php Good luck JM Gregory Junker wrote: and it's all-around better to encrypt the password BEFORE you transmit it over an unsecure connection, or even between processes on a potentially unsecure machine. This means using, for example, the MD5() function in PHP... -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:51 AM To: mysql Subject: Re: Encrpt/Decrypt Manish Mehta wrote: Hi I can Encrypt password in mysql using password() command. what is the way to decrypt the password. Manish Hi Manish / All Somebody correct me if I'm wrong, but I think that what happens is what's called one-way encryption. This is how stuff is done in the world of Unix (and its clones) and others. Authentication is done by taking the password provided, encrypting it, then comparing against the encrypted key in the database. Cheers M -- Matthew Smith | _ ASCII Ribbon Campaign IT Consultant | ( ) - No HTML/RTF in e-mail Kadina, South Australia | X - No Microsoft docs in e-mail http://www.kbc.net.au | / \ - No vCards Ph: +61 888 212 395 | - 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: Math Computations
I agree with the suggestion below strip the character and typecast it if necessary. In JSP I think you can convert it to a number and then typecast it. In PHP, I think the principles might be the same. In addition, it might be a good idea to restrict the columns that require computation to a numeric value rather than a string because you can always add the comma later when totalling it for display. It might also be more efficient for sorting and doing sums, totals etc from your select statements.(i.e. select sum() total()) since computers are inherently better at handling numbers than strings (though I could be mistaken) So if its possible for you to redeclare the table definition then that will be great. Good luck [EMAIL PROTECTED] wrote: It could be best to parse and remove ',' from both of them first before calculation... R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: delz [SMTP:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 1:50 PM To: [EMAIL PROTECTED] Subject:Re: Math Computations Hi All, How do I make calculations in php or mysql if the value has a comma like 2,000 + 32,000 = 34,000. I have a problem calculating if one of my values has a comma. It doesn't display the right output. I'll appreciate anyone who can help me with this. Thanks. Delz. - Original Message - From: Adam Alkins [EMAIL PROTECTED] To: delz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 5:44 PM Subject: Re: Math Computations Something like ? $db = mysql_connect(localhost,database_user,password); mysql_select_db (database_name); $query = SELECT * FROM table_name; $result = mysql_query($query); echo Computers | Department | Price Per PC | Total Amountbr; while ($row = mysql_fetch_row($result)){ $subtotal=$row[0]*$row[2]; $total+=$subtotal; echo $row[0] | $row[1] | $row[2] | $subtotalBR; $comptotal+=$row[0];} } echo $comptotal $total; ? Obviously format it into a table would make sense, e.t.c. Adam - Original Message - From: delz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 5:29 AM Subject: Math Computations Hi, I have this table that looks like this Computers | Department | Price per PC | TotalAmount | 15 | Marketing | $500.00| | 5 | Purchasing | $ 300.00 | | I want this table to display the total price wherein Computer * Price Per PC = TotalAmount and want to display the total no. of computer and the OverAll TotalAmount. I want the output to look like this Computers | Department | Price per PC | TotalAmount | 15 | Marketing | $500.00| $ 7500.00 | 5 | Purchasing | $ 300.00 | $ 900.00 | - --- 20 $ 8400.00 Can anyone help me how to do this in mysql or php. I will surely appreciate any help I can get. Thanks. Delz - 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
MySQL for Digital UNIX V4.0F (Rev. 1229) binary?
We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but only binary is for OSF 5.1 version. This isn't adecvate. Can anybody help us in compiling source or have anybody binary version (just compiled)? Txs - 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: Installing....
Hi again, Th for the answer, but I still don't understand why do I get this error message. :( EZ mkdir .libs EZ gcc -O3 -DDBUG_OFF -O3 -mpentiumpro -felide-constructors -fno-exceptions EZ -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o EZ libs/mysql mysql.o readline.o sql_string.o completion_hash.o . EZ /readline/libreadline.a -lncurses ../libmysql/.libs/libmysqlclient.so -lz EZ -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl EZ /var/local/macasa/mysql-3.23.46/lib/mysql EZ ./libmysql/.libs/libmysqlclient.so: undefined reference to `atexit' EZ collect2: ld returned 1 exit status EZ make[2]: *** [mysql] Error 1 EZ make[2]: Leaving directory `/root/kituri/mysql/mysql-3.23.46/client' EZ make[1]: *** [all-recursive] Error 1 EZ make[1]: Leaving directory `/root/kituri/mysql/mysql-3.23.46' EZ make: *** [all-recursive-am] Error 2 EZ What is wrong with this? EZ My gcc is gcc version 2.96 2731 (Red Hat Linux 7.0). EZ Should I downgrade to 2.95? EZ I tried to compile this mysql version before with this gcc and it worked EZ fine... It looks like you have conflict with your MySQL servers (old and new) ... Take down your MySQL server and install it afresh .. - I have more then one Mysql server on this redhat7.0 server. There are working on different ip-s and ports. Which one should I take down? This conflict results upon the fact that the compiler uses some older lib -files instead of this 49 version distribution libs? All these Mysql servers were compiled( not rpms) so I have all servers placed in different folders. How can this compiler know where are these older lib files placed? I tried to downgrade my gcc to 2.95 version with an rpm which recuired an older cpp but with that the configure part dies. I get some error which notice me that gcc could not make any executable files :(. I upgraded back my gcc and tried to compile with -with-low-memory \ option but with no luck this time, too. :( My basic problem is: I want to install the 49 version Mysql and integrate the reverse_lookup and lookup functions which are included in the source distrubution, in the sql folder, in the udf_example.cc file. If this is possible by installing the binary then please let me know because I am at the end of my soplution list. :) I have compiled several mysql servers before but this is the first time when I experience such problems with it. th zoli - 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 needed with indexes / optimising query
Heya. Firstly, appologies if this is the wrong maillist to send this too. I'm using a great request tracking software package called RT ( www.fsck.com ) , however my database seems to be a little larger than the ideal config for this system as its not scaling very well, i've tracked most of the problems down to one query that takes forever to run, as it seems to access every row in the tables its looking at, I was hoping for some help in optimising this query or in creating some better indexes for it. Oh, and I have tried to get a solution from the RT mailing lists first, but no real luck I've tried a few different indexes myself, but nothing seems to work. when I explain this query it shows that all the rows are beening looked at to resolve this query. I would be very thankful for any help with this. Here is the query SELECT DISTINCT main.* FROM Tickets main, Watchers Watchers_1 LEFT JOIN Users as Users_2 ON Watchers_1.Owner = Users_2.id WHERE ((main.EffectiveId = main.id)) AND ((Watchers_1.Scope = 'Ticket')) AND ((Watchers_1.Type = 'Requestor')) AND ((Watchers_1.Email = '[EMAIL PROTECTED]')OR(Users_2.EmailAddress = '[EMAIL PROTECTED]')) AND main.id = Watchers_1.Value ORDER BY main.id DESC LIMIT 50 the tables are as follows mysql describe Tickets - ; +-+--+--+-+--+-- --+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+--+-- --+ | id | int(11) | | PRI | NULL | auto_increment | | EffectiveId | int(11) | YES | MUL | NULL | | | Queue | int(11) | YES | MUL | NULL | | | Type| varchar(16) | YES | | NULL | | | IssueStatement | int(11) | YES | | NULL | | | Resolution | int(11) | YES | | NULL | | | Owner | int(11) | YES | MUL | NULL | | | Subject | varchar(200) | YES | | [no subject] | | | InitialPriority | int(11) | YES | | NULL | | | FinalPriority | int(11) | YES | | NULL | | | Priority| int(11) | YES | | NULL | | | Status | varchar(10) | YES | | NULL | | | TimeWorked | int(11) | YES | | NULL | | | TimeLeft| int(11) | YES | | NULL | | | Told| datetime | YES | | NULL | | | Starts | datetime | YES | | NULL | | | Started | datetime | YES | | NULL | | | Due | datetime | YES | | NULL | | | Resolved| datetime | YES | | NULL | | | LastUpdatedBy | int(11) | YES | | NULL | | | LastUpdated | datetime | YES | | NULL | | | Creator | int(11) | YES | MUL | NULL | | | Created | datetime | YES | | NULL | | | Disabled| smallint(6) | | | 0| | +-+--+--+-+--+-- --+ 24 rows in set (0.00 sec) mysql describe Watchers - ; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | Type | varchar(16) | YES | MUL | NULL|| | Scope | varchar(16) | YES | MUL | NULL|| | Value | int(11) | YES | | NULL|| | Email | varchar(255) | YES | MUL | NULL|| | Quiet | int(11) | YES | | NULL|| | Owner | int(11) | YES | MUL | NULL|| | Creator | int(11) | YES | | NULL|| | Created | datetime | YES | | NULL|| | LastUpdatedBy | int(11) | YES | | NULL|| | LastUpdated | datetime | YES | | NULL|| +---+--+--+-+-++ 11 rows in set (0.01 sec) mysql describe Users; +---+--+--+-+-+- ---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+- ---+ | id| int(11) | | PRI | NULL| auto_increment | | Name | varchar(120) | | UNI | | | | Password | varchar(40) | YES | | NULL| | | Comments | blob | YES | | NULL| | | Signature | blob | YES | | NULL| | | EmailAddress |
Re: MySQL for Digital UNIX V4.0F (Rev. 1229) binary?
On Thu, 18 Apr 2002, Atila Hajnal wrote: We have Digital UNIX V4.0F (Rev. 1229) and we will to run MySQL but only binary is for OSF 5.1 version. This isn't adecvate. Can anybody help us in compiling source or have anybody binary version (just compiled)? I have a version 3.23.18 binary built under DU 4.0D if that's of any help to you. Should run OK under 4.0F. If you can wait a week or so, I'm about to build 3.23.49 on this platform and you can have that binary also. Andy - 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
Foreign keys
Hello! I have a problem: How can I find the FOREIGN KEY definitions for a table? I'm using MySQL 4.0.1 MAX, and I define the table as a InnoDB-table. Someone, pleace help me! Marius - 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
Migration from windows to linux
Hello list, I`m a newbie to mysql and linux and have at the moment a necessity concerning to both that I`m not able to handle due to my lack of knowledge in these fields. The fact is that I need to migrate a mysql database and its tables from windows to linux and haven`t found anything in the web that could give me a hint so could someone tell me something about how to migrate a database from one platform to another? I really would appreciate the help! Looking forward at least one answer ;-) , thanks a lot in advance. Sonia. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is there a function like for multiplying grouped values ... ?
Say, I have a table (simple case): +--+---+ |id|val| +--+---+ | 1| 10| | 1| 20| | 2| 5| | 2| 5| | 2| 10| +--+---+ SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)| ++---+ | 1|200| | 2|250| ++---+ ** I know there is now function MUL(), but is there anything comparable ? Thanx (mysql,query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there a function like for multiplying grouped values ... ?
SELECT id, MUL(val) FROM above_table GROUP BY id; I would get: ++---+ | id| MUL(val)| ++---+ | 1|200| | 2|250| ++---+ ** I know there is now function MUL(), but is there anything comparable ? Nope, you have to write your own UDF. sql, table -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.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: Foreign keys
Hi! use mysqlSHOW TABLE STATUS FROM yourdatabasename LIKE 'yourtablename'; 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 - Original Message - From: Marius Røstad [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, April 18, 2002 11:44 AM Subject: Foreign keys Hello! I have a problem: How can I find the FOREIGN KEY definitions for a table? I'm using MySQL 4.0.1 MAX, and I define the table as a InnoDB-table. Someone, pleace help me! Marius - 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: a query from php doen't work
The problem was with the ; I ended my queries on each line (!!!) Not needed for only one query -one for every line. Thanks to you all and to those who send me prive Now runs on server too, only I had to change the filename to upercase.(Linux server) Makis -Original Message- From: Carsten Gehling [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 11:23 PM To: savaidis; [EMAIL PROTECTED] Subject: SV: a query from php doen't work Fra: savaidis [mailto:[EMAIL PROTECTED]] Sendt: 17. april 2002 22:14 Emne: a query from php doen't work I get a Query failed error on this: What could hapent? Try to alter this line: $result=mysql_query($buffer); to look like this: $result=mysql_query($buffer) or die($buffer.hr.mysql_error()); Then you will a) print the failed query, and b) print MySQL's own error-response. Then you cal probably figure out, what is wrong. - 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
RE: Migration from windows to linux
* Sonia I`m a newbie to mysql and linux and have at the moment a necessity concerning to both that I`m not able to handle due to my lack of knowledge in these fields. The fact is that I need to migrate a mysql database and its tables from windows to linux and haven`t found anything in the web that could give me a hint so could someone tell me something about how to migrate a database from one platform to another? I really would appreciate the help! 1. Export your data with the mysqldump utility: C:\mysql\bin\ mysqldump --opt dbname export_file.sql URL: http://www.mysql.com/doc/m/y/mysqldump.html 2. Transfer the data to the linux box 3. From the linux box, import the data with a statement like: $ mysql dbname export_file.sql ($ is my linux prompt... yours may be different) You may need to provide extra parameters, like -u for user name, -p for password. If you have a TCP/IP connection between the win box and the linux box, you could do it all in one operation from the win machine...: C:\mysql\bin\ mysqldump dbname | mysql -h ip-to-linux-box -- Roger - 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 client issues
I can get safe_mysqld to run, but when I launch mysql I receive the error message listed below. Any thoughts what cause this issue would be appreciated. ++ E R R O RM E S S A G E ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed +++ root 17181 17127 0 05:32:07 pts/60:00 /bin/sh ./safe_mysqld mysql 17203 17181 0 05:32:09 pts/60:00 /usr/local/mysql/libexec/mysqld l # ./mysqlbug.sh 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: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) 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-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@) Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.45, for sun-sola ris2.5.1 on sparc 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.45 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 min 58 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open table s: 0 Queries per second avg: 0.017 Environment: machine, os, target, libraries (multiple lines) System: SunOS dbmon 5.6 Generic sun4m sparc SUNW,SPARCstation-20 Architecture: sun4 Some paths: /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='@CC@' CFLAGS='@CFLAGS@' CXX='@CXX@' CXXFLAGS='@CXXFLAGS @' LDFLAGS='@LDFLAGS@' LIBC: -rw-r--r-- 1 bin bin 1585072 Jul 15 1997 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 24 21:47 /lib/libc.so - ./libc.so. 1 -rwxr-xr-x 1 bin bin 1000252 Jul 15 1997 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1585072 Jul 15 1997 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 24 21:47 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 bin bin 1000252 Jul 15 1997 /usr/lib/libc.so.1 Configure command: @CONF_COMMAND@ # ./mysqlshow +---+ | Databases | +---+ | mysql | | test | +---+ _ Chat with friends online, try MSN Messenger: http://messenger.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: can't init my database for innoDB in mysql
Hi! You have not specified innodb_data_home_dir. Then InnoDB uses the MySQL datadir as the default home dir. But below you are putting absolute file paths to the last two data files: innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata 3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata 7:2000M;ibdata8:2000M;/usr/ibdata/ibdata9:2000M;/usr/ibd ata/ibdata10:2000M You should set in my.cnf innodb_data_home_dir= and then specify the absolute file paths to each of your data files. 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: [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 1:33 PM Subject: Re: can't init my database for innoDB in mysql Hi Heikki, sorry for a direct question I need an answer whether I should submit an InnoDB problem as a bug or whether it is already known I am using 4.01 with InnoDB. This does not,as I understand support autoextend, so I need to have a few ibdatas, of size 2GB each , since I think this is max (under Linux 2.4.10). I have currently ibdata1-ibdata8 and there is no problem. However, I get table full, so I am adding more and this is where the problems start. Please advise if ibdata8 is the max or else known problem. If not, please let me know if this should be submitted as a bug report(after analysing the stack) Thanks, S.Alexiou [EMAIL PROTECTED] Here is hostname.err (On a 2GB RAM, 2x1000 CPU, see end for df -h) InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 3 751045500 020418 0:50:33 InnoDB: Started /usr/sbin/mysqld: ready for connections InnoDB: Assertion failure in thread 40971 in file trx0trx.c line 228 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against 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. key_buffer_size=402649088 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=10 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer) *max_connections = 434131 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x807db7f 0x823d60a 0x8179eac 0x80d50b7 0x80cd82d 0x807798d 0x807d88a 0x8082515 0x824f1b8 0x823d383 0x823ab69 0x807d905 0x8084403 0x823baa7 0x826c1ca New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=2916 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 2916 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 020418 14:01:56 mysqld restarted InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket =
AW: User Define Function
I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc file gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc where /var/local/mysql/include is the folder where some mysql header files are included This works fine.(I did not get any errors on that!!) 2) I have copied udf.so in the /usr/lib, where mysql searches for so files ( this is the default folder for it, as I understand) 3) restart mysql 4) use mysql db 5) CREATE FUNCTION lookup RETURNS STRING SONAME udf.so; 6) ERROR and this is bad for me:( ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot open shared object file: Invalid argument) What am I doing wrong? Any help is appretiated!! th zoli - 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
super-smack
I am trying to compile super-smack on a FreeBSD-4 systems. I have got some thing working but it sill not right. Running it gives me. %super-smack -d mysql select-key-mysql.smack 10 1000 super-smack: Unsupported database type Is my copy just broken? If so what is the best way to compile on FreeBSD? Thanks Simon - 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: AW: User Define Function
No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made a hardcopy on that server and I have changed the startup paramaters. The only different thing is the database. after that comes CREATE FUNCTION lookup RETURNS STRING SONAME udf_example.so; CREATE FUNCTION reverse_lookup RETURNS STRING SONAME udf_example.so; which said that everything is OK!!! restart mysql WITHOUT --skip-grant-tables so that the UDF initialisation to be OK ,too. when I try select reverse_lookup('64.228.188.164'); I get Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8236d38 = select reverse_lookup('64.228.188.164') thd-thread_id=7 the error message is bigger but this is the important stuff!! The server restarts :(( I mean the server crashes and not always restarts. :( And I still don't know what is the problemm :((( zoli ---Original Message--- From: Christian Rabe Date: Thursday, April 18, 2002 14:07:56 To: Elteto Zoltan; [EMAIL PROTECTED] Subject: AW: User Define Function I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc file gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc where /var/local/mysql/include is the folder where some mysql header files are included This works fine.(I did not get any errors on that!!) 2) I have copied udf.so in the /usr/lib, where mysql searches for so files ( this is the default folder for it, as I understand) 3) restart mysql 4) use mysql db 5) CREATE FUNCTION lookup RETURNS STRING SONAME udf.so; 6) ERROR and this is bad for me:( ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot open shared object file: Invalid argument) What am I doing wrong? Any help is appretiated!! th zoli - 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 lt;[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
Optimization
Confucius say: Man who kisses girl's behind gets crack in face. Hi All ! I made a virtual stock exchange using PHP + MySQL. I'm not a programmer, so I don't know how well the sistem behaves itself when it comes to performance. Now, the project: 2 databases: stock players Tables in stock: -- CREATE TABLE ring ( id smallint(5) unsigned NOT NULL auto_increment, data datetime DEFAULT '-00-00 00:00:00' NOT NULL, initiator varchar(8) NOT NULL, titlu char(3) NOT NULL, cant smallint(5) unsigned DEFAULT '0' NOT NULL, curs mediumint(8) unsigned DEFAULT '0' NOT NULL, partener varchar(8) NOT NULL, status enum('N','D','A') DEFAULT 'N' NOT NULL, tip enum('V','C') DEFAULT 'V' NOT NULL, dataex datetime DEFAULT '-00-00 00:00:00' NOT NULL, suma int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY initiator (initiator), KEY titlu (titlu) ); This table includes the transactions between players. CREATE TABLE titluri ( id smallint(5) unsigned NOT NULL auto_increment, nume char(3) NOT NULL, valini mediumint(9) DEFAULT '0' NOT NULL, contracte smallint(6) DEFAULT '0' NOT NULL, PRIMARY KEY (id), UNIQUE nume (nume), KEY nume_2 (nume) ); This table includes the stocks that are exchanged between players and their value. CREATE TABLE users ( id smallint(5) unsigned NOT NULL auto_increment, nume varchar(8) NOT NULL, pass varchar(30) NOT NULL, fullname varchar(30) NOT NULL, tip enum('U','A') DEFAULT 'U' NOT NULL, PRIMARY KEY (id), UNIQUE nume (nume), KEY nume_2 (nume) ); This includes the list of players in the game, their passwords, fullname Tables in players: CREATE TABLE user1 ( id smallint(5) unsigned NOT NULL auto_increment, data date DEFAULT '-00-00' NOT NULL, suma int(10) unsigned DEFAULT '0' NOT NULL, stock1 int(10) unsigned DEFAULT '0' NOT NULL, stock2 int(10) unsigned DEFAULT '0' NOT NULL, ... stockX int(10) unsigned DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); there are also user2 ... userN Each player (included in stock.users) has a table in players, named after their name (stock.users.nume). Each player's table has, in the last row, his current financial situation - money and stock. The the name of the columns in the tables corresponding each player, (those named FYI stock1 ... stockX) are taken from stock.titluri.nume. When a player (playerX) wants to buy / sell stock, I write-lock stock.ring and players.playerX and after that INSERT / UPDATE the necessary data. The sistem works. I expect about 100 players. I don't know how good in terms of performance is this structure, so please tell me your opinion. Another question is about expanding the game. If I want to include another stock in the game, I might be in trouble. For this I have to do something like this: 1. add a new row in stock.titluri 2. LOCK TABLES stock.users WRITE 3. SELECT nume FROM stock.users 4. UNLOCK TABLES 5. LOCK players.* by building a PHP string LOCK TABLES stock.users WRITE, user1 WRITE, user2, WRITE ... userX WRITE; 6. ALTER each table in players, adding a new stock column (the one I added on step 4). 7. UNLOCK TABLES The problem I anticipate here is: what if a new player registrate himself between step 4 and 5? His table won't be included on step 6. I see the following solution: LOCK stock.users and players.* in one step, but I can't / don't know how to lock an entire database. Suggestions here? Thanks -- Ciprian He who laughs last, thinks slowest. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API
In fact, i'm trying to read data from a binary file and want to insert that into the database. I guess, it would be easier and more efficient if i use some data structure like we have vectors in C++ API. Thanks, Ritu Singla On Thu, 18 Apr 2002, Robert Cross wrote: you wrote: I want to know if there is any datatype in MySQL C API which is similar to a structure in C??? Why? The purpose of the API is to permit use of MySQL as a backend or datasource for user-written programs. That said, if your table consists of columns of differing types, then any the results of any query will be similar to a C struct. In which case the mysql_row type is probably the closest. The easiest answer is to refer to section 8.4.1 of the manual at http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_datatypes (amongst others) Hope this helps. Robert Cross. - 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
Version
Anyone know about when will be available the new version of mysql? Alexander A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - 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
AW: AW: User Define Function
I found one possible problem. I compiled the udf_exaple.cc with -shared etc. After that I did a ldconfig -l udf_example.so and got: ldconfig: ./udf_example.so is not a shared library I havn't found a solution yet. -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 18. April 2002 13:17 An: Christian Rabe; [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: AW: User Define Function No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made a hardcopy on that server and I have changed the startup paramaters. The only different thing is the database. after that comes CREATE FUNCTION lookup RETURNS STRING SONAME udf_example.so; CREATE FUNCTION reverse_lookup RETURNS STRING SONAME udf_example.so; which said that everything is OK!!! restart mysql WITHOUT --skip-grant-tables so that the UDF initialisation to be OK ,too. when I try select reverse_lookup('64.228.188.164'); I get Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8236d38 = select reverse_lookup('64.228.188.164') thd-thread_id=7 the error message is bigger but this is the important stuff!! The server restarts :(( I mean the server crashes and not always restarts. :( And I still don't know what is the problemm :((( zoli ---Original Message--- From: Christian Rabe Date: Thursday, April 18, 2002 14:07:56 To: Elteto Zoltan; [EMAIL PROTECTED] Subject: AW: User Define Function I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprüngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc file gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc where /var/local/mysql/include is the folder where some mysql header files are included This works fine.(I did not get any errors on that!!) 2) I have copied udf.so in the /usr/lib, where mysql searches for so files ( this is the default folder for it, as I understand) 3) restart mysql 4) use mysql db 5) CREATE FUNCTION lookup RETURNS STRING SONAME udf.so; 6) ERROR and this is bad for me:( ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot open shared object file: Invalid argument) What am I doing wrong? Any help is appretiated!! th zoli - 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 lt;[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
replication and indexes
Hi, I am using replication only for backup. My original database (MASTER) is using quite a lot of indexes. Currently my SLAVE has all the indexes too. I wonder if I can safely drop them on the SLAVE in order to increase replication-performance on the SLAVE? Are there pros and cons? Thanks, Peter -- sql, query, mysql - 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 client issues
ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory What kind of system are you using? Linux? Verify on your system for libncurses.so, it should be in /usr/lib. If you have that library on your system then check for library path Hisseine - Original Message - From: john v [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 5:50 AM Subject: mysql client issues I can get safe_mysqld to run, but when I launch mysql I receive the error message listed below. Any thoughts what cause this issue would be appreciated. ++ E R R O RM E S S A G E ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed +++ root 17181 17127 0 05:32:07 pts/60:00 /bin/sh ./safe_mysqld mysql 17203 17181 0 05:32:09 pts/60:00 /usr/local/mysql/libexec/mysqld l # ./mysqlbug.sh 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: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Super-User Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) 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-@VERSION@@MYSQL_SERVER_SUFFIX@ (@COMPILATION_COMMENT@) Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 3.23.45, for sun-sola ris2.5.1 on sparc 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.45 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 min 58 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open table s: 0 Queries per second avg: 0.017 Environment: machine, os, target, libraries (multiple lines) System: SunOS dbmon 5.6 Generic sun4m sparc SUNW,SPARCstation-20 Architecture: sun4 Some paths: /usr/ccs/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='@CC@' CFLAGS='@CFLAGS@' CXX='@CXX@' CXXFLAGS='@CXXFLAGS @' LDFLAGS='@LDFLAGS@' LIBC: -rw-r--r-- 1 bin bin 1585072 Jul 15 1997 /lib/libc.a lrwxrwxrwx 1 root root 11 Jan 24 21:47 /lib/libc.so - ./libc.so. 1 -rwxr-xr-x 1 bin bin 1000252 Jul 15 1997 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1585072 Jul 15 1997 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jan 24 21:47 /usr/lib/libc.so - ./libc .so.1 -rwxr-xr-x 1 bin bin 1000252 Jul 15 1997 /usr/lib/libc.so.1 Configure command: @CONF_COMMAND@ # ./mysqlshow +---+ | Databases | +---+ | mysql | | test | +---+ _ Chat with friends online, try MSN Messenger: http://messenger.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 - 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
Installing MySQL via RPM on RH72 (Involves Compiling PHP)
Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld. Do I need to install the src files also ? what else do I need to do for this. PS. MySQL is working with No Problem v3.23 and php 4.1.2 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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: LOOKUP
This set of responses is getting away from the original question. The lookup data type in Microsoft Access is not a data type at all. It creates a join with another table underneath the surface. If you try to implement this with ENUM and Alter Table you will destroy the existing data/ENUM relationships for any values already in the table which fall after the value in the list which you removed. Either just add another table and do joins or live with only being to add to the list. Gordon Bruce Interstate Software A MySQL Training Partner -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 2:40 PM To: 'Gurhan Ozen'; [EMAIL PROTECTED] Subject: RE: LOOKUP Good point. Also, how would you capture the current enum list to add or substract from? Might have to hold that in an array or constant of some sort depending upon the language used. Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:32 PM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi, Your solution would work if the set of the values you'll get from one table is primary key.. If it is not a primary key, i.e. allowing duplicate values, then everytime there is an insertion to the table you will have to check to see if it is a new-added value or not. Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:58 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where you make a change to the table you want to reference as the lookup (as in Access), you could include another sql command to alter the table with the enum column to change the list of accepted values for the enum. Would this work Gurhan, or would the constant ALTER table commands mess things up? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:46 PM To: Andrew Hazen; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Ugh, I am being too goofy today.. Simon, the answer to the question is no, you can't do that in MySQL. You can, however, create a column with enum datatype and define set of valid values. In a case where you try to insert an invalid value to an enum field, it will insert an empty string for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table. ?? Andrew Hazen -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 10:22 AM To: Simon Tienery; [EMAIL PROTECTED] Subject: RE: LOOKUP Hi .. You can define ENUM datatype for a column while creating the table and along with the possible values, and if you are using phpMyAdmin to admin MYSQL, it will only give you the possible values for that ENUM column. See: http://www.mysql.com/doc/C/o/Column_types.html http://www.phpmyadmin.net/ Gurhan -Original Message- From: Simon Tienery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:50 AM To: [EMAIL PROTECTED] Subject: LOOKUP Dear Group, Could anyone help me please, I want to create an ENUM column in one table that lists the entries in another table. For example, the sales table to have a staff column that automatically gives a choice of the names of all staff listed in the staff table. I have been told that Access has a data type that does this called lookup, but I only want to use MySQL. I couldn't locate the answer in the manual and I'd appreciate it if someone can explain how this can be achieved / worked around. many thanks Simon T - 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
Pubs2/Pubs3 database
Hi All, I am trying to install the Pubs2/Pubs3 database that comes with Sybase on my machine for SQL training and query. 1) I am not really sure how can I do that. 2) I am not where can I get the database dump from. I have tried to email Sybase but I received no response!! Could you help please. Thanks. Ali _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: Test for MySQL connection
Dear all, I don't know where to look for this information... Couldn't find it in the manual. How do I test whether a connection has been established so I don't need to open a new one again? e.g. MYSQL tmp; void f1(){ mysql_init(tmp); mysql_real_connect(tmp,...) } void f2(){ if(!connected(tmp)) do_error(connection not established); ... } I don't know what should go into the function connected() ... Thanks for any tips, fei - 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: Installing MySQL via RPM on RH72 (Involves Compiling PHP)
It isn't generally a good idea to install one piece by rpm and another by compiling and installing. A straight compile and install will put things in different directories from an rpm install. You will have a hard time making it all work. You can go with rpm or compiling from source, but be consistent. If you want to compile everything from source, a goood tool to assist you is here: http://www.apachetoolbox.com It will install MySQL, Apache and PHP and allow you to enable the options you need. It takes a lot of the guesswork out of configuring and compiling. On Thursday 18 April 2002 09:37 am, Daniel Negron/KBE wrote: Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld. Do I need to install the src files also ? what else do I need to do for this. PS. MySQL is working with No Problem v3.23 and php 4.1.2 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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: Newbie: Test for MySQL connection
Try shell cd YourMysqlInstallationDirectory shell bin/safe_mysqld shell mysql -h host -u user -ppassword Hisseine - Original Message - From: Fei Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 10:36 AM Subject: Newbie: Test for MySQL connection Dear all, I don't know where to look for this information... Couldn't find it in the manual. How do I test whether a connection has been established so I don't need to open a new one again? e.g. MYSQL tmp; void f1(){ mysql_init(tmp); mysql_real_connect(tmp,...) } void f2(){ if(!connected(tmp)) do_error(connection not established); ... } I don't know what should go into the function connected() ... Thanks for any tips, fei - 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: Installing MySQL via RPM on RH72 (Involves Compiling PHP)
Jens and Jim Thank you, this helps alot. Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Jim Philips | || jcphil@mindsp| || ring.com | ||| || 04/18/02 10:36| || AM| ||| |+ -| | | | To: Daniel Negron/KBE [EMAIL PROTECTED], [EMAIL PROTECTED] | | cc: | | Subject: Re: Installing MySQL via RPM on RH72 (Involves Compiling PHP) | -| It isn't generally a good idea to install one piece by rpm and another by compiling and installing. A straight compile and install will put things in different directories from an rpm install. You will have a hard time making it all work. You can go with rpm or compiling from source, but be consistent. If you want to compile everything from source, a goood tool to assist you is here: http://www.apachetoolbox.com It will install MySQL, Apache and PHP and allow you to enable the options you need. It takes a lot of the guesswork out of configuring and compiling. On Thursday 18 April 2002 09:37 am, Daniel Negron/KBE wrote: Hi All having a problem with install for PHP. I am trying to compile using --with-mysql=/dir/name I used an RPM to install mysql. during configure I get an error saying that it can not find the header files for mysql. I have used '=/shared' and every directory where there is mysql and mysqld. Do I need to install the src files also ? what else do I need to do for this. PS. MySQL is working with No Problem v3.23 and php 4.1.2 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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
SELECT from blob column
Hello everybody, I know it has been covered before. I read the manual, I folow the examples, and I am still having problems. What I want is store a blob in a blob field, so: CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB ); Query Ok. INSERT INTO blobtest VALUES ( '1', LOAD_FILE('/root/.profile') ); Query Ok, 1 row affected. SELECT * FROM blobtest; +---+-+ | Name | myblob| +---+-+ | 1| NULL | +--+--+ I've tried LOAD_FILE with many other files, including files in world-readable directories, and I always get the same result. Am I missing something ? -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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
how to delete from one table based on external conditions?
hi, i would like to know how i can achieve this kind of query: delete form table1 where table2.x=table1.y I checked the manual, there nothing like that! Am using mysql 3.23.49 SQL SQL SQL SQL SQL _ 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
MySQLDump
Hi; I can't get a dump of a database! I'm in as every user I have and get this: mysql mysqldump --databases nwhotspring a.a; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --databases nwhotspring a.a' at line 1 I can't even run mysqldump --help without getting that error! What am I doing wrong? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLDump
At 08:46 AM 4/18/02 -0700, you wrote: mysql mysqldump --databases nwhotspring a.a; BO ERROR 1064: You have an error in your SQL syntax near 'mysqldump BO --databases nwhotspring a.a' at line 1 BO I can't even run mysqldump --help without getting that error! What am I BO doing wrong? BO TIA, BO BenO mysqldump is a program which is to be run from your shell prompt, not your MySQL monitor prompt. LOL! Thanks! BenO - Julie -- Julie Meloni -- [EMAIL PROTECTED] -- www.thickbook.com Find Sams Teach Yourself MySQL in 24 Hours at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLDump
From: Ben Ocean [EMAIL PROTECTED] I can't even run mysqldump --help without getting that error! What am I doing wrong? 'mysqldump' is a system command, not an SQL command. You need to run it from the command prompt. --- Rodney Broom - 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 + JBoss
Has anyone out there tried using jboss with mysql? Any luck/problems? Thanks Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQLDump
Hi Ben, You need to run mysqldump command in the unix shell prompt, NOT in mysql shell. See: http://www.mysql.com/doc/m/y/mysqldump.html Gurhan -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: MySQLDump Hi; I can't get a dump of a database! I'm in as every user I have and get this: mysql mysqldump --databases nwhotspring a.a; ERROR 1064: You have an error in your SQL syntax near 'mysqldump --databases nwhotspring a.a' at line 1 I can't even run mysqldump --help without getting that error! What am I doing wrong? TIA, BenO - 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: Changing international charset for ORDER by sorting
Webmaster33, Wednesday, April 17, 2002, 7:21:55 PM, you wrote: W Anybody knows how can I change the character set, when MySQL is running, W to be able to do ORDER BY using international strings? W I would need to do this without changing config, while I run my perl script. W I would need to do sortings for different languages. So locale definition W should be changed right from within MySQL. W (changing locale in config is not solution, because I need to change more W times for different languages) W How it is possible to change character set dynamically, or W to set different character sets for different tables within the same database? Nope. Currently you need to run another instance of mysqld or restart MySQL server to change character set. If you use SET CHARACTER SET character_set_name statement you set it for that thread only. Currently this option supports only cp1251_koi8 for the character_set_name. Look at: http://www.mysql.com/doc/S/E/SET_OPTION.html W Thanks in advance. W Best regards, W Webmaster33 -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Re: some good tutorial
Ashish, Wednesday, April 17, 2002, 10:01:24 PM, you wrote: AJ i have just joined the list and wanted to know something about mysql. AJ is there some really good tutorial you think might be good for a AJ starter in mysql. i am a master's student and have some knowledge AJ of databases like ms access, oracle. Paul's DuBois book and the documentation from www.mysql.com will help you to learn MySQL as well. AJ hope to get some good stuff. AJ regards AJ ashish -- 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
Re: Foreign keys
Marius, Thursday, April 18, 2002, 11:43:38 AM, you wrote: MR I have a problem: How can I find the FOREIGN KEY definitions for a table? MR I'm using MySQL 4.0.1 MAX, and I define the table as a InnoDB-table. SHOW TABLE STATUS statement shows you foreign key constraints for a table, look at: http://www.mysql.com/doc/S/E/SEC445.html MR Someone, pleace help me! MR Marius -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Re: SELECT from blob column
João, Thursday, April 18, 2002, 5:16:26 PM, you wrote: JPV I know it has been covered before. I read the manual, I folow the examples, JPV and I am still having problems. What I want is store a blob in a blob field, JPV so: JPV CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB ); JPV Query Ok. JPV INSERT INTO blobtest VALUES ( '1', LOAD_FILE('/root/.profile') ); JPV Query Ok, 1 row affected. JPV SELECT * FROM blobtest; JPV +---+-+ JPV | Name | myblob| JPV +---+-+ JPV | 1| NULL | JPV +--+--+ JPV I've tried LOAD_FILE with many other files, including files in world-readable JPV directories, and I always get the same result. JPV Am I missing something ? Check your permissions on files, that you want to insert into BLOB field and dirs that contain those files. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
Re: mysql client issues
john, Thursday, April 18, 2002, 12:50:14 PM, you wrote: jv I can get safe_mysqld to run, but when I launch mysql I receive the error jv message listed below. Any thoughts what cause this issue would be jv appreciated. jv ++ E R jv R O RM E S S A G E jv ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or jv directory jv Killed jv +++ It's not a MySQL problem. You need to get and install ncurses library. -- 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
Re: RE: how many tables can I create with one created MySql database?
Roger, Wednesday, April 17, 2002, 6:54:29 PM, you wrote: RB * Egor Egorov RB 1) does this apply to InnoDb tables? Not quite, InnoDB stores tables in the tablespace, that may consists of several files.. RB Yes... but rarely one file per table... RB But what about the .frm files...? Are they kept open? RB 2) does this apply to the number of _existing_ tables in a db, or to the RB number of tables in a single select statement...? Existing tables, temporary tables ... whatever MySQL is storing on disk. RB Are you saying that the mysql server will need to open all the tables in a RB database at the same time? When does this happen? When I issue the USE RB command? Roger, number of opened files is not the same as number of files in the directory. When table is created, MySQL creates file(s) on the disk. So, the maximum number of tables is defined by OS characteristics: how many files (subdirs) OS can handle for the directory. This does not apply to InnoDB tables as they use different storage scheme. RB Roger -- 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
Error in mysql.server?
Hi, I'm about to try out mysql.server to automatically start/stop mysql, but am wondering if there might be a mistake in the instructions which say: # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/S01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. Should the second link be to /etc/rc0.d/K01mysql? And should there be similar links in rc1.d,rc6.d and rc2.d? (I'm using version mysql-max-3.23.49-pc-linux-gnu-i686) Cheers, elaine - 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: sigwait problem in mysql -3.23.49 installation to openbsd 3.0 i386
can anyone help with this problem ? i looked mysql manual pages and also openbsd.. but still i cant get any information about this problem. please help me. On Thu, 18 Apr 2002 17:59:42 GMT Unknown wrote: i try to configure mysql 3.23.49 with command line --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static --with-unix-socket path=/usr/local/mysql/tmp/mysql.sock and in make process it stops with problem- /usr/include/signal.h:116: conflicting types for `sigwait' ../include/my_pthread.h:317: previous declaration of `sigwait' now this what i have on /usr/include/signal.h line 116 int sigwait __P((const sigset_t *, int *)); and full thingi #ifndef _POSIX_SOURCE int killpg __P((pid_t, int)); int sigblock __P((int)); int siginterrupt __P((int, int)); int sigpause __P((int)); int sigreturn __P((struct sigcontext *)); int sigsetmask __P((int)); int sigstack __P((const struct sigstack *, struct sigstack *)); int sigaltstack __P((const struct sigaltstack *, struct sigaltstack *)); int sigvec __P((int, struct sigvec *, struct sigvec *)); voidpsignal __P((unsigned int, const char *)); int sigwait __P((const sigset_t *, int *)); #endif /* !_POSIX_SOURCE */ #endif /* !_ANSI_SOURCE */ __END_DECLS now in mysql ../include/my_pthread.h:317 i have int sigwait(sigset_t *setp, int *sigp); /* Use our implemention */ and full thingi #if !defined(HAVE_SIGWAIT) !defined(HAVE_mit_thread) !defined(HAVE_rts_threads) !defined(sigwait) !defined(alpha_linux_port) !$ int sigwait(sigset_t *setp, int *sigp); /* Use our implemention */ #endif i think that in my_pthread.h:317 int sigwait(sigset_t *setp, int *sigp) is not combatible with opensbd signal.h specified.. but what i dont know what it must be then ? any help needed thnks Romka. - 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 start MySQL in Solaris8
Hi all, I just downloaded MySQL package from SUN website and installed it on my unix machine which runs Solaris8. How do I start MySQL in Solaris8? If I need to create a new account to start it then how do I create a new account? Thanks, David - 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 international charset for ORDER by sorting
I understand. Bad to hear. :-( I think there would be important to implement features to be able to set different character sets for each table, or to change character sets dynamically without the need to restart MySQL server. This would be especially important for the ORDER BY string collations (result ordering, sorting) ... Where should I suggest this feature? Is there any place where suggestions can be sent? Thanks, Webmaster33 *** REPLY SEPARATOR *** On 2002.04.18 at 19:40 Victoria Reznichenko wrote: Webmaster33, Wednesday, April 17, 2002, 7:21:55 PM, you wrote: W Anybody knows how can I change the character set, when MySQL is running, W to be able to do ORDER BY using international strings? W I would need to do this without changing config, while I run my perl script. W I would need to do sortings for different languages. So locale definition W should be changed right from within MySQL. W (changing locale in config is not solution, because I need to change more W times for different languages) W How it is possible to change character set dynamically, or W to set different character sets for different tables within the same database? Nope. Currently you need to run another instance of mysqld or restart MySQL server to change character set. If you use SET CHARACTER SET character_set_name statement you set it for that thread only. Currently this option supports only cp1251_koi8 for the character_set_name. Look at: http://www.mysql.com/doc/S/E/SET_OPTION.html W Thanks in advance. W Best regards, W Webmaster33 -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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 *** END REPLIED MESSAGE *** - 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: SELECT from blob column
I have found LOAD_FILE has to be used in an update statement. So to insert a row that includes a blob such as your example you would have the following two statements: INSERT INTO blobtest (name ) VALUES ( '1'); followed by: UPDATE blobtest SET myblob = LOAD_FILE('/root/.profile') WHERE name = '1'; I have been able to corrupt a datafileconsistently doing this interactively with the server. The disk that the datafile was on ran out of space. So you might want to check the robustness of your situation and plan accordingly. -Grady - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 12:40 PM Subject: Re: SELECT from blob column João, Thursday, April 18, 2002, 5:16:26 PM, you wrote: JPV I know it has been covered before. I read the manual, I folow the examples, JPV and I am still having problems. What I want is store a blob in a blob field, JPV so: JPV CREATE TABLE blobtest ( name CHAR(5), myblob MEDIUMBLOB ); JPV Query Ok. JPV INSERT INTO blobtest VALUES ( '1', LOAD_FILE('/root/.profile') ); JPV Query Ok, 1 row affected. JPV SELECT * FROM blobtest; JPV +---+-+ JPV | Name | myblob| JPV +---+-+ JPV | 1| NULL | JPV +--+--+ JPV I've tried LOAD_FILE with many other files, including files in world-readable JPV directories, and I always get the same result. JPV Am I missing something ? Check your permissions on files, that you want to insert into BLOB field and dirs that contain those files. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Mysql unresponsive ....
Since I didn't get any response (like mysql server) I am sending it again. thanks Vivek -Original Message- From: CHAUDHARY, Vivek Sent: Wednesday, April 17, 2002 3:34 PM To: '[EMAIL PROTECTED]' Subject: Mysql unresponsive Hi all, Last friday we found that mysql was unresponsive (all the SQL activities were on hold) but the daemon was still running. We shutdown the daemon and restarted and everything was OK. My questions: 1) What could cause this behavior ? 2) Is there any way to monitor such a behavior ? any commands, scripts that could test for inactivity etc. Needless to say that I am a newbie on mysql front. Vivek Chaudhary Database Administrator IT STMicroelectronics, Phoenix. Phone:(602)485-2271 Fax: (602)485-6402 Cell:(602)363-1492 Email: [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
BSD: Random unknown database error
All: Recently I've run into a problem where I intermittently receive an Unknown database error while attempting to communicate with a local MySQL server. I read through the mail list archives and discovered that others reported similar problems under BSD, but I didn't see any concrete solutions. I may not be able to provide a solution, but I believe I can pinpoint the cause. Let me apologize now for the length of this message. I'm trying to explain enough so that someone else, more knowledgable about MySQL's internals, can either use it to solve the problem or refute my guess. First, my environment: MacOS X (10.1.4), MySQL 3.23.49, running on a G3 PowerBook (Firewire), latest dev tools from Apple. The MySQL server is running on that system as well as my own C++ code. Before seeing the problem within MySQL I found a problem with my own multithreaded code. Each thread is responsible for loading a file in one directory and then manipulating a couple of other files in a different directory, all referenced relatively to the application's directory. When the load got high -- there were many concurrent threads -- I would intermittently receive an error from the OS telling me that one of the files I was trying to open could not be found. Given that the file in question was one that was supposed to always be present, I grew suspicious. After a bit of debugging, imagine my surprise when I discovered that the full pathname the OS was trying to use was wrong. Example Source file:foo/text.txt Dest file: data/index.txt App directory: /Users/lordgrey/Projects/myproject/ When the problem occurred while opening the dest file, referenced relatively, the OS was actually trying to open: /Users/lordgrey/Projects/myproject/foo/data/index.txt instead of /Users/lordgrey/Projects/myproject/data/index.txt Once I nailed down a variable with the current working directory at application launch time and used that to fully qualify my datafiles, all of my problems disappeared. As further testing, I started cranking up the number of threads. Now, in addition to dinking around with files, each thread has its own MySQL connection. Increasing the number of threads started causing the unknown database error to appear, pretty much in direct proportion to the number threads. The other problem reports in the archive noted that the unknown database problem seemed to occur when the system's load was high. That would agree with what I found. Anyway, it occurs to me that MySQL is failing to find a database -- which is a directory -- for the same reason that my code couldn't find its own data files. Namely: MySQL is using a relative path, BSD is mucking around with the concept of current working directory incorrectly and it's colliding with other concurrent threads also trying to use relative paths. I haven't picked the MySQL source code apart to see if this is really the case or not, but it seems reasonable. If it's true then the actual problem lies in BSD/MacOS/etc. but it can be worked around in the MySQL server. Cheers, DSC _ Dan S. Camper Borrowed Time, Inc. Software Thaumaturge http://www.bti.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
Grant User Persmissions
Hello, Is there any way to grant a user only SELECT permissions on a set of tables in MySQL, but to also allow them to have CREATE, DROP, and INSERT on the Database itself?? What I want is a database where the users cannot modify the core tables, but I want them to be able to CREATE and DROP temporary tables that they have created?!? Any help would be great.. Thanks, 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
MyODBC arrrgghh!
Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - 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
insert french accent with java
Hi, I want to insert into the Mysql db some text containing French Accent. If I do this using the console (mysql), it work fine. But if I try the same query via Java and JDBC, I loose the French accent. They are replaced by '?'. Any idea ??? Thank a lot - 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: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - 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 many tables can I create with one created MySql database?
* Egor Egorov RB Are you saying that the mysql server will need to open all the tables in a RB database at the same time? When does this happen? When I issue the USE RB command? Roger, number of opened files is not the same as number of files in the directory. When table is created, MySQL creates file(s) on the disk. So, the maximum number of tables is defined by OS characteristics: how many files (subdirs) OS can handle for the directory. This does not apply to InnoDB tables as they use different storage scheme. From your original post in this thread, answering a question if 300 tables in one database is ok: Maximum number of tables depends on your OS - the maximum numbers of file descriptors allowed. This was a confusing use of the term 'file descriptor', if I may say so... ;) Also, the number must be divided by 3, as each myisam table have a .frm, a .MYD and a .MYI file... Well, I am not confused any more. Thanks. :) -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lock databases
Is there a way to Lock all databases for a couple of minutes and then resume. I don't want to run mysqldump for a backup. I have another utility that I will use to take a snapshot of the databases at that instant and it might take a minute to run so thats way I need them locked.. -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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
How to build mysql on HP-UX 11.x with GCC 3.0.4
Please help...I'm ready to give up. I cannot get mysql.3.23.42 built on HP-UX 11.x. I'm using gcc 3.0.4 because I cannot find a gcc 2.95.3 or 2.95.2 binary version for HP-UX 11.x anywhere (most of the links I've tried don't work anymore). Here was my configure: CC=gcc CFLAGS=-march=1.1 -DHPUX CXX=gcc CXXFLAGS=-march=1.1 -DHPUX -felide-constructors -fno-exceptions -fno-rtti -O3 ./configure --prefix=/usr/local/mysql --localstatedir=/home/data --with-raid --without-readline --disable-largefile --with-pthread --enable-thread-safe-client --with-named-thread-libs=-ldce --enable-assembler --disable-shared I fail on: Making all in libmysql_r gmake[2]: Entering directory `/home/software/mysql-3.23.42/libmysql_r' /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include-I./.. -I.. -I..-O3 -DDBUG_OFF -march=1.1 -DHPUX -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -c libmysql.c gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -march=1.1 -DHPUX -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -c libmysql.c -o libmysql.o In file included from /usr/include/sys/user.h:52, from /usr/include/sys/stream.h:53, from ../include/global.h:208, from libmysql.c:18: /usr/include/machine/sys/setjmp.h:45: redefinition of `struct label_t' In file included from libmysql.c:39: /usr/include/sys/socket.h:484: parse error before sendfile /usr/include/sys/socket.h:484: parse error before bsize_t /usr/include/sys/socket.h:485: parse error before sendpath /usr/include/sys/socket.h:485: parse error before bsize_t gmake[2]: *** [libmysql.lo] Error 1 gmake[2]: Leaving directory `/home/software/mysql-3.23.42/libmysql_r' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/software/mysql-3.23.42' gmake: *** [all-recursive-am] Error 2 It seems more like a problem with gcc? I see on the GCC site that HPUX 11 is supported, but that threads are not? Am I out of luck trying to use gcc on HP? Any help is hugely appreciated. Thanks, 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: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); quit -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 AM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - 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: MyODBC arrrgghh!
Your workstation is 192.168.1.101: insert into user values ('192.168.1.101', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); Allow class C network access with: insert into user values ('192.168.1.%', 'netUSER', Password ('netPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); OR insert into user values ('%.indominion.com', 'hostUSER', Password ('hostPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); C:~ -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); quit -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 AM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - 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 - 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! With sql date type
Hello, I would like to add a date column to my sql database table that auto-increments the date's week field by 2 weeks for every entry. I have set up the mysql database table to automatically take entries for ad submissions and I want to timestamp each entry with the calculated date. Is this possible? Thanks Stan - 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: MyODBC arrrgghh!
Well go figure. Seems like our firewall is blocking things. Guess I'll have to run local for development. Thanks for your help. Andrew Hazen -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 3:12 PM To: [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! Your workstation is 192.168.1.101: insert into user values ('192.168.1.101', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); Allow class C network access with: insert into user values ('192.168.1.%', 'netUSER', Password ('netPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); OR insert into user values ('%.indominion.com', 'hostUSER', Password ('hostPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); C:~ -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 12:01 PM To: [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! Here's the basics for MySQL database access (seven lines total: use mysql; create database myDB; insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER', 'Y','Y','Y','Y','N','N','N','N','N','N'); insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N'); quit -Original Message- From: Land, Christopher [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:26 AM To: Andrew Hazen; [EMAIL PROTECTED] Subject: RE: MyODBC arrrgghh! The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - 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 - 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: Help! With sql date type
A timestamp-datatype automatically updates itself with the current date if the row has changed, so, in this case timestamp is not the preferred datatype. As far as i know, in MySQL Procedures are just for output, Triggers are not implemented...Only method would be to insert this field using insert select(data_add(max_date ,interval 2 weeks)) as date from ..., but i don't know how to get max_date if you are not allowed to use order by. This is why you would have to store it an a variable then update etc... My suggestion is to take a simple date-field and manage it by your program. - Original Message - From: stan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 9:37 PM Subject: Help! With sql date type Hello, I would like to add a date column to my sql database table that auto-increments the date's week field by 2 weeks for every entry. I have set up the mysql database table to automatically take entries for ad submissions and I want to timestamp each entry with the calculated date. Is this possible? Thanks Stan - 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
table-building advice requested
Hello, I was hoping to solicit some advice on the structure of the database I am building. Here is a simplified version of my scenario: The application that I am designing, in PHP4.1.2 with MySQL (3.23.46 on RedHat 7.2), has a feature which allows it to keep track of graphics files (JPGs, GIFs, PSDs, AIs, QPTs, etc), which are stored on CDs in a CD cabinet. I have already designed a table to store information about files, where each row is an individual file and each column is an attribute of that file. mysql describe files; +-+---+--+-+-+ | Field | Type | Null | Key | Default | +-+---+--+-+-+ | file_id | int(10) unsigned | | PRI | NULL| | file_name | varchar(64) | | | | | filetype_id | smallint(5) unsigned | YES | | NULL| | stor_id | mediumint(8) unsigned | YES | | NULL| | file_size | float(4,2)| | | 0.00| | width_in| float(4,2)| | | 0.00| | height_in | float(4,2)| | | 0.00| | file_res| smallint(5) unsigned | YES | | NULL| | cre_date| date | YES | | NULL| | insert_date | datetime | YES | | NULL| | inserter_id | smallint(5) unsigned | YES | | NULL| +-+---+--+-+-+ (there are other tables that relate to this one, but they are not relevant to my problem) Using my application via a web browser, users can select existing file records which need to be printed, and store them as objects into an array (actually a session variable array), similar to a shopping cart. Later, they will use another section of the application to check out, meaning each object in the array will become a row in another table (printedfiles), representing files that have been selected to be printed. (What happens with this data is irrelevant to my problem) The problem comes into play here: in addition to files they have selected from the database (let's use the alias files since they are all rows from the files table), users may also select files which do not exist in the database yet -- let's use the alias user files. I do not wish to store user files in the files table, because they are different entities. But I would like to have these entities stored in the printedfiles table, along with any files that were selected using the application. What is the best way to do this? Originally, I was thinking that I could have a printedfiles.file_id column, which would store either the file_id of a files record, or the file_id of a userfiles record, depending on whether or not the printedfiles record was selected using the application or defined by the user. But then I wondered if that was a good idea after all -- after all, how would I know whether the printedfiles.file_id was a files file_id or a userfiles file_id ? To solve this, I thought I could add a column like ALTER TABLE printedfiles ADD COLUMN source ENUM('files', 'userfiles') to qualify the file_id as belonging to either a files record or a userfiles record. But I am wondering if this is really a good idea -- when I need to query for all records in printedfiles and categorize them, will I be able to use this source column? Or is there a better way I could be going about all of this... Thanks for any insight you can provide. 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
SQL-Statement Near
Hi List, I am using MySQL MAX 3.23 on a SuSE Linux System. But my problem is about SQL: Is there a in the near of my result statement that returns the surrounding rows, e.g. SELECT name FROM names WHERE name=foo NEAR(-2,2) which results: ann marie foo bar john? I know, if my keys would be incremented numbers I could use BETWEEN or HAVING, but they aren't incremented (but numbers;-)). Now I solve this Problem by an external Program, but this is very slow for large tables. Any suggestions? Thanks a lot, Jan (p.s. in core this MUST be a simple problem) - 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: SELECT from blob column
Well, I found that I can use LOAD_FILE in INSERT statement, and I foud that my text file should be finished with a newline char :( . Well... never mind. Just another question : If i use PHP fread and got all the content of a file in a single var, can I just INSERT the variable ? sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: Lock databases
On Thu, Apr 18, 2002 at 12:54:47PM -0600, Kory Wheatley wrote: Is there a way to Lock all databases for a couple of minutes and then resume. I don't want to run mysqldump for a backup. I have another utility that I will use to take a snapshot of the databases at that instant and it might take a minute to run so thats way I need them locked.. FLUSH TABLES WITH READ LOCK will do what you want. 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 70 days, processed 1,880,517,572 queries (309/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: super-smack
On Thu, Apr 18, 2002 at 12:09:40PM +0100, Simon Green wrote: I am trying to compile super-smack on a FreeBSD-4 systems. I have got some thing working but it sill not right. Running it gives me. I built it on FreeBSD (after some code changes) about a year ago. Lemme see if I can dig it up. And maybe I'll even be able to get a patch for FreeBSD to the maintainer. 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 70 days, processed 1,880,536,573 queries (309/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
Large Index's Fail
Okay, this may well be a LINUX issue I am having, so be kind before you flame. When I try to index a large file, it fails with a write error on the /tmp directory. Now my /tmp directory is on a smaller partition (as sent to me by dell). Can I configure MySQL to use a different area when creating indexes? If not, would I have to configure something in the OS to use a different partition as the temporary storage area. - 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
Renaming database
Is there a sanctioned way to rename a MySQL 3.23.x database, consisting of MyISAM tables? Thanks, MH - 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: SELECT from blob column
Well, I found that I can use LOAD_FILE in INSERT statement, and I found that my text file should be finished with a newline char :( . Well... never mind. Would you give an example please? -Grady - Original Message - From: João Paulo Vasconcellos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 4:15 PM Subject: Re: SELECT from blob column Well, I found that I can use LOAD_FILE in INSERT statement, and I foud that my text file should be finished with a newline char :( . Well... never mind. Just another question : If i use PHP fread and got all the content of a file in a single var, can I just INSERT the variable ? sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: AW: User Define Function
Hi, You have some problems with the MYSQL LIBRARY PATH.(Check in the /etc/ld.so.conf file) You don't have link to some mysql libraries when you compile the source file. Try to copy all mysql libraryes in /usr/lib. ...or...if you find out what libray is missing, try to add -l namelybrary and after -L/path_of_your_library Good luck, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Elteto Zoltan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 2:16 PM Subject: Re: AW: User Define Function No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made a hardcopy on that server and I have changed the startup paramaters. The only different thing is the database. after that comes CREATE FUNCTION lookup RETURNS STRING SONAME udf_example.so; CREATE FUNCTION reverse_lookup RETURNS STRING SONAME udf_example.so; which said that everything is OK!!! restart mysql WITHOUT --skip-grant-tables so that the UDF initialisation to be OK ,too. when I try select reverse_lookup('64.228.188.164'); I get Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8236d38 =elect reverse_lookup('64.228.188.164') thd-thread_id= the error message is bigger but this is the important stuff!! The server restarts :(( I mean the server crashes and not always restarts. :( And I still don't know what is the problemm :((( zoli ---Original Message--- From: Christian Rabe Date: Thursday, April 18, 2002 14:07:56 To: Elteto Zoltan; [EMAIL PROTECTED] Subject: AW: User Define Function I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc file gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc where /var/local/mysql/include is the folder where some mysql header files are included This works fine.(I did not get any errors on that!!) 2) I have copied udf.so in the /usr/lib, where mysql searches for so files ( this is the default folder for it, as I understand) 3) restart mysql 4) use mysql db 5) CREATE FUNCTION lookup RETURNS STRING SONAME udf.so; 6) ERROR and this is bad for me:( ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot open shared object file: Invalid argument) What am I doing wrong? Any help is appretiated!! th zoli - 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 lt;[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
Automatic Startup of mysqld in Mac OS X
I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have tried many different approaches. I can get mysqld to start manually from the terminal window, as follows su safe_mysqld But not from startup. Does anyone have any experience with this? Thank You, Jimi Oleksiak - 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 build mysql on HP-UX 11.x with GCC 3.0.4
I've made some progress - I eliminated the problem with the socket header file by changing the CFLAGS and CXXFLAGS to include: -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE -D_INCLUDE_HPUX_SOURCE -D_INCLUDE_XOPEN_SOURCE_EXTENDED But I still get the following error: Making all in libmysql_r gmake[2]: Entering directory `/home/software/mysql-3.23.49/libmysql_r' /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -march=1.1 -DHPUX -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE -D_INCLUDE_HPUX_SOURCE -D_INCLUDE_XOPEN_SOURCE_EXTENDED -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -DDO_NOT_REMOVE_THREAD_WRAPPERS -c libmysql.c gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -march=1.1 -DHPUX -D_XOPEN_SOURCE_EXTENDED -D_HPUX_SOURCE -D_INCLUDE_HPUX_SOURCE -D_INCLUDE_XOPEN_SOURCE_EXTENDED -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -DDO_NOT_REMOVE_THREAD_WRAPPERS -c libmysql.c -o libmysql.o In file included from /usr/include/sys/user.h:52, from /usr/include/sys/stream.h:53, from ../include/global.h:208, from libmysql.c:18: /usr/include/machine/sys/setjmp.h:45: redefinition of `struct label_t' gmake[2]: *** [libmysql.lo] Error 1 gmake[2]: Leaving directory `/home/software/mysql-3.23.49/libmysql_r' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/software/mysql-3.23.49' gmake: *** [all-recursive-am] Error 2 I'm beginning to remember why I didn't like working on HP. Maybe some other flag(s) I'm missing or need to set up? Thanks, Rick -Original Message- From: Rick Robinson [mailto:[EMAIL PROTECTED]] On Behalf Of Rick Robinson ([EMAIL PROTECTED]) Sent: Thursday, April 18, 2002 02:54 PM To: '[EMAIL PROTECTED]' Subject: How to build mysql on HP-UX 11.x with GCC 3.0.4 Please help...I'm ready to give up. I cannot get mysql.3.23.42 built on HP-UX 11.x. I'm using gcc 3.0.4 because I cannot find a gcc 2.95.3 or 2.95.2 binary version for HP-UX 11.x anywhere (most of the links I've tried don't work anymore). Here was my configure: CC=gcc CFLAGS=-march=1.1 -DHPUX CXX=gcc CXXFLAGS=-march=1.1 -DHPUX -felide-constructors -fno-exceptions -fno-rtti -O3 ./configure --prefix=/usr/local/mysql --localstatedir=/home/data --with-raid --without-readline --disable-largefile --with-pthread --enable-thread-safe-client --with-named-thread-libs=-ldce --enable-assembler --disable-shared I fail on: Making all in libmysql_r gmake[2]: Entering directory `/home/software/mysql-3.23.42/libmysql_r' /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include-I./.. -I.. -I..-O3 -DDBUG_OFF -march=1.1 -DHPUX -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -c libmysql.c gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/home/data\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -march=1.1 -DHPUX -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKEN_GETPASS -DNO_FCNTL_NONBLOCK -c libmysql.c -o libmysql.o In file included from /usr/include/sys/user.h:52, from /usr/include/sys/stream.h:53, from ../include/global.h:208, from libmysql.c:18: /usr/include/machine/sys/setjmp.h:45: redefinition of `struct label_t' In file included from libmysql.c:39: /usr/include/sys/socket.h:484: parse error before sendfile /usr/include/sys/socket.h:484: parse error before bsize_t /usr/include/sys/socket.h:485: parse error before sendpath /usr/include/sys/socket.h:485: parse error before bsize_t gmake[2]: *** [libmysql.lo] Error 1 gmake[2]: Leaving directory `/home/software/mysql-3.23.42/libmysql_r' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/home/software/mysql-3.23.42' gmake: *** [all-recursive-am] Error 2 It seems more like a problem with gcc? I see on the GCC site that HPUX 11 is supported, but that threads are not? Am I out of luck trying to use gcc on HP? Any help is hugely appreciated. Thanks, 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: SELECT from blob column
In Thursday 18 April 2002 17:56, Grady Drago wrote: Well, I found that I can use LOAD_FILE in INSERT statement, and I found that my text file should be finished with a newline char :( . Well... never mind. Would you give an example please? If you do : $ cat test.file Some text. ^D $ And then use LOAD_FILE(), the data doesn't show up. But if you do: $ cat test.file Some text. ^D $ Then the text shows up. Better saying, if you create a file without a trailing newline, the text does not show up, but if you put a trailing newline, it appears. sql -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: AW: User Define Function
...sorry...i didn't read the previus e-mail to the finish i saw only : ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot - Original Message - From: Elteto Zoltan [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 18, 2002 2:16 PM Subject: Re: AW: User Define Function No I have not :((( And believe me I have tried several posibilities... I have on one mysql server such a setup and this works good. So I have made a hardcopy on that server and I have changed the startup paramaters. The only different thing is the database. after that comes CREATE FUNCTION lookup RETURNS STRING SONAME udf_example.so; CREATE FUNCTION reverse_lookup RETURNS STRING SONAME udf_example.so; which said that everything is OK!!! restart mysql WITHOUT --skip-grant-tables so that the UDF initialisation to be OK ,too. when I try select reverse_lookup('64.228.188.164'); I get Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8236d38 =elect reverse_lookup('64.228.188.164') thd-thread_id= the error message is bigger but this is the important stuff!! The server restarts :(( I mean the server crashes and not always restarts. :( And I still don't know what is the problemm :((( zoli ---Original Message--- From: Christian Rabe Date: Thursday, April 18, 2002 14:07:56 To: Elteto Zoltan; [EMAIL PROTECTED] Subject: AW: User Define Function I'm having the same problem (Invalid Argument) at the moment. Did you find any solution ? Thanx -Ursprngliche Nachricht- Von: Elteto Zoltan [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 11:32 An: [EMAIL PROTECTED] Betreff: User Define Function Hi all, I need to create 2 user defined functions. lookup end reverse_lookup These functiouns are included in the udf_example2.cc source file. I have gcc version 2.96 2731 (Red Hat Linux 7.0) and mysql-3.23.49-pc-linux-gnu-i686 (Binary distribution) 1)step: Compiling the udf_example2.cc file gcc -shared -I /var/local/mysql/include -o udf.so udf_example2.cc where /var/local/mysql/include is the folder where some mysql header files are included This works fine.(I did not get any errors on that!!) 2) I have copied udf.so in the /usr/lib, where mysql searches for so files ( this is the default folder for it, as I understand) 3) restart mysql 4) use mysql db 5) CREATE FUNCTION lookup RETURNS STRING SONAME udf.so; 6) ERROR and this is bad for me:( ERROR 1126: Can't open shared library 'udf.so' (errno: 22 udf.so: cannot open shared object file: Invalid argument) What am I doing wrong? Any help is appretiated!! th zoli - 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 lt;[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: Automatic Startup of mysqld in Mac OS X
Yes. Look in this months digest. There is a thread about this. -RG On Thu, 18 Apr 2002, Jimi Oleksiak wrote: I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have tried many different approaches. I can get mysqld to start manually from the terminal window, as follows su safe_mysqld But not from startup. Does anyone have any experience with this? Thank You, Jimi Oleksiak - 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
error during configuration
Trying to configure mysql 3.23.49 on Solaris 8, and I got the error: checking return type of sprintf... configure: error: can not run test program while cross compiling. The last lines of the config.log are: ltconfig:603: checking for object suffix ltconfig:604: gcc -cconftest.c 15 ltconfig:629: checking for executable suffix ltconfig:630: gcc -o conftest conftest.c 15 ltconfig:776: checking if gcc PIC flag -fPIC works ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15 ltconfig:829: checking if gcc supports -c -o file.o ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15 ltconfig:862: checking if gcc supports -c -o file.lo ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15 ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15 ltconfig:958: checking if gcc static flag -static works ltconfig:959: gcc -o conftest -static conftest.c 15 ltconfig:1653: checking if global_symbol_pipe works ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$ /\1 \2\3 \3/p' conftest.nm ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c conftstm.o 15 configure:2114: checking for a BSD compatible install configure:2174: checking for bison configure:2174: checking for byacc configure:2207: checking for pdftex configure:2235: checking return type of sprintf (END) I am a newbie at MySQL, so any help would be appreciated. Thanks. Greg - 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 upgrade/migrate Mysql Server
Mysql Gurus, We are currently using Mysql (3.22.32) on a Solaris platform. We are looking to upgrade/migrate this current version to 3.23.49a, for utilizing the replication functionality. I would appreciate if anyone can clarify the following: 1) Any known/unknown issues with 3.23.49a 2) What are the steps in migrating to this new version. I say this because i come from a Oracle dba world. 2) Anything in particular that i need to watch for, while upgrading to this new version. Thanks Sri - 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 Error while starting up
Has anyone encountered the following error, while starting the mysql daemon as a user other than root. Can't create IP Socket: Permission Denied I do not encounter any problem when running the same as root I have checked the permission on /datadir /basedir /tmp, they seem to be OK. Thanks Sridhar - 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 Error while starting up
At 17:01 -0500 4/18/02, Sridhar Peddireddy wrote: Has anyone encountered the following error, while starting the mysql daemon as a user other than root. Can't create IP Socket: Permission Denied I do not encounter any problem when running the same as root I have checked the permission on /datadir /basedir /tmp, they seem to be OK. Are you using a port number other than the default of 3306? Less then 1024, perhaps? Thanks Sridhar - 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: Automatic Startup of mysqld in Mac OS X
Here is a link to an installer that will install the needed parts to cause MySQL to start on restarts of the computers. http://www2.entropy.ch/download/mysql-startupitem.pkg.tar.gz On 4/18/2002 2:33 PM, Russell E Glaue [EMAIL PROTECTED] wrote: Yes. Look in this months digest. There is a thread about this. -RG On Thu, 18 Apr 2002, Jimi Oleksiak wrote: I am having real trouble trying to get mysqld to start automatically when I restart my Mac OS X or Mac OS X Server systems. I am reading the MySQL document, chapter 2.4.3, and have tried many different approaches. I can get mysqld to start manually from the terminal window, as follows su safe_mysqld But not from startup. Does anyone have any experience with this? Thank You, Jimi Oleksiak - 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 -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ eFax: 1-419-791-8924 - 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 for MYSQL installation
Dear Sir/Madam, I downloaded the latest mysql-3.23.49 and wanted to install MYSQL in my FreeBSD 2.2.7 OS. The configuration (./configure) and Make both went smoothly, but it failed when I installed (make install) and here is the error message: -- mv -f .libs/get_password.lo get_password.lo /bin/sh ../libtool --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I..-O3 -DDBUG_OFF -c errmsg.c rm -f .libs/errmsg.lo gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c errmsg.c -fPIC -DPIC -o .libs/errmsg.lo gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c errmsg.c -o errmsg.o /dev/null 21 mv -f .libs/errmsg.lo errmsg.lo make: don't know how to make my_init.c. Stop *** Error code 1 Please help. Chip Thanks! __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.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
vio_is_blocking?
What is vio_is_blocking and why would it cause a client to crash? This is with MySQL 4.0.1 on OS X. It did appear that my connection stuttered right before the crash (or during). I was not at the computer at the time. Exception: EXC_BAD_ACCESS (0x0001) Codes: KERN_INVALID_ADDRESS (0x0001) at 0x7561205e Thread 0 Crashed: #0 0x00020cfc in vio_is_blocking #1 0x00018b64 in simple_command #2 0x0001b23c in mysql_send_query #3 0x0001b3f8 in mysql_real_query #4 0x0001afb4 in mysql_query -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insanely Great People --- Please include any previous correspondence in replies, it helps me remember what we were talking about. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: how to delete from one table based on external conditions?
Try delete table1.* from table1 inner join table2 on table2.x=table1.y You may not need the .* in table1.* but I know it works with the .*. delete table1.* from table1, table2 where table2.x=table1.y From the manual 6.4.6 DELETE Syntax DELETE [LOW_PRIORITY | QUICK] FROM table_name [WHERE where_definition] [ORDER BY ...] [LIMIT rows] or DELETE [LOW_PRIORITY | QUICK] table_name[.*] [table_name[.*] ...] FROM table-references [WHERE where_definition] Gordon Bruce Interstate Software A MySQL Training Partner -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 10:37 AM To: [EMAIL PROTECTED] Subject: how to delete from one table based on external conditions? hi, i would like to know how i can achieve this kind of query: delete form table1 where table2.x=table1.y I checked the manual, there nothing like that! Am using mysql 3.23.49 SQL SQL SQL SQL SQL _ 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 mysql-unsubscribe- [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
Really big text - where to get?
Hello developers, When you write another MySQL-based search engine, you obviosly test it issuing queries against big amounts of data which contains more or less sane text. Tell me, where (or how) you usually get the text when you need, say, 10GB of it and, I repeat, it should be a REAL non-repeating text, not just would-be words randomly generated with a filler script? Regards, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Downgrade
Are there any steps I need to take to ensure no corruption of the database if I downgrade from say 3.23.49 to 3.23.48 Thanks, Dave query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php