Backup/Restore + Data Export/Import via dbForge Studio
Without a doubt, you want your backup/restore and export/import operations to be fast, easy, and automated wherever possible. You can have it all that way with dbForge Studio for MySQL. As the name implies, it is an IDE for MySQL development, management, and administration, yet it works just as perfectly as a MariaDB GUI client. Now, let's see how it tackles routine database backups.
Create a MariaDB backup
1. On the Database menu, go to Backup and Restore, and click Backup Database to open Database Backup Wizard.
2. On the General page, specify the required connection and database, the path for the backup file to be saved to, and the output file name in the respective fields. Optionally, you can append a timestamp to the file name, enable the auto-deletion of old files, and compress your backup into an archive. After you set it all up, click Next.
3. On the Backup content page, select the content for your backup and click Next.
4. On the Options page, configure your detailed backup options—there are quite a few of those to match your requirements most precisely. Then click Next.
5. On the Errors handling page, configure the Errors handling and Log settings options. Afterwards, click Backup to run the backup process.
Note that you have two more options here: you can select Save Project to save your current backup project with all the settings—or you can select Save Command Line to save a backup script that you can execute from the command line whenever you need.
6. After you click Backup, wait for the backup process to be completed.
Note that you don't have to go through every wizard page to click Backup. You can do it whenever you've finished configuring your settings.
7. Finally, confirm the successful completion by clicking Finish.
As you can see, it's very easy. Furthermore, you can schedule to run regular backups using Action > Create Basic Task in Windows Task Scheduler.
Restore a MariaDB backup
This is an even faster task, done in half as many steps.
1. On the Database menu, go to *Backup and Restore, and click Restore Database to open the Database Restore Wizard.
2. On the Database Script File page, specify the required connection and database, as well as the path to the previously saved backup file.
3. After that, click Restore, and let the Studio do the rest for you.
And when it's done, click Finish, and there you have it.
You can learn more about this functionality on the dedicated backup/restore page. Please note: while the page focuses on MySQL databases, everything that's described there is just as perfectly applicable to MariaDB from the same Studio with the same workflow.
Export data from MariaDB
With dbForge Studio, you can export data to 14 most popular formats: HTML, TXT, XLS, XLSX, MDB, RTF, PDF, JSON, XML, CSV, OBSC, DBF, SQL, and Google Sheets. You can do it with an easy-to-follow wizard that guides you through the entire process and delivers quite a few customization options.
Let's see how it works. And before we start, note that different formats may have slightly different wizard pages. In our walkthrough, we'll take the HTML format as an example.
1. To open the export wizard, on the Database menu, click Export Data.
2. On the Export format page, pick the required format and click Next.
3. On the Source page, select the required connection, database, as well as tables and views to be exported. Then click Next.
4. On the Output settings page, specify the path for the output, select to export data into a single or several separate files, and configure a few other settings, such as timestamps and compression. Then click Next.
5. On the Options page, configure and preview table grid options for exported data. Click Next.
6. On the Data formats page, you have two tabs. On the Columns tab, you can check the list of columns to be exported.
Then, on the Formats tab, you can adjust the default format settings for Date, Time, Date Time, Currency, Float, Integer, Boolean, Null String, as well as select the required binary encoding.
Once you make sure everything is correct, click Next.
7. On the Exported rows page, select to export all rows or define a certain range of rows, and then click *Next.
8. On the Errors handling page, configure the errors handling behavior and select to keep a log file, if necessary.
But before you click Export, note that you can save templates with your settings for recurring export operations. To do that, click Save in the lower left corner of the wizard, specify a name and a destination for the template file to be saved to, and then click Save.
Also note that you don't have to go through every wizard page to click Export. You can do it whenever you've finished configuring your settings.
9. Finally, after you click Export, watch the progress and click Finish upon completion.
