The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
205 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
195 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
325 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
205 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
2answers
144 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
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 ...
1
vote
2answers
4k 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 ...
9
votes
3answers
3k 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 ...
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
1answer
4k 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
1answer
111 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
2answers
637 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 ...
3
votes
2answers
674 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
691 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
2k 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
432 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
1answer
254 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
3answers
1k views

Error importing PSTs into Exchange 2010 SP1

So I’d 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 ...
0
votes
2answers
134 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
1answer
189 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
1k 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 ...
1
vote
1answer
920 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
2answers
261 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 ...
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 ...
1
vote
1answer
3k 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
1answer
735 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
581 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
2answers
657 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 ...
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 ...
2
votes
1answer
3k 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
2answers
693 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
201 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
2answers
507 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 ...
8
votes
3answers
9k 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 ...
1
vote
2answers
70 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 ...
4
votes
1answer
5k 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
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
2
votes
1answer
554 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. ...