Mysql 4.0 Adding fields to large tables
Hello all, I am trying to add a field to a very large table. The problem is that mysql locks up when trying to do so. I even tried deleting the foreign keys on the table and it wont even let me do that, again locking up. It works for around 5 minutes or so then just either locks or the database dies and I have to restart it. Any ideas how to do this? Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character encoding problem STILL
Hey all, So I decided to start fresh on a test machine just to see if I could get french characters working. These are my steps: Freshly Installed Mysql 5.0.45 Configure the MySql Server now Detailed Configuration Developer Machine Multifunctional Database Online Transaction Processing Enable TCP/IP Networking and Enable Strinct Mode Best Support for Multilingualism Install as Windows Service Created a DB CREATE DATABASE testdb CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; Created a table: CREATE TABLE `testtable` ( `id` INTEGER(11) NOT NULL, `textfield` mediumtext, PRIMARY KEY (`id`))TYPE=InnoDB CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'; SHOW VARIABLES LIKE 'char%' produced all utf8 Trying INSERT INTO `testtable` VALUES (1,'é û ê à è'); produced incorrect string value DID: SET NAMES utf8; SET CHARACTER SET utf8; Trying INSERT INTO `testtable` VALUES (1,'é û ê à è'); produced incorrect string value Replaced: sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION with: sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION in the my.ini file restarted mysql Tried INSERT INTO `testtable` VALUES (1,'é û ê à è'); and was accepted Select returned nothing in the textfield field Tried SET NAMES utf8; SET CHARACTER SET utf8; INSERT INTO `testtable` VALUES (1,'é û ê à è'); again select returned nothing in the texfield field. Can someone PLEASE explain as to what I am doing wrong and why I cannot get french characters working in mysql 5?? Thanks --James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Character encoding problem
Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still show all screwed up.. I have read the manual regarding all the variables and have placed all I can in the my.ini etc. Can someone who has it working post the relevant info from their ini file along with any help for other setting we need to change? It would be GREATLY appreciated. --James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character encoding problem
Hello, Thanks for the info, For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to that I beleive. Is there a way to dump it to utf8? --James - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 4:23 PM Subject: Re: Character encoding problem James Sherwood wrote: Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still show all screwed up.. I have read the manual regarding all the variables and have placed all I can in the my.ini etc. Can someone who has it working post the relevant info from their ini file along with any help for other setting we need to change? Are you referring to data that is inserted via the client? If so, make sure to issue the following upon connecting: SET NAMES utf8; SET CHARACTER SET utf8; Was this dumped from the version 4.x DB? Are you sure that it really is UTF-8? If this is a web app, do you see any difference betwen the browser and a terminal? If you're looking at it through a browser, ensure that the correct character set header is sent out. brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character encoding problem
Hello, After I dump the database in and change everything to utf8(or if I try to dump and make them all utf8 on the dump) I get an incorrect string value error when trying to put french characters in. Any ideas?. --James - Original Message - From: James Sherwood [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 6:16 PM Subject: Re: Character encoding problem Hello, Thanks for the info, For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to that I beleive. Is there a way to dump it to utf8? --James - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 4:23 PM Subject: Re: Character encoding problem James Sherwood wrote: Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still show all screwed up.. I have read the manual regarding all the variables and have placed all I can in the my.ini etc. Can someone who has it working post the relevant info from their ini file along with any help for other setting we need to change? Are you referring to data that is inserted via the client? If so, make sure to issue the following upon connecting: SET NAMES utf8; SET CHARACTER SET utf8; Was this dumped from the version 4.x DB? Are you sure that it really is UTF-8? If this is a web app, do you see any difference betwen the browser and a terminal? If you're looking at it through a browser, ensure that the correct character set header is sent out. brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Character encoding problem
Hello, I too strict mode off on advice of a post in a forum. It allowed me to enter the items but they do not go in.. I am using EMS mysql manager sql editor to do it. This is my variables: Variable_name Value character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server utf8 character_set_system utf8 character_sets_dir C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ The SHOW FULL COLUMNS FROM `newsletter`; says the colums are utf8 and the table is utf8 When I do this statement it basically makes the field blank: SET NAMES utf8; SET CHARACTER SET utf8; update `newsletter` set `newsletter`.`story` = é û ê à èé û ê à èé û ê à è where `newsletter`.`news_id` = 35; Can anyone shed some light on what I am doing wrong? --James - Original Message - From: James Sherwood [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 7:37 PM Subject: Re: Character encoding problem Hello, After I dump the database in and change everything to utf8(or if I try to dump and make them all utf8 on the dump) I get an incorrect string value error when trying to put french characters in. Any ideas?. --James - Original Message - From: James Sherwood [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 6:16 PM Subject: Re: Character encoding problem Hello, Thanks for the info, For the dump, I would imagine that it is latin1 as mysql 4.x is defaulted to that I beleive. Is there a way to dump it to utf8? --James - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, November 07, 2007 4:23 PM Subject: Re: Character encoding problem James Sherwood wrote: Hello, We are trying to upgrade from 4.0 to 5 and we are not having any luck on the character sets. We need to use French characters for some things. We have tried setting utf8 for everything we can find but the characters still show all screwed up.. I have read the manual regarding all the variables and have placed all I can in the my.ini etc. Can someone who has it working post the relevant info from their ini file along with any help for other setting we need to change? Are you referring to data that is inserted via the client? If so, make sure to issue the following upon connecting: SET NAMES utf8; SET CHARACTER SET utf8; Was this dumped from the version 4.x DB? Are you sure that it really is UTF-8? If this is a web app, do you see any difference betwen the browser and a terminal? If you're looking at it through a browser, ensure that the correct character set header is sent out. brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2644 (20071107) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
php and utf8 problem
Hello, I am trying to install php nuke and I get this error: File 'c:\mysql\share\charsets\?.conf' not found (Errcode: 2) Character set '#33' is not a compiled character set and is not specified in the 'c:\mysql\share\charsets\Index' file I have researched it and nothing ive tried works. Any ideas? Thanks, James
ON DELETE CASCADE question
Hello. I have a question about on delete cascade. If i have 2 tables such as this: Table1Table2 PrikeyPrikey Table2foreinkey name name description description Now if I delete a row from table1 that has a foreign key from table 2 should it delete the row in table 2? Thanks, James
Weird error when creating a field
Hello, Today we tried to create a new field on a table in one of our databases. When we tried to save the field we get the error: Error on rename of ./DBNAME/TABLENAME.MYI to ./DBNAME/#SQL2-210-174.MYI (Errorcode: 13) Has anyone ever seen this before? Thanks, James
Re: Weird error when creating a field
Thanks for the info, Not sure how this came about as it has been working fine and it is on a windows system and using the root user. Any ideas would be much appreciated, Thanks, James - Original Message - From: Dan Buettner [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysqllist mysql@lists.mysql.com Sent: Monday, June 19, 2006 11:56 AM Subject: Re: Weird error when creating a field James, that is a permission denied OS error. When you run an alter table command (adding a field) MySQL builds a new table alongside the old, then swaps them. Some file move/rename perations are associated with that. I would check that the mysql user on your system has full privileges on the data and database directories and database files. Dan James Sherwood wrote: Hello, Today we tried to create a new field on a table in one of our databases. When we tried to save the field we get the error: Error on rename of ./DBNAME/TABLENAME.MYI to ./DBNAME/#SQL2-210-174.MYI (Errorcode: 13) Has anyone ever seen this before? Thanks, James __ NOD32 1.1607 (20060619) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql 4.0 cpu usage
I have solved this problem, I was missing a slash in the path to the data directory Thanks, James - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, October 26, 2005 4:41 AM Subject: Re: Mysql 4.0 cpu usage Hello. Are you able to connect to the server and found the states of its threads with SHOW PROCESSLIST statement? Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have tried to revert back to 4.0. I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the service it uses a constant 25%cpu and seems locked up. I cannot even stop the service I have to end the process in the task manager. Any ideas? James Sherwood wrote: -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1406
I have since uninstalled 5.0 and installed 4.0 I have found that 4.1 and 5.0 have a VERY hard time with french characters and there are MANY problems assosiated with french characters. The problem with this one seemed to be when the dump would get put back in, it would throw this error on all the french characters in the dump file. I looked in the file at the spot it was throwing the error and there was a french character, I deleted it from the dump file and it would throw the error at the next one. The server was installed with Utf8 so that is not the issue and the server from before dumped was utf8 as well. James - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, October 26, 2005 3:25 AM Subject: Re: Error 1406 Hello. I also tried modifying the mediumtext to longtext in the dumpfile but it produces a column with a -1 size for some reason. Please, could you provide a snip from your dump file. When I try to input it back into the new 5.0 database, it gives me this error (1406 data too long for column) Check your sql_mode system variable, if you have there STRICT_ALL_TABLES or STRICT_TRANS_TABLES values. Due to this all warnings are converted to errors and import fails. In 4.0 you might have the same problems, but server just doesn't produce warnings, and you don't know what's going on. James Sherwood [EMAIL PROTECTED] wrote: ello, I dumped a database from our 4.0 server to a .sql file. When I try to input it back into the new 5.0 database, it gives me this error (1406 data too long for column) This works fine on 4.0 but will not work on 5.0. I also tried modifying the mediumtext to longtext in the dumpfile but it produces a column with a -1 size for some reason. Any ideas? Thanks, James -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 150 when inputing a dump
Hello, I dumped a database from our 4.0 server to a .sql file. When I try to input it back into the new 5.0 database, it gives me this error which I beleive is a foreign key constraint error. Normally I just put FOREIGN_KEY_CHECKS=0; and that solves it but it doesnt accept that line in 5.0 Any help would be appreciated, James
Re: Error 150 when inputing a dump
SOLVED, sorry for the message. It was a different error, will post on it shortly James - Original Message - From: James Sherwood [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, October 25, 2005 1:39 PM Subject: Error 150 when inputing a dump Hello, I dumped a database from our 4.0 server to a .sql file. When I try to input it back into the new 5.0 database, it gives me this error which I beleive is a foreign key constraint error. Normally I just put FOREIGN_KEY_CHECKS=0; and that solves it but it doesnt accept that line in 5.0 Any help would be appreciated, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1406
Hello, I dumped a database from our 4.0 server to a .sql file. When I try to input it back into the new 5.0 database, it gives me this error (1406 data too long for column) This works fine on 4.0 but will not work on 5.0. I also tried modifying the mediumtext to longtext in the dumpfile but it produces a column with a -1 size for some reason. Any ideas? Thanks, James
Mysql 4.0 cpu usage
Hello, Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have tried to revert back to 4.0. I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run the service it uses a constant 25%cpu and seems locked up. I cannot even stop the service I have to end the process in the task manager. Any ideas? Thanks, James
Re: French Characters, Still no answer
Sorry, dont know how I missed: http://lists.mysql.com/mysql/187794 The old msql was 4.0 and the new one is 4.1. When we first imported the data the database was in latin1(my mistake) and we put it into production as everything seemed to work fine. We have one site that uses french characters sometimes and they compained 1 week later. By that time it was too late to roll back so now we have this problem. We tried converting the database over to Utf8 but it did not seem to fully work. We can put the french characters in, even from the tomcat server, but when they come back out to the webpage(we have a content management system) they are garbled. One night we did some testing and hooked the tomcat to the old database and everything worked fine with french characters so it has to be the new database. If no one has anymore ideas I think our best route is to dump it, install 4.0 on this server and import it back in. Everything looks ok as far as Utf8 on the tables and such, I feel that we are just missing one key thing that is garbling the characters. Also when we use EMS mysqlmanager to view the data, it is fine, it is only when it comes back to the tomcat server it seems. Thanks for your ideas thus far, James - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, August 15, 2005 1:41 PM Subject: Re: French Characters, Still no answer Hello. You've already got a good answer: http://lists.mysql.com/mysql/187794 Subscribe to mysql list or use web interface. Why are you mixing latin1 with utf8 in the same column? You can check if something is wrong with your connection variables using the following statement: show variables like '%char%'; Use mysql command line client or mysql-query-browser (or other client software which correctly handles UTF8 data) to check if import of your data was performed successfully. In such a way you can localize the problem, and find whether it is related to Tomcat or wrong data in MySQL. I am still having trouble with french characters if anyone has ANY ideas, please help. We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is Utf8 but some fields are like this: 'Story' longtext character set latin1 NOT NULL We tried linking our tomcat to the old database on the other server through this tomcat and everything works fine but when we link the tomcat back to the new database, it will not play nice with french characters. (they come out as outlined squares etc) Any ideas would be greatly appreciated James James Sherwood [EMAIL PROTECTED] wrote: -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French Characters, Still no answer
Hello, I dont think we want to go this route as it was working fine on the 4.0 database on the other server. I also might add that the old server was linux, and the new one is Windows 2000 Server Thanks, James - Original Message - From: Ace Dimitrievski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 6:38 PM Subject: Re: French Characters, Still no answer Im not sure if my experience will be of any help but here it is: I used a database with utf8 as default charset (you can easily set this with mysql administrator) and the columns that I needed to store Macedonian cyrilic characters were varchar. Some letters were stored as ?. When I changed the column type to varbinary I was able to store/retreive all the letters properly. However if you change the type of the columns you cannot use the mysql adminisators backup sql queries to restore a database that contains utf8 characters (at least I failed). Using a PHP script will help. For those that use mySQL with some script language using base64 encoding/decoding funtions for non latin1 letters is the safest way (however you cannot strictly predict the lenght of the encoded string based on the lenght of the plaintext). best regards --- Ace Dimitrievski, research assistant, Faculty of Electrical Engineering Skopje --- [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: The older version is 4.xx.xx im not sure how to tell. New version is 4.1.12 Thank you, James - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 2:50 PM Subject: Re: French Characters, Still no answer Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: I am still having trouble with french characters if anyone has ANY ideas, please help. We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is Utf8 but some fields are like this: 'Story' longtext character set latin1 NOT NULL We tried linking our tomcat to the old database on the other server through this tomcat and everything works fine but when we link the tomcat back to the new database, it will not play nice with french characters. (they come out as outlined squares etc) Any ideas would be greatly appreciated James -- 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] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- 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: French Characters, Still no answer
I think I have found the problem: Doing Select @@character_set_database , results, client and connection it all returns latin1 I tried set character_set_x = utf8; for them all but it did not work, they stayed latin1 and need to be utf8 Any ideas how to change this? Thanks, James - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 16, 2005 11:16 AM Subject: Re: French Characters, Still no answer Hello. Also when we use EMS mysqlmanager to view the data, it is fine, it is only when it comes back to the tomcat server it seems. That means that data on the server is ok. Check the values of your character_set_client, character_set_connection and character_set_results variables from Tomcat's application. See: http://dev.mysql.com/doc/mysql/en/charset-connection.html If no one has anymore ideas I think our best route is to dump it, install 4.0 on this server and import it back in. Perform an import so that all fields in your table have an utf8 character set. And tune properly the connection variables. James Sherwood [EMAIL PROTECTED] wrote: Sorry, dont know how I missed: http://lists.mysql.com/mysql/187794 The old msql was 4.0 and the new one is 4.1. When we first imported the data the database was in latin1(my mistake) and we put it into production as everything seemed to work fine. We have one site that uses french characters sometimes and they compained 1 week later. By that time it was too late to roll back so now we have this problem. We tried converting the database over to Utf8 but it did not seem to fully work. We can put the french characters in, even from the tomcat server, but when they come back out to the webpage(we have a content management system) they are garbled. One night we did some testing and hooked the tomcat to the old database and everything worked fine with french characters so it has to be the new database. If no one has anymore ideas I think our best route is to dump it, install 4.0 on this server and import it back in. Everything looks ok as far as Utf8 on the tables and such, I feel that we are just missing one key thing that is garbling the characters. Also when we use EMS mysqlmanager to view the data, it is fine, it is only when it comes back to the tomcat server it seems. Thanks for your ideas thus far, James -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: French Characters, Still no answer
We are using 3.0.9 and the latest is 3.1.10 But we connect to the old 4.0 database fine, would the connector matter? James - Original Message - From: Jason Pyeron [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 16, 2005 1:59 PM Subject: Re: French Characters, Still no answer On Tue, 16 Aug 2005, James Sherwood wrote: I think I have found the problem: Doing Select @@character_set_database , results, client and connection it all returns latin1 I tried set character_set_x = utf8; for them all but it did not work, they stayed latin1 and need to be utf8 Any ideas how to change this? Which version of the Conenctor J are you using?, is it the latest? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- 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]
French Characters, Still no answer
I am still having trouble with french characters if anyone has ANY ideas, please help. We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is Utf8 but some fields are like this: 'Story' longtext character set latin1 NOT NULL We tried linking our tomcat to the old database on the other server through this tomcat and everything works fine but when we link the tomcat back to the new database, it will not play nice with french characters. (they come out as outlined squares etc) Any ideas would be greatly appreciated James
Re: French Characters, Still no answer
The older version is 4.xx.xx im not sure how to tell. New version is 4.1.12 Thank you, James - Original Message - From: Bruce Dembecki [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, August 15, 2005 2:50 PM Subject: Re: French Characters, Still no answer Still no answer, perhaps, but ther'es still no question. Per my earlier response... What version of MySQL is the old version you refer to, what version is the new version you refer to? With that information someone here is more likely to be able to tell you something useful... without that you're not likely to get much of a response. Best Regards, Bruce On Aug 15, 2005, at 7:59 AM, James Sherwood wrote: I am still having trouble with french characters if anyone has ANY ideas, please help. We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is Utf8 but some fields are like this: 'Story' longtext character set latin1 NOT NULL We tried linking our tomcat to the old database on the other server through this tomcat and everything works fine but when we link the tomcat back to the new database, it will not play nice with french characters. (they come out as outlined squares etc) Any ideas would be greatly appreciated James -- 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]
Character Set Question
Hello, We have installed the newest version of MySql and cannot get it to play nice with French characters. Our older version worked fine. The problem may (or may not) be that when we put the dump into the new database(yes its default charset is Utf8) the default character set for the table is Utf8 but some fields are like this: 'Story' longtext character set latin1 NOT NULL We tried linking our tomcat to the old database on the other server through this tomcat and everything works fine but when we link the tomcat back to the new database, it will not play nice with french characters. (they come out as outlined squares etc) Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
max_connections
Hello, I have a problem with a database mask I use named torque. I get an error Cannot get connection from pool I beleive it is from the max_connections reaching their limit. I put the line max_connections=200 in the my.cnf file but when I check the show variables of the database through EMS mysqlmanager it says 100. I restarted the server etc. Any ideas as to why the max is not going to 200 in the variables list? Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_connections
This error is thrown in a mask we use called Torque, it does the connection pooling but we have never had a problem with it such as this until now. James - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, June 07, 2005 1:23 PM Subject: RE: max_connections Where are you getting this error from? Sounds like something on top of mysql that is doing the connection pooling perhaps. -Original Message- From: James Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 12:28 PM To: mysql@lists.mysql.com Subject: max_connections Hello, I have a problem with a database mask I use named torque. I get an error Cannot get connection from pool I beleive it is from the max_connections reaching their limit. I put the line max_connections=200 in the my.cnf file but when I check the show variables of the database through EMS mysqlmanager it says 100. I restarted the server etc. Any ideas as to why the max is not going to 200 in the variables list? Thanks, James -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_connections
Yes, we have been looking into that as well, the problem is is that some changes we have made seemed to have helped and it takes 12hours or so for the error to occur, making it a slow process:) James - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, June 07, 2005 1:55 PM Subject: RE: max_connections I would then gather to say that the limit (hence the error) is being generate by Torque, which does the connection pooling, and has nothing to do directly with max_conn. Is there a config file or something that you can look for in torque? -Original Message- From: James Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 12:51 PM To: mysql@lists.mysql.com Subject: Re: max_connections This error is thrown in a mask we use called Torque, it does the connection pooling but we have never had a problem with it such as this until now. James - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, June 07, 2005 1:23 PM Subject: RE: max_connections Where are you getting this error from? Sounds like something on top of mysql that is doing the connection pooling perhaps. -Original Message- From: James Sherwood [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 07, 2005 12:28 PM To: mysql@lists.mysql.com Subject: max_connections Hello, I have a problem with a database mask I use named torque. I get an error Cannot get connection from pool I beleive it is from the max_connections reaching their limit. I put the line max_connections=200 in the my.cnf file but when I check the show variables of the database through EMS mysqlmanager it says 100. I restarted the server etc. Any ideas as to why the max is not going to 200 in the variables list? Thanks, James -- 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] -- 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: Cannot complete database transfer
It seems like the database installed fine(it is up and running, but I use a manager from a windows box to manipulate it) but maybe the client messed up on install? If so is there a way to just install the mysql client? James - Original Message - From: Jason McKnight [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:07 AM Subject: Re: Cannot complete database transfer I keep getting 'command not found'. This error indicates that your shell cannot find the mysql file to execute (or that it is not executable for some reason... bad permissions). This can be caused by mysql (client) not being installed or by the client not being on a path that your user can see. more below... Victor Pendleton wrote: Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d The mysql in init.d is a control script that starts and stops the daemon. It is not the mysql client program and mysql mysqld. vi (or whatever your text editor preference may be) the script and look at it. You can find your bin dir somewhere in this file. Once you find it you can see if mysql is in there. I have root access try su - instead of su if that is what you are using for root access. I keep getting 'command not found'. Any ideas would be greatly appreciated James hth, -- Jason McKnight Mgr. Information Services The InSite Group,LLC -- 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: Cannot complete database transfer
Yes, there are other databases on that mysql installation. The only thing is, I recently upgraded it to the latest release of mysql. James - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: James Sherwood [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 10:47 AM Subject: Re: Cannot complete database transfer Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot complete database transfer
I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a mysqldump and it worked fine. On the other I created the database using a manager and tried the 'mysql username password database filename.sql' command The problem is, I cannot seem to get the box to see the mysql. I found it in init.d I have root access I keep getting 'command not found'. Any ideas would be greatly appreciated James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Starting mysql as a service once installed
Hello, I have installed mysql but did not install it as a service. All I do is runmysqld-max-nt.exe Now I need it to run as a service. It is on a win2003 machine. Can I make it run as a service once I already have it installed. I cannot lose data and do not want to do a mysqldump, uninstall and reinstall as this would bring the server down for too long. Is there a way to make it start running as a service? Thanks in advance James