Hi, do you have an example to backup and restore database?
thank you
backup and restore database
Re: backup and restore database
Please check this tutorial on backing up and restoring a MySQL databasetuxor wrote:Hi, do you have an example to backup and restore database?
thank you
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.
Re: backup and restore database
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
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
Re: backup and restore database
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.
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.
Re: backup and restore database
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
thank you
-
- Posts: 5
- Joined: 2015-07-22 07:29
Re: backup and restore database
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.