joeyjj Posted August 9, 2010 Share Posted August 9, 2010 Hello, I'm attempting to build my first website and I'm a complete beginner. I have a question regarding MySQL. I am currently using the MAMP program rather than an actual online server and the MySQL version is: MySQL 5.1.44. In one database I will have various forms of media, .jpg, .mov, .pdf, etc. and I wish to export this database into an offline storage, DVD, hard drive, etc. The various export options I have are CodeGen, CSV, CSV for MS Excel, Microsoft Excel 2000, Microsoft Word 2000, LaTeX, Open Document Spreadsheet, Open Document Text, PDF, SQL, Texy! text, XML and YAML. I know what some of these are, and some others I have no clue. I want to store the database offline and then sometime in the distant future I'll want to read it again (i.e. 1 year, 10 years or even 100 years). Which of the above formats would preserve the movies and pictures best so they can be read again? EDIT: Sorry by preserve, I mean keep the data completely readable as some of the above formats seem to print the data as hexadecimal code and seem to cut out before they finish. I don't be preservable as in to remain uncorrupted for a long time. Sorry if this turns out to be a silly question, like I say I'm a complete beginner. Cheers for any time/help you can give me. Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/ Share on other sites More sharing options...
tomhoad Posted August 9, 2010 Share Posted August 9, 2010 I generally backup as a CSV as I consider that the most versatile format - however I'd be interested in a more authoritative answer as well! Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/#findComment-1097194 Share on other sites More sharing options...
fenway Posted August 10, 2010 Share Posted August 10, 2010 SQL is useful if you want to repopulate the table. Otherwise, CSV is deal. Everything else is just silly. Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/#findComment-1097310 Share on other sites More sharing options...
Barand Posted August 10, 2010 Share Posted August 10, 2010 You might struggle storing those movies in a CSV Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/#findComment-1097502 Share on other sites More sharing options...
fenway Posted August 10, 2010 Share Posted August 10, 2010 You might struggle storing those movies in a CSV Good point ... missed that... then SQL. Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/#findComment-1097554 Share on other sites More sharing options...
joeyjj Posted August 10, 2010 Author Share Posted August 10, 2010 Cheers for the help guys! Quote Link to comment https://forums.phpfreaks.com/topic/210248-whats-the-best-way-to-export-a-database-to-store-in-an-offline-location/#findComment-1097746 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.