20 votes

How do I load a sql.gz file to my database? (importing)

If you get an error from zcat, in which the error message contains the file name with an extra suffix .Z, then try using gzcat instead, as described at https://stackoverflow.com/questions/296717/zcat-...
Mark Howells-Mead's user avatar
7 votes

How do I load a sql.gz file to my database? (importing)

On macOS, I used this: zcat < [Database].sql.gz | mysql -u root -p [Database Name in MySQL] Enter your password, and voila!
Qasim's user avatar
  • 171
5 votes

How do I load a sql.gz file to my database? (importing)

You can use -c, --stdout, --to-stdout option of gunzip command for example: gunzip -c file.sql.gz | mysql -u root -p database
Ali Jazayeri's user avatar
4 votes

How do I load a sql.gz file to my database? (importing)

If you are using small size database it's better to extract and import. Here is the extract command tar -xf dbname.sql.tar.gz Here is importing command. mysql -u username -p new_database < data-...
Abu Bakar Iqbal's user avatar
4 votes

Workstation VM unable to start after import on ESXi

As another option, you can use StarWind V2V that also converts VMware Workstation VM image to ESXi one.
Mr. Raspberry's user avatar
4 votes
Accepted

Workstation VM unable to start after import on ESXi

VMware Workstation VMs are not compatible to ESXi. VMware Workstation uses different virtual hardware than ESXi. The easiest way is to convert the VM using VMware Converter.
Gerald Schneider's user avatar
3 votes
Accepted

importing data into Amazon RDS extremely slow

The default postgresql configuration is not good for bulk import of data. The main thing you need to do before importing that much data is to increase max_wal_size to reduce the number of times ...
DerfK's user avatar
  • 19.7k
3 votes
Accepted

Import PNG to SQL Server (without disk access)

You can encode your image with base64 like: cat YOUR_IMAGE.png | base64 or directly base64 YOUR_IMAGE.png and add the output to your database.
deagh's user avatar
  • 2,039
3 votes

How do I load a sql.gz file to my database? (importing)

On MacOS I've been using the following one-liner with no need of installing additional programs, except for the MySQL client itself. $ cat /path/to/file.sql.gz | gzip -d | mysql -u root <db_name&...
Gustavo Straube's user avatar
3 votes

How to import XenServer's ovf/ova/xva format to KVM?

The following is a straight quote from the Red Hat 6 help link, in case it fails. It seems everything is based on using virt-v2v now, and doing an offline xva to kvm isn't so simple. Try the virt-v2v ...
Tom Koch's user avatar
3 votes

How can one import existing vSphere virtual machines into vRealize Automation 8.0?

I believe I've figured out where the option is. Under Cloud Assembly, choose Infrastructure -> Onboarding, then create a new onboarding plan and rules based on the machine hostnames. It seems like ...
tj94's user avatar
  • 79
3 votes

Have List of user but I want to find out if they are added to specific ADGroupMember

I think your main issue is that you're using Get-ADGroupMember rather than what you need which is Get-ADPrincipalGroupMembership You use Get-ADGroupMember to query a group and find out who is a member ...
Keith Langmead's user avatar
2 votes

Error importing large MySQL dump file which includes binary BLOBs in Windows

Ok, I had this issue today. But my problem was that the database was already dropped when I realized that the backup was broken. So, no --hex-blob for me! To be able to fix it I made a little script ...
KnF's user avatar
  • 21
2 votes
Accepted

How to initiate AWS import export disk service

Looks like it isn't directly in the services, but is an S3 related tool that is accessed using a command line tool or the APIs. This page explains: http://docs.aws.amazon.com/AWSImportExport/latest/DG/...
Kris C's user avatar
  • 145
2 votes
Accepted

Importing Virtualbox to vsphere 6

Your best option is probably to just use the VMware vCenter Converter, and treat your Virtualbox guest as if it were a physical machine.
Charles Burge's user avatar
2 votes

google cloud hates my import - ssh and ping not working, http:// and web ssh is.. why?

Iptables on CentOS could be enabled by default, which could block external traffic to the VM instance. You could verify by following the instruction on this GCP document, and as a workaround you could ...
Fady's user avatar
  • 206
2 votes
Accepted

MariaDB - import raw InnoDB frm/ibd files?

If you have the entire /var/lib/mysql then you should probably try completely replacing the current contents of /var/lib/mysql with the content you have. Depending on your mariadb/mysql options some ...
Zoredache's user avatar
  • 132k
2 votes
Accepted

Wordpress import process ends in 502 Bad Gateway error

This usually happens if your import is large and PHP runs into its execution time limit. You can restart the import and it will pick up where it left off. Depending on the size of the import, you may ...
Michael Hampton's user avatar
2 votes

How to in-place register a VM to the host's default location

Registering a VM in-place that's not in the hosts default location and wanting it to be in the hosts default location is a contradiction in terms. In-place registration means you want to register and ...
joeqwerty's user avatar
  • 111k
2 votes

Mysql 5GB file import stalls (consequently, it is practically failed)

Maybe it's server's runtime limit, I advise you to control logs of mysql. If that's the case you can go around this problem by trying to split your dump into more more dumps. For exemple, you'll have ...
r3d's user avatar
  • 148
2 votes
Accepted

Apply Exchange Public Folder Permission import via Import-CliXML

Finally the following PowerShell script allowed me to apply all the permissions from the XML file to the public folder structure. Thanks to Ivan_Wang who led me to the right direction with his answer. ...
Michael Uray's user avatar
2 votes

promtool tsdb create-blocks-from openmetrics doesn't show any data in Prometheus

You are creating the backfill-file with a wrong time format, it just takes a normal unix timestamp, but yours is in milliseconds. so, change it to: # HELP mymetric My metric. # TYPE mymetric counter ...
Thoro's user avatar
  • 43
1 vote
Accepted

KVM - Import CentOS 7 from XenServer

The problem was that the device "xvdb1" (XenServer)... [root@vmrhs1doctxt01 consultor]# cat /etc/fstab [...] /dev/xvdb1 /mount ext4 defaults 0 1 [...] ... is ...
Eduardo Lucio's user avatar
1 vote

PSQL : ERROR: could not extend file No space left on device HINT: Check free disk space

So i've followed this tutorial to move the datadir to /home/postgresql/ and it's working.
jeydan12's user avatar
1 vote

Importing a machine from VMware to xenServer

Note that to do something like that, your XenServer should be configured with a default storage repository (SR). You can do that using the xe command. Another similar issue may be encountered if your ...
Overmind's user avatar
  • 3,141
1 vote

Error importing VM to AWS : S3 key does not exist

As Alex Moore suggested in the comment to the original question. When you say 'vhdx files & container.json are on the same folder', you mean on the folder on your local machine? because the ...
bustedware's user avatar
1 vote

How to upgrade Python 2.7.x version to the newest version 2.7.14?

(You haven't mentioned, but I assume you are using an Ubuntu Linux as you have the "apt-get" command.) You installed the python from source and tried to install the modules via apt, this is not ...
redseven's user avatar
  • 252
1 vote
Accepted

Import CSV of user accounts containing semicolon-delimited proxyAddresses

I created the following AD PowerShell command which worked great: $Users = Import-Csv "<CSV_Path>\<CSV_FileName>.csv"; ForEach ($User in $Users){ New-ADUser -Name $User."DisplayName" ...
mythofechelon's user avatar
1 vote

How to remove old session from Azure Storage Explorer?

As per Step 3, sub-step 6 in this https://support.office.com/en-us/article/use-network-upload-to-import-your-organization-s-pst-files-to-office-365-103f940c-0468-4e1a-b527-cc8ad13a5ea6#step3 article ...
Jamie Bird's user avatar
1 vote
Accepted

How to remove old session from Azure Storage Explorer?

The solution to this problem was to clear out the old application data in %AppData%. Close all instances of Azure Storage Explorer. Open File Explorer and navigate to %AppData% (i.e. C:\Users\<...
Appleoddity's user avatar
  • 3,860

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