Tag Info

Hot answers tagged

10

Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query results operations” Click “Export” link from the above and you will get the page to export all the results of the queries to desired format. That’s it.


9

To backup: sudo dpkg --get-selections > /tmp/dpkglist.txt To Restore: sudo dpkg --set-selections < /tmp/dpkglist.txt sudo apt-get -y update sudo apt-get dselect-upgrade Also see this question for additional options and info: http://serverfault.com/questions/737/ubuntu-how-to-setup-a-new-machine-like-an-existing-one I have the above running in a ...


9

nfs-kernel-server cannot work with a FUSE folder like an encrypted ecryptfs home directory.


8

It's a lot simpler then that: Use DCPROMO to make a new Domain Controller. Move the Functional Roles from one to the other. Schema Master (from the AD Schema MMC) Domain Naming Master (from AD Sites and Trusts) Relative ID Master (from ADU&C) Primary Domain Controller Emulator (from ADU&C, only useful for NT services) Infrastructure Master (from ...


6

In the Exchange Management Shell New-MailboxExportRequest It will request a filepath, which is relative to the Exchange server holding the mailbox, and must be accessibly by the same user that the store.exe process is running as (typically the machine account). It will also ask for the Mailbox, specify by the alias. You can get an update of what it's doing ...


6

I've used DNSShell before. http://dnsshell.codeplex.com/. To get all A records in a zone you can do this: Get-DnsRecord -RecordType A -ZoneName FQDN -Server ServerName To get this into a text file: Get-DnsRecord -RecordType A -ZoneName FQDN -Server ServerName | % {Add-Content -Value $_ -Path filename.txt}


6

Another method I don't see mentioned yet: Get-WmiObject -Namespace Root\MicrosoftDNS -Query "SELECT * FROM MicrosoftDNS_AType WHERE ContainerName='domain.com'" WMI is good to remember when you can't download DnsShell for some reason, or if you're on an older version of Powershell that doesn't have the baked-in Cmdlets, or if you're targeting an older ...


5

I believe that true Bourne shell (/bin/sh on many commercial Unix variants) does not support the assignment and export in a single statement. This is how I remember it from my days on Solaris. I don't know if the new Solaris versions use bash by default now. Regardless, your latter case is more portable so I'd stick with that.


5

You can also use aptitude for the same. This preserves information about "automatically installed" packages that other methods do not. Run following on the reference machine aptitude search -F '%100p' '~i!~M' > package_list copy package_list to the other machine and run xargs aptitude --schedule-only install < package_list; aptitude install;


5

It sounds like what you are looking for would be best handled by an SVN hook script. Hook scripts basically exist on the SVN server, and can be used to automatically perform actions, like doing an and updating files. Though your question mentions FTP I strongly suggest you consider using ssh/scp/rsync instead. You could possibly just have your hook ...


4

Unfortunately, with the modular nature of group policy extension handlers I don't believe you're going to find any tool better than Group Policy Management Console to do what you're after. Your easiest path is going to be to either use a computer joined to the domain to run GPMC and examine / export the GPOs. Of course, if there are GPOs that have had ...


4

Exporting private keys on certificates that have been marked non-exportable? Uh, how about an article I wrote about a tool called Jailbreak...


4

Starting from Oracle 11gR2 (11.2.0.1) there is a new feature: Deferred Segment Creation: the creation of a table sent is deferred until the first row is inserted. This results as empty tables not being listed in dba_segments and not being exported by exp utility. The easiest solution is to use expdp utility. If you have to use exp utility, you must run ...


4

See Options > Query Results > SQL Server > Results to Text Check "include column headers". My text results are being enclosed in doublequotes so that should take care of the comma issue. Take a look at the "Results to grid" tab as well - I see a "Quote strings containing list separators when saving .csv results" If not through SSMS then you can also use ...


4

If you have a large database which you want to keep online (i.e. not read lock) during backups you can also consider the innobackupex script which uses xtrabackup from percona which supports online backups of both inno and myisam (to some degree of consistency) Zmanda has a ZRM manager product which wraps the mysqldump tool and combines a scheduler and ...


4

Instead of the export button at the top of the GUI, use the one at the bottom, within the "Query results operations" box. That is the one you want.


4

You're executing the script by running "sh myscript.sh". If you invoke bash with "sh", bash will try "to mimic the startup behavior of historical versions of sh as closely as possible, while conforming to the POSIX standard as well" (according to the man page for bash, in the Invocation section). The historic Bourne shell doesn't recognize "export ...


4

It appears (judging from the 'e$' in the screenshot) you're trying it from a client workstation using the Hyper-V Manager. Try logging into the virtual host and exporting it to a drive that is local to that host machine. Unfortunately if this does work, it does not explain why what you are doing isn't working. I was able to verify the ability to ...


4

I suspect the tool you may want to look at is ldifde. It will not export passwords (password hashes) though (ref). Getting passwords hashes out of the AD is pretty difficult by design.


3

If is so easy, go ahead, patch the verification logic of IE and CryptoAPI. If you succeed, put out a tool that exports an unexportable private key. For, ahem, backup purposes and such... First of all the CryptoAPI and friends don't refer to files and memory only. The really strong security is implemented in hardware modules. Even a trivial employee badge ...


3

In Solaris, /bin/sh requires the two statements, while /bin/bash is fine with it on one statement. On linux, /bin/sh is usually a symlink to /bin/bash, so there isn't a difference. If you are writing a script which may be sourced by another script, then always use the two statement format. If the script isn't or won't be sourced, just check the shebang ...


3

100GB on recordable CD's! Yeeouch! I wouldn't burn CDs for 100GB of data. You're talking about around 150 CDs at 700MB / ea. If the server isn't too old to have USB 2.0 ports, stick an external hard disk with a USB interface on it and copy the files that way. You might mention the operating system on the server computer. That would tell us if things like ...


3

I see AdminSettings.php so this is almost certainly a MediaWiki installation. What you are going to want to do is emulate the old system that this was hosted on, most likely a LAMP setup (Linux, Apache, MySQL, PHP). Essentially, you are going to want to do the following steps (very much simplified): Build new LAMP server Copy data to public_html or ...


3

Unless that "copy" contains the database files in the mysql-data (.myd) then it probably does not have the data you are looking for. If you do have the .MYD file, then you have the actual MySQL database that the Wiki was run against and you should be able to attach that to another MySQL instance and query the data there.


3

You didn't say what version. Since we're talking SQL Server, there are several ways to approach this. If you're on SQL Server 2005/2008, the easiest way is to probably use the Import Data function within SQL Server Management Studio. Actually, what this does is creates an SSIS package that allows you to bring data in to the combined database. This is a ...


3

Using the SQL Management Studio you can use the Generate Script functionality to generate an SQL script to create some or all of the objects in the database, suitable for execution on another server.


3

mysqldump - read the man page for details. Note that it may take a time to generate the full backup file - if you want a consistent backup then consider setting up a replication slave (and turn off replication while taking the backup).


3

I think I've figured it out. Step 1) Go to the snapshots directory. You can figure out which of the uuid encoded filenames refers to your snapshot by consulting the Virtual Media Manager (ctrl-D under ubuntu). cd ~/.VirtualBox/Machines/ubuntu-minimal VBoxManage clonehd 7020aee6-f3aa-49d1-805a-30a127132c90 /home/vm-exports/ubuntu-minimal.vdi -format raw ...


3

Check you're using the same encoding/collation in the source and destination database servers. If you're not specifying anything in particular you could be getting the default treatment on both, and that could be Latin-1 in one and UTF-8 in the other - specially if the distributions are different. Also check that the Wordpress settings are the same in the ...


3

You have to generate the list of tables you want to dump then act upon it. mysql -u USER -p -D test -Bse "show tables like 'wiki_%'" >tables.out mysqldump -u USER -p test <tables.out >wiki_tables.dump or as a one liner mysqldump -u USER -p test $(mysql -u USER -p -D test -Bse "show tables like 'wiki_%'") but you still get to enter the password ...



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