Re: transferring databases
Hello, check if the files have to be in a special directory. check the datadir varible from show variables hope this helps samier. Myk MelezAn: abw [EMAIL PROTECTED] [EMAIL PROTECTED]Kopie:[EMAIL PROTECTED] Thema:Re: transferring databases 22.05.02 22:18 abw wrote: Is it possible to zip up database directories on one server and move them to another server, then simply unzip them? Yes. If so, once that is done, does something need to be done to mysql so it is aware of the databases? Is there some file that has a list of databases that must be updated or something? No. Mysql is running, because I see it in the process list, and from what the customer told me, he does see the databases, but he cannot access them. This is probably a file permissions problem. Make sure the user mysqld runs as (probably mysql) has access to the database directory and files (chown -R [name of mysql user] [directory name] should do the trick). -myk - 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
Antwort: Problem with MySQL server - 3.21.33b
Hi, check the niced processes (on BSD #ps aux). These are processes which have been assigned a higher priority and there for kill your server. Also the man page from top (the CPU STATE comes from top ?) writes that the nice % should also be seen in user and system % which is not the case in your snip. Could be of the high CPU overload hope this helps a bit sake. Sheni R. Meledath An: MySQL Masters [EMAIL PROTECTED] [EMAIL PROTECTED] Kopie: Thema:Problem with MySQL server - 3.21.33b 15.05.02 11:24 Hello: We are facing a serious problem with the MySQL server installed on our web server (BSD/OS). The server was working fine till last week. Since then it started crashing. It crashes 2-3 times a day. Every time we have to kill the process and restart the server (UNIX). Not only the MySQL server the entire server crashes because of the load on the CPU. ###CPU STATE### load averages: 1.00, 1.00, 0.92 02:47:57 278 processes: 13 running, 265 sleeping CPU states: 0.0% user, 98.4% nice, 1.6% system, 0.0% interrupt, 0.0% idle Memory: Real: 40M/94M Virt: 217M/1481M Free: 342M PID PRI NICE SIZE RESSTATE TIME WCPU CPUCOMMAND 270 94 44420K 2024K run43:48 97.17% 97.17% mysqld ## The MySQL version is 3.21.33b . Since its an old version I couldn't find out any information regarding the issue from the MySQL web site. We have got 4-5 MySQL databases on this server. Could anybody help me out to solve this issue. Regards Sheni R Meledath [EMAIL PROTECTED] - 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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
diffrent amount of datasets with mysql man perl
Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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: diffrent amount of datasets with mysql man perl
Hi, thanks for the fast replies, It was a database problem. I compared two tables wich were not syncronised and therefor didnt have the same amount of datasets. Thanks sake. Samier.Kesou@bfa-berli An: [EMAIL PROTECTED] n.de Kopie: Thema:diffrent amount of datasets with mysql man perl 14.05.02 15:55 Hello, im using mysql 3.23.41-log perl 5.6 This might be a perl question but I have to start somewhere:-) to get the data out of the DB im using: --- perl snip --- while (my @fields = $sth-fetchrow_array()) { print join (;, @fields), \n; } --- perl snip --- so each data set is presented in csv style. But the amount of data sets is not the same. For a sql statement im using a simple select count(*)... When im using the mysql client for the select statement more datasets are returned then with the perl script( as an example 2348 lines to 3206 lines). does someone have a clue to this problem? Thanks in advance, sake. - 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