Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I should have added what I was using to do the transfer. I am using phpmyadmin to do a dump to a gzipped file and then I am importing. Thanks for the info. -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12:29 PM To: Lehman, Jason (Registrar's Office) Cc: [EMAIL PROTECTED] Subject: Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18 On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. I suspect you are using MySQL version 4 or later? I'm not sure how/what you are using to extract the data and display it on a web page but we had a similar problem after we upgraded from MySQL 3.23.18 to 4.0.18 and our experiences may be of some help to you. We use Macromedia Cold Fusion MX 6.1 with apache on Linux - as Cold Fusion is an ODBC-oriented environment, they supply the Merant ODBC driver for MySQL to connect the two. After the upgrade, things like the UK pound symbol and apostrophes in text fields were being displayed as black squares or '?' on a web page even though they appeared correctly if viewed with the mysql command-line client. After a lot of investigation I eventually found that I had to add a parameter like: useUnicode=truecharacterEncoding=Windows-1252 to the ODBC/MySQL driver which solved the problem. It sounds to me as if you have a similar problem in your environment although the fix in your case will be different. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Website
I should have been clearer. I can't reach the website. I can get to lists.mysql.com with no problem except for the fact that images won't pull form www.mysql.com but I definitely come to a grinding halt when I try to reach www.mysql.com. I can't do a tracert because the university has shut that off here. But I guess it is working for everyone else. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 6:31 PM To: Lehman, Jason (Registrar's Office) Subject: Re: MySQL Website - Original Message - From: Lehman, Jason (Registrar's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 11:53 AM Subject: MySQL Website Does anyone know what is going on with the MySQL website? It appears to be undergoing a major redesign. The sections appear to be organized differently and the style sheets have also changed. Or did you have something else in mind? Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Website
Does anyone know what is going on with the MySQL website? Jason Lehman Webmaster, Registrar's Office (813)974-4157 Phone 574-4157 Suncom (813)974-5271 FAX [EMAIL PROTECTED] Email -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql -u is not working for me today but was yesterday
I have read the documentation and I understand the grant and revoke but mysql -u is just not working for me. Yesterday I was able to do a mysql -u root and it would ask me for my password and I would enter the one that I created for root in my grant statement and it would let me in. But any other user that I had created and try to use with mysql -u username would just let me in and not prompt me for a password. Today no matter what mysql -u username I put in it lets me slide thru. Now if I add the -p it prompts me for my password but even when I put in the correct passwords I get errors even for the root. But if I login to linux with my root username and password then go to mysql it allows me to do root mysql admin. So I must have done something but I don't know what I have done. Any help would be appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
