Questions tagged [export]
The export tag has no usage guidance.
175
questions
50
votes
5
answers
126k
views
How to export result of a MySQL query using phpMyAdmin 3.4.3?
I've got a 30K row table
When I run a long, 50-line query on that table, a GROUP function reduces the number of rows to 7K
I want to export the grouped 7K rows as a new table, or save them as a
CSV
...
39
votes
5
answers
113k
views
How can I copy MySQL users table from one server to another? [duplicate]
I'm setting up up a new MySQL server and I'd like to give it the same set of usernames, allowed hosts, and passwords as an existing server (which is going away).
Would it work to just do a dump of ...
21
votes
6
answers
46k
views
exportfs: Warning: /home/user/share does not support NFS export
'exportfs -r' returns me this error when I'm trying to export /home/user/share (ext4):
exportfs: Warning: /home/user/share does not support NFS export.
/etc/exports:
/home/user/share 192.168.1....
16
votes
5
answers
16k
views
install the same debian packages on another system
How do I export a list of installed Debian packages on a system, and then install those same packages on a new system?
16
votes
3
answers
9k
views
MySQL dump, output each table row on a new line whilst using --extended-insert
I'm having an issue, where for ease of use, I'd like to be able to format a command line MySQL dump so that each row of a given table is on a new line when using the --extended-insert option.
Usually ...
9
votes
2
answers
53k
views
NFS Share with root for anonuid / anongid
I've exported a share from my server and set anonuid and anongid to be 0 (root). However, when I mount the share on the client, it doesn't appear my settings are working as I'm getting permission ...
9
votes
6
answers
89k
views
How can I export all group policies to a easily-parseable format?
I need to dump all the Group Policies within Active Directory to review offline at a later date. Is there a way I can easily export all the Group Policies to text or some other easily-parseable format?...
8
votes
4
answers
138k
views
How to export a detailed list of Active Directory users' "Member of" tab?
I am currently in the process of restructuring the Active Directory user list of the company I'm working for, and the person who did it did an awful job, and is of course, not working here anymore.
...
7
votes
3
answers
47k
views
Export VM from Proxmox
I want to export the vm from proxmox to virtualbox or vmware.
Is it possible? and how?
6
votes
2
answers
8k
views
How to dump multiple subversion repositories at once on various OSs
How do I make a dump of a number of subversion repositories - with all repositories residing in one folder - on various operating systems (Linux shells, Windows 9x/Vista/XP/Server, etc.)?
I'll post ...
6
votes
3
answers
20k
views
What does the NO_ALL_SQUASH option do in NFS exports?
From the exports(5) man page, in the "User ID Mapping" section, it says:
User ID Mapping
...
Very often, it is not desirable that the root user on a client machine is also treated as root ...
6
votes
1
answer
17k
views
mongoexport csv output array values
I'm using mongoexport to export some collections into CSV files, however when I try to target fields which are members of an array I cannot get it to export correctly.
command I'm using:
...
6
votes
2
answers
22k
views
How export database from mssql by using command line
I am using windows7 os and i have a database on MSSQL server 2005 i am using following codes to import database
sqlcmd -S [server instance name] -d [database name] -i [filename you want to import]
...
5
votes
6
answers
27k
views
Error in New-MailboxExportRequest - "Couldn't find the Enterprise Organizational Container" even though permissions seem right
When disabling users I typically will be asked to retain a copy of their mailbox. I accomplish this by literally creating their mailbox in Outlook and then exporting to PST. Is there some way around ...
5
votes
2
answers
7k
views
MySQL export tables with prefix from Unix command line
I want to export certain tables from one database and import them to another. The tables in question are used for my MediaWiki installation and are prefixed with "wiki_".
I do not have access to ...
5
votes
2
answers
7k
views
How to export a specific virtualbox snapshot as a raw disk image
I created a Linux appliance for my friends. It's a small Ubuntu installation with Trac, lighthttp and ufw configured.
I made it using VirtualBox.
Now I want to export the latest snapshot version ...
5
votes
4
answers
17k
views
MS SQL Server 2008: How to export all the tables into CSV?
I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables.
For that I need to get the data from dozens of tables as unicode CSV or TXT ...
5
votes
3
answers
5k
views
Export SharePoint Wiki to PDF from the Command Line
We use a SharePoint wiki* at the office to serve as a knowledgebase for our IT operations. Recently we went through a disaster recovery exercise where we realized we had a key hole in our plans: how ...
5
votes
4
answers
4k
views
NFS hide /export from path
How can I share FolderA on ServerA so that my client can simply access it as ServerA:/FolderA if FolderA is not in / ?
Lets say FolderA is actually
/usr/local/test/RandomName
I can use bind in ...
4
votes
3
answers
27k
views
Export all hosts from DNS Manager using Powershell
While I'm rather new to powerShell v3, there's some things I can do with it, however, one thing that has eluded me is how to pull all hosts listed in our DNS Manager (Server 2008 R2). I don't need to ...
4
votes
8
answers
19k
views
Oracle 11gR2 exp does not export some tables
I have an Oracle 11g (11.2.0.1) Database running on Linux (x64). Within the database I have a schema and 33 tables for it (all in the same tablespace). When I log in via sqlplus I can list all the ...
4
votes
2
answers
2k
views
Workstation VM unable to start after import on ESXi
I've been given a folder of a VM (with .vmdk, .vmx, ...), created and used in VMWare Workstation. I want to use it on my VMWare ESXi.
How do I correctly import the VM?
I've tried to import it, by ...
4
votes
3
answers
4k
views
Are "unexportable" certificates a real security measure or just security theater?
Recently I was working on recovering data from dead (bricked PSU) Windows XP machine, which included some client certificates installed into IE 6. I plugged in a temporary PSU and tried to export the ...
4
votes
2
answers
12k
views
export proper csv from SqlServer management studio query result
in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
4
votes
1
answer
9k
views
How can I set a specific IP range for NFS exports file?
For example, I want to set an allowed IP range from 192.168.0.12 to 192.168.0.20.
Would it require me to input all the IP addresses on that one line? Or is there an easier way to set this specific ...
4
votes
3
answers
8k
views
How to call pg_dump from Google Cloud SQL
I am looking for a solution to backup my Cloud SQL schemas (and Cloud Storage files).
At first I tried using Cloud Scheduler to call the googleapis (https://cloud.google.com/sql/docs/postgres/import-...
4
votes
2
answers
21k
views
how to backup/export office 365 email to pst in exchange hybrid environment?
We have a exchange hybrid environment. (some users are in onpremises exchange and some users are office 365. )
When we want to export emails from onpremis we use , below command to export mail box ...
4
votes
1
answer
1k
views
How to export a virtual machine in Hyper-V?
i am trying to export a virtual machine in Hyper-V.
i click Export, i select a location:
and click Export, and nothing happens:
How do you export a virtual machine in Windows Server 2008 R2 Hyper-...
4
votes
1
answer
1k
views
datadog python data export
I want to be able to export raw data from Datadog.
the idea is to support higher level of analysis in regards to the metrics captured, upstream from the Datadog UI.
the metrics query API, allows only ...
4
votes
2
answers
3k
views
How to handle one-way synchronization of two Oracle databases with no network connection?
Here's the situation:
I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the ...
4
votes
4
answers
3k
views
mysqldump --where with = operator doesn't get all rows
I have a situation with a particular table that now thinks it contains 4 Petabytes of data. I know that sounds cool, but I assure you, it is only on a 60GB partition.
This table has 9 fields in it. ...
3
votes
6
answers
8k
views
How should I export a shell variable in bash?
I usually work in bash in Linux, and if I need to export a variable I might write:
export LC_ALL=C
However, I am doing more Solaris work these days, and Solaris Admin's I work with will always write:...
3
votes
3
answers
3k
views
How do I back-up a MySQL database from the command-line in CentOS?
I need to make a back-up of a database on CentOS 5.5, running MySQL server from the command line. Basically I need to export everything in it.
3
votes
2
answers
45k
views
How do I see why a Mailbox Export Request failed?
I'm trying to export a bunch of mailboxes to PST files and a few of the requests terminated early in a failure.
A few 5GB+ mailboxes succeeded and a few really small ones failed, I can't see anything ...
3
votes
2
answers
10k
views
Export a list from AD
Mostly when I export a list from AD I get the telephone number under the general tab. I would like to export a list containing First Name, Last name and all the phone numbers under both the general ...
3
votes
2
answers
3k
views
Copy files from SVN server to external server via FTP
Currently I have about 5 servers, one I would like to use as a SVN server for development reasons, but I want it to be able to update the external server such as copying committed files to the ...
3
votes
2
answers
934
views
Export VM ESX Thin Provisionned
I have a question. I need to export a VM Thin Partionned. But the problem is that this VM is too big ... Regarding to VSPHERE client, it says that this VM is about 2TO used. But someone told me that ...
3
votes
2
answers
5k
views
How to export AD security list to Excel
How can I export the security member's list from a security group to an excel sheet. I've found some code on the web but I would need an UI or a software that can do this.
I'm open to Powershell tho....
3
votes
3
answers
3k
views
Export massive MySQL database, from a shared level hosting account
I need to export a huge database, with thousands of tables and millions of rows. I'm on shared hosting so I can't use command line exports, and I really have no easy way to get to this data other than ...
3
votes
1
answer
875
views
phpMyAdmin export, half file compressed?
Okay, I have to admit, that I derped up. I've exported a database from a to-be-reinstalled server and didn't check that file.
Now, that I try to import it, I've discovered something very strange, the ...
3
votes
1
answer
6k
views
Exporting GCP Compute Engine instance fails: Quota 'SSD_TOTAL_GB' exceeded
I'm following instruction on: https://cloud.google.com/compute/docs/images/export-image
When running:
gcloud compute images export --destination-uri gs://my-bucket/my-image.tar.gz \
--image my-image ...
2
votes
2
answers
879
views
ActiveDirectory add backup domain controller on other computer
I have Active Directory and need to move to another ActiveDirectory(PDC) on the other computer and
I want to do it this way:
Add a Backup Domain Controller
Synchronize the settings from Primary ...
2
votes
1
answer
3k
views
Export mail queue to another server
When I run mailq on SSH command line terminal, I got list of mail. However, the server does not have mail server to send those mails.
How can I export the mail queue and export it to another server?
2
votes
2
answers
2k
views
Any way to overwrite (not merge) Outlook contacts when importing from a file?
I'm trying to create a contact list for Outlook 2010 that will contain contact information for every person in my company. I intend on keeping the list current, which means I will be manually adding ...
2
votes
1
answer
3k
views
Export apt package list for reuse (debian)
Is it possible to export a list of packages from a (Debian) server,
so I can reuse this list and simply hit apt-get install <exported_package_list>
on a different server?
Can I also pipe a ...
2
votes
1
answer
82
views
How to Properly Migrate SQL
If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server.
I notice that in this process, ...
2
votes
1
answer
13k
views
How to use PhpMyAdmin to import/export from/to the server it runs on?
When I choose to import/export a data script with PhpMyAdmin, it offers me to upload/download a file with my browser from/to my PC where I access it from. But I'd like to load/save the file from/to ...
2
votes
2
answers
707
views
Exchange 2010 Powershell Output Each Mailbox permission to separate text files
I am looking to output the results of
Get-Mailbox –Server MYserverName | Get-MailboxPermission | FL
piped into individual text files for each individual mailbox, with the text file named for the ...
2
votes
2
answers
2k
views
Powershell script to Inventory File Types
I have been writing a script to inventory drives by specific file types. (AVI, MPG, MP3, etc....)
I can get the base script to work using only a set drive and extension, but I would really like to ...
2
votes
2
answers
243
views
How To Backup A Maintenance Plan
I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored (...