Hy, sorry for the trouble! i tried to do a chown mysql:daemon -R * in the data dir, and after that it worked.
I didn't try that before because somehow i couldn't see a connection between differing ownerships and disfunctional tables when looking at this. sorry, henning Henning Sprang wrote: > Hy all, > I just try to set up Replication with two mysql databases, > i did everything like described in the Replication-Howto. > > Now i get the following errors when starting the slave: > > 020117 18:37:55 mysqld started > Can't initialize InnoDB as 'innodb_data_file_path' is not set > /usr/sbin/mysqld-max: ready for connections > 020117 18:37:55 Slave: connected to master '[EMAIL PROTECTED]:3306', > replication started in log 'samba-bin.001' at position 536 > ERROR: 1017 Can't find file: './tropon_0000001/Tagesberichte.frm' > (errno: 13) > 020117 18:37:55 Slave: error running query 'CREATE TEMPORARY TABLE > TB_Tage TYPE=HEAP SELECT DISTINCT Datum FROM Tagesberichte AS TB WHERE > Besucher_ID=10021 ' > 020117 18:37:55 Error running query, slave aborted. Fix the problem, > and re-start the slave thread with "mysqladmin start-slave". We stopped > at log 'samba-bin.001' position 536 > 020117 18:37:55 Slave thread exiting, replication stopped in log > 'samba-bin.001' at position 536 > > > the file is actually there (in the data directory at least, i don't know > what is meant with the "./tropon..." directory exactly as it is a > relative path, > and i checked if mysql recognizes the data directory by setting some > unimpoortant settings in a my.cnf file in there - the changes where > accepted correctly, i did make sure to remove that testing file again. > > When I connect to the database on the slave with mysql-client i get the > following: > > ... > Didn't find any fields in table 'Statistiken' > Didn't find any fields in table 'Tagesberichte' > Database changed > > > I see there are some tables which don't produce errors, but for all, > with or without errors, there are .frm files in the data directory, > i see there are different file permissions for differenbt table files, > but again the failing tables don't have something of those in common. > > > has anyone an idea what i can look for? > > > henning > > > > > --------------------------------------------------------------------- > 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
