Re: Patch for mysql
Nagaraj S wrote: Hi Gurus, Good Day! How to apply mysql bug fixing patches or it is just updating or replacing some code in a c file and recompiling the source? Depending on how your patch looks like, you will use the Unix patch(1) utility or not Anyone able to supply some simple steps to patch instructions? I have mysql server running on Solaris 10 system. Why not just use the method that Solaris provides to update the MySQL package? Applying patches requires you to recompile MySQL, and if you're already curious about how to apply a patch (and you're not clear what patch this might be), I'd avoid this method of getting things done -- Colin Charles, http://bytebot.net/blog/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migration from 32-bit to 64-bit MySQL
Mike wrote: Hi! I would like to move from 32-bit to 64-bit MySQL within the next year. Unfortunately, there is not a lot of documentation on migration or anything else regarding 64bit MySQL. Dump the database, restore on the 64-bit box, and all should be well What is the difference between 32-bit and 64-bit? Is this a good idea? Can it be done? What would make this go wrong? Addressing more RAM currently is your only gain... On a 32-bit system, you tend to only have 2.5-2.7GB of RAM available to MySQL (your OS needs the remainder) Kind Regards -- Colin Charles, Community Relations Manager, APAC Database Group, Sun Microsystems Inc., http://www.mysql.com/ Tel: +6012 204 3201 (Malaysia) | colincharles (Skype) Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Migration from 32-bit to 64-bit MySQL
On 4/26/08 Mihail Manolov wrote: Hi! MyISAM (MERGE; and therefore not an issue). The only exception is Falcon, which is only available in MySQL 6.0. While I haven't had a chance to read the wiki link you posted, as I write this email offline, it should be noted that Falcon previews even (currently available on forge.mysql.com/wiki/) are only built for 64-bit There are no 32-bit binaries built for Falcon Falcon, the engine itself, was designed to shine on 64-bit platforms. By the time Falcon is GA (heck, even now when its not GA), people will not be buying 32-bit hardware any longer kind regards -- Colin Charles, Community Relations Manager, APAC Database Group, Sun Microsystems Inc., http://www.mysql.com/ Tel: +6012 204 3201 (Malaysia) | colincharles (Skype) Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Availability of 5.1 as production release ?
Ulrich Staudinger wrote: first of all, thanks for the world's finest open source database! I would like to know if someone has an estimate for the availability of v5.1 as a production release. ? Keep watching http://dev.mysql.com/doc/refman/5.1/en/news.html and its a safe bet if its Q3/Q4 this year, I believe -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Ekiga/Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Users Conference: http://www.mysqluc.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: incompatible libmysqld.a
Carlos Soria wrote: Thank you for your answers. gcc (GCC) 4.1.1 20060724 (prerelease) (4.1.1-3mdk) mysql Ver 14.12 Distrib 5.0.24a, for mandriva-linux-gnu (i586) using readline 5.1 GNU C Library development release version 2.4, I think MySql 5.0 requires glibc 2.3. I do not know if v2.4 is a problem. It compiles with glibc v2.5 on Fedora Core 6 This computer is a laptop Acer Aspire 5633WLMi, Intel Core Duo processor. Can you file a bug report at bugs.mysql.com? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Ekiga/Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error MYI 1016 - damaged database table
Rodica Rosu Fridez wrote: Bonjour, Parlez vous anglais? Mon francais, est plutot limite. Nous avons rencontré ce message d'erreur lorsqe l'on veut accéser notre plateforme e-commerce www.styltech.ch La personne qui administrait le site ne travaille plus chez nous. J'ai trouvé la documentation qui nous conseille: 1016 - Can't open file 'database table name.MYI' (errno: 145) Yes, your table is marked as having crashed, and you need to repair it (by one of the following methods) To find out, type: perror 145 in the command line Now to fix it, try: check table database_table_name; in the mysql prompt. Then you can do repair table database_table_name; You can also use the myisamchk command - read more about it at http://dev.mysql.com/doc/refman/5.0/en/myisamchk.html Hope this helps! The error message will always be shown until the database table involved has been repaired. The following methods are available to repair damaged database tables, depending on whether the database server is still running or not: 1. Using the repair table SQL statement 2. Using the myisamchk command The database table name part in the commands below must be replaced with the actual database table name as shown in the error message. 1. Using the repair table SQL statement The following SQL statement can be executed when the database server is still running: repair table database table name; 2. Using the myisamchk command The following command, which is part of the MySQL installation, can be executed on the server when the database server is no longer running: myisamchk /path/to/database/directory/database table name.MYI Dans quel fichier devrais-je intervenir? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_upgrade shows errors
Yves Goergen wrote: On 14.02.2007 08:00 CE(S)T, Colin Charles wrote: The MySQL 5.0 release is available as a binary and is currently at 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads I read in the news some time ago that MySQL 5.0 is only going to be available as source version in the future, which it currently looks like. (Can't currently find that news.) But a more important fact is that the MySQL pre-built binary doesn't work correctly on my machine, anything that links to the mysqlclient crashes when using SSL. Since I build MySQL from source, that's gone. Yes, so the idea behind this is one release source only, one release source + binary, one release source only, one release source + binary. Frequency should be similar to previous releases, so currently, 5.0.27 is in binary, 5.0.33 is in source only, and 5.0.35 will have both binaries and sources Regarding the SSL bug, can you please file a bug at bugs.mysql.com? MySQL server is version 5.0.33, OS is Debian Linux 3.1, previous MySQL version was 5.0.17, installed from the binary release. Whats wrong with using the version via apt-get? Debian has very sensible packaging, and its currently at version 5.0.32 afaik Not quite... I can choose from 4.0.24 and 4.1.11a. While 4.0 seems to be unsupported by MySQL AB for a while. Thats true, we've dropped support for 4.0 since end-2006. I believe the roadmap does say 4.1 will be dropped in due time too -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: incompatible libmysqld.a
Carlos Soria wrote: Hello, I am working with MySQL 5.0.24 on Mandriva-Linux 2007. I can't compile book example test1_libmysqld due to an incompatibility gcc -g -W -Wall -I/usr/include/mysql -D_THREAD_SAFE -D_REENTRANT -static test1_libmysqld.c -L/usr/lib/mysql -lmysqld -lz -lm -lcrypt -lpthread -o test1_libmysqld /usr/bin/ld: skipping incompatible /usr/lib/mysql/libmysqld.a when searching for -lmysqld /usr/bin/ld: cannot find -lmysqld collect2: ld returned 1 exit status make: *** [test1_libmysqld] Error 1 What is libmysqld incompatible with? Whats your configure options? Please provide more details. Also, what version of gcc is this? thanks -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Repairing a table
Ian Barnes wrote: Im having another problem with a large db. I have a 160Gig drive dedicated to the database partition and I have on database in particular that is taking up the space. My .MYD is 78Gig and my .MYI is 34 gig. Thats fine i have a couple of gig left, but whenever i try and do anything on it, the disk fills up and I have to run a repair table tablename quick to get it going and that takes forever since its quite large. What kind of filesystem is this? I suggest running Linux, and using a sensible filesystem like XFS, possibly Repairing tables take a long time usually (Falcon is meant to fix this)... Do you know why the disk is filling up so fast? What MySQL version is this? And how much *actual* free space do you have? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_upgrade shows errors
Yves Goergen wrote: Hello, I noticed that the current MySQL 5.0 release is not available as binary, so I downloaded the source and compiled it on my testing machine. Compilation went fine and I can connect to the new MySQL server version. But then I tried to run the mysql_upgrade script to fix possible issues and here's what it gave me: The MySQL 5.0 release is available as a binary and is currently at 5.0.27. Grab it at: http://dev.mysql.com/downloads/mysql/5.0.html#downloads ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv' @hadGrantPriv:=1 1 1 ERROR 1060 (42S21) at line 28: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 29: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 30: Duplicate column name 'Grant_priv' ERROR 1060 (42S21) at line 41: Duplicate column name 'ssl_type' ERROR 1061 (42000) at line 66: Duplicate key name 'Grantor' ERROR 1054 (42S22) at line 102: Unknown column 'Type' in 'columns_priv' ERROR 1060 (42S21) at line 124: Duplicate column name 'type' @hadShowDbPriv:=1 1 1 (and some more similar stuff) I tried it twice. At the first time, all other tables had an OK besides them, at the second time, those lines didn't show up anymore. MySQL server is version 5.0.33, OS is Debian Linux 3.1, previous MySQL version was 5.0.17, installed from the binary release. Whats wrong with using the version via apt-get? Debian has very sensible packaging, and its currently at version 5.0.32 afaik What do the above error messages mean? The upgrade script picked up on the fact that you had duplicate column names -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting up multiple daemons
Devi wrote: Hi MySQLeers, How can I setup multiple daemons, One daemon for one database? So that they can act independenly. What might be the pitfalls over here? In what situation one can opt for multiple daemons? What about maximum_connections. Is it for all the server instances? You might consider reading: http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html There is also documentation if you wanted to do this on Windows -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log Warnings Level
Kristen G. Thorson wrote: But all I really get from this reading is 0 turns it off, 1 prints some warnings, and 2 prints level 1 warnings plus aborted connections warnings. I have not been able to find any additional information in my search. Am I missing something, or is this all the documentation there is on this? What kind of additional information are you looking about the --W (or --log-warnings=N) option? Thank you for the response. I was looking for information on how high the level can go - 2? 5? 200? - and what types of warnings are logged for a given level? AFAIK, 2 is the highest. Anything beyond that, is equivalent to it I'd pay attention to aborted connections, as MySQL Network's monitoring service actually does do so I'm not sure what you mean by this. Could you clarify? With a log level of 2 here, you actually get to see aborted connections -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administrator problem
Ed Reed wrote: Unable to manage user accounts through MySQL Administrator 1.2.8. I've found that I'm not the only one with this problem but no one seems to have an answer for it. Have you reported a bug to bugs.mysql.com ? kind regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log Warnings Level
Kristen G. Thorson wrote: Hi! But all I really get from this reading is 0 turns it off, 1 prints some warnings, and 2 prints level 1 warnings plus aborted connections warnings. I have not been able to find any additional information in my search. Am I missing something, or is this all the documentation there is on this? What kind of additional information are you looking about the --W (or --log-warnings=N) option? I'd pay attention to aborted connections, as MySQL Network's monitoring service actually does do so kind regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld_safe failing
Nishant Gupta wrote: When i try to run mysqld_safe cmd, it fails saying : Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070105 20:23:40 mysqld ended Also mysqld.pid does not exist at the given path! It looks like the mysql server can't access /var/run/mysqld I suggest making sure the permissions are correct (using chown will fix it) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Please help*
VeeJay wrote: How and at What place, can I configure the Makefile under /usr/ports/databases/mysql50-server/ to have MySQL server working with above mentioned configurations? Why not just use MySQL that comes from ports? If you really want to build from source, read: http://dev.mysql.com/doc/refman/5.0/en/installing-source.html -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: yum version 5.*
Karl Larsen wrote: I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 of any other and find with Core 4 I can yum only mysql version 4. I imagine Core 5 might be able to yum mysql version 5 but not certain of that. Is there a way I can yum the later version? I studied the man for yum but could not see a way to do that. Fedora Core 4 doesn't include MySQL 5, which is why yum will not pick it up If you set yum to use a Fedora Core 5 repository, you can download MySQL 5 from there. You might also consider upgrading to Fedora Core 6, which is what is currently released -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Mobile: +614 12 593 292 / Skype: colincharles Web: http://www.bytebot.net/blog/ MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL MiniConf at linux.conf.au 2007 CfP
This is a call for participation in the second MySQL Miniconf which will be part of the linux.conf.au (LCA) 2007 conference in Sydney, Australia. The Miniconf will be run on Monday, January 15th, before the conference proper starts. This is the first conference of its type to be held in the Southern hemisphere and we are looking forward to participants from areas around Australia, New Zealand, South-East Asia, India and South America. Any topic is allowed based around MySQL. Types of presentations that we're after, include: Conference presentations (30 - 45 minutes) Tales of Deployment (10 - 30 minutes) - these are designed to show people how MySQL has been implemented in the real world, which will comprise of a mash-up of a case study and a discussion session. Please submit an abstract of your suggested presentation via email to [EMAIL PROTECTED] For all abstracts, the following information is required: Title of Presentation Description (no longer than 250 words) Targeted Audience Full Name Email Address URL of Home Page (if it should be listed in the program) Job Title (if it should be listed in the program) Company/Affiliation (if any) Postal Address Contact Telephone Number (for last minute issues, cell phone number preferred) Short Biography (1 or 2 paragraphs) Your proposal must be sent before the 30th November 2006 in order to be considered for inclusion in the conference. Please note that the MySQL Miniconf forms part of the LCA 2007 main conference held by Linux Australia. This means that you must register for LCA 2007 attendance to participate in the conference. For further details regarding registration and accommodation for LCA 2007, please visit LCA 2007. Speakers will be notified by 7th December 2007. -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Camp
Hi all, Please note that MySQL Camp will be happening soon in San Francisco, and its being hosted at the Google campus. Do pay it a visit if you're nearby http://mysqlcamp.org/ Check out the interesting topics! -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: installing mysql
jagdish gunjal wrote: i m upgrading mysql from 3.23 to 4.1.8. there was packge conflict for so many files like /etc/my.cnf Also i installed shared-compat for removing such problems. Is there any solution? Can you provide us with more about your environment? Also, have you read the 3-4 MySQL upgrade guide in our excellent documentation? best regards, -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How does the federated engine table work
wangxu wrote: How does the federated engine table work when the query statement include a join substatement, it joins a local table with innodb engine and a federated table. How does the server deal with the query substatement like this? Have you taken a gander at the documentation? http://dev.mysql.com/doc/refman/5.0/en/federated-description.html http://www.oreillynet.com/pub/a/databases/2006/08/10/mysql-federated-tables.html hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL App development
[EMAIL PROTECTED] wrote: Is there anything called MySQL application development environment guide, as it is there DB2 (IBM) which explains how to work with MySQL and C++ together? Can you show me what DB2 does that's different from our C++ API? Or can I refer DB2 App guide? No -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL+OpenVPN
Asif Lodhi wrote: Hi, Can anyone on this list tell me _how_ i can connect to my MySQL-5.0.22 server running on Windows-XP-SP2 using OpenVPN on Windows? It looks like a good VPN/SSL implementation. once you've got the VPN connection, just the usual: mysql -uUser -hHost -pPass How your VPN is setup is a completely other matter -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Drupal and MySQL
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? No, upgrading between versions should be OK. Want to provide the exact version numbers, in the /rare/ event that the ABI broke (which really shouldn't affect Drupal, unless PHP itself is to be blamed) -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 5.1
Logan, David (SST - Adelaide) wrote: Hi! Does anybody have any idea when 5.1 may come to General Release? I am particularly interested in MySQL Cluster as I have several databases (around 50) totalling 26Gb and would like to consider moving to this version because of the Cluster Disk Data Storage and the fact the current hardware doesn't have the RAM requirements to hold these databases. I expect late (Q4/2006) to early (Q1/2007) as a good time for release. I plan to store the data on a SAN and was wondering if anybody had any experience with this as yet? This is why you're after 5.1, so you get disk as opposed to memory only based storage then -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Support for JDBC 4.0?
Steven Buroff wrote: Does anyone know if there are plans to add support for JDBC 4.0 to the java connector? I'm particularly interested in support for the Connection.createQueryObject(Class cls) method. Its mostly already there in the trunk, and keep in mind that JDK-6 (w/JDBC-4) isn't even being released by Sun till late October. So, we expect to start shipping after Sun's sorted things out hope this helps -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Drupal and MySQL
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: On Thu, Aug 31, 2006 at 09:52:37AM +1000, Colin Charles wrote: Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: Has anyone heard of drupal breaking under a minor upgrade from Mysql 4.1.1X to 4.1.2X ? MySQL 4.1.18 to 4.1.21 And what problems are you facing? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles MySQL Forge: http://forge.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: measuring query time
Deniz Ersoz wrote: Is there a way to get the time spent in the server for each query? Write it in a log or append it to the result ??? Will what is in the slow query log help? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles Using MySQL for a FLOSS application? http://dev.mysql.com/doc/refman/5.0/en/mysql-floss-license-exception.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: /var/log/mysql.000001 Not Found?
David P. Donahue wrote: /usr/libexec/mysqld: File '/var/log/mysql.01' not found (Errcode: 13) [ERROR] Could not use /var/log/mysql for loggins (error 13). Turning logging off for the whole duration of the MySQL server process. [ERROR] Aborting If I touch the file, the error is for mysql.02, then mysql.03. What would be causing this, and how should I go about fixing it? Any help would be much appreciated, thanks. Running: perror 13 OS error code 13: Permission denied It would seem that /var/log/mysql.xxx isn't using the correct permissions For what its worth, you should be logging to /var/log/mysql/foo, and make sure that /var/log/mysql can be read/written to by the mysql server HTH -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles Using MySQL for a FLOSS application? http://dev.mysql.com/doc/refman/5.0/en/mysql-floss-license-exception.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error Messages
rb wrote: Hi! Does anyone know the cause of the following error message Ignoring query to other database When I log onto the mysql monitor and use any command I get this message. This is strange because last time I used my copy of mysql it worked just fine. I am using MAC OSX and I was wondering if the latest OSX update may have caused this issue. This is the only change on my machine. Or may be I have just forgotten how to log in properly. Your MySQL client is configured to only run queries for a certain database and ignore all others. Do check your command line options and the my.cnf config file Also, is this with MySQL 5.0.19? -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Mobile: +614 12 593 292 / Skype: colincharles Using MySQL for a FLOSS application? http://dev.mysql.com/doc/refman/5.0/en/mysql-floss-license-exception.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can MySQL jobs be posted to this list?
Beau Gould wrote: Thank you, Beau Gould The best place for this would probably be the Jobs forum located at http://forums.mysql.com/list.php?8 -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade advice
Jon Miller wrote: Jon, I'm currently running MySQL on RedHat 7.2 and now I'm in the processing of finishing testing a new server which has SUSE Linux Enterprise Server 9. My question is my database currently resides on RH7.2 and MySQL-server-4.0.13-0. I want to install the latest version on the SUSE system but I believe this to be Version: 4.0.18 Release: 32.20 (this is with Service Pack 3 from Novell). How do I do a backup of the existing and restore to the current? Are there any changes that may cause my apps to have a fit? Seeing that you're moving from 4.0.x to a 4.0.x, its highly unlikely that any of yours apps should have a fit. You might fancy reading: http://dev.mysql.com/doc/refman/5.0/en/disaster-prevention.html (our backup and recovery guide) If you fancy performing an upgrade to a newer version, do pay http://dev.mysql.com/doc/refman/4.1/en/upgrade.html a visit as well. Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to create database in different location
Chris Guo wrote: Chris, We are using mysql as backend database for one of the application in our company server, and there are too many data in the Mysql database. So I wonder how I create a database on different location. How do you define too much data in the MySQL database? Do you want to replicate? Or use clustering? More details are required. Kind regards -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: which release of Mysql is compatible with fedora core3 ?
ali asghar torabi parizy wrote: i have fedora core3 installed on my system. which release of Mysql is compatible with fedora core3 ? You should have no issue installing MySQL 5 from the download site, while using Fedora Core 3 - http://dev.mysql.com/downloads/. If however, you want to use the Fedora Project provided version, that caps of 3.23 (the RPM's available via yum) Hope this helps -- Colin Charles, Community Engineer MySQL AB, Kuala Lumpur, Malaysia, www.mysql.com Office: [EMAIL PROTECTED] / +46 18 174 400 ext. 4528 Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to installing mysql5 on fc3?
ali asghar torabi parizy wrote: hi all i want to install mysql5 on fc3 but i cant when i trying to implement it by rpm. i remove mysql3 with rpm -e directive. So, now when you do: rpm -qa |grep -i mysql You see nothing, right? who cabn help me?:( thanks rpm -ivh MySQL-server-5.0.15-0.i386.rpm error: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature: BAD, key ID 5072e1f5 error: MySQL-server-5.0.15-0.i386.rpm cannot be installed ** The error simply means that RPM has detected that your package is bad, in the sense that it has a signature that is inappropriate. If you want to check to see if its file corruption (say via a possibly bad download), do: rpm -K --nogpg MySQL-server-5.0.15-0.i386.rpm. If the response is md5 OK, all's well. Its most likely a bad download that a re-download can/will solve Best regards -- Colin Charles, Community Engineer MySQL AB, Melbourne, Australia, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]