database-backups
mySQL daily backup from one table to another
If I have 2 tables with the same definition, how would I backup data from it daily? Can I use mySQL Administrator to perform something like this[详细]
2023-01-31 21:39 分类:问答SQL Server 2008 Backup Transaction Logs
I understand that the transaction logs keep a record of historical transactions in order to facilitate a restore if needed. However do I need to keep creat开发者_如何学JAVAing transaction log backups[详细]
2023-01-27 08:25 分类:问答Is it viable to handle MySQL backups with git?
Today I had this really neat idea for backing up my database: put the dump file in a git repository, then commit on each dump so that I have both the most recent copy, but can easily roll back to any[详细]
2023-01-26 20:38 分类:问答Is there any embedded database/files backup framework for Java?
开发者_运维百科I\'m trying to find a Java library/framework, which I can add to my WAR and enable regular backup of files and databases (started on my own timer). I don\'t want to use a standalone sol[详细]
2023-01-26 16:53 分类:问答Backing up a SQL Server database from hard disk with stored procedures?
I can backup a database on hard disk with the following method : void BackUp(string ConnectionString, string DatabaseFullPath, string backUpPath)[详细]
2023-01-26 09:13 分类:问答Bash script to scp newest file in a directory on a remote server
Ok so I kinda know how to do this locally with a find t开发者_JAVA技巧hen cp command, but don\'t know how to do the same remotely with scp.[详细]
2023-01-23 14:12 分类:问答Replace a database MDF file with backup file during runtime in C#
I\'ve written quite a long C# program using Linq to Sql an开发者_运维问答d my data are stored in an MDF file located near my program\'s EXE.[详细]
2023-01-22 09:38 分类:问答How to Exclude Data for Specific Tables
I am using mysqldump to create a canonical installation script for a MySQL database. I would like to dump the data for able half of the tables in the database, but exclude the data from the other tabl[详细]
2023-01-22 02:55 分类:问答mysqldump Fully Qualifies Triggers with Database Name
I\'m am trying to use mysqldump to export a database which needs to be imported using a different database name. Looking at the SQL generated by mysqldump, it appears that triggers are the only object[详细]
2023-01-21 05:12 分类:问答Throttling i/o in postgres's pg_dump?
So we have a production database that is 32GB on a machine with 16GB of RAM. Thanks to caching this is usually not a problem at all. But whenever I start a pg_dump of the database, queries from the ap[详细]
2023-01-19 00:22 分类:问答