Online Database Backup

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
uchhavi
Veteran Member
Posts: 66
Joined: 2018-05-15 14:07

Online Database Backup

Post by uchhavi » 2019-04-24 08:07

Hello

I went through the tutotials and backup section.

I think it talks about the backup on of the database stored in the local drive.

I want to take backup of the database on my website. How to do it. and then how to restore it?

I do have a normal way of database backup setup on my site, is there anything special i need to do while backing up for appgini database?
and then restoring it. Please advise.
Best regards,

Chhavi Jain

uchhavi
Veteran Member
Posts: 66
Joined: 2018-05-15 14:07

Re: Online Database Backup

Post by uchhavi » 2019-04-29 18:32

Please can someone help?
Best regards,

Chhavi Jain

pböttcher
AppGini Super Hero
AppGini Super Hero
Posts: 608
Joined: 2018-04-01 10:12

Re: Online Database Backup

Post by pböttcher » 2019-04-29 20:30

Hi,
not sure what exactly you are looking for. Usually you should stop your database (or with AppGini you could put it maintenance mode), backup your database and restart your database.
For restore, the same applies.

uchhavi
Veteran Member
Posts: 66
Joined: 2018-05-15 14:07

Re: Online Database Backup

Post by uchhavi » 2019-04-30 08:53

hi,
can u please tell the procedure to do it.
I want to understand the backup process of the online database.
Best regards,

Chhavi Jain

kbarrett
Veteran Member
Posts: 50
Joined: 2019-02-24 16:35
Location: Calgary Alberta

Re: Online Database Backup

Post by kbarrett » 2019-04-30 15:23

Uchavi,

Here is a blog link that provides instruction on moving your app to a server. In it there is instructions on using the back up process within the the AppGini generated app:
https://bigprof.com/blog/appgini/moving ... ew-server/
An easy process that essentially automates the back up process that is on the tutorial.

uchhavi
Veteran Member
Posts: 66
Joined: 2018-05-15 14:07

Re: Online Database Backup

Post by uchhavi » 2019-05-03 06:58

hi kbarrett,

thank u for the link. it was helpful.

however i want to know if i need to know. that is after creating the backup i want to download it to the local drive, how to do it.

I need to create database backup on my local drive.
Best regards,

Chhavi Jain

kbarrett
Veteran Member
Posts: 50
Joined: 2019-02-24 16:35
Location: Calgary Alberta

Re: Online Database Backup

Post by kbarrett » 2019-05-03 14:19

Hi Uchavi,

You can FTP into your server and download it no different that if you had created the application on your local machine, did a back up and uploaded to your server. When you FTP into your server switch to the directory where your app is located, switch to the admin folder then backup. You should then see an SQL file with some sort of hash file name an a file extension of .sql, download that file. I hope that helps.

User avatar
a.gneady
Site Admin
Posts: 1033
Joined: 2012-09-27 14:46
Contact:

Re: Online Database Backup

Post by a.gneady » 2019-05-08 11:35

In the admin area > Utilities menu > Database backups. From there, you can create a backup with a button click or restore an existing one. You don't need to put the site in maintenance mode first, as this is done automatically during backup/restore. If you want to download the backup to save it somewhere else, you can find it in admin/backups folder.
:idea: Learn all the tips and tricks of customizing AppGini apps through our online course.
:arrow: Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
:arrow: Summary Reports plugin: Build powerful reports and charts for your AppGini apps.
:arrow: Search Page Maker: Compose user-friendly yet powerful search pages for your AppGini apps.

uchhavi
Veteran Member
Posts: 66
Joined: 2018-05-15 14:07

Re: Online Database Backup

Post by uchhavi » 2019-05-09 19:18

thank u so much... this iw exactly what i wanted to know.
Best regards,

Chhavi Jain

Post Reply