Advanced web 2012 lecture 7
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Advanced Web 2012 Lecture 7 PowerPoint PPT Presentation


  • 90 Views
  • Uploaded on
  • Presentation posted in: General

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.

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Advanced web 2012 lecture 7

Advanced Web2012Lecture 7

Sean Costain 2012


Exporting sql

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


Exporting cont

Exporting Cont.

Steps for Exporting - Click

You are then displayed the following:

Click Go and Save the document

Sean Costain 2012


Exporting cont1

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


Backup assessment submission

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


  • Login