backup and restore database

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
tuxor
Veteran Member
Posts: 48
Joined: 2014-06-15 00:09

backup and restore database

Post by tuxor » 2015-01-30 18:00

Hi, do you have an example to backup and restore database?

thank you

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

Re: backup and restore database

Post by a.gneady » 2015-01-31 13:23

tuxor wrote:Hi, do you have an example to backup and restore database?

thank you
Please check this tutorial on backing up and restoring a MySQL database
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

DrKnow
Posts: 2
Joined: 2015-02-04 22:10

Re: backup and restore database

Post by DrKnow » 2015-02-04 22:16

Hello

You can also use PhpAdmin if you have Xampp installed.

If you run it as admin, select the database on the right panel should display structure. You can select all the tables and then with the drop select EXPORT which will dump the tables into a dump file.

You can also select the Export option too.

You will have to create the database again to restore the backup.

Here you simply IMPORT and choose file and go...viola!

I use this method to move applications with their data to client computer.

Hope this helps

peebee
AppGini Super Hero
AppGini Super Hero
Posts: 352
Joined: 2013-03-21 04:37

Re: backup and restore database

Post by peebee » 2015-02-05 06:54

This free application will perform remote and scheduled backups of your MySQL database, then send them via ftp to your chosen destination.

http://mysqlbackupftp.com

The free version has limitations but will be adequate in most circumstances. It does work - I've used it for a couple of years now. Nightly scheduled backups have never failed yet.

At $69 USD the Pro version is not a bad option either for the features provided.

PS: I have nothing to do with the product - I'm just a satisfied user.

tuxor
Veteran Member
Posts: 48
Joined: 2014-06-15 00:09

Re: backup and restore database

Post by tuxor » 2015-04-06 21:14

Hi, thank you for all your replies, but finally i found a code to make a backup of the database. I'll share the code in the forum to create a database just clicking in a button. It could be a great idea include the code in appgini, for all apps created.

thank you

HaroldNHulsey
Posts: 5
Joined: 2015-07-22 07:29

Re: backup and restore database

Post by HaroldNHulsey » 2015-07-22 09:07

The backup part of the strategy defines the type and frequency of backups, the nature and speed of the hardware that is required for them. The restore part of the strategy defines who is responsible for performing restores and how restores should be performed to meet your goals for availability of the database and for minimizing data loss.

Post Reply