backup – Page 3 – Make Me Engineer

How to take backup of a single table in a MySQL database?

July 13, 2022 by Tarik

Dump and restore a single table from .sql Dump mysqldump db_name table_name > table_name.sql Dumping from a remote database mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql For further reference: http://www.abbeyworkshop.com/howto/lamp/MySQL_Export_Backup/index.html Restore mysql -u <user_name> -p db_name mysql> source <full_path>/table_name.sql or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and … Read more

Restore a postgres backup file using the command line?

July 13, 2022 by Tarik

There are two tools to look at, depending on how you created the dump file. Your first source of reference should be the man page pg_dump as that is what creates the dump itself. It says: Dumps can be output in script or archive file formats. Script dumps are plain-text files containing the SQL commands … Read more

Backup and restore SQLite database to sdcard

July 11, 2022 by Tarik

Here is my code: // Local database InputStream input = new FileInputStream(from); // create directory for backup File dir = new File(DB_BACKUP_PATH); dir.mkdir(); // Path to the external backup OutputStream output = new FileOutputStream(to); // transfer bytes from the Input File to the Output File byte[] buffer = new byte[1024]; int length; while ((length = … Read more

How can I backup a Docker-container with its data-volumes?

July 8, 2022 by Tarik

if I want to revert the container I can try to commit an image, and then later delete the container, and create a new container from the committed image. But if I do that the volume gets deleted and all my data is gone As the docker user guide explains, data volumes are meant to … Read more

How can I detect only deleted, changed, and created files on a volume?

July 7, 2022 by Tarik

You can enumerate all the files on a volume using FSCTL_ENUM_USN_DATA. This is a fast process (my tests returned better than 6000 records per second even on a very old machine, and 20000+ is more typical) and only includes files that currently exist. The data returned includes the file flags as well as the USNs … Read more

Can I restore a single table from a full mysql mysqldump file?

June 15, 2022 by Tarik

You can try to use sed in order to extract only the table you want. Let say the name of your table is mytable and the file mysql.dump is the file containing your huge dump: $ sed -n -e ‘/CREATE TABLE.*`mytable`/,/Table structure for table/p’ mysql.dump > mytable.dump This will copy in the file mytable.dump what … Read more

How do I backup a database file to the SD card on Android?

May 28, 2022 by Tarik

This code works for me! try { File sd = Environment.getExternalStorageDirectory(); File data = Environment.getDataDirectory(); if (sd.canWrite()) { String currentDBPath = “//data//{package name}//databases//{database name}”; String backupDBPath = “{database name}”; File currentDB = new File(data, currentDBPath); File backupDB = new File(sd, backupDBPath); if (currentDB.exists()) { FileChannel src = new FileInputStream(currentDB).getChannel(); FileChannel dst = new FileOutputStream(backupDB).getChannel(); dst.transferFrom(src, … Read more

Restoring MySQL database from physical files

May 24, 2022 by Tarik

A MySQL MyISAM table is the combination of three files: The FRM file is the table definition. The MYD file is where the actual data is stored. The MYI file is where the indexes created on the table are stored. You should be able to restore by copying them in your database folder (In linux, … Read more

Fully backup a git repo?

May 24, 2022 by Tarik

git bundle I like that method, as it results in only one file, easier to copy around. See ProGit: little bundle of joy. See also “How can I email someone a git repository?”, where the command git bundle create /tmp/foo-all –all is detailed: git bundle will only package references that are shown by git show-ref: … Read more

Backup a GitHub repository

May 20, 2022 by Tarik

I am not sure it could cover all your requirements, but you could check out git bundle git bundle This command provides support for git fetch and git pull to operate by packaging objects and references in an archive at the originating machine, then importing those into another repository using git fetch and git pull … Read more