[Deploying Sakai] MySQL dump format for backing up

Mike De Simone michael.desimone at rsmart.com
Mon Oct 10 09:01:15 PDT 2011

i usually just use mysqldump to produce 1 big file.  but if you have these
tab-delimited files, it seems like a small bash script could do what you

something like this should work (assuming database is 'dbname', adjust as

for i in `ls *sql`; do
   mysqlimport dbname $i



Mike DeSimone
Lead Systems Engineer
*r**Smart* | 602-490-0473

On Sun, Oct 9, 2011 at 16:16, Colin Tatham <colin.tatham at unimelb.edu.au>wrote:

> Hi
> Just wondering whether anyone has any experience or opinions on this.
> mysqldump has an option which produces separate files for the database
> structure (in SQL files) and content (in tab-delimited plain text files):
> http://dev.mysql.com/doc/refman/5.0/en/mysqldump-delimited-text.html
> We have a Sakai DB dump in this format which I need to restore, but as
> there
> doesn't seem to be any MySQL facility to restore from the 677 files in the
> tar archive automatically, I'll need to script it. Anyone done that
> already?
> I'm also interested to know what the usual practice is for backing up; do
> most of you do the standard mysqldump back-up to a single very large SQL
> file, and then have that backed up at the file-level by your normal back-up
> software (TSM, in our case)? Anyone have any opinions of the possible
> advantages of using the separated format?
> Thanks!
> Colin
> --
> Colin Tatham | Educational Technologist | Learning Environments
>  University Library | The University of Melbourne
> W http://www.trs.unimelb.edu.au
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
> TO UNSUBSCRIBE: send email to
> production-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20111010/bb1c4278/attachment.html 

More information about the production mailing list