|Ciaran_H||chadmaynard: 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.|
|Ciaran_H||chadmaynard: Sarge used 4.0.24, Etch uses 5.0.32.|
|chadmaynard||Ciaran_H: that's a big jump. The mysqldump will be necessary from 4.0 -> 5.0|
|kimseong||if you use the same default charset, should still be fine|
there is a mysql_upgrade
|Ciaran_H||chadmaynard: 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?
|chadmaynard||you can try what kimseong says but mysql's website says you can't do it i believe|
Okay, I didn't realise there was a mysql_upgrade.
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.
|action||chadmaynard hops in his time machine|
|chadmaynard||hops in his time machine|
|tussey_||is there a way to do SELECT * FROM roster WHERE lname contains foobar|
|jsoftw||If 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 ?|
|kimseong||mysql has no ownership|
You know what I mean
Eg, the grants that apply to that database.
|kimseong||jsoftw: the grants are separate, you have to move that over|
|Ciaran_H||tussey_: SELECT * FROM roster WHERE lname LIKE "%foobar%"|
|tussey_||SELECT * FROM `roster_cadre` WHERE title LIKE "enrollment"|
returns empty set
|Ciaran_H||tussey_: Right, you need ...LIKE "%enrollment%"|
With the % symbols.
|tussey_||what are the % for?|
|Ciaran_H||They're wildcard symbols.|
Basically equivalent to * in globs.
|chadmaynard||and we'll ignore '%foobar%' being evil|
|Ciaran_H||chadmaynard: 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
sometimes you need evil