The import tag has no wiki summary.
0
votes
0answers
34 views
Import Postgres timestamp columns into SQL Server with Import Wizard
I am attempting to import Postgresql tables into SQL Server via the import wizard. I can get everything to work except timestamp columns for which I'm getting the following overflow error:
Error ...
0
votes
0answers
27 views
Need some information about using SQL-Express 2012 with an OLD databse software
I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
1answer
62 views
ZFS import pool ahcich0: timeout (NanoBSD 8.2 -> 9.1)
Many times when I had to make changes to the system, I boot from the USB drive to the new build NanoBSD then import the pool to the system. In the transition from 8.2 to 9.1, I do the same - boot from ...
0
votes
0answers
235 views
How to import XenServer's ovf/ova/xva format to KVM?
Now I'm considering migrate from Xen to KVM. I exported some exist virtual machines from Xen in the formats ovf and xva. How could I import them into KVM?
As there're only a few of virtual machines, ...
0
votes
0answers
27 views
Prevent UNDOTBS to abort import
I have a dumpfile that I want to import in an Oracle 10g database in a virtual machine (with limited disk space). The dump file is about 3.5GB.
When I try to import the dump, the size of the ...
0
votes
1answer
100 views
mysql: import multiple databases from sql dump with prefix
I have a mysql dump in a .sql file. There are many databases in it with DROP DATABASE and USE commands before each database.
On the running server are databases with the same names. I don't want to ...
0
votes
3answers
419 views
MySQL PHP configuration does not allow LOAD DATA LOCAL INFILE
I tried adding lines to my.cnf
[mysql]
infile = 1
[mysqld]
infile = 1
SHOW VARIABLES LIKE "%infile" displays true in mysql.
But LOAD DATA does not work. I tried it in a PHP script and in ...
0
votes
1answer
83 views
Oracle Import Dump [closed]
After system failure I have bought a new server and now Im trying to recreate the oracle database I had. I have a dump file which was made with the command exp and full=y. So can I restore the full ...
0
votes
3answers
169 views
Import e-mails from old account in Kloxo
Good morning everyone. Our client has moved their domain to another server we provide (moved from VM to dedicated). Can anybody advise me on how to import the client's e-mails from the previous IP ...
1
vote
1answer
151 views
Update mysql database with arpwatch textfile database
I'm looking to keep arpwatch entries in a mysql database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
2
votes
2answers
247 views
Any way to overwrite (not merge) Outlook contacts when importing from a file?
I'm trying to create a contact list for Outlook 2010 that will contain contact information for every person in my company. I intend on keeping the list current, which means I will be manually adding ...
0
votes
1answer
210 views
Command line import of database using latin1 encoding
I'm using a particular cloud hosting solution (one which i won't name) and they don't provide ssh access so i'm at a whim on how the database is dumped.
I downloaded the dump which is packed into a ...
3
votes
2answers
999 views
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 ...
0
votes
1answer
170 views
Xpath XML filter works locally but not online on my VPS
I tested build site locally on xammp, has datafeeds that are read in using for example this xpath
/products/product[contains(categorie,'Kinderwagens')]
Now it works perfectly locally but not on my ...
0
votes
0answers
63 views
Azure Table Storage bulk import app? [closed]
Is there a (preferably threaded) app for doing bulk imports to Windows Azure Table Storage which does the inserts in batches and has automatic retry, going from CSV or XML? TableXplorer seems to do ...
1
vote
3answers
321 views
Getting data from this MS SQL bak file
The following commands
restore filelistonly from disk = 'C:\....bak'
restore verifyonly from disk = 'C:\....bak'
produce this error
The media family on device 'C:\...bak' is incorrectly formed. ...
1
vote
1answer
90 views
Running mysqlimport on a MyISAM table for hours, Data_length stays at 0 [closed]
I'm trying to import a fairly large file (5Gb, ~130M records) into a MyISAM table (mysql 5.1.61). It's been running for more than 5 hours now with no errors displayed, and I can see "LOAD DATA INFILE ...
2
votes
3answers
904 views
How to import PST extracted from Exchange db to linux IMAP server?
I had an Exchange 2000 server that crashed, I recovered the PST mailboxes from the .edb database.
Now I'll move to a linux webhosting with imap support. I've to import the PST contents in the ...
1
vote
2answers
233 views
jboss wildcard cert import
I have a wildcard Cert from godaddy that is installed in our network on a 2008 R2 server running IIS. I have several windows servers now using this wildcard cert and importing into IIS was very ...
1
vote
3answers
250 views
10 gig MySql database import stalls and doesn't finish
I am trying to import a 10 gig database to my local installation of mysql. I'm using Ubuntu 11.10. I am using the command line to do it.
mysql -u root -p database < database.backup.sql
I left ...
0
votes
1answer
58 views
Updating the same .htaccess file on multiple sites
I manage 400+ wordpress blogs across 8 shared hosting accounts and I'm looking for a simple way to distribute changes to certain files.
In particular, I want to push out the same .htaccess file to ...
0
votes
1answer
112 views
Where to create directory for importing over network link?
While using data pump import over network link in Oracle:
impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT
directory=TEST_DIR remap_schema=SCOTT:TEST
Where are we creating ...
0
votes
2answers
184 views
Is it possible to load access-list on Cisco Router with BGP or SNMP?
I was wondering if there is any Cisco product that supports import of external list with IP ranges to be blocked or allowed.
CIRD format:
# List distributed by ...
123.15.49.0/24
60.166.28.0/24
...
1
vote
2answers
355 views
How do I import multiple tasks from a XML in Windows Server 2008?
I have all the tasks from a server in a XML file obtained using
schtasks /Query /XML ONE>C:\schedtasksBackup.xml
Now, I want to import all the tasks in another server. All the info explains how ...
0
votes
1answer
286 views
MySQL cancelled import - orphaned data in ibdata file
I was importing a database dump - almost 1GB worth:
mysql -uroot -ppassword < mysqldump.sql
When I received warnings that the hard drive was almost full. I panicked and Ctrl-Ced the import. ...
1
vote
2answers
427 views
Oracle import fails due to NLS_DATE_LANGUAGE setting
I have an Oracle 10 database server and a dump created on another Oracle 10 server. When using the imp command to import the dump to the database:
imp 'sys/*** as sysdba' file=c:\[...]\strukt.dmp ...
4
votes
1answer
925 views
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 ...
2
votes
3answers
5k 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
2answers
554 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
1answer
62 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
1answer
103 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
2answers
277 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 ...
0
votes
1answer
113 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
483 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
377 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
639 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
25 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
1answer
127 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
162 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
215 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
178 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
131 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
3k 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
2k 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 ...
8
votes
2answers
2k 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
1k 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
2k 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
88 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
506 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
369 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 ...
