Questions tagged [import]
About the act or process of importing data
149
questions
3
votes
3
answers
42k
views
How do I make imp use right charachter set?
I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import.
...
1
vote
2
answers
3k
views
Importing large data into MySQL (MyISAM)
I am using the 64-bit version of MySQL 5.5 on a Windows 7 machine.
I am trying to import some very large geospatial data files from geonames.org into MySQL so that I can run queries against it and ...
0
votes
1
answer
77
views
Transfering database from SQL Server
My old hard disk have a problem that I can't use it now and my database is currently still on it. How can I copy my database by connecting my old hard to my new laptop ?
Like excel that have a file ...
2
votes
1
answer
361
views
Microsoft SQL alternative for Oracle's Imp and Exp command
I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases.
Any suggestions?
0
votes
2
answers
1k
views
Microsoft SQL alternative for Oracle's Imp and Exp command [duplicate]
Possible Duplicate:
Microsoft SQL alternative for Oracle's Imp and Exp command
I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp ...
0
votes
1
answer
554
views
Does Oracle DB has a tool like DTS Wizard in SQL Server?
Is there a tool like the Microsoft SQL Server's DTS (Data Transformation Services) Wizard that simplifies the process of ad-hoc importing of flat files (CSV, TSV, or XLS) to Oracle database?
...
0
votes
1
answer
3k
views
mysqlimport and "duplicate entry" error
I've used mysqlimport for MyISAM tables a lot in the past, without any problems. But now i want to import data into a InnoDB table and are facing the following problem: mysqlimport reports the ...
1
vote
3
answers
2k
views
2GB mysql import
I am running wamp on my local host, the question is, how do I import 2GB mysql database backup file into phpmyadmin.
I tried this command in mysql command line
mysql -u root -p databasename > D:/...
0
votes
1
answer
3k
views
Migrate openldap users and groups
I have an OpenLDAP server running on one of my ubuntu 8.10 servers. I used command-line only for OpenLdap installation and some basic configurations, everything else I'll configure with the Webmin gui ...
0
votes
1
answer
39
views
Subscript import to MAS200
We are planning an import into mass too. One of our fields has "chemical name." These chemical names have subscript. Example: H20, where the 2 is small... Can this be done, or does it have to be all ...
0
votes
1
answer
3k
views
import configuration file when batch start ? (OS=Windows)
I write batch file and it has a large number of variable so i decided to put all variable on text file (conf.txt) and import it at the beginning of batch file so please i need the command line do this ...
1
vote
1
answer
471
views
getting syntax error while importing database backups in mysql
I'am going to restore a database backup which has separated files for each table with same table name prefix, and the problem is when I try to import I get this syntax error:
EERROR 1064 (42000) at ...
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?
3
votes
2
answers
203
views
Need simple graphical interface for Oracle IMP utility
the company receives several Oracle database dumps from clients for analysis. My programmers are not Oracle literate and find it difficult to restore the dumps using the IMP utility.
They need a ...
1
vote
1
answer
6k
views
How can I export / import all email aliases for an Exchange 2010 User Account?
I have a number of users in our 2010 Exchange server. I wish to export (into a file) all the email addresses for a particular user. Later on, I wish to be able to import all the email addresses once ...
18
votes
5
answers
27k
views
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 ...
11
votes
4
answers
5k
views
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....
3
votes
1
answer
3k
views
File not found error with mysqlimport
I'm setting up a local database for gene annotation following the instructions on this page. They provide an .sql file to create some MySQL table structures (step 4) and several data files to populate ...
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 ...
0
votes
1
answer
254
views
How can I automatically transfer data between R-Base database version 4 and SQL Server 2008?
I'm looking to set up a recurring data import from a very old, R-Base 4 database, into SQL Server 2008. I know close to nothing about R-Base databases - is there any way to do this?
0
votes
2
answers
2k
views
about mysqlimport show warnings
i try to use mysql command to achieve show warnings after execution
but my command seems didn't work,what's wrong with the below code,i have tested for many times
mysql -uroot -pbin \W --execute="...
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 ...
2
votes
1
answer
2k
views
VirtualBox on Windows Hosts | Export and Import batch automate
VirtualBox on Windows
I am planning to deploy virtual box on around 10 computers (Vista / 7), I have setup a centos vm and exported it as an appliance with the ovf and vmdk files in the same folder.
...
2
votes
1
answer
5k
views
bcp import file how to ignore duplicates?
I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this:
bcp Database..TableName in TableName.csv -n -T -E -S localhost
My problem: the table ...
2
votes
1
answer
814
views
Can I use the export/import data in SQL 2008 with FK constrained tables?
For sending data back and forth between tables having identical schema I have used the import/export task in management studio.
The problem is that SQLServer seems to do the import/export ops in ...
1
vote
2
answers
276
views
Looking to migrate from 2003 to Exchange 2010, what are best practices for importing PSTs?"
I'm looking at ways to import PST files into Exchange (specifically Exchange 2010) during an Exchange 2003 to 2010 migration. Any handy tips and tricks anyone?
1
vote
4
answers
1k
views
Error importing PSTs into Exchange 2010 SP1
I created a PST at the location c:\pstfiles\user.pst to test importing PSTs into Exchange 2010 via PowerShell.
I'd already installed 64bit outlook on the server, and added import export roles to the ...
0
votes
2
answers
199
views
django import settings problem
This seems to be a common problem for many others, but none of the other fixes have helped me. Here's my apache2/sites-available file:
<Location "/">
SetHandler python-program
...
0
votes
1
answer
240
views
Can I get SQL Server Import Wizard to create PK's, FK's and Indexes?
I'm importing data from one SQLServer2005 instance to another using the Import wizard and getting the importer to drop/create the tables for me. This runs great but on the new server, the tables are ...
1
vote
2
answers
3k
views
Merging two SQL Server databases
I'd like to import data from one SQL Server DB to another. Both DBs have the same table definitions, etc. but different data. The primary keys are auto-incrementing, so the same primary key will ...
2
votes
1
answer
2k
views
Copy one db diagram from one db to another on different servers? (Same db)
I used the copy database wizard to copy my database from our test server to our production server, the database copied everything fine except for the diagram.
Okay no problem, first I make sure the ...
1
vote
3
answers
280
views
Exchange 2010 Where did import go
I see a ton on articles on importing PST files in Exchange 2010, but I do not have the option. I need to import PST files, can anyone shed some light.
I added the administrator to the “Mailbox Import ...
229
votes
13
answers
459k
views
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
2
votes
1
answer
7k
views
Clone virtual machine with Server 2008 R2 and Hyper-V?
I've recently just started working with Hyper-V, and so far it's quite nice. However, I've been running into problems with what seems like it should be the most basic of workflows. I've set up a ...
16
votes
3
answers
34k
views
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
-...
3
votes
1
answer
11k
views
Importing GPG Key
I have problems importing my GPG-Keys into my new installation of debian. I exportet the private-key a few years ago. Now I am trying to get everything running under a new debian.
I tried to do
...
0
votes
2
answers
2k
views
Is there a way to import a MS SQL .db.back (database backup) into PostgreSQL?
I've received MS SQL backups from a client, I'm wanting to import/restore them into a PostgreSQL environment. Is this possible?
0
votes
2
answers
920
views
Oracle Database Recovery Problem
I am very new to Oracle, and trying to restore a oracle 8i database on win 2000 server.
I have one week old database backup (backup taken with exp command), and i want to restore it now.
Now I am ...
1
vote
2
answers
27k
views
Datadump Fails with Exit Code 1
I am in mySQL Workbench trying to import a datadump in a .sql file (generated by phpMyAdmin) into mySQL (server administration>data dump>import from disk), and it keeps failing with the ...
4
votes
1
answer
14k
views
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 ...
1
vote
2
answers
748
views
export from Oracle into SQL Server/mySQL
I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required.
Is there a standard/recommended method of ...
0
votes
2
answers
243
views
SQL Server 2005 -- Not Able To Export Using Management Studio Express
I heard this was not available with the free express version.
I need to move a moderately sized database to another computer.
How can I most easily accomplish this task?
We are not in a position to ...
0
votes
2
answers
916
views
Importing oracle dump file, getting error on stored procedures
I export an oracle "schema" using
exp userid=/ file=pt.dmp log=pt.log owner=FOO buffer=10000000 statistics=NONE direct=Y
and then import it into a different schema on the same oracle instance on ...
29
votes
3
answers
30k
views
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 ...
3
votes
3
answers
4k
views
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 ...
1
vote
2
answers
224
views
How do I re-execute a skipped section in Oracle Data Pump?
I did a start_job=skip_current on a large import because I thought it was hanging on some bad data. It turns out it was just a really large index so I'd like to re-run it but I don't want to do the ...
8
votes
2
answers
23k
views
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 ...
1
vote
1
answer
4k
views
How to import Access 2007 to SQL Server through Import Wizard?
Is there a way to get around this problem? (through GUI)
Currently SQL Server 2005/2008 do not allow me to import Access 2007 database as shown below
2
votes
1
answer
1k
views
Oracle DB import error
I get the error below when importing a database - any ideas why? I do this type of import all the time and I've never seen this error.
Prior to doing the import we drop all objects in the schema. ...