Most voted "backup" questions
Backup is the copy of data from one storage device to another so that they can be restored in case of loss of the original data.
Learn more…71 questions
Sort by count of
-
14
votes8
answers26648
viewsHow to backup Mysql Database Diaries?
Is there any free tool, or even a script (.bat) that I can use to make a backup automatic from my database? I wish that backup was generated by saving a single file .sql.…
-
10
votes4
answers1358
viewsConceptual database and file backup strategy
This is a conceptual question that fits into two on-topic themes of Software architecture and engineering. Concepts and practice and database question involving SQL on server. As this type of…
-
7
votes1
answer2867
viewsBackup all tables except one
In Mysql we can perform backups via terminal as follows: Database mysqldump nomeBaseDados > meuFicheiroBackup.sql Table mysqldump nomeBaseDados nomeTabela > meuFicheiroBackupDaTabelaX.sql How…
-
7
votes1
answer252
viewsGenerate database backup
In my project, I have a database that has a lot of record. So I wanted SQL Server to make a backup per day or per week. But I think the per day is better. But how can I do this script to be…
-
7
votes3
answers339
viewsBash - Mysql backups
I rode the script below, to perform backups of three Mysql bases. I would like to know if it is correct. #VARIAVEIS DATE=`date +%Y%m%d-%H%M` HOSTNAME1="xxxxx" HOSTNAME2="yyyyy" HOSTNAME3="zzzzz"…
-
5
votes1
answer903
viewsHow to check SQL backup integrity
I’m using MySQL and, to back up the banks, I am using the mysqldump. My question is whether and how I can check if the file generated by the dump is intact automatically, without having to "upload"…
-
5
votes1
answer688
viewsMysql Backup with Event Scheduler
I would like some tip on how to backup a mysql database with Event Scheduler. I only got in my searches, find Event to back up tables individually. I wish I could back up the whole bank, someone can…
-
5
votes2
answers5281
viewsBackup sql server express database using . bat
I created a file .bat with the content: USE T4FAT; GO BACKUP DATABASE T4FAT TO DISK = 'C:\Dropbox\MF-YCORN\BK_MF\T4FAT.Bak' WITH FORMAT, MEDIANAME = 'T4FATBackups', NAME = 'Full Backup of T4FAT'; GO…
-
4
votes3
answers1608
viewsIs it possible to backup a remote bd sql server via c#?
I am using Assembly Microsoft.SqlServer.Management.Smo to back up an Sql Server database to c#. The problem is that the way it is implemented I can only perform the action if I am running the…
-
4
votes1
answer113
viewsHow should the perfect backup of wordpress blog be done?
I’ve been looking on the Internet for a while how to backup the theme I am developing in wordpress and database. I use the xampp and the banco de dados in the phpMyAdmin. I found several tutorials,…
-
4
votes1
answer9873
viewsHow to backup a Postgresql database via pgAdmin 4
I am trying to generate a backup of my Postgresql database through pgAdmin 4, but every time I try to backup an error occurs: I am configuring the Postgresql preferences as follows: And when I set…
-
3
votes1
answer1046
viewsWhat is the best way to make an online database backup
There is a client of mine who owns two machines, one of them is the server where all the data of the bank is, and the other is the cashier. However, there is customer concern in case something…
-
3
votes2
answers1978
viewsIn Postgresql, is there a difference between running a dump or exporting?
this question really left me in doubt, as in postgres there are three types of backup/Restore that are: SQL Dump (Generates a text file with SQL command) File System Level Backup (Save PG Data File)…
-
3
votes2
answers2742
viewsHow to backup the database to cloud and how to have the data synchronized across multiple devices?
Well folks my question is this. I have an App that has a local Sqlite database. I want to know if you have any library, framework, code that does the following: Backup that database to Cloud…
-
3
votes1
answer1101
viewsincremental vs differential backup in SQL Server
Whenever I need to set up the backup routine of an SQL Server database I confuse these two types of backup. Therefore I would like to know: What each one does? Whereas I do a full backup on Sunday,…
-
2
votes1
answer109
viewsBackup 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 to backup all Databases together? Each one in a…
-
2
votes1
answer1272
viewsHow to change the name of the target database when performing the restore? (Restore C# .net class)
I am backing up and re-storing an SQL Server database using the C# NET Backup and Restore classes with Smo. The problem is that after backing up the database with the name, for example "Test", I…
-
2
votes1
answer128
viewsHow do I restore a database from postgres logs?
I have the database logs I get through the commands pg_start_backupand pg_stop_backup. I wonder how do I restore the bank through them? Thank you!
-
2
votes1
answer263
viewsgdrive error in crontab
I am trying to accomplish a way to perform a backup using mysql and transfer the data to the cloud from google drive. I am using the mysqldump to carry out the backup and the gdrive to upload to the…
-
1
votes3
answers864
viewsDifference between ways to perform a backup (Disk space, buffer, etc.)
Suppose I have a machine with 10GB free disk space, and I have a backup script from a database postgresql, that when run, it backs up locally and just after finished, copies to another remote…
-
1
votes0
answers49
viewsBackup System in Php and Mysql (with Codeigniter)
Intending to put in my software a database backup system, where the user will perform this backup manually. Only I have never done this procedure, and I am using the Codeigniter framework. Could…
-
1
votes2
answers1731
viewsI can’t restore my backup
I backed it up once and it all worked out. Now more tables, views w wtc have been created and I need to update the database. As the bank is at a network address and for security, we have no way to…
-
1
votes1
answer1688
viewsSecure backup using Mysql and C#
My application is C# and BD is Mysql, when I do the backup he creates a arquivo.sql. That one arquivo.sql can be easily edited in a notepad, or any other editor, thus leaving my comic very truthful,…
-
1
votes2
answers457
viewsAutomated backup in SQL Server Express
In my current scenario I have a service of Windows which rotates in the background which at a specified time by me rotates a batch that makes the backup and saved in the Dropbox. But what happens is…
-
1
votes1
answer87
viewsBackup Windows Server 2008 FTP and Cloud
I need to generate daily backups on a server windows server 2008 R2, the backups are several folders and applications installed on this server, windows server has tool for this, some tool of the own…
-
1
votes2
answers2695
viewsPerform backup automatico Mysql
I am using Mysql as DBMS, and when searching the internet a way to create a routine backup found that the old versions had a tool that no longer exists in the newer versions, I believe that those…
-
1
votes2
answers183
viewsBatch file anchored
How do I get a batch anchored to a folder for a backup operation on a USB stick where the drive letter always changes example: @echo off mkdir ..\subs move /y .\*.srt ..\subs pause exit…
-
1
votes1
answer674
viewsImport Sql Server Backup and Differential
I’m having a problem importing a backup to the secondary server: The topology: Server Production >> Server contingency. When Full Backup is imported it matters without any problem. The problem…
-
1
votes1
answer928
viewsBackup and Restore using Postgresql in C#
To back up or re-store a database through a C# application using the Postgresql DBMS, you need to send a command to pg_dump. It is possible to execute it via a select by sending an Executenonquery…
-
1
votes1
answer789
viewsCan you create a cron to delete files with retroactive dates?
See my need, I have a cron that runs every morning and creates a file.ddmmaaaa.backup on the Linux Kubuntu server, it happens that the hard drive fills up quickly since this backup file has 500MB on…
-
1
votes2
answers334
viewsCheck Consistency of a SQL Server backup in C#
How can I verify the integrity of the backup file of an SQL Server database in C#?? I used the following namespace and classes to generate the backup: Microsoft.SqlServer.Management.Smo {…
-
1
votes1
answer40
viewsBackup Database - error in SQL Syntax
I am building a button to make a backup of mine dbvia application C#, everything is going well, but at the time of applying the Executenonquery is accusing error of syntax. Follows: Designate Path:…
-
1
votes3
answers6281
viewsFile . bat to generate backup and Restore in Postgresql
I am creating . bat files to backup and restore a database in Postgresql using windows 10 and pg 9.4 I perform the following command to perform the backup set PGUSER=postgres set…
-
1
votes1
answer186
viewsError while trying to perform postgresql database backup
I am trying to perform a backup of a database in Postgresql, however I am getting the following error: erro ao ler objeto grande 118287: ERROR: permission denied for large object 118287 I searched…
-
1
votes1
answer213
viewsLinux - Copy only attributes of files into a folder
At first... I had a problem with my partitioning and needed to reset my hard drive. I am running Linux Mint 19 on Live-CD (USB) to be able to copy the contents of my /home folder (which was on…
-
1
votes1
answer1000
viewsConversion from . FRM to . SQL
I have a 300MB database and all I have are 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…
-
1
votes0
answers35
viewsSQL Server Base with encrypted columns
I have an SQL database in which I encrypted some columns following the steps of the following explanation: https://www.devmedia.com.br/criptografia-de-dados-no-sql-server/37027 I basically created…
-
1
votes0
answers201
viewsError while restoring mysql backup
Good afternoon Personal. I have a problem related to the backup and restoration of data from a Mysql database. I generated a backup of the data using mysqldump to format the pc and install a new…
-
0
votes1
answer354
viewsHow to Dump in Mysql for the file to contain the date?
I would like to do a Dump in my Mysql database, but I need this Dump to create the.sql file with the date Dump was made, so that I have saved all previous backups by date.
-
0
votes1
answer126
viewsBackup SQL SERVER database
I have a database stored on the client’s server. I only have access to the Connection string of this database, so I can manage it, as I can back up the bd on Server for My Local Machine, for…
-
0
votes0
answers90
viewsHow do I make an incremental backup script in a postgresql database?
I would like to know how to make a script . sp1 to make a daily incremental backup? Gratitude!
-
0
votes1
answer178
viewsHow to verify integrity or violations in SQL Server database?
I created an application to run in the background to back up my SQL Server database using the class Backup of Microsoft.SqlServer.Management.Smo. I would like to add to this backup tool something…
-
0
votes0
answers40
viewsError back-up wordpress folder wp-content hosted on hostgator
I need to migrate a website WordPress (Woocommerce) from Hostgator to Digital Ocean. However, I cannot access the folder wp-content. I already backed up the entire site via Hostgator, but it comes…
-
0
votes1
answer588
viewsbackup of specific mysql content data via java
Hello, I have the following method that backs up my database: public static void makeBackup() throws IOException{ String caminho = "C:\\Program Files\\MySQL\\MySQL Workbench 6.3 CE\\mysqldump.exe";…
-
0
votes1
answer20
viewsWordpress - Backup/clone help
I’ve been doing a job that the customer has required their site to stay online and the same way until all the changes are made. How can I do that ?? Would I have to use another domain?? I would like…
-
0
votes1
answer937
viewsRunning SQL Server External HD Database
I am starting the construction of a web application using SQL Server and talked to my client to provide the backup of the database avoiding access to its production base, because it has no…
-
0
votes1
answer277
viewsBackup Incremental Postgresql PITR
I have an incremental backup routine running daily saving the logs from Postgresql. Every morning the full backup is performed: pg_start_backup() tar -cvzf /usr/local/pgsql/pgDataPITR/pgdatabk.tar…
-
0
votes1
answer345
viewsHow to remove folders from a directory
I have a project in Delphi 2010 in which I use to compress and create backups Winrar, through the following code I can compress the following folder teste3: AFile := 'C:\teste1\teste2\teste3';…
-
0
votes1
answer901
viewsBackup and Restore in Delphi with Sql Server how to do?
Hello I would like to know how I can do a Backup and Restore to integrate in my system. I have a code ready but is for Firebird I believe that does not fit to Sql Server. I read in some topics that…
-
0
votes0
answers716
viewsRetrieve Java Class Code in Netbeans
My computer suffered a forced shutdown due to a surge of light and when I reopened my project in Netbeans (8.2) one of the classes was empty, there is some way to retrieve such code?