Milan, Friday, May 03, 2002, 2:15:49 PM, you wrote: MR> I have a problem with updating MySQL database on linux with mysql MR> 3.23.24-beta-log. I have prepared a database on Win98 SE platform MR> with 3.23.49a and when i moved to my linux server at school (RedHat MR> 7.0 CZ with MySQL 3.23.24-beta-log) I can't update or insert to table. I MR> have changed rights to database files with chmod to 744 but this MR> doesn't take any effect. Can someone help me?
I assume that you have copied files directly on your Linux server. When you change permissions with chmod, you change permissions for user that file belongs. So, if files are not belonging to MySQL user, the server will not open tables. MySQL must be owner of its' data dir and files. mysqldump is recommended for moving database from one server to another. -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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