The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
3k 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 ...
0
votes
2answers
197 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
3answers
3k 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
63 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
158 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
1answer
372 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. ...
0
votes
2answers
373 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
910 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
153 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 ...
0
votes
1answer
3k 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
107 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
604 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 ...
0
votes
2answers
513 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
637 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
0answers
17 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
0
votes
1answer
46 views

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 ...
0
votes
0answers
174 views

Passwords imported from SQLite to MySQL don't work

When importing an SQLite database into MySQL I have repeatedly encountered the problem that encrypted passwords (even when copied manually) do not work anymore. Everything else works fine, but all ...
0
votes
0answers
74 views

Mysql dump wont import - Created on same version of mysql etc

I have a 2.2gb SQL dump that I need to import. I'm using the following: mysql -u myuser -p mydb < backup-20-june.sql Which i've used many times in the past. However this is what's happening, ...
0
votes
0answers
35 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
191 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
1answer
66 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
105 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
1answer
581 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 ...
0
votes
1answer
250 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
1answer
170 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
687 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
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
203 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 ...
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 ...
0
votes
2answers
126 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
182 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 ...
0
votes
2answers
475 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 ...
-1
votes
1answer
486 views

Is it possible to import VirtualBox 4.2.12 exported OVA file into VMWare ESX 4? [closed]

I have created an OVA file from VirtualBox 4.2.12, and someone tried to import this ova file into VMWare ESX 4. When he was doing so, VMWare ESX 4 promopted: Line 25: Unsupported hardware family ...