#mysql - Mon 7 May 2007 between 00:00 and 00:19

NY Lost Funds



ToeBeemmhmm
Ciaran_Hchadmaynard: Yeah, I know, I was just referring to them as I figured people would be more aware. Hang on, I'll get the version info.
chadmaynardToeBee--
Ciaran_Hchadmaynard: Sarge used 4.0.24, Etch uses 5.0.32.
chadmaynardCiaran_H: that's a big jump. The mysqldump will be necessary from 4.0 -> 5.0
kimseongif you use the same default charset, should still be fine
there is a mysql_upgrade
Ciaran_Hchadmaynard: Okay then. I didn't realise it'd be neceessary. Okay... can I use a chrooted Sarge installation to run 4.0's mysqldump on the backup files without contacting the running MySQL version, then use Etch's tools to re-import them, or will I have to reboot properly into Sarge to do it?
In other words, can I generate an SQL dump from .MYD/.MYI/.FRM files directly?
chadmaynardyou can try what kimseong says but mysql's website says you can't do it i believe
Ciaran_H...oh.
Okay, I didn't realise there was a mysql_upgrade.
<-- stupid
Gaaaah.
Okay, bleh.
Hmm.
Now, see, another rather stupid thing is that I don't have binary logging enabled. I wish I did, since I could then have replayed changes that were made since the backups. But, meh.
actionchadmaynard hops in his time machine
chadmaynardhops in his time machine
tussey_is there a way to do SELECT * FROM roster WHERE lname contains foobar
jsoftwIf i have a database owned by user foo, and I import the foo database into another mysql server, does that automagically import the user that owns the foo database ?
kimseongmysql has no ownership
jsoftw:\
You know what I mean
Eg, the grants that apply to that database.
kimseongjsoftw: the grants are separate, you have to move that over
jsoftwdamn :/
Ciaran_Htussey_: SELECT * FROM roster WHERE lname LIKE "%foobar%"
tussey_SELECT * FROM `roster_cadre` WHERE title LIKE "enrollment"
returns empty set
jsoftwdamn!
Ciaran_Htussey_: Right, you need ...LIKE "%enrollment%"
With the % symbols.
tussey_what are the % for?
Ciaran_HThey're wildcard symbols.
Basically equivalent to * in globs.
chadmaynardand we'll ignore '%foobar%' being evil
Ciaran_Hchadmaynard: I'm aware it's evil, but I'm not sure of the alternatives, other than FULLTEXT indexing, which I don't really know how to do and what to use.
I'm willing to learn. :D
actionchadmaynard shrugs.
chadmaynardshrugs.
sometimes you need evil

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds