How to Manually Back-Up MySQL Database
MySQL database back-up can be really useful if you are going to upgrade your store, load a new csv file, or just to have in case anything happens to your server. Manually backup is a very good idea and most of the developers do it.Back up the database
For back up the database you are going to need to login to the cpanel for your site. They are located at cpanel.yourdomain.com or domain.com/cpanel. For login please see below screen.
From this you can login to your cpanel login information refer to the email your host set up when you created your account or email them for asking to the login information. Also sometimes your cpanel login is the same as your ftp login, but that is not always the case. Once you are logged in, look for the phpMyAdmin icon at the bottom under the headings databases. For this please see below screen.
After that click on the icon and your database will be open. Click on the Database menu (located in the upper left corner of the page) that you want to backup from the left column. Please see below screen.
When you click on your database (prestashop) from the left column it will open a view that shows all of the tables in your database. After you click on Export in the top menu. For more information please see below screen.
After that click on Export to see the next screen with two export method.
- Quick export.
- Custom export.
For size limitations and Prestashop 1.6 databases can get large, select custom and press Go button. And then need to select the gzipped option under the compression, as it is universally supported.
Now press Go button and then your Prestashop database start to download.
When you have a complete backup of your database. If any problems to your site, you will be able to restore your back up database.
How to Manually Back-Up PrestaShop Files via FTP
Back up your website is a necessary step for all users. First things you need to login information to login FTP. When you signed up for your web hosting you should have received an email with FTP information.
However, if your site is very large you'll want to use an FTP client to download your website files instead. I recommend Filezilla, it is the most popular on these days.
Please see below steps backup your files using the Filezilla FTP client.
- Download and Install Filezilla
- Use Filezilla to connect to your account
After you have downloaded and installed Filezilla, use login information to connect to your ftp account.
Host : Enter host name (yourdomain.com)
Username : Enter your username here.
Password : Enter your password here.
Port : You can leave the port blank or the default port number is 21.
Please see below ftp account screen to quick connect feature.
3. Download your files
After you have connected, you can then download your files. First to create new folder "Website Backup". As per the below screens.
After that right click on any of the highlighted public_html directory and click "Download". This will download all of your files / folders to the "Website Backup" folder that we created. Please note that the time it will take to download all of your files will depend on the number of files / folders that you have and how large they are. Please see below screens.
The following time that your files will ever need to be backed up again is if you
- Add new products/category to your site.
- Install or remove any modules.
- Install another template.
- Edit your existing template.
- Upgrade your shop.
- Or any changes to core files.
