The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
204 views

Cannot import my MySQL database to new server

In phpmyadmin, when I try to import the database, I get this error: http://i.stack.imgur.com/iDBfE.png I do not understand why it wont let me import it. Im running RedHat x86_64 es5. Both my old and ...
3
votes
1answer
143 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 ...
0
votes
1answer
28 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
2answers
413 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 ...
2
votes
1answer
158 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
1answer
182 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
1answer
758 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 ...
0
votes
3answers
580 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 > ...
0
votes
1answer
1k 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
1answer
183 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
1answer
185 views

getting syntax error while importing database backups in mysql

Hi 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) ...
0
votes
1answer
308 views

Export mail que CentOS (mailq log)

when I type 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 ...
0
votes
2answers
626 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 ...
1
vote
1answer
4k 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 ...
7
votes
3answers
8k 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 ...
2
votes
1answer
2k 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 ...
0
votes
2answers
488 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 ...
3
votes
2answers
577 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
1answer
673 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. ...
0
votes
1answer
1k 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
1answer
388 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 ...
0
votes
2answers
131 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 ...
1
vote
1answer
839 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 ...
0
votes
1answer
187 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
2answers
999 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
1answer
5k 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 ...
0
votes
1answer
698 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
2answers
539 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?
1
vote
1answer
2k 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 ...
0
votes
2answers
4k 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 following ...
1
vote
2answers
692 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
2answers
200 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 ...
1
vote
2answers
68 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 ...
2
votes
1answer
531 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. ...
1
vote
1answer
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