Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory with the control tables (e.g. user, db, host). I have run "yum remove mysql" and "yum install mysql" and "yum install mysql-server" and the control files are not recreated.
Any suggestions?
Todd
On 9/4/05, Todd Cary todd@aristesoftware.com wrote:
Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory with the control tables (e.g. user, db, host). I have run "yum remove mysql" and "yum install mysql" and "yum install mysql-server" and the control files are not recreated.
Any suggestions?
Are you removing /var/lib/mysql after you "yum remove mysql-server" ? The mysql-server package will not overwrite the files that currently exist as a safety measure for your data, but if you're already stuck, the install won't fix the problem either. Remove the /var/lib/mysql files, then 'yum install mysql-server' then restore your data. Should solve your troubles.
On Sun, Sep 04, 2005 at 08:24:17AM -0700, Todd Cary wrote: TC> Unfortunately, I blew MySQL away by replacing the MySQL control tables TC> with others and not making a copy of the folder. TC> TC> My data is backed up, so that is not a problem, but I cannot reinstall TC> MySQL and create the mysql directory with the control tables (e.g. user, TC> db, host). I have run "yum remove mysql" and "yum install mysql" and TC> "yum install mysql-server" and the control files are not recreated. TC> TC> Any suggestions? rm -f /var/lib/mysql/mysql/* mysql_install_db
Alex -
I had figured out the first, but did not remember nor note the second...
< mysql_install_db >
Todd Alex Antropoff wrote:
On Sun, Sep 04, 2005 at 08:24:17AM -0700, Todd Cary wrote: TC> Unfortunately, I blew MySQL away by replacing the MySQL control tables TC> with others and not making a copy of the folder. TC> TC> My data is backed up, so that is not a problem, but I cannot reinstall TC> MySQL and create the mysql directory with the control tables (e.g. user, TC> db, host). I have run "yum remove mysql" and "yum install mysql" and TC> "yum install mysql-server" and the control files are not recreated. TC> TC> Any suggestions? rm -f /var/lib/mysql/mysql/* mysql_install_db
Am Mo, den 05.09.2005 schrieb Todd Cary um 0:04:
Alex -
I had figured out the first, but did not remember nor note the second...
< mysql_install_db >
Todd
It is not necessary to run that command manually as the init script runs that step automatically if the mysql data directory is missing.
Alexander
On Mon, Sep 05, 2005 at 01:09:53AM +0200, Alexander Dalloz wrote: AD> Am Mo, den 05.09.2005 schrieb Todd Cary um 0:04: AD> AD> > Alex - AD> > AD> > I had figured out the first, but did not remember nor note the second... AD> > AD> > < mysql_install_db > AD> > AD> > Todd AD> AD> It is not necessary to run that command manually as the init script runs AD> that step automatically if the mysql data directory is missing. It is not necessary to reinstall all mysql packages to fix this problem ;-)
AD> _______________________________________________ AD> CentOS mailing list AD> CentOS@centos.org AD> http://lists.centos.org/mailman/listinfo/centos
-
Alex Antropoff -
Alexander Dalloz -
Jim Perrin -
Todd Cary