backup – Page 4 – Tarik Billa

How to take a backup for the ‘connection details’ in sqldeveloper?

May 25, 2023 by Tarik

The ‘oracle sqldeveloper’ stores all the connection details in an xml file ie. connections.xml. If you want to have a backup for the connection details, you will have to navigate to In windows XP C:\Documents and Settings\<YourUserName>\Application Data\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\ In Windows 7 C:\Users\<YourUserName>\AppData\Roaming\SQL Developer\systemX.X.X.X.X\o.jdeveloper.db.connection.X.X.X.X.X.X.X\ and take a backup of connections.xml . Later, if you need … Read more

How should I backup & restore docker named volumes

May 21, 2023 by Tarik

Actually it should be done same way as written in official documentation. Data volume container stores it’s data in “virtual root”, so you should backup with next command: docker run –rm \ –volume [DOCKER_COMPOSE_PREFIX]_[VOLUME_NAME]:/[TEMPORARY_DIRECTORY_TO_STORE_VOLUME_DATA] \ –volume $(pwd):/[TEMPORARY_DIRECTORY_TO_STORE_BACKUP_FILE] \ ubuntu \ tar cvf /[TEMPORARY_DIRECTORY_TO_STORE_BACKUP_FILE]/[BACKUP_FILENAME].tar /[TEMPORARY_DIRECTORY_TO_STORE_VOLUME_DATA] where: –rm means that the image created for this run command … Read more

How to backup Sql Database Programmatically in C#

May 19, 2023 by Tarik

you can connect to the database using SqlConnection and SqlCommand and execute the following command text for example: BACKUP DATABASE [MyDatabase] TO DISK = ‘C:\….\MyDatabase.bak’ See here for examples.

How to remove all files ending with ~ made by Emacs

May 18, 2023 by Tarik

While all the others answers here correctly explain how to remove the files, you ought to understand what’s going on. Those files ending in ~ are backup files, automatically created by Emacs. They can be useful sometimes. If you’re annoyed by the files and want to delete them every time, then you either (1). prevent … Read more

Override file while backup database

May 10, 2023 by Tarik

sqlcmd -S servername -Q “BACKUP DATABASE [DBName] TO DISK = ‘C:\backup.bak’ WITH INIT”

How to skip row when importing bad MySQL dump

May 9, 2023 by Tarik

If you can make the dump again you could add –insert-ignore to the command-line when dumping. Or you can try using the mysqlimport command with –force,which will continue even if it encounters MySQL Errors.

Speeding up mysql dumps and imports [closed]

May 6, 2023 by Tarik

Assuming that you’re using InnoDB… I was in the situation of having a pile of existing mysqldump output files that I wanted to import in a reasonable time. The tables (one per file) were about 500MB and contained about 5,000,000 rows of data each. Using the following parameters I was able to reduce the insert … Read more

restoring git repository from bundle backup

May 6, 2023 by Tarik

Short answer: $ git bundle verify $somewhere/foo.bundle $ git clone $somewhere/foo.bundle Cloning into ‘foo’… Receiving objects: 100% (10133/10133), 82.03 MiB | 74.25 MiB/s, done. Resolving deltas: 100% (5436/5436), done. $ cd foo $ git status … Lazy Badger said this, but it’s in the last paragraph. 🙂

Restore database backup over the network

May 5, 2023 by Tarik

You have few options to use a network file as a backup source Map network drive/path, hosting file, under SAME user as MS-SQL Server. Use xp_cmdshell extended stored procedure to map network drive from inside of MS SQL (such way, command shell will have the same privilegies as the user account running SSMS) — allow … Read more

Opening a SQL Server .bak file (Not restoring!)

May 3, 2023 by Tarik

From SQL Server 2008 SSMS (SQL Server Management Studio), simply: Connect to your database instance (for example, “localhost\sqlexpress”) Either: a) Select the database you want to restore to; or, alternatively b) Just create a new, empty database to restore to. Right-click, Tasks, Restore, Database Device, […], Add, Browse to your .bak file Select the backup. … Read more