I have presented git restore (which is still marked as “experimental”) in “How to reset all files from working directory but not from staging area?“, with the recent Git 2.23 (August 2019). It helps separate git checkout into two commands: one for files (git restore), which can cover git reset cases. one for branches (git … Read more
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
After revisiting my question, I was able to get it to work after looking at how ConnectBot does it. Thanks Kenny and Jeffrey! It’s actually as easy as adding: FileBackupHelper hosts = new FileBackupHelper(this, “../databases/” + HostDatabase.DB_NAME); addHelper(HostDatabase.DB_NAME, hosts); to your BackupAgentHelper. The point I was missing was the fact that you’d have to use … Read more
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