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;…
![](../../users/profiles/54220.webp)
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…
![](../../users/profiles/82012.webp)
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…
![](../../users/profiles/163768.webp)
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…
![](../../users/profiles/162497.webp)
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…
![](../../users/profiles/34880.webp)
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…
![](../../users/profiles/142219.webp)
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…
![](../../users/profiles/133856.webp)
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…
![](../../users/profiles/61076.webp)
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)?…
![](../../users/profiles/105021.webp)
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…
![](../../users/profiles/34871.webp)
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?
![](../../users/profiles/80947.webp)
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…
![](../../users/profiles/38887.webp)
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:…
![](../../users/profiles/7952.webp)
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…
![](../../users/profiles/53864.webp)
user53864
- 1,653
- 8
- 36
- 66