Hot answers tagged

26

This link shows what one can do to speed up restoring process. http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html One can put put the commands at the top of the dump file SET @OLD_AUTOCOMMIT=@@AUTOCOMMIT, AUTOCOMMIT = 0; SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS = 0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,...


11

None of the above worked for me - maybe outdated - anyway, I found this solution: apt-get -o Dpkg::Options::="--force-confmiss" install --reinstall mysql-common


7

If you only want the CREATE TABLE statements, then you can do pg_dump -s databasename | awk 'RS="";/CREATE TABLE[^;]*;/'


7

Now pg_restore has -d option and you could set database name for importing data. on source: pg_dump -v -Fc mydb.dmp mydb on dest: createdb -T template1 mydb2 pg_restore -v -e -d mydb2 mydb.dmp


5

So far, I've been able to come up with the following procedure, but I really hope there is some simpler way: Install the operating system on a new server Create a new "dummy" domain and make the server its domain controller Install the operating system on a second server Join the server to the "dummy" domain Install DPM on the second server and connect it ...


5

I don't know anything about Veeam or VRanger/HP Data Protector but I wouldn't expect them to be compatible unless Veeam made specific statements about it. Even if Veeam made those statements I would certainly have tested the claim before I needed to use it. The last time I switched backup products I kept my legacy solution available until the retention ...


5

I'm afraid time has moved on, and F22 is one of those cherishable distros using the adorable new systemd to start things up. One of the many happy enjoyable side effects is that rc.local is no longer run (or to be more precise, I haven't been able to make it run reliably) so that won't be helping. Put your firewall rules into /etc/sysconfig/iptables in the ...


4

We backup the DPM server separately (via command line schedeuled task) weeklyt, and DPM database daily. That way we can bootstrap the DPM server from non-DPM managed backups, and logon works with cached domain credentials. Then I can start restoring "real" backups from our virtual tape library. This works because the DPM server uses a local database with ...


4

Deleted workflows will appear in the SharePoint recycle bin. You can restore them out of here. Do that and the workflow will show up in SharePoint Designer again. Unfortunately restoring will not re-associate the workflow with the list again so it won't actually do anything useful. It will however let you view it in SharePoint Designer and create a new ...


4

(upfront, I'll say hopefully you aren't using Previous Versions as your backup) Couple of ideas come to mind: First, search Microsoft's KB here: http://technet.microsoft.com/en-us/ms772425.aspx for any VSS updates that might be applicable to your OS revision level. Second check that the VSS writers are working correctly: Open an administrative cmd prompt ...


4

You shouldn't have copied the entire directory. You should have copied only the database and transaction log files for the database in question. Uninstall and reinstall SQL Server on the target host. Copy the database and transaction log files for the database in question to the target host. Attach the database.


4

You should always have more than one domain controller to help avoid this! Microsoft provides documentation for this task. For recent versions, you can use the windows server backup tool to perform an unscheduled backup and then later a full restore: https://technet.microsoft.com/en-us/library/cc753359(v=ws.10).aspx You will want to read through the ...


4

You have to use Robocopy with a /MIR switch as it will preserve all the NTFS permissions. https://blogs.technet.microsoft.com/filecab/2008/07/31/robocopy-mir-switch-mirroring-file-permissions/ Robocopy is easily scriptable with PowerShell and has some nice GUI now. https://gallery.technet.microsoft.com/scriptcenter/PowerShell-Robocopy-GUI-08c9cacb ...


3

Backup your DCs to Azure. It's extremely cheap (100GB costs $10/month) and super easy to use. Then the recovery of AD only requires the following: access to your Azure subscription - shouldn't be a problem the passphrase used for encrypting the Azure backups - save it offsite, to your pendrive where you store SSH/BitLocker/etc keys, or something Then you ...


3

You can get this information with a query such as: SELECT TOP 1 b.type, b.first_lsn, b.last_lsn, b.checkpoint_lsn, b.database_backup_lsn FROM msdb..restorehistory a INNER JOIN msdb..backupset b ON a.backup_set_id = b.backup_set_id WHERE a.destination_database_name = 'AV_PROD' ORDER BY restore_date DESC


3

Not entirely true. It is possible but there is no guarantee that it will work. The basic steps are: Recreate the LUN and make sure it is EXACTLY the same size as the delete LUN. Present the LUN to a server and use FDISK or equivalent to recreate the partition. In my case I was using the LUN on a VMWARE ESXi host and once I had recreated the LUN, I ...


3

1. Excluding /var/run As you already noticed, excluding /var/run during a complete restore of a CentOSĀ 6 system causes problems, because it also excludes directories created by installed packages. Excluding /var/lock can also cause similar problems, because some packages create subdirectories there too. (There may be no such issues on more recent Linux ...


3

I don't have a proper solution to backup and restore a FreeIPA server on CentOS, only a workaround to have a server operative with the same configuration in the shortest time possible. You do lose the CA and you need to rejoin the hosts to the server. This is the way I dealt with "disaster recovery" while using the 2.x series. I did many trial and error ...


3

FreeIPA (now branded as Red Hat Identity Manager on RHEL) as of 4.x includes CLI tools: ipa-backup (producing a GPG-encrypted backup dump of either all server information or LDAP data only) and ipa-restore. One caveat: after restoring a data-only backup on a freshly installed server I found that it clobbered the admin credentials and I couldn't log in as ...


3

The snapshot is made with the lock file. Normally MongoDB would delete the lock file on shutdown but as you have restored it, MongoDB thinks it was shut down unclean (in fact it wasn't shutdown at that moment). The guide you provided states the following to start the server after a recover: backup shell> chown -R mongodb /var/lib/mongodb/toyko0 backup ...


3

Run rpm -Vac. You will get a list of every configuration file installed by RPM which has been altered. Also, if you restore the contents of /etc before installing the packages, then yum will notice, and place any configuration files that are different with a .rpmnew extension. You can then go and look at those files individually.


3

Reinstall the purged package (sysv-rc). If that isn't enough, try to recreate the links using insserv /etc/init.d or something similar.


3

Only indexes that were created with {background: true} originally (and hence have that option set in the system.indexes collection) are built in the background once restored. Once you have the database dumped you will have your data in the name.bson file and the metadata (indexes to build) in the name.metadata.json file. Unlike the BSON file, the JSON ...


3

You have multiple options to recover from this, but it should always be possible to rebuild the database of the backup content with the bscan program. Depending on how your system is configured and what was damaged on the crashed bacula server, you might also have a bootstrap file helping you out. Refer to the Bacula documentation for more help.


3

I would definitely consider using a config management tool like ansible, salt, chef, or puppet (or others I can't think of just now). If you have network access, it not only allows you to template out the bits of the system you care about, but keep things up to date easily. If you have no access, it allows someone who does to download your config ...


2

I had this Issue the other day. We captured an image from an HP server, where they were using a very cheap RAID controller. I actually had two problems: First, the image came out with a corrupted boot loader (I was able to fix this one using ISO Server 2008 Disk, repair mode, cmd line, i used bcdedit utility). Second, after taking care of that, the server ...


2

(I realize this is a rather old question but there are other options.) To be pedantic, it is not necessary to have Amanda even installed to read backups off those tapes. Having Amanda just makes it a lot easier. I just recently experienced this sort of failure and didn't find the information I needed from the current Zmanda wiki, but I did find it in ...


2

The SQL Server is having a problem finding or accessing the backup file on the file system. Does the file exist in the location that is shown in the UI?


2

Yes, as long as you are restoring it to a server instance that is the same build number that it came from originally you should be fine. If you try to restore a system database on an instance with different build number it will fail.


2

I can confirm it is indeed possible to recover data with only .frm and ibdata1 files. See here: http://www.nerdydork.com/restoring-mysql-innodb-files-on-windows.html. My solution was a little more difficult and my config settings etc were all in different places, but generally that solution worked for me... and saved my life too ;)


Only top voted, non community-wiki answers of a minimum length are eligible