Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [import]

144 questions
205
votes
13 answers

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

I'm trying to import a gzipped SQL file into mysql directly. Is this the right way? mysql -uroot -ppassword mydb > myfile.sql.gz
Alex
  • 8,111
  • 24
  • 71
  • 99
29
votes
3 answers

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within MySQL itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings it has generated. I cannot seem to get warnings to…
brink
  • 293
  • 1
  • 3
  • 5
16
votes
5 answers

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

I'm trying to import a MySQL dump file, which I got from my hosting company, into my Windows dev machine, and i'm running into problems. I'm importing this from the command line, and i'm getting a very weird error: ERROR 2005 (HY000) at line 3118:…
Daniel Magliola
  • 1,402
  • 9
  • 20
  • 33
14
votes
3 answers

mysqldump doesn't create tables or import any data

I am trying to import a mysqldump into a new database. When I run: mysqldump -umydbuser -p --database testimport < database.dump I get the following output: Enter password: -- MySQL dump 10.11 -- -- Host: localhost Database: testimport --…
George
  • 263
  • 1
  • 2
  • 7
12
votes
2 answers

Import RDP file into Microsoft Remote Desktop Connection Manager 2.7

I have been using Microsoft Remote Desktop Connection Manager 2.7 for a while now and enjoy using it a lot. What I have noticed is that there doesn't seem to be a way to import the connection settings from a standard RDP file into Remote Desktop…
DigiOz Multimedia
  • 221
  • 1
  • 2
  • 5
11
votes
4 answers

EC2 VM import: VirtualBox

I would like to know if it's currently possible to import a virtualbox vm on the ec2 cloud, I have tried with a virtualbox vmdk but it did not succed. Apparently it is designed for VMware's vmdk files. Is there a trick I could use to convert my…
mnml
  • 327
  • 1
  • 7
  • 21
8
votes
2 answers

Converting Filemaker to SQL or another database system

Currently at work we have a Filemaker database running on Filemaker Server 7 on a Windows Small Business Server 2003. I would like to change from using Filemaker to a different database, one with a web based front-end. It doesn't have to be MySQL,…
Will3265
  • 123
  • 1
  • 1
  • 5
6
votes
3 answers

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error in your SQL syntax; check the manual that corresponds…
Spacedust
  • 558
  • 5
  • 12
  • 28
5
votes
2 answers

Can an AWS AMI name be set during import

I am trying to import an OVA into AWS using the aws CLI. To do this I run the following command: aws ec2 import-image import-image --client-token 653151442415980 --disk-containers '[{"UserBucket":{"S3Key":"my.ova","S3Bucket":"my…
efunneko
  • 245
  • 1
  • 3
  • 11
4
votes
1 answer

solaris zfs won't import pools from another system after a system crash

attempted to import a couple zfs pools from another solaris 11.1 box that crashed hard. the log device went corrupt but the disks are fine. there weren't any writes to the system (it sits idle) so i'm not worried about missing data in…
daft
  • 41
  • 1
  • 2
4
votes
1 answer

How to add 50 or so aliases to an existing DNS zone in Windows Server DNS?

I have a few zones in my Windows Server DNS. I wish to add around 50 unique aliases to the existing zone. Is there any trick I can use? I've tried to google for it where the odd post suggests using dnscmd .. but I'm not sure if this is right and if…
Pure.Krome
  • 6,338
  • 17
  • 72
  • 86
4
votes
2 answers

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 data on database B to match that database A. Database…
ColinD
  • 143
  • 1
  • 5
4
votes
1 answer

SQL Import to update existing records?

I've got a table in a database that contains costs for items that gets updated monthly. To update these costs, we have someone export the table, do some magic in excel, and then import the table back to the database. We're running MSSQL 2005 and…
Kenundrum
  • 43
  • 1
  • 1
  • 4
3
votes
4 answers

Import cert into AWS ACM: ValidationException when calling the ImportCertificate operation: The certificate field contains more than one certificate

I'm trying to import some ssl certificates in PEM format into AWS ACM via aws cli. The certificates come from an nginx installation, when trying to import them with the following command: aws acm import-certificate --certificate ssl.website.com.crt…
Juancho
  • 176
  • 1
  • 8
3
votes
3 answers

MySQL backup and restore with views

I am having trouble getting mysql backups to run properly when their are views in the database. I think this might have something to do with needing a placeholder object for it. In any event I run this command: mysqldump -u myuser -pmypassword…
Codezy
  • 103
  • 1
  • 7
1
2 3
…
9 10