fasiso Posted November 10, 2004 Share Posted November 10, 2004 How can I make backup copy with MySQL Administrator. The file .sql that makes doesn?t work. Which options must be check? Thanks in advance. Link to comment Share on other sites More sharing options...
Guest Posted November 10, 2004 Share Posted November 10, 2004 I use a perl script that calls mysqlbackup instead. Then I can run it via cron. I'm sure I've posted it somewhere here before, but I can post it again if you find it useful. -jared Link to comment Share on other sites More sharing options...
Guest Posted November 10, 2004 Share Posted November 10, 2004 How can I make backup copy with MySQL Administrator. The file .sql that makes doesn?t work. Which options must be check? Thanks in advance. <{POST_SNAPBACK}> Why not just use the backup tool in osC admin? Link to comment Share on other sites More sharing options...
Guest Posted November 12, 2004 Share Posted November 12, 2004 My reasons not to use that backup: 1) no compression 2) no offsite backup 3) no automated backup (I have to remember) So, I cron a script to accomplish both of those goals. -jared Link to comment Share on other sites More sharing options...
Guest Posted November 12, 2004 Share Posted November 12, 2004 you can create a cron job, look in tips and tricks for a complete understanding of how to do that. then you can use this for mysql mysqldump -uUSERNAME -pPASSWORD --add-drop-table database > database.sql Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.