Date: Tue, 27 Feb 2007 10:59:50 -0800 (PST) From: Drew Jenkins <drewjenkinsjr@yahoo.com> To: freebsd-ports@freebsd.org Subject: Problem w/ MySQL Message-ID: <398767.37256.qm@web62203.mail.re1.yahoo.com>
next in thread | raw e-mail | index | archive | help
Hi;=0AThis perhaps should be directed to the MySQL list (*perhaps*), but I = tried posting twice and it never went up. I successfully installed MySQL fr= om port on both my home server and the new production server I'm building. = Then, stupidly, I taught myself that one can delete actual files when delet= ing symlinks :( I wiped out my entire /usr/local/include dir. Since I had a= duplicate on my home server, whatever I couldn't rebuild by simply rebuild= ing the ports, I just tarballed and replaced on the production server. That= worked grand for everything...except MySQL. It started complaining that it= didn't have permissions for file "ibdata1". However, said file doesn't eve= n exist on my home server, so how could it be part of the port buildout?! S= o, I created said file, gave it the appropriate permissions, and now I have= this error:=0A=0A070227 12:32:00 mysqld started=0AInnoDB: Error: auto-ext= ending data file ./ibdata1 is of a different size=0AInnoDB: 0 pages (rounde= d down to MB) than specified in the .cnf file:=0AInnoDB: initial 640 pages,= max 0 (relevant if non-zero) pages!=0AInnoDB: Could not open or create dat= a files.=0AInnoDB: If you tried to add new data files, and it failed here,= =0AInnoDB: you should now edit innodb_data_file_path in my.cnf back=0AInnoD= B: to what it was, and remove the new ibdata files InnoDB created=0AInnoDB:= in this failed attempt. InnoDB only wrote those files full of=0AInnoDB: ze= ros, but did not yet use them in any way. But be careful: do not=0AInnoDB: = remove old data files which contain your precious data!=0A/usr/local/libexe= c/mysqld: Table 'mysql.general_log' doesn't exist=0A070227 12:32:00 [ERROR]= /usr/local/libexec/mysqld: Can't create/write to file '/var/db/mysql/examp= le.com.pid' (Errcode:=0A13)=0A070227 12:32:00 [ERROR] Can't start server: c= an't create PID file: Permission denied=0A070227 12:32:00 mysqld ended=0A= =0A=0ASo, I created said pid file, gave it the appropriate permissions, tri= ed the command again, and it threw the same error _and_ blew up the pid fil= e! Like it didn't even exist...=0A=0AWhat do?=0ATIA,=0ADrew=0A=0A=0A=0A=0A = =0A________________________________________________________________________= ____________=0ABored stiff? Loosen up... =0ADownload and play hundreds of g= ames for free on Yahoo! Games.=0Ahttp://games.yahoo.com/games/front
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?398767.37256.qm>