Deployment, Security, and Maintenance To restore from the backups, all we need to do is browse for the file we wish to restore from, and then click on Upload. When restoring, any existing database or home directory content will be removed, so only do this if you really need to. If you need to gain access to a specific file that you need to back up, decompress the home directory backup, look for the file, and upload it to your site using an FTP client. Using the command line An alternative method to back up and restore our site is by using the command. | Deployment Security and Maintenance To restore from the backups all we need to do is browse for the file we wish to restore from and then click on Upload. When restoring any existing database or home directory content will be removed so only do this if you really need to. If you need to gain access to a specific file that you need to back up decompress the home directory backup look for the file and upload it to your site using an FTP client. Using the command line An alternative method to back up and restore our site is by using the command line. Command Line Access and PuTTY Most shared hosting accounts won t provide command line SSH access by default but many will enable it on request for your account. Simply file a support ticket with your host to request this and if they allow it they will provision it for you. To connect to the server using SSH you can either use the terminal interface on a Mac or Linux or on Windows use a program such as PuTTY a free SSH client available from http sgtatham putty . Backing up the site and database Once connected through SSH to the server we need to navigate to the location of our site. In most cases this will be home ourusername. cd home dinospac Then we can compress the public_html folder to a single file using tar cvzf public_html With the folder compressed we need to move it to within the public_html folder so we can download it by visiting mv public_html The following command exports our database to a web-accessible location on our server where we can download it using a web browser mysqldump -u username -p databasename home dinospac public_html 392 Download from Chapter 12 After executing this command we will be prompted for our password and then we can download the file from our browser. Once downloaded it is important that we remove the database and site downloads immediately so that it is not .
