#mysql
04 October 2007
Total 23 pages. You are browsing page 4/23.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
04:04 <****> avidal: that's something you can easily look up
04:04 <****> chadmaynard: Yeah...but it doesn't make sense. ANSI control codes 12 and 15 are form feed and shift in, respectively.
04:05 <****> \012 is octal not decimal
04:05 <****> so it is actually 10 in decimal
04:05 <****> oh thank you
04:05 <****> I just noticed that
04:05 <****> So yeah, it's CR+LF in octal
04:06 <****> chadmaynard: here is what i get : http://pastebin.ca/725048
04:06 <****> WooD: try to start the server
04:06 <****> I guess I'll replace it myself
04:07 <****> chadmaynard: ok
04:08 <****> ok great
04:08 <****> chadmaynard: i still get an error http://pastebin.ca/725051
04:09 <****> WooD: looks like the host.frm file is corrupt.
04:09 <****> chadmaynard: is there any way to reinstall mysql :S
04:09 <****> you can copy it from another machine of the same version or use mysql_install_db to recreate it
04:10 <****> chadmaynard: I have a backup of my databases
04:10 <****> WooD: you need not delete the databases themselves
04:10 <****> WooD: do you have any users other than root setup?
04:10 <****> chadmaynard: ok so ill try mysql_install_db
04:10 <****> chadmaynard: is it ok ?
04:11 <****> WooD: you should delete that host.frm file first
04:11 <****> chadmaynard: o k
04:11 <****> chadmaynard: done
04:12 <****> mysql_install_db and then try to start
04:12 <****> chadmaynard: ok thanks
04:14 <****> chadmaynard: ouchhh... I get an error ... maybe i need to restart the computer ?
04:14 <****> what error?
04:15 <****> chadmaynard: it does make a loop in the syslog file about an error
04:15 <****> WooD: what's it say?
04:15 <****> chadmaynard: my server is coming craisy right now lol
04:16 <****> chadmaynard: i hear the hard drive writing
04:16 <****> chadmaynard: ill past
04:16 <****> chadmaynard:paste
04:17 <****> chadmaynard: http://pastebin.ca/725057
04:18 <****> ouch.
04:19 <****> buy mysql enterprise and get professional help
04:19 <****> :)
04:19 <****> lol
04:20 <****> hmm i got kicked off
04:20 <****> chadmaynard: ok
04:20 <****> chadmaynard: did you see the paste i gave to yo u?
04:20 <****> WooD: what'd you decide?
04:21 <****> chadmaynard: http://pastebin.ca/725057
04:21 <****> the error? yes. and i said hehe. You might want to cd delete the entire directory that contained that host.frm file. The consequence is that you will lose your database users. The files will still be there as long as nothing else is wrong. only root user will exist and have no password.
04:21 <****> chadmaynard: i have reboot the server
04:21 <****> that won't change anything : )
04:21 <****> this is mysql, not windows
04:21 <****> :)
04:22 * chadmaynard is on windows
04:22 <****> loser
04:22 * chadmaynard hides to prevent being smashed
04:22 <****> chadmaynard: OK so the best thing to do is to remove all files into the /var/lib/mysql/mysql
04:23 <****> WooD: yes, and re-run mysql_install_db
04:23 <****> chadmaynard: ouch I have reboot and still have a looping error in syslog
04:23 <****> well of course
04:24 <****> chadmaynard: ok after deleting all files into the dir: /var/lib/mysql/mysql/ the error has stopped looping
04:24 <****> WooD: now mysql_install_db
04:25 <****> chadmaynard: filling help tables .. OK and Installing MYSQL system tables ... OK
04:25 <****> /etc/init.d/mysql start
04:25 <****> chadmaynard: ok now I start ?
04:25 <****> chadmaynard :O K
04:25 <****> yes
04:26 <****> chadmaynard: * Starting MySQL database server mysqld
04:26 <****> ...done.
04:26 <****> error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
04:27 <****> oupss sorry
04:27 <****> only the root user will work for now
04:27 <****> re-create that user
04:27 <****> ok
04:28 <****> ok im connnected to mysql with mysql -u root
04:28 <****> you have to create that debian-sys-maint user again if you want the cron user to scan and update tables on start
04:28 <****> no i need to make users..
04:28 <****> hooo
04:28 <****> chadmaynard: what would be the procedure ?
04:28 <****> for the debian user?
04:29 <****> chadmaynard: yeah
04:29 <****> chadmaynard: I know how to recreate my user ..
04:29 <****>' WITH GRANT OPTION;
04:30 <****> is in /etc/mysql/debian.cnf i think
04:30 <****> chadmaynard: ouchh how can you know so much things like this ?
04:31 <****> I remember it from a guy yesterday with the same problem
04:31 <****> haha
04:31 <****> chadmaynard: your right it was in that debian.cnf
04:31 <****> ho lol
04:31 <****> chadmaynard is a bot
04:31 <****> lol
04:32 <****> hehe
04:32 <****> the_wench is a bot
04:32 <****> You dont want to know what I think chadmaynard is!
04:32 <****> but seriously, hang in here long enough, just lurk and you'll learn lots
04:33 <****> chadmaynard: ok the debian user is created .. how to test if it works ?
04:33 <****> mysql -udebain-sys-maint -p
04:33 <****> WooD: /etc/init.d/mysql restart
04:34 <****> it will complain if it doesn't work
04:34 <****> would help if you spelt debian properly though
04:34 <****> or listen to chad
04:34 <****> debain
04:34 <****> chadmaynard: ok
04:34 <****> vluther: either way works, mine takes less effort
Total 23 pages. You are browsing page 4/23.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last