Arabic text storing problem
i have one problem with Arabic text. I have created database with charaterset utf8. when i insatal sql file all the content which is arabic that content stored as arabic. but when i retrieve this content it is display something like ASCII value(ÙعاÙÙSØ© ادارة اÙÙ^Ù,ت). one more thing that when i edit any fields with arabic text. it is storing the text like (??), but when i retrieve it display proper rabic text. my table structure like that CREATE TABLE `mdl_jobs` ( `id` int(11) NOT NULL auto_increment, `company` varchar(200) collate utf8_unicode_ci default NULL, `position` varchar(200) collate utf8_unicode_ci default NULL, `location` varchar(100) collate utf8_unicode_ci default NULL, `emp_status` tinyint(1) default '1', `qualification` varchar(200) collate utf8_unicode_ci default NULL, `descr` text collate utf8_unicode_ci, `posteddate` bigint(10) unsigned default NULL, `expdate` bigint(10) unsigned default NULL, `status` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ; -- -- Dumping data for table `mdl_jobs` -- Please help me...
Problem connection to mysql
Hi, I am facing problem conneting to mysql from client machine. I have MySQL server running on dummy2 machine and programs running on other client machine. when I check netstat -a , I get following tcp sockets in TIME_WAIT and ther are few in ESTABLISHED Any one has idea about , why the socket connection remains in TIME_WAIT. and how to solve this problem. Regards, Bharat Below is sample of netstat -a Actual connetions : 12425 TIME_WAIT 93 ESTABLISHED tcp0 0 dummy2.ezee:mysql dummy77.ezee:3262 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3261 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3260 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3259 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3258 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3257 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3256 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3255 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy77.ezee:3254 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2302 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2298 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2296 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2295 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2290 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy50.ezee:4741 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2283 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2281 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2277 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2274 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2271 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy101.ezee:2270 TIME_WAIT tcp0 0 dummy2.ezee:mysql dummy50.ezee:4735 TIME_WAIT - 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
Re: Starting Server
Hi Chris, I suppose that gumby , is your machine name . It seems from the messages that /usr/local/var does not permits mysql daemon to create file. you can chnage mode to 777 to the directory, and for host.frm , you have to run /usr/local/mysql/scripts/mysql_install_db which will create mysql database which has all these tables. Regards, Bharat Chris wrote: Greetings: I recently upgraded my MySQL server on a Linux box. When I try to start the server, it says started, then immediately it stops. The log file gumby.err reports: -- 020206 14:38:35 mysqld started /usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13) 020206 14:38:36 Could not use gumby-bin for logging (error 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't create/write to file '/usr/loc al/var/gumby.pid' (Errcode: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/g umby.pid' (Errcode: 13) 020206 14:38:36 mysqld ended --- Anyone have any ideas on how I should troubleshoot? Thanks Chris Mulcahy __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com - 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 - 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
Problem: mysqld restarts automatically
Hi, I have install mysql-RPM 3.23.38 on red hat linux 6.2 machine, which was running properly for more than 3 months . recently , It started restarting after every 30 min. I am trying to find the problem but, error file shows stack trace which I could not understand. I have upgraded mysql version to the latest one 2.23.47, thinking that might solve the problem. Does any one know the reason why this is happens? please reply immediately. Regards, Bharat - 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
How to upgrade mysql version on linux
hi we are using two different servers for our operation. unfortunately they have installed two different version of mysql. on one server we are using 3.22.32 ( mysqldump 7.1 ) on another server we are using 3.23.23 ( mysqldump 8.8 ) i want to know how to update the two versions to the present latest versions. this is why because i wnat transfer the database to only one server. i tried with mysqldump option,but when i try to install to get inot another server. i is dumping. i think due to version problem. if any one has solution, let me know. Regards and thanks. Bharat Kumar, SurgoSystems (Singapore) Pte Ltd. - 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