1 / 5

Advanced Web 2012 Lecture 7

Advanced Web 2012 Lecture 7. Exporting SQL. Exporting your SQL to a singular file is an excellent way to create a portable backup. This SQL file is a single text file that can contain all of the information that is needed to recreate the database and the tables and the raw data if needed.

germane-blevins
Download Presentation

Advanced Web 2012 Lecture 7

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Web2012Lecture 7 Sean Costain 2012

  2. Exporting SQL Exporting your SQL to a singular file is an excellent way to create a portable backup. This SQL file is a single text file that can contain all of the information that is needed to recreate the database and the tables and the raw data if needed. If your system contained the following info and you needed a backup. Exporting is a great way to do this. Sean Costain 2012

  3. Exporting Cont. Steps for Exporting - Click You are then displayed the following: Click Go and Save the document Sean Costain 2012

  4. Exporting Cont. From the saved document you will get a tabl.sql file, in this case it looks like this: The SQL file is a text document, with SQL commands setup in it to restore the table and data. Sean Costain 2012

  5. Backup & Assessment Submission • When it comes to submitting your assessment item, you will zip up your htdocs folder, make an export of your entire database and then email it to me. • This is also a great way of having a backup. Store your data • Uni drive, so it is always with you on campus • Skydrive, so it is always with you anywhere • Dropbox, so it is always with you anywhere • Always, always make a backup of your files. • NB. You can recompress a zip file and your sql file together to make a single zip file. • When naming these files be descriptive • <name><date><version>.zip • Advweb-12-9-12-v2.zip • You can always put a time in the name as well, but versioning your backups will be just as effective. Sean Costain 2012

More Related