Transcript class 17 - Temple Fox MIS

MySQL Backup, Transfer and Restore
MIS 3501, Fall2016
Brad N Greenwood, PhD
Department of MIS
Fox School of Business
Temple University
10/25/2016
Objective
• We want to be able to move our work from our
personal development systems (e.g. your laptop,
or the class computers) to a server.
• Only when your code and data have been made
available on a server environment will they be of
any practical use.
2
A tale of two systems…
Your System
The MIS3501 server
Apache Web
Service
Apache Web
Service
PHP
Interpreter
PHP
Interpreter
MySQL
MySQL
3
They are not automatically “synched”. Direct
database connectivity is not permitted.
Your System
The MIS3501 server
Apache Web
Service
Apache Web
Service
PHP
Interpreter
PHP
Interpreter
MySQL
MySQL
4
We need to do two things
Your System
Apache Web
Service
#2 Copy the files
(.php, .css, .html,
etc.)
MIS3501
Apache Web
Service
PHP
Interpreter
PHP
Interpreter
MySQL
MySQL
#1 Backup,
Transfer, and
Restore our
database tables
But look out!
When our database
moves, our connection
credentials will change
5
So here is the process…
#1. Get
your code
working
locally.
#2. Upload
your
database to
the server.
#5. Test. Is
the code
working on
the server?
#4. Copy
your php
files using
SSH
#3. Update
your
connection
parameters
6
Time to give it a try…
7