Hebrew Characters
Hi Our host runs MySQL 4.1 and we have a number of datasets with Genealogical data in them. When a grave stone is translated to English often the meaning is lost or the translation is simply not accurate. So how easy or difficult would it be to actually hold the text in Hebrew purely for display purposes (dont think we need to search it etc) within the data set. Thoughts appreciated. Regards John Berman [EMAIL PROTECTED] -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.1 - Release Date: 27/01/2005
Data and strucuture importing from MSAccess to MySQL
Which way is easier to import data and structure of database from MSAccess to MySQL. I know that there is several commercial softvare tools, but is there some open source tool or other way in MySQL itself? -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Data and strucuture importing from MSAccess to MySQL
Suggest you download MYdbPAL from www.it-map.com . It is FREE, will do the complete import of structure and data for you (in next to no time) and you can carry on using it for modeling and database development. There is a great write-up this week at : http://blogs.ittoolbox.com/database/solutions/archives/002944.asp Tim Hayes -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: 29 January 2005 04:44 To: mysql@lists.mysql.com Subject: Data and strucuture importing from MSAccess to MySQL Which way is easier to import data and structure of database from MSAccess to MySQL. I know that there is several commercial softvare tools, but is there some open source tool or other way in MySQL itself? -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.2 - Release Date: 1/21/2005 -- 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]
build problem on solaris 8
Hi all, I got the following error during the configure phase: configure: WARNING: term.h: present but cannot be compiled configure: WARNING: term.h: check for missing prerequisite headers? configure: WARNING: term.h: see the Autoconf documentation configure: WARNING: term.h: section Present But Cannot Be Compiled configure: WARNING: term.h: proceeding with the preprocessor's result configure: WARNING: term.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## configure: WARNING: sys/ptem.h: present but cannot be compiled configure: WARNING: sys/ptem.h: check for missing prerequisite headers? configure: WARNING: sys/ptem.h: see the Autoconf documentation configure: WARNING: sys/ptem.h: section Present But Cannot Be Compiled configure: WARNING: sys/ptem.h: proceeding with the preprocessor's result configure: WARNING: sys/ptem.h: in the future, the compiler will take precedence configure: WARNING: ## -- ## configure: WARNING: ## Report this to the AC_PACKAGE_NAME lists. ## configure: WARNING: ## -- ## I was using gcc from sunfreeware to attempt the build. I'm doiong a source build as the binary from sunfreeware did not include libmysqlclient.10.so -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport --replace
I need to update a table with mysqlimport. I would like to update the table lines with the same unique key and mantain the other lines untouched. When I use mysqlimport --replace the table lines with the same unique key are updated but the others are deleted. Is it the expected behavior? How to avoid the other lines being deleted? Using FC3. The server version is 4.0.23-standard and the mysqlimport version is Ver 3.4 Distrib 4.0.23. The command line: /usr/local/bin/mysqlimport --replace --local --fields-terminated-by=';' --fields-optionally-enclosed-by='' --lines-terminated-by='\n' --fields-escaped-by='' --host=localhost --user=* --password=* --verbose dbname /path/to/txt/Temp.txt import.log 2importErr.log import.log: Connecting to localhost Selecting database dbname Loading data from LOCAL file: /path/to/txt/Temp.txt into Temp dbname.Temp: Records: 2415 Deleted: 0 Skipped: 0 Warnings: 0 Disconnecting from localhost importErr.log is empty. Table structure: CREATE TABLE Temp ( team int(10) unsigned NOT NULL default '0', points int(11) NOT NULL default '0', wus int(11) NOT NULL default '0', day date NOT NULL default '-00-00', PRIMARY KEY (team, day) ) TYPE=MyISAM; Regards, Clodoaldo Pinto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
libmysql10 missing for fedora core 3 x86_64
Hi All, We are using Fedora core 3 x86_64 with Intel Xeon EM64T. We have also installed MySQL-4.1 with Intel x86_64 RPMs form mysql.com and upgraded php to php-4.3.10-3.2 with RPM. The problem which we encountered then, is connecting mysql from php. From the archives we could trace that the solution is to 1) install php-mysql, 2) make changes in php.ini file and 3) restart httpd. Likewise, we downloaded php-mysql-4.3.10-3.2.x86_64.rpm, but we were unable to install, as file libmysql10 was missing. Unfortunatly, we couldn't find any such file for Fedora, whereas, we could find the same for mandrake (libmysql10-3.23.56-1.4mdk.x86_64.rpm) which after installation we could install php-mysql from the RPMs. Now we can connect mysql through php with out any hindrance. Could anyone tell me if there is any such file for Fedora core 3 x86_64. Moreover, MySQL for x86 release there is MySQL-shared-compat RPM to take care of all these dependencies which is missing in x86_64 RPMs. Regards, Soumyadeep __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump unusable, bugged?
On Thu, 27 Jan 2005, matt_lists wrote: Having repeatable problems doing restores, 4.1.8 and 4.1.9 both do the same error Is there some setting I'm missing? mysqldump -u username-pPassword --all-databases --quote-names /intranet/backup/backup.sql E:\intranet\backupmysql -u xotech -pDaredevil22 -f backup.sql ERROR at line 2153: Unknown command '\m'. ERROR at line 2153: Unknown command '\m'. ERROR at line 2153: Unknown command '\m'. mysql: Out of memory (Needed 626767192 bytes) mysql: Out of memory (Needed 626763096 bytes) E:\intranet\backup I've seen this quite a few times, but never been able to reproduce it properly. I'm assuming you're running on Windows, correct? I'd search your dump-file for DATA DIRECTORY the problem on Windows is that it uses \ instead of / in the path names there, which makes it use it as an escape character. Since dATA/INDEX DIRECTORY in CREATE TABLE is ignored on Windows when importing anyways, it's safe to remove those clauses. If you can find a way to reproduce it, feel free to add it to my old bug report about this at: http://bugs.mysql.com/bug.php?id=6660 cheers, -- Tobias Asplund [EMAIL PROTECTED] Trainer and Consultant, Sweden MySQL AB http://www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hebrew Characters
Hello. I think, that you should start with reading the appropriate pages of the manual: http://dev.mysql.com/doc/mysql/en/charset.htm [snip] Our host runs MySQL 4.1 and we have a number of datasets with Genealogical data in them. When a grave stone is translated to English often the meaning is lost or the translation is simply not accurate. So how easy or difficult would it be to actually hold the text in Hebrew purely for display purposes (don?t think we need to search it etc) within the data set. Thoughts appreciated.John Berman [EMAIL PROTECTED] wrote: [snip] -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlimport --replace
Please do not consider the previous email. I found my error. mysqlimport is behaving exactly as expected. Regards, Clodoaldo Pinto On Sat, 29 Jan 2005 15:53:48 -0200, Clodoaldo Pinto [EMAIL PROTECTED] wrote: I need to update a table with mysqlimport. I would like to update the table lines with the same unique key and mantain the other lines untouched. When I use mysqlimport --replace the table lines with the same unique key are updated but the others are deleted. Is it the expected behavior? How to avoid the other lines being deleted? Using FC3. The server version is 4.0.23-standard and the mysqlimport version is Ver 3.4 Distrib 4.0.23. The command line: /usr/local/bin/mysqlimport --replace --local --fields-terminated-by=';' --fields-optionally-enclosed-by='' --lines-terminated-by='\n' --fields-escaped-by='' --host=localhost --user=* --password=* --verbose dbname /path/to/txt/Temp.txt import.log 2importErr.log import.log: Connecting to localhost Selecting database dbname Loading data from LOCAL file: /path/to/txt/Temp.txt into Temp dbname.Temp: Records: 2415 Deleted: 0 Skipped: 0 Warnings: 0 Disconnecting from localhost importErr.log is empty. Table structure: CREATE TABLE Temp ( team int(10) unsigned NOT NULL default '0', points int(11) NOT NULL default '0', wus int(11) NOT NULL default '0', day date NOT NULL default '-00-00', PRIMARY KEY (team, day) ) TYPE=MyISAM; Regards, Clodoaldo Pinto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SuSE 9.2 Professional, Runlevel editor via telnet innodb
Greetings, I need help with a few things: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns chroot: No such file or directory Aborting mysqld -shutdown returns: Can't start server: Bind on TCP/IP port: Address already in use Do you already have another mysqld server running on port: 3306 Aborting mysqld: Shutdown Complete ps -aux shows mysqld is still active. It works if I shut it down via YaST and the runlevel editor. The manual says that innodb is enabled by default with 4.01 however that is not true in my case. mysql show variables like have_%; +--+---+ | Variable_name| Value | +--+---+ | have_bdb | NO| | have_crypt | YES | | have_innodb | NO| | have_isam| YES | | have_raid| NO| | have_symlink | YES | | have_openssl | NO| | have_query_cache | YES | +--+---+ 8 rows in set (0.00 sec) I am runing SuSE 9.2 Professional mysqld Ver 4.0.21 for suse-linux on i686 Any help appreiciated. Ed -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.7.5 - Release Date: 1/26/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SuSE 9.2 Professional, Runlevel editor via telnet innodb
Ed Patterson wrote: First I am looking for a way to shutdown and or restart MySQL via telnet. mysqld -restart returns You want `mysqladmin [command]` -- try `mysqladmin --help` for a quick list of available commands. HTH! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with query and password
Hello everbody,i have a problem with mysql and i wish you could help me. I have this table named users : +++--+--+---+-+- + | ID | user | pass | thegroup | firstname | surname | enabled | +++--+--+---+-+- + | 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr| Admin | 1 | | 2 | admin2 | *4ACFE3202A5FF5CF467 | 1 | Mr| Admin | 1 | +++--+--+---+-+- The password in both cases are : admin . When i do any of this querys : select * from users where pass=password(admin); select * from users where pass='admin'; select * from users where pass=password('admin'); i get an empty set, i dont know why. When i do : select password('admin') i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441 Please help me. Thanks -- lancer emotion 16 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with query and password
Lancer Emotion 16 wrote: I have this table named users : + | ID | user | pass | thegroup | firstname | surname | enabled +++--+--+---+-+- | 1 | Admin | *4ACFE3202A5FF5CF467 | 1 | Mr| Admin | 1 The password in both cases are : admin . When i do any of this querys : select * from users where pass=password(admin); that one should work, except... When i do : select password('admin') i get : *4ACFE3202A5FF5CF467898FC58AAB1D615029441 You wouldn't maybe guess that your pass field above is too small? :-) FWIW, -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connection latency reduction attempt for load balancing mysql slaves.
I'm experimenting with using ConnectorJ 3.1.7 to connect to MySQL slaves to handle load balancing queries. The environment would either include a hardware loadbalancer or round robin DNS (or static configuration). The main component though is having the JDBC driver continually reconnect (to actually balance the load) The major problem is that we run a LOT of small queries to generate our pages so per-query latency is very important. After benchmarking continual reconnect to my laptop running MySQL 4.1.9 and with our DB connection pool I'm noticing a 14x performance gap (with manual reconnects still loosing). Here are the results: // Total parse count: 1000 // Total duration: 3173 milliseconds // Total avg duration: 3.173 milliseconds // Total per second: 315.15915 // Testing method: test2 // // Total parse count: 1000 // Total duration: 217 milliseconds // Total avg duration: 0.217 milliseconds // Total per second: 4608.295 So with our DB pool each query only takes .217 ms but without it its taking 3.173 ms. This doesn't sound like much but if you multiply that by 1000x queries its significant and can seriously screw with total throughput. I've also tried removing any queries and JUST connection (without a SELECT 1) test and it still takes 2.8ms. Here's my JDBC connection string: jdbc:mysql://127.0.0.1/mysql?useUnicode=truecharacterEncoding=UTF-8useOldUTF8Behavior=trueholdResultsOpenOverStatementClose=truecacheServerConfiguration=trueelideSetAutoCommits=true I've also increase thread_cache_size on the server and Thread_created is a static value. This only had a slight performance advantage. Any ideas? Kevin -- Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat. Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html If you're interested in RSS, Weblogs, Social Networking, etc... then you should work for Rojo! If you recommend someone and we hire them you'll get a free iPod! Kevin A. Burton, Location - San Francisco, CA AIM/YIM - sfburtonator, Web - http://peerfear.org/ GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data and strucuture importing from MSAccess to MySQL
Paul: For database conversion, take a look @: [http://access2sql.sourceforge.net/] or [http://sourceforge.net/projects/dbconverter/] For database modeling and development, try: [http://www.fabforce.net/dbdesigner4/] and [http://www.gnome.org/projects/dia/] All of these are free utilities. Harsh Prakash On Sat, 29 Jan 2005 11:14:29 -0600, Tim Hayes [EMAIL PROTECTED] wrote: Suggest you download MYdbPAL from www.it-map.com . It is FREE, will do the complete import of structure and data for you (in next to no time) and you can carry on using it for modeling and database development. There is a great write-up this week at : http://blogs.ittoolbox.com/database/solutions/archives/002944.asp Tim Hayes -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: 29 January 2005 04:44 To: mysql@lists.mysql.com Subject: Data and strucuture importing from MSAccess to MySQL Which way is easier to import data and structure of database from MSAccess to MySQL. I know that there is several commercial softvare tools, but is there some open source tool or other way in MySQL itself? -- Sent via the WebMail system at regiononepdc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection latency reduction attempt for load balancing mysql slaves.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin A. Burton wrote: I'm experimenting with using ConnectorJ 3.1.7 to connect to MySQL slaves to handle load balancing queries. The environment would either include a hardware loadbalancer or round robin DNS (or static configuration). The main component though is having the JDBC driver continually reconnect (to actually balance the load) The major problem is that we run a LOT of small queries to generate our pages so per-query latency is very important. [snip] So with our DB pool each query only takes .217 ms but without it its taking 3.173 ms. This doesn't sound like much but if you multiply that by 1000x queries its significant and can seriously screw with total throughput. I've also tried removing any queries and JUST connection (without a SELECT 1) test and it still takes 2.8ms. Here's my JDBC connection string: jdbc:mysql://127.0.0.1/mysql?useUnicode=truecharacterEncoding=UTF-8useOldUTF8Behavior=trueholdResultsOpenOverStatementClose=truecacheServerConfiguration=trueelideSetAutoCommits=true I've also increase thread_cache_size on the server and Thread_created is a static value. This only had a slight performance advantage. Any ideas? Kevin Kevin, You're caching just about everything that can be cached on the client side, so the client side is as fast as it's ever going to get. Since you're caching the server configuration as well as not sending auto-commits when they're not needed, the only thing that's happening is TCP/IP connection setup, followed by the MySQL authentication protocol (unless you're calling setTransactionIsolation() or other session-level stuff before you issue queries). You might consider running a connection pool, but with _really_short_ lifetimes (on the order of a few seconds/few 10 seconds), which would spread the TCP/IP establishment/authentication overhead out over a few of your 'transactions', but still allow load balancing at a slightly less granular level than 'single-shot' connections, or use a ThreadLocal and hold the same connection for the duration of your pageview. A simple benchmark I just threw together is telling me that you're probably going to use up .5-.7ms just to setup a vanilla TCP/IP connection over 100mbit (localhost was actually _slower_ on my development machine, even to a generic ServerSocket instance), so I'm not sure you're never going to see anything faster if you always create a new connection. The only other obvious thing I can think of since you're using short-lived connections is to make sure you've not running reverse-DNS lookups inside the MySQL server (--skip-name-resolve), although that's usually one of the first things a really high-volume installation does. Hopefully someone from the non-Java camp where they're used to dealing with short lived connections will have some more pointers for you. -Mark - -- Mark Matthews MySQL AB, Software Development Manager - Client Connectivity Office: +1 408 213 6557 www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB/EcHtvXNTca6JD8RAi3jAJ9NmX3NuzmDMI9nWDEeWtWYAZs0IACeJgGW 1zZjrtA1eq0YIJWYtfp2sN8= =nrh8 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
age of last checkpoint / log group capacity
Hi, I'm running a conditional delete against a large table. Every 20 seconds or so, an error message gets written to the logfile: 050129 19:32:26 InnoDB: ERROR: the age of the last checkpoint is 1334658464, InnoDB: which exceeds the log group capacity 483180135. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB: largest such row. The age of checkpoint keeps going up. The combined size of ib_logfile1 and ib_logfile0 is 512M, if this is what the error message is referring to, and it's certainly more than 10 times bigger than any row. How serious is this? Why is it happening? Thanks, Sergei
Re: FULLTEXT index on InnoDB tables (looking for a workaround)
At 02:32 PM 1/28/2005, you wrote: And, of course, another option is to contact Heikki and coax him into hiring somebody to add FULLTEXT to InnoDB tables. And bring lots of cash with you. :-) I've pestered Heikki a couple of years ago and he's willing to do it only if there is someone willing to fund it. So far it doesn't look like there have been any takers. If I win the lottery, this is going to be in my top 10 list. g Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]