Questions tagged as 'backup'

1
answer

What is the best way to do a database backup online

There is a client of mine that has two machines, one of which is the server where all the data in the database is stored, and the other is the box. However, there is the customer's concern that something happens to the server that the data is...
asked by 06.02.2014 / 15:57
1
answer

How to back up a PostgreSQL database using pgAdmin 4

I'm trying to generate a backup of my PostgreSQL database through pgAdmin 4, however whenever I try to backup an error occurs: I'msettingthePostgreSQLpreferencesasfollows: AndwhenIsetupthebackupI'mdoingitthisway: Ifyouhaveanysuggestionsastow...
asked by 30.11.2016 / 12:30
1
answer

incremental vs differential backup in SQL Server

Whenever I need to configure the backup routine of a SQL Server database I confuse these two types of backup. So I'd like to know: What does each one do? Given that I do a full backup on Sunday, when I have to restore a database do I have...
asked by 15.03.2017 / 18:07
2
answers

In PostgreSQL, is there a difference between running a dump or doing an export?

This question really left me in doubt, because in postgres there are three types of backup / restore which are: SQL Dump (Generates a text file with SQL command) File System Level Backup Continuous Archiving I wonder if these forms ar...
asked by 26.07.2014 / 18:31
1
answer

How to change the name of the target database when performing the restore? (Class Restore C # .NET)

I am backing up and restoring a SQL Server database using the C # .NET Backup and Restore classes, with Smo. The problem is that after performing the backup of the database with the name, for example "Test", I can not restore the database with a...
asked by 20.01.2015 / 12:45
1
answer

Backup Database SQLServer

I know that to perform a backup in SQL Server just use: BACKUP DATABASE nome_database TO DISK = 'endereco\nome__arquivo.bak' But does anyone know how I back up all Databases together? Each in a .bak ?     
asked by 10.11.2014 / 21:24
1
answer

How do I restore a database from logs in postgres?

I have the database logs that I get through the pg_start_backup and pg_stop_backup commands. I would like to know how do I restore the bank through them? Thank you!     
asked by 11.09.2015 / 14:55
1
answer

.bat file to generate backup and restore in PostgreSQL

I am creating .bat files to perform the backup and restore of a database in PostgreSQL I use windows 10 and pg 9.4 I execute the following command to perform the backup set PGUSER=postgres set PGPASSWORD=postgres123 "C:/Program Files/Postg...
asked by 27.10.2017 / 00:26
1
answer

Secure backup using MySQL and C #

My application is C # and BD is MySQL, when I do the backup it creates a arquivo.sql . This arquivo.sql can be edited easily in a notepad, or any other editor, thus leaving my bd well summery, how can I do that nobody edits my BD...
asked by 30.01.2015 / 21:15
1
answer

Convert .FRM to .SQL

I have a database of 300MB and I only have the FRM, MYI and MYD files. I need to convert the FRM files first to create the structure of the tables, I have already used the following tools and methods and I did not succeed: link Error: ER...
asked by 11.09.2018 / 01:17