[Linux-disciples] Replaying MySQL commands

[Stephen R Laniel]

On Fri, Apr 21, 2006 at 12:24:14PM -0400, Adam Rosi-Kessel wrote:
> Can't you just redirect from the file?
> 
> mysql [switches] < logfile.sql
> 
> This is what I've done in the past to move entire databases
> 
> mysqldump [stuff] > logfile
> mysql [stuff] < logfile

Well, what I've got is the logfile, not a dump. The logs
look like so:

		   2893 Connect     thinkpuser at localhost on 
		   2893 Init DB     thinkp
		   2893 Query       SELECT DISTINCT * FROM wp_posts  WHERE 1=1 AND post_name = 'faviconico' AND post_date_gmt <= '2006-04-20 22:09:59' AND (post_status = "attachment") GROUP BY  wp_posts.ID  ORDER BY post_date DESC
		   2893 Quit       
		   2894 Connect     thinkpuser at localhost on 
		   2894 Init DB     thinkp
		   2894 Quit       
		   2895 Connect     thinkpuser at localhost on 
		   2895 Init DB     thinkp
		   2895 Quit       

I could munge these into a dumpish format. And in fact
that's probably the best idea.

-- 
Stephen R. Laniel
steve at laniels.org
Cell: +(617) 308-5571
http://laniels.org/
PGP key: http://laniels.org/slaniel.key
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.bostoncoop.net/pipermail/linux-disciples/attachments/20060421/70962843/attachment.pgp