Questions tagged as 'backup'

7
answers

How to back up daily Mysql Database?

Is there any free tool, or even a script ( .bat ) that I can use to make an automatic backup of my database? > I would like this backup to be generated by saving a single file .sql .     
asked by 31.01.2014 / 14:39
1
answer

Generate database backup

In my project, I have a database that has a lot of registry. So I wanted SQL Server to do a backup a day or a week. But I think the per day is better. But how can I make this script to be scheduled in SQL Server and it does the scheduled...
asked by 27.11.2014 / 13:23
1
answer

Backup of all tables except one

In MySQL we can perform terminal backups as follows: Database mysqldump nomeBaseDados > meuFicheiroBackup.sql Table mysqldump nomeBaseDados nomeTabela > meuFicheiroBackupDaTabelaX.sql How can I back up all tables in my nome...
asked by 17.10.2014 / 21:28
3
answers

Bash - Mysql Backups

I set up the script below to perform backups of three Mysql databases. I wonder if it's correct. #VARIAVEIS DATE='date +%Y%m%d-%H%M' HOSTNAME1="xxxxx" HOSTNAME2="yyyyy" HOSTNAME3="zzzzz" USER='xyzedmar' PASSWORD='xyz2' DATABASE1='xxxxx' DATABA...
asked by 07.12.2015 / 22:51
1
answer

MySQL Backup with Event Scheduler

I would like some tips on how to back up a mysql database with Event Scheduler. I just got in my searches, find event to back individual tables. I would like to be able to backup the whole database, can anyone help me? (this code is just...
asked by 05.01.2015 / 14:07
1
answer

How to check SQL backup integrity

I'm using MySQL , and to back up the banks, I'm using mysqldump . My question is if and how can I check if the file generated by the dump is intact automatically, without having to "upload" the dump into the bank?     
asked by 28.08.2014 / 19:20
2
answers

Backup database sql server express using .bat

I made the creation of a .bat file 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';...
asked by 24.11.2016 / 14:13
3
answers

Is it possible to back up a remote bd sql server via C #?

I am using the Microsoft.SqlServer.Management.Smo assembly to back up a Sql Server database in C #. The problem is that in the way it is implemented I can only perform the action if I am running the application on the same database server. Wo...
asked by 14.04.2015 / 14:41
1
answer

How should the perfect wordpress blog backup be done?

I've been looking for some time on the internet how to backup the theme I'm developing in wordpress and database . I use xampp and banco de dados in phpMyAdmin . I've found several tutorials, but I'm not feeling secure...
asked by 20.12.2015 / 00:53
2
answers

How to back up the database to the cloud and how to have data synchronized across multiple devices?

Good people, my doubt is as follows. 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 this database to Cloud (Own server or Google if it has some implem...
asked by 01.10.2015 / 22:08