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. 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! 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. 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 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. 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! 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
Archived
This topic is now archived and is closed to further replies.