Re: ssh connecting with a mysql client I get: ERROR 2013
Gleb Paharenko wrote: Hello. Can you connect using the mysql command line client program? leegold [EMAIL PROTECTED] wrote: ssh connecting with a mysql client gui I get: ERROR 2013 Lost connection to MySQL server during query I'm using mysqlyog and trying connect via the ssh tunnel. I can connect with out the ssh w/mysqljog OK. It's a very nice client and would like to get this working. I have googled it but nothing seems to ring a bell. I can ssh connect with Putty OK. Is this a problem on the mysql on server or my desktop? What can it be? I solved that by using the real IP address of the MySQL server and not localhost or 127.0.0.1 in my ssh tunnel. Then make sure you have proper permissions for the user, since the user will come from the real IP address. Thanks. -- Ugo - Please don't send a copy of your reply by e-mail. I read the list. - Please avoid top-posting, long signatures and HTML, and cut the irrelevant parts in your replies. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Books
Kieran Kelleher wrote: This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks after MySQL installations for Yahoo.com) (fix the link if it wordwraps in this email): http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20? creative=327641camp=14573link_code=as1 -Kieran I have mysql from Paul Duboir, 2nd ed here. Very complete. However, I like high performance mysql more because it is close to what I do - sysadmin/dba. I also read MySQL enterprise solutions. Good, but I like the two others more. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql Performance
Vasiliy Boulytchev wrote: Brent, Would you be so kind to throw out some links to tweaking mysql to run to its full performance. I am googling right now for the answeres. Is there books you would recommend? THANKS High Performance Mysql (oreilly) MySQL enterprise solutions (wiley) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Sasha Pachev wrote: So all I have to do, using the binary, is to take the mysqld file and replace my old one (from 4.1.3 to 4.1.7, for example). And for the source, I compile in another directory, then take the mysqld file and replace my old one? Is that documented somewhere? Do not forget to replace errmsg.sys with the newer version. This method does not seem to be documented anywhere, but I have successfully used it since early 3.23. Ok, but is an upgrade within the same version (from 4.1.6 to 4.1.7) documented somewhere? I never found it. If there is missing something in the doc, maybe I could help... Here is another trick you can do if you want to benchmark a certain mysqld binary on some random system where you have an account: scp sql/mysqld sql/share/english/errmsg.sys host: ssh host mkdir mysql-data ./mysqld --skip-grant --skip-net --datadir=`pwd`/mysql-data --language=`pwd` --socket=`pwd`/mysql-data/mysql-test.sock you can now connect on socket `pwd`/mysql-data/mysql-test.sock and issue queries. Thanks, this is interessting. Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Ini (cnf) file location
Roland Carlsson wrote: Hi! I've got a Mac OS X server with a preinstalled mysql from Apple. My problem is that I can't find the ini (cnf) file witch the documentation so very non-windows-friendly shall be located in C:\Windows. Could anyone please tell me where mysql excpects to find the ini (cnf) file? Thank you very much Roland Carlsson mysql will look in to /etc/my.cnf (global prefs), ~/my.cnf (user prefs), $datadir/my.cnf (server-specific prefs). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Sasha Pachev wrote: It can be even simpler than that, if you stay withing the same branch. Just replace mysqld and share/english/errmsg.sys ( or share/your langauge/errmsg.sys if you want them in your native language) with the files from the new version. This is for the source, binary or both? Sorry to ask stupid questions, but I do have read 3 MySQL books (including yours), and went through the manual, and I've never really seen a section about updating MySQL. It does not matter. mysqld is the only file in the server that really does the job - mysqld_safe is just a wrapper and if it does change from version to version at all, using the old version does not hurt. mysqld does need to see the error messages file on startup and the error messages file gets changed sometimes from version to version. mysqld does know how many error messages it is supposed to have, and will not start unless the error messages file has the expected number. Otherwise, if you are within the same version, mysqld will be able to deal with all the files from the old one. So all I have to do, using the binary, is to take the mysqld file and replace my old one (from 4.1.3 to 4.1.7, for example). And for the source, I compile in another directory, then take the mysqld file and replace my old one? Is that documented somewhere? Hmmm, ok. Do you think I should file a bug? Lenz is already looking at it. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimizing MySQL
Shaun wrote: Thanks for your help Dathan, I will make the required changes. I just have one other problem. I'm not sure what queries don't use an index. I've attmepted to turn on the slow-queries-log, but nothing ever shows up in the file. Here's what I have in the my.cnf [mysqld] skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = max_connections=500 set-variable = ft_min_word_len=1 long_query_time=1 log-long-format log-slow-queries = /var/log/slow.log Do you have any idea why my slow query log isn't working? Can the mysql user write to this file? --log-long-format should show you queries that don't use an index. Do I have something wrong in my syntax? I'm using MySQL 4.0. Thanks for your help, I really appreciate it. http://www.hdtv-info.org http://www.entertainment-news.org http://www.political-news.org Look at Created_tmp_disk_tables 14768 Created_tmp_tables 269520 Created_tmp_files 3 Increase tmp_table_size = 64M: it's used to stop going to disk and some internal mysql operations. Handler_read_rnd_next 58229817 Your tables are not index properly, your doing a lot of table scans. Your biggest perf. Gain will come from changing your schema and or optimizing your queries. DVP Dathan Vance Pattishall http://www.friendster.com Hello, I was wondering if a more knowledgeable person could help me out with my configuration and let me know how I could further optimize MySQL. Here's the hardware on my dedicated server: Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz Processor #1 speed: 2400.152 MHz Processor #1 cache size: 1024 KB Memory 512 MB Here's what I get for the command SHOW STATUS: Aborted_clients247 Aborted_connects483 Bytes_received 531539854 Bytes_sent 503095410 Connections 450758 Created_tmp_disk_tables 14768 Created_tmp_tables 269520 Created_tmp_files 3 Delayed_insert_threads 0 Delayed_writes 0 Delayed_errors 0 Flush_commands 1 Handler_commit 0 Handler_delete 27837 Handler_read_first 670529 Handler_read_key 285579436 Handler_read_next 394084433 Handler_read_prev 680815 Handler_read_rnd5230552 Handler_read_rnd_next 58229817 Handler_rollback 0 Handler_update 384098 Handler_write 77442968 Key_blocks_used 50333 Key_read_requests 1081940322 Key_reads 45598 Key_write_requests 66458416 Key_writes 41372551 Max_used_connections 154 Not_flushed_key_blocks 0 Not_flushed_delayed_rows 0 Open_tables256 Open_files 323 Open_streams 0 Opened_tables 1022 Questions 30428972 Qcache_queries_in_cache0 Qcache_inserts0 Qcache_hits 0 Qcache_lowmem_prunes0 Qcache_not_cached 0 Qcache_free_memory 0 Qcache_free_blocks 0 Qcache_total_blocks 0 Rpl_status NULL Select_full_join 268 Select_full_range_join0 Select_range 66211 Select_range_check 0 Select_scan 151459 Slave_open_temp_tables 0 Slave_running OFF Slow_launch_threads 2 Slow_queries 15783 Sort_merge_passes 0 Sort_range 476962 Sort_rows 5241809 Sort_scan 283556 Table_locks_immediate31443397 Table_locks_waited 20243 Threads_cached 4 Threads_created 2423 Threads_connected5 Threads_running 1 Uptime 771502 Here are the complete contents of my my.cnf file [mysqld] skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = max_connections=500 set-variable = ft_min_word_len=1 log-slow-queries=/var/log/slow-queries.log set-variable = long_query_time=1 safe-show-database Thanks a lot for your help! http://www.hdtv-info.org http://www.entertainment-news.org http://www.political-news.org -- MySQL
Re: 4.1.7 serious problems
Sasha Pachev wrote: Ugo Bellavance wrote: Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon MP. Are you using the same mysqld binary on both? [EMAIL PROTECTED] local]# md5sum mysql-standard-4.1.7-pc-linux-i686.tar.gz 50adc5470228028dd28f0d51ae4f10f3 mysql-standard-4.1.7-pc-linux-i686.tar.gz [EMAIL PROTECTED] local]# md5sum mysql-standard-4.1.7-pc-linux-i686.tar.gz 50adc5470228028dd28f0d51ae4f10f3 mysql-standard-4.1.7-pc-linux-i686.tar.gz Ugo: Try compiling from source on the production system and see if it fixes the problem. I did compile it from source, with the flags used for the binaries, and now it does work. I'm totally confused now. Is it easy to upgrade from source? With the binary, I could have two separate directories and I would symlink the one I tested (most recent version) and could get back to the earlier version by just re-creating my symlink... And I'd really like to know what is wrong when I'm using the binary distribution. Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Low-end SATA vs. SCSI
Gary Richardson wrote: If you are talking about the WD Raptor's -- stay away. Out of 6 we used, 3 failed. Do a few googles and you'll hear the same from other users. On the other hand, the do fly. Raid10 them them on a 3ware 9500 and you'll be amazed. I agree on the 3Ware... Exceptionnal cards. Too bad for the Raptors :(. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Sasha Pachev wrote: I did compile it from source, with the flags used for the binaries, and now it does work. I'm totally confused now. Is it easy to upgrade from source? With the binary, I could have two separate directories and I would symlink the one I tested (most recent version) and could get back to the earlier version by just re-creating my symlink... It can be even simpler than that, if you stay withing the same branch. Just replace mysqld and share/english/errmsg.sys ( or share/your langauge/errmsg.sys if you want them in your native language) with the files from the new version. This is for the source, binary or both? Sorry to ask stupid questions, but I do have read 3 MySQL books (including yours), and went through the manual, and I've never really seen a section about updating MySQL. And I'd really like to know what is wrong when I'm using the binary distribution. Most likely a mistake of some kind on the part of MySQL AB. A similar problem has happened in the past. I hope somebody on the build team is listening. Hmmm, ok. Do you think I should file a bug? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Sasha Pachev wrote: I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Ugo: Do the production and the test server run on the same hardware? One is a single Athlon XP, the other is a dual Athlon MP. Are you using the same mysqld binary on both? [EMAIL PROTECTED] local]# md5sum mysql-standard-4.1.7-pc-linux-i686.tar.gz 50adc5470228028dd28f0d51ae4f10f3 mysql-standard-4.1.7-pc-linux-i686.tar.gz [EMAIL PROTECTED] local]# md5sum mysql-standard-4.1.7-pc-linux-i686.tar.gz 50adc5470228028dd28f0d51ae4f10f3 mysql-standard-4.1.7-pc-linux-i686.tar.gz What I am suspecting is that the binary on the production system does has not been compiled for the right processor type. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which PHP for MySQL 4.1
Jay Blanchard wrote: [snip] I would like to migrate my MySQL servers from 4.0 to 4.1. As I use PHP as well as Java with these servers I wonder what PHP 4 version would be compatible with MySQL 4.1. Has anyone used MySQL 4.1 with PHP yet? [/snip] PHP 4 is compatible with MySQL 4.1. My caution to you would be using Apache 2 as it has some quirks that haven't been worked out yet. Must be careful about authentification though. see http://dev.mysql.com/doc/mysql/en/Password_hashing.html and http://dev.mysql.com/doc/mysql/en/Old_client.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Heikki Tuuri wrote: Ugo, - Original Message - From: Ugo Bellavance [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Friday, November 05, 2004 3:42 PM Subject: Re: 4.1.7 serious problems Gleb Paharenko wrote: Hi. There were several posts in list like yours. Do you use InnoDB tables? Try to increase values of key_buffer_size, read_buffer_size and so on. InnoDB is enabled but no InnoDB table is used yet (coming soon). However, it crashes with only 1 client connected. There is still plenty of free memory. if mysqld crashes that easily, then you may have a hardware fault, or the OS version in that computer is buggy. I tested the memory and it seems ok. I doubt this is an hardware issue, since version 4.1.3 works perfectly. Thanks, You can try running memtestx86 or memburn: http://v.iki.fi/~vherva/memburn.c You can also try upgrading the kernel. Thanks, Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Gleb Paharenko wrote: Hi. There were several posts in list like yours. Do you use InnoDB tables? Try to increase values of key_buffer_size, read_buffer_size and so on. InnoDB is enabled but no InnoDB table is used yet (coming soon). However, it crashes with only 1 client connected. There is still plenty of free memory. Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.1.7 serious problems
Hi, I've upgraded one of my servers (test) to 4.1.7 this week, all went ok. Now I'm trying to upgrade another server (production) from 4.1.3 to 4.1.7 and I'm having serious problems. I tried 4.1.6 as well, same problem. OS: Tao Linux (Red Hat Enterprise Linux 3.0 clone). First, since I couldn't find a procedure saying how to upgrade a binary distribution, here is what I do. -Stop MySQL -Downoad the tarball in /usr/local/. -Check the md5 -untar the tarball -copy the content of the data directory of old version into new version's data directory. -fix up the permissions like described in the INSTALL-BINARY file included -delete the /usr/local/mysql symlink and re-creating another one pointing to the new version. -Start MySQL -Test Here is the problem: After this procedure, I connect with a mysql client, use db, and then when I run a command like a select or update, the server crashes, giving me those errors on the client: ERROR 2013: Lost connection to MySQL server during query Or: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:1 Current database: db When I go to the error log, here is what I got: 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=16384 read_buffer_size=258048 max_used_connections=1 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 31615 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8908e40 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... Cannot determine thread, fp=0xbfe7eca8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x808af93 0x82d6de8 0x80c00bf 0x80bdeee 0x80ba6e9 0x80bcd51 0x80b9de6 0x809a1dd 0x809e6e9 0x8098def 0x8098778 0x8097eb7 0x82d459c 0x82fdf1a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/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 0x890f370 = SELECT * FROM `ville` thd-thread_id=1 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. == When resolving the stack trace, I get this: /usr/local/mysql/bin/resolve_stack_dump -s ./symbols -n ./stack 0x808af93 handle_segfault + 423 0x82d6de8 pthread_sighandler + 184 0x80c00bf get_best_combination__FP4JOIN + 147 0x80bdeee make_join_statistics__FP4JOINP13st_table_listP4ItemP16st_dynamic_array + 4206 0x80ba6e9 optimize__4JOIN + 457 0x80bcd51 mysql_select__FP3THDPPP4ItemP13st_table_listUiRt4List1Z4ItemP4ItemUiP8st_orderT7T5T7UlP13select_resultP18st_select_lex_unitP13s + 745 0x80b9de6 handle_select__FP3THDP6st_lexP13select_result + 150 0x809a1dd mysql_execute_command__FP3THD + 1241 0x809e6e9 mysql_parse__FP3THDPcUi + 169 0x8098def dispatch_command__F19enum_server_commandP3THDPcUi + 1643 0x8098778 do_command__FP3THD + 188 0x8097eb7 handle_one_connection + 615 0x82d459c pthread_start_thread + 220 0x82fdf1a thread_start + 4 Any help would be appreciated. Please let me know if you need more info. Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.7 serious problems
Anders Green wrote: There are differences, starting with 4.1.5, with the user/schema administration, that need to be updated/massaged. Perhaps that is your problem? I don't think so, everything works perfectly on my test server, which is very similar. Thanks, Maybe. :) Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com/ | +===+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication error
Hi, I'm trying to do a replication of two servers (one is mysql version 4.1.0-alpha-debug-debug (slave) on debian and the other is 4.1.0-alpha-debug-debug-log (master) on RH9). No I can't upgrade for now. What I've done is that I stopped the master, copied the data folder to the slave. I got the data from SHOW MASTER STATUS and input it in the slave, and created the user on the master, as directed. The problem is that when I START SLAVE, I get this error: ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO The problem might be caused by the fact that I have a firewall with nat between them, but I set up the user accordingly ([EMAIL PROTECTED] name of the firewall]. The slave is able to reach port 3306 on the master and port-forwarding is enabled on the firewall, forwarding port 3306 to the slave. SHOW MASTER STATUS on the master: mysql show master status; +--+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--+--+--+--+ | bobby-bin.23 | 79 | | | +--+--+--+--+ 1 row in set (0.00 sec) Thanks -- Ugo Bellavance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slave behing nat firewall
Hi, I'm trying to set this up: Master (in DMZ) = Firewall (nat with port forward 3306 to slave) = Slave. Is that possible? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Hi all.
-Message d'origine- De : Andy Fletcher [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, January 27, 2004 4:42 AM À : [EMAIL PROTECTED] Objet : Hi all. I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select USERID,NAME,LNAME Where DOC contains what ever words or phrases ; How would I do this ? First, try to use a significant subjet to your messages. It helps when searching the archive. Then, I don't think your needs can be fullfilled, since I don't think mysql can tell what is in a Blob, except that it is a series of 1 and 0. hth Many thanks for information on this. Here from you soon I hope, Best regards Andy Fletcher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: netstat
Adam Hardy wrote: I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat (see the output below) and it makes me wonder if the mysql port needs to be open at all, since the tomcat and mysql database are running on the same machine. Can I block off these ports? Would I have to use a firewall to do that? (like ip_tables) Maybe you can communicate through the socket. It will allow you to use the skip-networking option, so mysql will not listen on the NIC Thanks Adam Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp0 0 localhost:8005 *:* LISTEN 30723/java tcp0 0 *:mysql *:* LISTEN 1890/mysqld tcp 0 0 *:www *:* LISTEN 30723/java tcp0 0 *:ssh *:* LISTEN 248/sshdtcp 0 0 *:12121 *:* LISTEN 267/perltcp0 0 *:smtp *:* LISTEN 239/master tcp 0 0 *:https *:* LISTEN 30723/java tcp0 0 localhost:mysql localhost:1311 ESTABLISHED 1890/mysqld tcp 1 0 localhost:1312 localhost:mysql CLOSE_WAIT 30723/java tcp0 0 localhost:1311 localhost:mysql ESTABLISHED 30723/java -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: large SQL statements
-Message d'origine- De : brent [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 22, 2004 4:50 PM À : [EMAIL PROTECTED] Objet : large SQL statements Everyone, I downloaded Backup Watcher for MySQL today and am trying a few tests. I created one backup from a remote server, but the SQL statement Backup Watcher generated is over 20 megs, making it a little difficult (at least for me) to process. I'm running a W2K-SP4 setup, MySQL 3.23.49. I'm able to open the Backup Watcher-generated statement in Word, but I have to copy it in relatively small chunks to keep MySQL Front from hanging. I tried the command line approach, but again, it hangs. Is there a more practical way to execute a statement of this size, or another program that will handle remote server backups differently? Sorry if my ignorance has caused me to miss something obvious... What command do you use to restore your backup? mysql filename? Ugo Thanks in advance, Brent -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql 4.1.1 and PHP
-Message d'origine- De : I.P. [mailto:[EMAIL PROTECTED] Envoy : Friday, January 16, 2004 6:41 AM A : [EMAIL PROTECTED] Objet : Mysql 4.1.1 and PHP Hi. I would like test mysql 4.1.1 with php but, i cann't connect to it. I have error when use password :( From mysql CC beta 0.9.4 i could connect to my 4.1.1 server to. I can connect to mysql 4.1.1 - only if i have no password set. What's going on ? Just connect without password, then set it one. Ugo Regards. Irens. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: setting a variable
-Message d'origine- De : Mikael Fridh [mailto:[EMAIL PROTECTED] Envoyé : Friday, January 16, 2004 4:19 AM À : Ugo Bellavance Objet : Re: setting a variable On Thursday 15 January 2004 19.51, Ugo Bellavance wrote: No problem, I thought I could change any variable at runtime, since 4.0. I've got no prob with doing it at a restart of the server. I tried putting set-variable = log=on at the end of /etc/my.cnf (redhat) and nothing changed. Thanks, Ugo I think it's not a normal variable, it needs to be passed as a command-line parameter to mysqld. in my.cnf put: log or if you need the logfile in some other dir than the datadir: log=/var/log/logfile Mikael. Thanks, I ried the latter, but I didn't have the right permissions on the file, so I tried with just log, it worked. I then changed my permissions and all went fine. I have another question: why so many people replied to me off-list, without even cc:'ing the list? Thanks, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: setting a variable
-Message d'origine- De : Tobias Asplund [mailto:[EMAIL PROTECTED] Envoyé : Wednesday, January 14, 2004 1:53 PM À : Ugo Bellavance Cc : [EMAIL PROTECTED] Objet : Re: setting a variable On Wed, 14 Jan 2004, Ugo Bellavance wrote: mysql 4.0.17 on redhat 9 or debian 3.0 mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set global log=on; ERROR 1193: Unknown system variable 'log' What am I doing wrong? Currently you cannot start logging while the server is running. No problem, I thought I could change any variable at runtime, since 4.0. I've got no prob with doing it at a restart of the server. I tried putting set-variable = log=on at the end of /etc/my.cnf (redhat) and nothing changed. Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
setting a variable
mysql 4.0.17 on redhat 9 or debian 3.0 mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set global log=on; ERROR 1193: Unknown system variable 'log' What am I doing wrong? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: setting a variable
Sorry, 4.0.16, not 4.0.17, if it changes anything. -Message d'origine- De : Ugo Bellavance Envoyé : Wednesday, January 14, 2004 12:07 PM À : [EMAIL PROTECTED] Objet : setting a variable mysql 4.0.17 on redhat 9 or debian 3.0 mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set global log=on; ERROR 1193: Unknown system variable 'log' What am I doing wrong? Thanks, Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL GPL License Question
-Message d'origine- De : Computer Mail [mailto:[EMAIL PROTECTED] Envoyé : Wednesday, January 14, 2004 2:45 PM À : [EMAIL PROTECTED] Objet : MySQL GPL License Question I understand some of the GPL but I am a little confused on this issue: If I create a program that just queries data from a MySQL table and processes it...am I required to release that program under the GPL? I have a MySQL server set up with some tables and I created a seperate application to query the tables and process the data. Is writing an app that is able to connect with MySQL a situation where I will need to release it under the GPL? There is no code or any part of MySQL used in the application. I think that as long as you can distinguish mysql from your application you don't need a licence. When you can't remove mysql without playing into the code, it is embedded, thus require a licence. my 2cents Any help would be greatly appreciated. __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Control Center!!!
-Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Saturday, January 03, 2004 9:24 AM À : [EMAIL PROTECTED] Objet : MySQL Control Center!!! Hello: I have been reading MySQL Control Center. There are screen shots but I have not been able to find documentation. Is the documentation is hidden or not available? I think that it is so straightforward that you don't need doc. Or if you need help, use the help in the program. If there is documentation, kindly direct me to the URL. Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Perl Modules!!!
-Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Saturday, January 03, 2004 9:43 AM À : [EMAIL PROTECTED] Objet : Perl Modules!!! Hello: I need some advise. I am trying to learn and install MySQL, RH9 distro. My question is about Pearl Modules: 1) Is it common to install Perl Modules? 2) If I do not install Perl Modules now, can I install later on with any big headache? First, you're in a MySQL list. This is not the place to ask questions about perl. Write to a perl list or a redhat list. I'll answer your questions the best I can, but if you have other questions, don't post them here, go to the right list. I think many perl modules are available via rpm. Get apt from http://apt.freshrpms.net do a apt-get update apt-get upgrade then when you are looking for a package use apt-cache apt-cache search query ex: apt-cache search perl-DBI another thing: you can install perl modules using cpan. get perl-cpan by doing apt-get install perl-CPAN then have a look here http://www.brandonhutchinson.com/installing_perl_modules.html For your last question: you can _usually_ wait until you need the module to install it. hth Ugo Thanks, Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Broadcast to search available MySQL Server in Network?
-Message d'origine- De : Manfred Süsens [mailto:[EMAIL PROTECTED] Envoyé : Saturday, January 03, 2004 7:58 AM À : [EMAIL PROTECTED] Objet : Re: Broadcast to search available MySQL Server in Network? Yes, I tried to find the port 3306, but MySQL doesn't answer! Maybe it is just not listening. Do you have skip-networking in your my.cnf by any chance? Is your server even started? How do you try to find the port? So, has MySQL a functionality to answer automatically? yes, of course, as long as the server is started and skip-neworking is not enabled. Using telnet you can check wether it is listening. telnet hostname 3306 should give you something like: Connected to hostname. Escape character is '^]'. 0 4.0.16-standard_l%q,%r4I, What is the port number MySQL is listening? 3306/tcp What kind of family MySQL use? Do MySQL use UDP protocol? no hth Ugo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: BUG IN MYSQL
-Message d'origine- De : Richard S. Huntrods [mailto:[EMAIL PROTECTED] Envoyé : Saturday, January 03, 2004 6:05 PM À : [EMAIL PROTECTED] Objet : BUG IN MYSQL I've submitted this problem three times now, and been ignored all three times. http://bugs.mysql.com/ I guess bugs are simply not popular. Since the problem described below is 100% repeatable, I will now escallate it from problem with delete/insert to BUG IN MYSQL. Cheers... I've distilled the problem I'm having with DELETE/INSERT to an even simpler test case. Here's the SQL - it can be used with any database, not just the special expdb I created. I run this script followed by running mysqlcheck expdb. # USE expdb; DROP TABLE IF EXISTS appraised; CREATE TABLE appraised ( idNumber int(11) NOT NULL default '0', indexNo int(11) NOT NULL default '0', experience int(11) default NULL, lastused int(11) default NULL, competence int(11) default NULL, status int(11) default NULL, appraiser int(11) default NULL, comments text, PRIMARY KEY (idNumber,indexNo) ) TYPE=MyISAM; PRINT; DELETE FROM appraised; INSERT INTO appraised VALUES (1,1,1,1,1,1,1,'aaa1'); SELECT * FROM appraised; DELETE FROM appraised; # If you run this with the INSERT commented out, mysqlcheck reports OK. If you don't comment out the INSERT, mysqlcheck reports: C:\mysql-4.0.15\binmysqlcheck expdb expdb.appraised warning : Table is marked as crashed warning : Size of indexfile is: 2048 Should be: 1024 warning : Size of datafile is: 160 Should be: 0 error: Record-count is not ok; is 4 Should be: 0 warning : Found 4 partsShould be: 0 parts error: Corrupt This happens every single time. You cannot use the -autorepair function, as it reports appraised.MYD cannot be opened. What is going on? Thanks, -Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Installation Question
-Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! It is not optimized. It is optimizeable, not the same thing. However, you need to know exacly what are the compiler flags to optimize it. If you run on x86, you are better of with the binary or the .rpm. No offense, but people who compile at mysql are a lot better than you and me to get the best flags. hth Ugo Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start all over again. Thanks again. Kirti -Original Message- From: dan orlic [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 12:07 PM To: Kirti S. Bajwa Subject: Re: Installation Question i never had much luck with the source distribution, let alone using the prefix flag. Try untarring it in /usr/local/mysql dir yourself and then continue with the ./configure make and so forth... better yet, i would untar it in a /usr/local/mysql-whatever-version and then make a soft link of mysql point to that directory, allows you to have multiple installs of mysql where all you have to change is the link and restart mysql. my humble option, go with the binary installation it will take you less then a couple minutes to install. hope this helps. dan Kirti S. Bajwa wrote: I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in /usr/local/mysql. After I run this configure statement, I do not see a folder /usr/local/mysql!! Is it correct? Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Remote access FROM a secure server
-Message d'origine- De : Amer Neely [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 3:07 PM À : Larry Brown Cc : MySQL List Objet : Re: Remote access FROM a secure server Larry Brown wrote: Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a secure facility so I haven't messed with SSL for mysql, so for instance it may use a different port number etc. Just my 2 cents worth... Larry -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Thursday, January 01, 2004 2:07 PM To: MySQL Subject: Remote access FROM a secure server I have a Perl script running on a secure server (https) and am trying to access the mysql server on a different (unsecure) server. My ISP administrator has done the following: GRANT ALL ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Then he restarted the server. But I'm still not getting access. Is the 'FLUSH PRIVILEGES' still necessary, or is the restart sufficient? I can access the db from a local phpMyAdmin and am using the same parameters in my script, so I know it is accessible. We're both stumped. Anyone shed some light on this please? Good thought. I just tried that and still got booted away. Connecting To xxx.xxx.xxx:3306...Could not open a connection to host on port 23 : Connect failed Curious where the 'port 23' came from. It is the standard telnet port. You must not put the colon in a telnet command. here is the right command: telnet host.domain.com 3306 hth Ugo -- sigAll outgoing email scanned by AVG Antivirus Amer Neely, Softouch Information Services | Home of Spam Catcher Research Central. W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work!/sig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem Installation
-Message d'origine- De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, December 30, 2003 10:43 AM À : Mikhail Entaltsev Cc : [EMAIL PROTECTED] Objet : Re: Problem Installation Thanks, I installed, but i don't to connect!! bashmysql bashERROR 2002: Can't connect to local MySQL server through socket 'var/lib/mysql.sock' (2) Is the server running? Ugo On Tue, 30 Dec 2003, Mikhail Entaltsev wrote: Hi You need to install first rpm with dynamic client libraries (including 3.23.x libraries). You can find them on http://www.mysql.com/downloads/mysql-4.0.html Best regards, Mikhail. - Original Message - From: Carlos Andre Moura de Amorim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 4:20 PM Subject: Problem Installation I have red hat 9.0, i don't to install mysql RPM appear: erro: Failed dependencies: libmysqlclient.so.10 is needed by perl-DBD-MySQL-2.1021-3 Please Help me!! -- ** ** *** Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 ** ** *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- *** Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem
-Message d'origine- De : Carlos Andre Moura de Amorim [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, December 30, 2003 11:23 AM À : [EMAIL PROTECTED] Objet : problem i have a follow problem, please, help-me [EMAIL PROTECTED] db]# mysql --user=root --password=xx ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) have you tried without password? if not, look in google mysql root password recovery. There is a section on this in the mysql manual available on mysql.com hth Ugo -- ** * Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 ** * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to backup MySQL databasee?
-Message d'origine- De : florence florence [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, December 30, 2003 1:46 PM À : [EMAIL PROTECTED] Objet : How to backup MySQL databasee? Hi, Can somebody teach me how to do MySQL server backup? Any answer will be much appreciated. Start with mysqldump Ugo regards, florence Thank you very much. regards, florence The New Yahoo! Search - Now with image search! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Log Files in MySQL
-Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Envoyé : Monday, December 29, 2003 8:12 PM À : [EMAIL PROTECTED] Objet : Log Files in MySQL I think I am confused. I have many bin index files, but I have not gotten rid of them. I read somewhere that I should not remove them...or I should not remove the entries in the index file. Since I am unsure of which one above is correct, I am posting to the list. Can someone let me know which of the above is correct, and what I should do? First, please let us know what you are trying to achieve (save space, optimize...). Ugo Thanks Eric eric wagar glxvr623 on AIM [EMAIL PROTECTED] on MSN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: backup
-Message d'origine- De : Rick [mailto:[EMAIL PROTECTED] Envoyé : Saturday, December 27, 2003 6:33 AM À : [EMAIL PROTECTED] Objet : backup i guys!! im newbie, how can i backup a mysql database? what do you recommend me? mysqldump to begin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Hot standby database question
-Message d'origine- De : Jim Richardson [mailto:[EMAIL PROTECTED] Envoye : Thursday, December 25, 2003 10:18 AM A : [EMAIL PROTECTED] Objet : Hot standby database question I would like to set up two systems, a primary, and a backup, in physically seperate locations. I want the backup to be synced with the primary, and if the primary goes down, dns will resolve to the backup, so it needs to be able to start processing transactions immediately. I am new to MySQL, and to SQL in general, I *think* I can do the first part (stay in sync with the primary) by making the backup a slave, and replicating the DB on a constant basis. But will the slave DB happily start accepting transactions when stuff starts coming in from the webserver? or do I have to do something to allow that in MySQL? As an aside, a recommendation on good beginner and intermediate level MySQL books would be appreciated. I want to RTFM, but I want to make sure it *is* the Fine manual :) The first reference is the mysql reference manual available online at www.mysql.com. I am reading Mysql enterprise solutions from Alexander Sasha Pachev (Wiley) and MySQL, from Paul Dubois (developper's library) and they're both good. Oh, and seasons greetings to all, yes I'm working on Christmas, it's a startup, what can I say... -- Jim Richardson http://www.eskimo.com/~warlock Quantum mechanics: The dreams stuff are made of. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]