How can I put a database under git (version control)?

I'm doing a web app, and I need to make a branch for some major changes, the thing is, these changes require changes to the database schema, so I'd like to put the entire database under git as...

How can I clone an SQL Server database on the same server in SQL Server 2008 Express?

I have an MS SQL Server 2008 Express system which contains a database that I would like to 'copy and rename' (for testing purposes) but I am unaware of a simple way to achieve this. I notice that...

How can I retrieve the logical file name of the database from backup file

I was looking into the steps of how to Restore Database Backup using SQL Script (T-SQL). Here are the steps: Database YourDB has full backup YourBackUpFile.bak. It can be restored using following...

Backup a database mdf & Entity Framework

I have a database (mdf file) which I'm approaching with the Entity Framework. Is it possible to make a backup of the MDF file. I tried already but SMO but the problem is because I'm using a mdf...

SQL-Server: The backup set holds a backup of a database other than the existing

I am trying to restore a SQL Server backup file for my database, but it is throwing an error as follow: The backup set holds a backup of a database other than the existing My database in SQL...

XAMPP - MySQL shutdown unexpectedly

When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working. 12:19:12 PM [mysql] Attempting to start MySQL app... 12:19:12 PM...

Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1 So, for exporting table dumm I do: Right click on table, then in menu click on backup, then in Format choice Plain and save file as some_name.sql Then I remove...

Mongodump from remote server

We recently ported some data over to MongoDB and are now looking into running daily backups, preferably from a cron job, and restore one of the backups to a secondary mongo database. Our system is...

Postgres 9.3 Backup and Restore Error

Fine i have taken backup of my database using "pg_dump" utility(dump file name is "testbackup.sql").Before restoring it back,i dropped all tables,view,sequences,functions which i have created....

The fastest backup/restore strategy for Azure SQL databases?

What is the fastest way to backup/restore Azure SQL database? The background: We have the database with size ~40 GB and restoring it from the .bacbac file (~4GB of compressed data) in the native...

How to create copy of database using backup and restore

Using SQL Server Management Studio 2012, I'm trying to create a copy of a local database. I found a few variants of solution. One of them - backup and restore database as new one - HERE. Currently...

How do I set mysql error log to to capture mysql syntax error

I am using ubuntu, apache, mysql. I want to capture mysql syntax error in the mysql error log file. In /etc/mysql/my.cnf configuration file, I did something like this:: general_log_file =...

MySQL running very slowly on local IP Server running Windows 7

I have installed MySQL on Machine running Windows 7. That system is dedicated for MySQL and SVN only. No-one else is using that system except I have remote access to that system for setups and...

improve speed of mysql import

I have large database of 22GB. I used to take backup with mysqldump command in a gzip format. When i extract the gz file it produces the .sql file of 16.2GB When I try to import the database in my...

pg_dump postgres database from remote server when port 5432 is blocked

I'm trying to pg_dump a SQL database on a remote server in our DMZ. There are 2 problems. there is n't a lot of space left on the remote server so the normal command run to locally backup the...

pg_restore in postgres docker container

I am trying to restore database in PostgreSQL docker container using pg_restore from a shellscript taht will be called from docker file .I am getting following error "ERROR: canceling autovacuum...

PgAdmin 4: Terminate database backup process

I am attempting to back up a PostgreSQL database from pgAdmin 4, but a pg_dump backup process is already running, and I am unable to stop it. I've restarted the postgres server, restarted the...

Cant use AWS RDS Native Backup on MSSQL Database

I'm moving resources from one AWS account to another and I need to move a database - the native database backup doesn't seems to work. I configured the IAM Role and the RDS database has the...

Why Logical Name is different from .bak file in SQL Server

I am restoring a backup file and i encountered an error. It says something like Use FileListOnly" to get logical name of file. When I run this query, restore filelistonly from...

RDS server backup

Intention is to export RDS and load data to local mssql DB. Getting below errors when trying to backup rds server. SQL Statement used to initiate: USE [msdb] GO DECLARE @return_value int EXEC ...

barman PostgreSQL: FAILED

I am in the process of setting up a database backup system using Barman. My database is a postgreSQL db. When I run barman check main-db I get the following error: PostgreSQL: FAILED ...

Cannot Start MYSQL Server Mac

I am currently trying to run mysql server on a mac, but the Start MySQL Server from the preferences pane doesn't work, and neither does starting it from the Terminal. I have found a lot of fixes,...

Golang Error with Backing up the DBmssql: BACKUP DATABASE is terminating abnormally

I am trying to do a full backup for an MSSQL database using go. However, I tested the connection to the MSSQL server and it works like charm! By executing also a query into the code SELECT...

In laravel npm run dev errors:

I have next errors output running npm command for my laravel 5.6 with bootstrap project: $ npm run dev > @ dev /mnt/_work_sdb8/wwwroot/lar/B4test > npm run development > @ development...

Keep XAMPP & Install WAMP

I am using Windows 7 and I have XAMPP installed. In Git Bash when I type php -v I get PHP 5.6.15. I need newer version of PHP because I am using Composer and I am unable to install packages that...

Issue Deploying Install/Updates On GitHub with ClickOnce

I've been trying to figure out the best way to deploy a WPF application with ClickOnce. I'd download the setup file from the GitHub URL, and cross my fingers, and run into this every...

How to restore a postgres backup - ERROR: cannot drop the currently open database

I'm trying to restore a postgres backup from a system that is no longer provisioned, and I'm getting a range of errors, depending on what I try. I have only the backups, no original servers to...

Aborted the task because of a task failure or a concurrent HA_RESTORE_DB request. while restored S3 to RDS

I have uploaded the backup file to S3 using CLI I am I am getting an error while restoring the database from amazon s3 I have using below commands to restore the database exec...

How to compress postgres database backup using barman

We are backing up 1TB+ of postgres database using barman. Barman is backing up full database daily. Every day we are dumping 1TB+ database. So it's consuming huge space. We have following...

Developing Strapi locally and deploy on production server

I am using Strapi as a headless cms for my website. First I have started one version only on the production environment and there was no other environment like development or staging. So when I...