Sponsored Content
Full Discussion: Recover dropped database
Operating Systems Linux SuSE Recover dropped database Post 302311846 by choogendyk on Wednesday 29th of April 2009 07:16:03 PM
Old 04-29-2009
Since you restored from a backup, I presume that was the last full backup? In other words, if you had a full backup from last night, it seems you would have chosen that. Then you would have only lost today's work.

So, do you have a database transaction log file? Or an incremental backup from last night?

If you provide more information, someone might be able to help. Or you might answer your own question. However, if you don't have the answers, and don't have a transaction log, then it's likely that you've simply lost the data (you're not running zfs snapshots or a NetApp with snapshots are you?).
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

are dropped packets a sign of network problem?

in a xen environment , i see a lot op dropped packets via netstat -i Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this? I guess i have a xen issue of some sort,... (1 Reply)
Discussion started by: progressdll
1 Replies

2. Ubuntu

System chrashe , dropped into Busybox

This is the mistake that i've done : First of all go to /etc/apt/sources.list folder from terminal or using file manager ... than copy the content of sources.list in to your adequate source.list. Create a file named sources.list.bt and paste the same content In the end open the... (0 Replies)
Discussion started by: dud3
0 Replies

3. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

4. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

Fedora and openSUSE will replace MySQL with MariaDB: Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies

5. UNIX for Dummies Questions & Answers

MySQL Database Missing on UNIX server. Possible to recover?

My dedicated server is VERY old (running Apache/1.3.37 (Unix) PHP/4.4.4 FrontPage/5.0.2.2510). We have a script that runs and manages our customer database. Early in the morning last Friday, it was working fine and processed data as usual. Later in the day, we got this error: Cannot... (2 Replies)
Discussion started by: SurfMe69
2 Replies

6. Solaris

Recover Solaris 11 pkg database

Hi, I was messing with pkgsrc and wanted to start fresh so I manually deleted the /var/pkg directory on Solaris 11 :eek: (of course I was supposed to delete the /var/db folder instead)... Anyways... I've basically bricked the Solaris11 Package Manager. Do you know if there is any way to... (1 Reply)
Discussion started by: testers1717
1 Replies

7. UNIX for Advanced & Expert Users

Find User who dropped table in teradata DB

HI Team Is there a way to track which user dropped the table in Teradata ? Please share the query or approach . Thanks (0 Replies)
Discussion started by: Perlbaby
0 Replies

8. Shell Programming and Scripting

Records not dropped from UNIX Script

Hi All, As per my biz requirement, I need to drop the partition from our PROD table based on the retention period. Hence I have written the script and called the drop partition procedure within the script. The procedure is working fine and droped the partition from the table when I execute... (4 Replies)
Discussion started by: suresh_target
4 Replies
backintime(1)							   USER COMMANDS						     backintime(1)

NAME
backintime - a simple backup tool for Linux. This is command line tool. The graphical tools are: backintime-gnome and backintime-kde4. SYNOPSIS
backintime [ --backup | --backup-job | --snapshots-path | --snapshots-list | --snapshots-list-path | --last-snapshot | --last-snapshot-path | --help | --version | --license ] DESCRIPTION
Back In Time is a simple backup tool for Linux. The backup is done by taking snapshots of a specified set of folders. All you have to do is configure: where to save snapshots, what folders to backup. You can also specify a backup schedule: disabled, every 5 minutes, every 10 minutes, every hour, every day, every week, every month. To configure it use one of the graphical interfaces available (backintime-gnome or backintime-kde4). It acts as a 'user mode' backup tool. This means that you can backup/restore only folders you have write access to (actually you can backup read-only folders, but you can't restore them). If you want to run it as root you need to use 'su'. A new snapshot is created only if something changed since the last snapshot (if any). A snapshot contains all the files from the selected folders (except for exclude patterns). In order to reduce disk space it use hard-links (if possible) between snapshots for unchanged files. This way a file of 10Mb, unchanged for 10 snapshots, will use only 10Mb on the disk. When you restore a file 'A', if it already exists on the file system it will be renamed to 'A.backup.currentdate'. For automatic backup it use 'cron' so there is no need for a daemon, but 'cron' must be running. user-callback During backup process the application can call a user callback at different steps. This callback is "$XDG_CONFIG_HOME/backintime/user- callback" (by default $XDG_CONFIG_HOME is ~/.config). The first argument is the progile id (1=Main Profile, ...). The second argument is the progile name. The third argument is the reason: 1 Backup process begins. 2 Backup process ends. 3 A new snapshot was taken. The extra arguments are snapshot ID and snapshot path. 4 There was an error. The second argument is the error code. Error codes: 1 The application is not configured. 2 A "take snapshot" process is already running. 3 Can't find snapshots folder (is it on a removable drive ?). 4 A snapshot for "now" already exist. OPTIONS
-b, --backup take a snapshot now (if needed) --backup-job take a snapshot (if needed) depending on schedule rules (used for cron jobs) --snapshots-path display path where is saves the snapshots (if configured) --snapshots-list display the list of snapshot IDs (if any) --snapshots-list-path display the paths to snapshots (if any) --last-snapshot display last snapshot ID (if any) --last-snapshot-path display the path to the last snapshot (if any) -h, --help display a short help -v, --version show version --license show license SEE ALSO
backintime-gnome, backintime-kde4. Back In Time also has a website: http://backintime.le-web.org AUTHOR
This manual page was written by BIT Team (<bit-team@lists.launchpad.net>). version 1.0.10 Mars 2009 backintime(1)
All times are GMT -4. The time now is 08:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy