Questions tagged [import]

144 questions
0
votes
1 answer

Parallel mysqlimport Syntax Wrong?

I'm trying to import a large 70GB+ database (all InnoDB) using mysqlimport. This is a development system on Windows using WAMP server. MySQL 5.6.17. I'm getting the following error: mysqlimport: Error: 1064 You have an error in your SQL syntax;…
BT643
  • 551
  • 3
  • 9
  • 21
0
votes
1 answer

Export openssl cert public key to DER format

i'm looking for a way to export my openssl certificate (the public part) used by apache2 (.pem file) to import it to an android device's credential storage (Settings menu> Security > Credential storage > Install from device storage) as explained…
nodiscc
  • 187
  • 8
0
votes
0 answers

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 who bought them out went to cloud hosting…
questorfla
  • 11
  • 4
0
votes
1 answer

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 the USB drive new build NanoBSD 9.1. When I…
Allan Sundry
  • 53
  • 1
  • 2
  • 8
0
votes
1 answer

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 UNDOTBS01.DBF file explodes (up to 12GB – stopped because…
gregseth
  • 193
  • 1
  • 8
0
votes
1 answer

Oracle Import Dump

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 database from this dump? If yes how? Oracle…
Alexk
  • 3
  • 1
0
votes
1 answer

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 VPS, I'm using the wp import all plugin btw I have…
Bram
  • 3
  • 3
0
votes
1 answer

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 the root of each blog, that restricts access to the…
harvest316
  • 115
  • 8
0
votes
1 answer

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 directory object (TEST_DIR, for the above example)?…
bonsvr
  • 101
  • 2
0
votes
1 answer

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. Twice. Looking at my DB I can see that the import was…
Rudolf Vavruch
  • 1,215
  • 2
  • 11
  • 16
0
votes
1 answer

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 for each database .
Arash
0
votes
2 answers

Microsoft SQL alternative for Oracle's Imp and Exp command

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 and exp commands of Oracle databases. Any suggestions?
ferdyh
  • 183
  • 10
0
votes
1 answer

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? Preferably free ones or the ones that are licensed…
adib
  • 101
  • 2
0
votes
1 answer

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 following error and won't import anything: mysqlimport:…
harald
  • 393
  • 1
  • 5
  • 17
0
votes
1 answer

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 tool. I'm trying to migrate to ubuntu 10.04 and…
user53864
  • 1,653
  • 8
  • 36
  • 66