InnoDB “log sequence in the future!” crashing, won't start

2011-11-05 Thread Kevin Wang
I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when innodb_force_recovery = 5 and nothing lower. When I "check table" for my MyISAM tables, they check fine, but t

Re: can I get around error 1451 in innodb

2011-11-05 Thread Hal�sz S�ndor
2011/11/06 13:56 +1000, Edward avanti #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`vmail`.`domain_admins`, CONSTRAINT `domain_admins_ibfk_1` FOREIGN KEY (`domain_id`) REFERENCES `virtual_domains` (`id`) ON DELETE CASCADE) In table domain_admins

can I get around error 1451 in innodb

2011-11-05 Thread Edward avanti
We have aded an internal domain, its assigned the latest id ( 20433), we have safeguards in our portal that stop domains with id less than 5 from being deleted, the table doesnt show "3" so it is not used, but when I try alter the table it fails: update virtual_domains set id='3' where id='20433'

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
Roger, 2 mins. of Google turned up these (just f.y.i.): http://www.cyberciti.biz/faq/mysql-change-root-password/ http://www.cyberciti.biz/tips/recover-mysql-root-password.html -G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
>> >>> ...as Brandon said.. from terminal you have to type something to get into >>> mysql, and if you are like me, then that is: >>> >>> /usr/local/mysql/bin/mysql >> >> Oh, I forgot to add - but you might need to be super user first. >> >> su >> (input pass..) > > why in the world should s

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Reindl Harald
Am 06.11.2011 02:00, schrieb Govinda: > >> ...as Brandon said.. from terminal you have to type something to get into >> mysql, and if you are like me, then that is: >> >> /usr/local/mysql/bin/mysql > > Oh, I forgot to add - but you might need to be super user first. > > su > (input pass..)

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
> ...as Brandon said.. from terminal you have to type something to get into > mysql, and if you are like me, then that is: > > /usr/local/mysql/bin/mysql Oh, I forgot to add - but you might need to be super user first. su (input pass..) > > -Govinda > >> I installed Mysql using the .dmg pa

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Govinda
...as Brandon said.. from terminal you have to type something to get into mysql, and if you are like me, then that is: /usr/local/mysql/bin/mysql -Govinda > I installed Mysql using the .dmg package. I can use System Preferences to > start and stop the program. When I open a terminal window,

Re: New-be: problem installing on Mac SO10.6

2011-11-05 Thread Brandon Phelps
On 11/5/2011 12:32 PM, Roger CPL wrote: I installed Mysql using the .dmg package. I can use System Preferences to start and stop the program. When I open a terminal window, I think this is the way to us the program, any Mysql command I inter is not recognized. Thanks Roger You will need to

New-be: problem installing on Mac SO10.6

2011-11-05 Thread Roger CPL
I installed Mysql using the .dmg package. I can use System Preferences to start and stop the program. When I open a terminal window, I think this is the way to us the program, any Mysql command I inter is not recognized. Thanks Roger -- MySQL General Mailing List For list archives: http://list