| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
<ecliptik> iviso_, ummm, okay
<^Willie^> i don't have mysqld_safe so i use mysqld --safe-mode
<inviso_> ^Willie^: whereis mysqld_safe; whereis safe_mysql; whereis safe_mysqld;
<^Willie^> ask sun
<will_> Give me the Cobalt
<^Willie^> i did reset my p***word befor on an server like this with same install from restore cd but don't ask me how thats why i ask you ppl here
<llewelyn> having issues with mysql
<^Willie^> will_ look al ebay
<ecliptik> the issue I have is I did a database copy of a webmail, and for whatever reason any email stored in sub folders didn't work properly, so I've created a small script to pull the missing EmailMessage,id from the old DB and insert it into the new one, hopefull filling in the missing gaps. Unfortunately I haven't had any luck yet, and I thought maybe instead of using the old id # it just start auto incrementing again
<llewelyn> i downloaded the source
<will_> ^Willie^: If you have the reset CD, reset the whole system again, and try a blank p***word. Or read the docs to find out what the default one Sun gave you.
<llewelyn> compiled
<^Willie^> inviso if yyou don't know stf !!
<^Willie^> i just want help not ****
<will_> ^Willie^: Calm down.
<llewelyn> and it gives me this error
<^Willie^> this take me 4 hours now
<will_> llewelyn: One line will do...
<will_> ^Willie^: Don't blame anyone else for that.
<llewelyn> damnit it closed the shell
<^Willie^> ok but he can akt normal
<inviso_> ecliptik: to fill in gaps, that's what you would need to do.. Hardly ever necessary to fill in gaps though and usually a bad idea.
<llewelyn> it can't find host.frm
<will_> ^Willie^: He doesn't have to do anything. Just answer my question
<^Willie^> if he don't accept my situation
<will_> llewelyn: You didn't follow all the instructions. Which install docs are you reading?
<ecliptik> inviso_, why is it a bad idea? because it'll pick up the autoincrement where it left off?
<will_> ^Willie^: Drop it.
<llewelyn> the ones at mysql.org
<will_> ^Willie^: Just look at my question.
<^Willie^> ok
<will_> llewelyn: Exact URL
<llewelyn> i think i might have screwed up when creating the db
<inviso_> ^Willie^: I already gave you the answer to the second error and you told me I was full of it. That's instant ignore material for me.. Good luck.
<will_> inviso_: Please don't provoke it.
<llewelyn> will_, http://dev.mysql.com/doc/refman/4.1/en/index.html
<will_> llewelyn: That doesn't look like an install doc..
<llewelyn> not it's the entire documentation
<inviso_> ecliptik: First, ask why you need to remove the gaps. Is there a really good reason to do so?
<llewelyn> i closed the window
<llewelyn> when i found out supper was ready
<llewelyn> .....
<llewelyn> erg be back in a bit hopefully you're still here
<ecliptik> inviso_, I don't need to remove the gaps, I need to fill them in. Say message id # 150000 was in a sub folder, and it wasn't inserted into the new DB, so I want to pull it from the old DB and then insert it into the new one, filling int he gap so message #150000 is there
<will_> heh
<inviso_> ecliptik: fair enough. Why do they need to be sequential?
<ecliptik> inviso_, they don't, I want the same id # that was in the old DB in the new one, so I don't want autoincrement to think they're new values and give them a new id #
<inviso_> will_: it's just a good thing I'm not a mod ;o)
<inviso_> ecliptik: oh, perfect. Just specify the old ids for that column and you're good to go.
<ecliptik> inviso_, that's what did but it doesn't seem to be working.
<^Willie^> will_ : what happend when i remove the user.MYD and user.MYI file ??
<ecliptik> how can I show at the next autoincremented value will be?
<inviso_> ecliptik: something like insert into tablename (id_col, col2, col3) values (old_id, "col2", "col3")?
<inviso_> ecliptik: can't
<ecliptik> inviso_, that's what I have, still no luck though
<Kinkew> well you can if you know the highest value was the last value..
<inviso_> ecliptik: pastebin the following. show create table new_tablename; show create table old_tablename; as well as a sample insert
<Kinkew> select max(column_with_auto_increment) from tbl_name
<Kinkew> but the last value may have been deleted.
<inviso_> Kinkew: nope. No concept of "next" with regard to auto_increment. Multiple connections will always mess with you.
<llewelyn> back
<ecliptik> Kinkew, what do you mean deleted?
<llewelyn> let me get that information will_
<ecliptik> both my old db and test db show the same number
<inviso_> ecliptik: if you insert row 22 and then delete row 22, the next up is 23 even though max(id)+1 will show 22
<Kinkew> yes, that's why I said that.
<inviso_> at least for MyISAM. InnoDB functions differently
<llewelyn> will_, 051022 20:36:27 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
<ecliptik> inviso_, that's fine, I understand that, I just don't want to run the show query and have it delete anything
<inviso_> !perror 13
<will_> llewelyn: Pull up the doc you used to install it. :)
<llewelyn> k
<inviso_> ecliptik: nope, show create table won't affect the data
<^Willie^> will_ ?
<llewelyn> http://dev.mysql.com/doc/refman/4.1/en/installing-binary.html
<will_> llewelyn: Did you install the binary or source?
<will_> ^Willie^: Yes?
<llewelyn> source
<llewelyn> going through history now just a sec
<will_> llewelyn: You're looking at the wrong doc then. Why don't you install the binary instead?
<llewelyn> pain in the arse
<llewelyn> i've done this before
<^Willie^> will_: is it an option to remove te user.MYD/MYI file ?
<llewelyn> a few times just forget how...
<will_> Actually, it's quite easy
<will_> Just follow that doc you pasted above.
<llewelyn> besides i already have the source compiled and installed already
<will_> It'll take you all of 3 minutes, minus download time.
<llewelyn> problem is configuration
<will_> llewelyn: Then pull up the doc you used to install.
<llewelyn> lol 856up/4meg down download time isn't an issue
<will_> ^Willie^: Why would you want to do that?
<will_> Ok fine.
<^Willie^> will_: i don't know what else to to
<will_> ^Willie^: RUN THE REINSTALL CD, like I said earlier.
<^Willie^> i just want to get ymsql running and not whasting my time
<will_> Start over because you might have messed something up.
<^Willie^> will_ i cant
<will_> Why not?
<^Willie^> this jsut have to run
<will_> Well, that ****s.
<llewelyn> will, i could del the binaries created by the source
<^Willie^> coust this take me 8 hours downtime now
<llewelyn> and the directories and such and begin new
<^Willie^> there is an way to reset that p***word but how
<will_> !m ^Willie^ reset root
<llewelyn> ^Willie^, windows or linux instalation?
<^Willie^> linux
<will_> llewelyn: SURE DO TAHT
<^Willie^> and that manual is nog right btw
<inviso_> ecliptik: any luck yet?
<llewelyn> will_, alright i'll ram together a script to do it
<llewelyn> should be back in a few minutes
<^Willie^> mysqld --mode-safe must work and i get an permision error
<llewelyn> why not just wun mysqld_safe
<will_> ^Willie^: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<will_> Read and do that.
<^Willie^> llewelyn: i don't have that exec
<will_> Find it.
<^Willie^> will_ i did
<ecliptik> inviso_, no, I'm still confused on how the db stores email when it gets it, so I think my query's are right, I just don't have the proper tables
<^Willie^> there is an way without that exec
<inviso_> ecliptik: ah, that makes sense.. Let me know if I can help with anything else.
<^Willie^> where else is the --safe-mode option for
<llewelyn> ^Willie^, you completely BOTCHED your install/configuration
<llewelyn> rebuild
<will_> You need that exec, since that's how you start MySQL.
<llewelyn> and reinstall
<llewelyn> thats your only recourse
<^Willie^> this is an production server and restore will take to mutch time
<^Willie^> this mysql need to be reset not more not less
<will_> SO READ THAT DOC
<will_> Stop whining on IRC.
<SQL> System error: 13 = Permission denied
<SQL> ^Willie^: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<will_> haha
<^Willie^> else can i ripp the db files from some tarball and place them in my database directory
<will_> ^Willie^: Sure, do that.
<^Willie^> will it work ??
<llewelyn> um, thats more difficult then it sounds...
<will_> SURE
<^Willie^> this manual talk about stuff that not work simple
<llewelyn> i suggest you read the doc
<will_> ^Willie^: FINE JUST DO IT. Stop wasting time.
<^Willie^> don't start jelling read that manual when i tell you i get stuck on that manual
<^Willie^> wtf is this this is no support just a bunch of kiddos
<llewelyn> ^Willie^, read the doc, i came here AFTER reading the docs, looking for a solution after 3 days of putting about
Return to mysql
or
Go to some related
logs:
vael lag
postfix fatal non-null host address bits in 127.0.
trondheim
|
|