Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8
hello, I have mysql-4.1.8 compiled form source working on RH7.2. I have tried to backup my database with mysqldump. > mysqldump --opt database_name > database_name.sql > mysqldump --lock-tables database_name > database_name.sql > mysqldump --skip-opt --lock-tables database_name > database_name.sql > mysqldump --lock-all-tables database_name > database_name.sql Unfortunately options --lock-tables, --lock-all-tables do not work. Only --add-locks works (alone or as part of --opt) but it can cause some inconsistencies because it locks tables individually. How to lock all tables at once? I would appreciate any help. Best regards Slawomir Orlowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
after upgrade from mysql 4.1.5 to 4.1.8 polish fonts dissapear
Hello everybody, I used to have mysql-4.1.5 (gamma version) on Linux RH7.2. I compiled it from source with gcc 2.96-98: shell> ./configure --with-charset=latin2 next I compiled and installed DBI-1.43 and DBD-mysql-2.9004, I have perl 5.8.5 in my perl cgi script I have: print "Content-type: text/html; charset=iso-8859-2\n\n"; Everything was working I coud see polish fonts on my web pages and could save through html FORM-s to the mysql database. Everything worked just fine. But because mysql crased one day I decided to upgrade to mysql-standard-4.1.8 (binnary distribution) (I had to recompile and install (DBI-1.46 and DBD-mysql-2.9004) too. Unfortunately polish fonts disappear, After I have set up latin2 charset: mysql> show variables like "char%"; character_set_client = latin2; character_set_connection = latin2; character_set_database = latin2; character_set_results = latin2; character_set_server = latin2; character_set_system = utf8; I could see in mysql (Select * from tablename) polish fonts, but they are not visible in my perl cgi web pages. I do not know what to do, do I have to recompile mysql from source with shell> ./configure --with-charset=latin2 to have them working again? Or there is one more setting I'm missing ? Please help anybody. I believe it must be mysql configuration problem because I using the some perl version5.8.5 only DBI was upgraded to DBI-1.46 from DBI-1.43 nothing else was changed. Best regards Slawomir Orlowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
unworking directive --with-unix-socket-path=/
Hello, I have RH 6.1. I have mysql 3.22.25 version binary installation databases are in /var/lib/mysql binaries in /usr/bin/mysql etc /var/lib/mysql/mysql.pid /var/lib/mysql/mysql.sock and rpm packages: perl-DBI-1.13-1, perl-DBD-mysql-mysql-1.22.10-1 perl-5-5.0050 and binary installation of php 4.04pl and it was working perfectly (I have web page written in php and perl), two day ago I have installed from source (to old RH to get binary installation) mysql 3.23.55. It compiled perfectly and was installed in /usr/local/mysql databases in /usr/local/mysql/var /tmp/mysql.sock I have stoped old mysql server and run new one. I could connect with new /usr/local/mysql/bin/mysql client (old one was not working) and select data from moved databases. problem is that web pages are not working any more, after running by hand some script (which use to work) I'm getting: " Date::Parse is not available but requested by Class::Date DBI->connect(database=class;host=localhost) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at ./class line 27 Can't call method "prepare" on an undefined value at ./class line 156. " it looks to me that that it somehow is trying to connect to old not working mysql database. because now mysql.sock is in /tmp/mysql.sock I have found somewhere that pearl script I can add directive: mysql_read_default_file $dbh = DBI->connect("DBI:mysql:$database" . ";mysql_read_default_file=$ENV{HOME}/.my.cnf", $user, $password); I did and it worked, but I do not know what to do in php scripts (I do not know php I'm admin) and it is daunting job to change manually all perl scripts. so far my problems my faults: but now we have bug: bacause I have problem with mysql.socket which was in old version in /var/lib/mysql now in /tmp so ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock make;make install etc. should produce mysql with socket in /var/lib/mysql dictionary instead of /tmp but once again I have got socket in /tmp/mysql.sock So this directive is not working. I have solved my problem by replacing in /etc/my.conf socket = /tmp/mysql.sock with socket = /var/lib/mysql/mysql.sock and now it is working. But it does not change the fact that directive --with-unix-socket-path=/var/lib/mysql/mysql.sock is not working. - 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
help needed
Hello, I have RH 6.1. I have mysql 3.22.25 version binary installation databases are in /var/lib/mysql binaries in /usr/bin/mysql etc /var/lib/mysql/mysql.pid /var/lib/mysql/=mysql.sock and rpm packages: perl-DBI-1.13-1, perl-DBD-mysql-mysql-1.22.10-1 perl-5-5.0050 and binary installation of php 4.04pl and it was working perfectly (I have web page written in php and perl), Yesterday I have installed from source (to old RH to get binary installation) mysql 3.23.55. It compiled perfectly and was installed in /usr/local/mysql databases in /usr/local/mysql/var I have stoped old mysql server and run new one. I could connect with new /usr/local/mysql/bin/mysql client (old one was not working) and select data from moved databases. problem is that web pages are not working any more, after running by hand some script (which use to work) I'm getting: " Date::Parse is not available but requested by Class::Date DBI->connect(database=class;host=localhost) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at ./class line 27 Can't call method "prepare" on an undefined value at ./class line 156. " it looks to me that that it somehow is trying to connect to old not working mysql database. because now mysql.sock is in /tmp/=mysql.sock I have found somewhere that pearl script I can add directive: mysql_read_default_file $dbh = DBI->connect("DBI:mysql:$database" . ";mysql_read_default_file=$ENV{HOME}/.my.cnf", $user, $password); I did and it worked, but I do not know what to do in php scripts (I do not know php I'm admin) and it is daunting job to change manually all perl scripts. So any advice would be appreciated. Best regards Slawomir Orlowski - 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
logrotate problem
Hello there! I have added recently administrative user to mysql database: #mysqladmin -u root password someposword since then I'm getting every day such e-mail from logrotate demon: Subject: errors rotating logs Message: errors occured while rotating /var/lib/mysql/mysql.log mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script My rogrotate demon have such configuration file for mysql: /var/lib/mysql/mysql.log { rotate 3 daily compress postrotate mysqladmin flush-logs endscript } Any advice will be greatly 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