Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Hot answers tagged

51

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.


25

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


12

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.


10

The accepted answer (using mysqldump to backup mysql.user table) is a very dangerous approach if you are migrating to a new server version. I did that in the past (migrating users from Mysql 4 to Mysql 5.1), and later I had problems trying to grant or modify privileges to my database users. This happens because mysql.users table structure differs between ...


9

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 ...


9

If you want any user on 10.0.5.10 to appear as root you want to do this: /STORAGE 10.0.5.10(rw,sync,no_subtree_check,all_squash,anonuid=0,anongid=0) all_squash tells NFS that for any user connecting from 10.0.5.10, ignore their actual UID/GID and instead treat them as if UID=anonuid and GID=anongid. Since you set anonuid=0,anongid=0 that gives all users on ...


7

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 ...


7

You're almost right, try this: id name address.0.line1 address.0.line2 address.0.city address.0.country address.0.postcode I inserted your sample document into collection bar in database test and then ran the export like this: ./mongoexport --port 31000 -d test -c bar -fieldFile fields.txt --csv > out.csv Then checked the results, which look good to ...


7

If you want to get a user's group memberships, run this PowerShell command: Get-ADPrincipalGroupMembership $Username | Select Name | out-file "filepath" where you want the document saved, including the name you want the document" Where $Username is the name of the user you're querying.


6

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 ...


6

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 VARIABLE=...


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 ...


6

You can start by exporting a detail report to a text for more detail Get-MailboxExportRequest -status failed | Get-MailboxExportRequestStatistics -IncludeReport | Format-List > c:\report.txt I hope your report will shed light on details of the failure


5

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 ...


5

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 ...


5

When exporting (unfortunately you do not specify which tool use) you specify which attributes you want to export. The names of the attributes and their compliance with ADUC GUI Tool can be found in the this article. You need attributes: givenName,sn,telephoneNumber,pager,mobile,facsimileTelephoneNumber,ipPhone But they can be added (hidden under the "...


5

You can't export Exchange Online mailbox directly to PST via PowerShell with built-in tools. Required New-MailboxExportRequest doesn't exist Online (or is not exposed to us mortals). You can: eDiscovery, that seems to be GUI-only. Offload/migrate mailbox to on-prem Exchange and run New-MailboxExportRequest on-prem (and migrate back to Exchange Online if ...


4

You may not be able to export an entire VM to another hypervisor, but you can at least export the disk(s): With VirtualBox: First, if the disk is not a "raw" type, then run the following on the KVM hypervisor/server: qemu-img convert -f qcow2 kvm_source.img -O raw kvm_destination.img Then, from VirtualBox: VBoxManage convertfromraw <filename> &...


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

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.


4

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

The DnsServer module available in Windows Server 2012, Powershell v3 has the following commands that might be useful to you: Get-DnsServerZone Get-DnsServerResourceRecord The first will get you all the zones The second will get you the records for whatever zone you pass to it They are basically the equivalent of DNSCMD's /EnumZones and /EnumRecords. So......


4

Group Policy: The user's policy isn't solely dependant on the user object - it can be affected by wmi filters, foreign domain groups or Authentication Mechanism Assurance, meaning your group membership is changed according to the way you provided your credentials. In short - the only 100% accurate way is actually logging in and checking GP results. You ...


4

Powershell Get-EventLog -LogName System -Newest 100 | select * | Export-Clixml log.xml


4

As another option, you can use StarWind V2V that also converts VMware Workstation VM image to ESXi one.


4

EBS snapshots are stored in S3, but they're managed by EBS and in buckets that you aren't able to access. While this sounds confusing, there is a good explanation. EBS snapshots are not stored individually. They rely on information provided by the EBS infrastructure so that they only capture blocks that have been changed since the previous snapshot. (...


3

On some query it's not possible in a direct way. You must write the query result to a table through the create table as syntax And then you can follow the normal export instructions: https://serverfault.com/a/300342/256884


3

You've already got the query? You can insert into a new table using another query's results Looks like the steps you need: Create the new table with all the columns. INSERT INTO newTable (field1, field2, field3) SELECT field1, field2, field3 FROM otherTable GROUP BY field1 Adjust for your 50-line query.


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 ...


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