| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> DING DING
<0> Maybe, yea
<0> "shining star" and all that
<0> until they migrate to pg
<0> hehe
<1> hi I've just rebooted my server after a *long* time, and it's restarted mysql which has caused problems - seems its been upgraded... Is there a howto somewhere on how I need to complete the upgrade so it can read the data etc? The version I'm now using is 4.1.19
<0> what was it using before?
<2> yes
<0> and what exactly is the problem now?
<1> Leith god knows...
<0> joy
<0> heh
<3> don't most systems keep an upgrade log somewhere?
<1> [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
<0> define more clearly "caused problems"
<4> Leith: haha, PG fanboys say "hey, now when they have him, project won't consider PG :("
<2> well most likely you had 3.20 before then :P
<0> madgoat: radical
<1> :) ok, how do I fix it?
<3> bummer, increasing tmp_table_size didn't help, using CREATE TEMPORARY TABLE instead of CREATE TABLE didn't help.. not sure what to try next.
<0> madgoat: install 3.2x version, dump it with mysqldump, load it to the new instance
<1> also at the moment mysqld won't actually start, but I think thats probably due to the above [error]
<0> there's a bunch of major changes between those versions
<0> a dump/load is the best option
<1> oh ok :( no easier way?
<2> not that is as reliable madgoat
<4> or it can be simply damaged :)
<1> anyone using gentoo? How do I specify the version is it something like 'emerge mysqld =3.2' ? (guessing now)
<3> try =mysql-3.2*
<1> ah ok thanks
<3> it's a single token including category, package, version... just that category's implied when there's no package name overlaps.
<4> madgoat: what are endings of mysql/user.* files?
<3> madgoat: also since you're on gentoo, try 'grep mysql /var/log/emerge.log'
<1> MYD, MYI and frm
<4> then it's definitely not 3.20
<5> andrewbryson: You got me halfway to success, thanks! Still have issues, though: http://pastebin.com/748664
<1> really? how come?
<4> 3.20 didn't have MyISAM :)
<4> madgoat: try myisamchk on those files
<2> joeKr: the second command is just the same as the first only is specifying the hostname
<1> myisasmchk comes back fine,
<5> That's how it looked to me. But it didn't complete sucessfully. Any ideas?
<4> madgoat: did you run mysql_fix_privilege_tables?
<2> well you need to specify the root p***word if you want to run something like run-all-tests as root...
<2> how i do not know
<4> did you try starting with --skip-grant-tables?
<4> ..
<2> but if you do not specify it it won't work :P
<1> I'll try a fresh install of 3.2 - see if that helps
<1> I'm pretty sure it was running an older version
<5> andrewbryson: How do I specify the root p***word while starting perl? I didn't see that in their perl test example.
<2> joeKr: no idea - it would depend on what the program is doing
<5> andrewbryson: Or is this because the second command didn't complete after setup?
<2> joeKr: the second command was the same as the first...
<2> it did not complete because at that point you had set the root p***word
<2> and were not specifying it
<2> so it generated a bad p***word error
<5> andrewbryson: But they show both and ask for both, I thought?
<2> well in that case they are wrong :P
<2> you can't believe everything that you read on the internet :P
<6> is this possible? SELECT * from LOWER("MYTABLE") where its really mytable my parent app doesnt have a stinking to_lower func
<6> some sort of excape sequence?
<5> andrewbryson: Don't I know it!
<2> SkyNetisHere: is your database case sensitive ?
<6> yup the table is lower case
<6> mydb.MYTABLE doesnt exist (mydb.mytable does)
<6> I found nothing in the manual and of course the query fails... there some funky brackets or something I can throw arround that LOWER() to get it to preevaluate?
<1> I installed mysql 3.2, but it won't start! Nothing in error log either
<7> errr .. 3.2?
<1> I'm just trying to get mysql working again...
<4> madgoat: did you run fix privilege tables? :)
<1> no... but I can't get mysqld to start at the moment at all...
<1> the scripts are out of sync
<1> its not running but the init.d script thinks it is
<1> any ideas what I need to delete to get the scripts back in sync on gentoo?
<3> madgoat: /etc/init.d/mysql zap
<1> cool just found it :)
<2> lol zap is a command ?
<2> whatever happened to "stop" ?
<3> stop is stop, zap is "i got confused and the process really isn't running but i think it is"
<2> ah :P
<2> so it deletes the pid file ?
<3> along with whatever other random things may be needed for a given process
<1> there isn't a /var/run/mysqld directory so it won't start. Who should own it and what permissions?
<2> nice
<3> only relevant on gentoo, afaik
<2> ah :P
<2> well since i most likely will never use gentoo is not an issue :P
<3> feel free to try elsewhere and report back =)
<2> no zap on slackware
<2> although it looks like rc.mysqld cleans up before trying to start mysqld
<1> "9:37:55 Can't start server : Bind on unix socket: Permission denied"
<2> so i guess it is like autozap :P
<5> andrewbryson: I got the tests running, but between perl and mysqld, I've got about an 85% user load. And I've got about 20 minutes into it on a fast 1-cpu system. How long should I expect these tests to take?
<2> i have never run them sorry
<5> andrewbryson: I thought not too long at first, but test 6 is slo-o-o-w.
<3> looks like it's been going about 35min on a dual proc athlon1800
<5> spyderous: keep us posted, won't you? I'll do the same.
<3> looks like i just started the wisconsin test
<8> hi
<5> spyderous: Isn't that the last test?
<8> i for got my root p***word
<8> how can i cahnge it ?
<3> i don't know what order it runs the stuff in.
<8> i tried with mysqladmin but did not maange
<5> everybody has the same problem tonight
<3> ah, there we go, done
<3> that was just under 40 min
<2> and with a fairly slow system too
<8> any hints ?
<5> spyderous: OK, thanks. And congrats, I ***ume all tests p***ed?
<3> All 9 test executed successfully
<9> !m archonel reset root p***word
<10> archonel: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<8> wobbles thank you
<5> thanks wobbles, I was scrolling back for archonel but it didn't go back that far
<3> looks like the insert tests took 2x more time than anything else, with select coming in 2nd
<5> spyderous: Great. I'm not finished with insert yet and haven't even *started* on select. Maybe I'll take a nap?
<5> spyderous: How long did insert say it took?
<3> wallclock in seconds: insert 1139, select 673, create 312, connect 137, others <50
<5> spyderous: Doh!
<3> alright, so now i've verified my mysql setup isn't totally broken. that's encouraging.
<5> my insert test just finished at 2062 secs. This is on a single athlon, but I forgot if it's a 2800 or 3200? Ram is 512MB
<11> hi how do I blitz my data directory and create a fresh one on a new install?
<2> rm -rf is generally effective so long as you make sure that you delete only stuff you want to get rid of
<11> ok then run mysql_install_db?
<11> is there any way to just refresh the 'mysql' database to defaults and leave the others alone?
<11> I guess I could move everything then move things back
<3> i guess i'll just recreate the whole database ...
<5> spyderous: my tests finished, 3430 total, so almost a hour. Test 8, transactions, "skipped because the database doesn't support transactions". Is that normal? The final score was 9 of 9, at least.
<12> joeKr, what tests ?
<3> joeKr: yeah i got the same skip.
<5> nife: the run-all-tests perl script
<5> nife: in my distro, it's in /usr/share/sql-bench
<13> hi
<13> anyone? is there a way to give a directive on my mysql server (windows) to be case sensitive like in linux?
<5> ruid0: Hi. Would you like to know how to reset your mysql root user p***word?
<5> Doh! guessed wrong!
<13> :)
<13> not very far tho
<5> ruid0: Just kidding with you, we've had a run on p***word resetting, including me!
<13> hehe
<13> maybe Denn needs that answear
<5> Denn: Hi. Would you like to know how to reset your mysql root user p***word? (buffer scrollback is great, isn't it?)
<3> looks like i might really be stuck: http://bugs.mysql.com/bug.php?id=14070
<2> lol joeKr
<2> it has come up a fair few times tonight :P
Return to
#mysql
or
Go to some related
logs:
start-stop-daemon redhat enterprise
0x736D7264
#linux
#css
clear buffer printer linux
mIRC Reklamos Botas
firefox yast
#perl
#linux
#math
|
|