The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
256 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
3answers
859 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 > D:/...
0
votes
2answers
761 views

Bulk Update AD Attribues with Employee ID as matched key

I have a CSV file that I need to bulk update AD with. The file has an employeeID, which would match the employeeID field in AD. So far, I've been able to update a user successfully with a CSV file if ...
0
votes
1answer
808 views

Export mail queue to another server

When I run 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 server?
0
votes
1answer
208 views

How to import postgresql file on Linux with space in path?

If I try to import an sql script with a space in path, the file is not found. mypsqluser=> \i /home/markus/Documents/Projekte/My App/Installation/server_sql_script.sql /home/markus/Documents/...
0
votes
1answer
451 views

How to use screen with mysql import

I need to import a very large MySQL table on remote server. Usually I'm using mysql -u mysql_user -pMypass db_name < sql_data.sql But it takes about 5 hours to complete the task. I tried using ...
0
votes
2answers
1k views

Problems migrating ZFS pool from Openindiana build 151a7 to FreeBSD 9.1

I'm currently running Openindiana on ESXi with RDM access to the 2 disks in my ZFS pool. I used to run Ubuntu with ZFS on Linux but since ESXi 5.1 supports my hardware I wanted to move away from that ...
0
votes
1answer
1k 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
1answer
72 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 ...
0
votes
1answer
2k 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
1k 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
8k 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
206 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
1answer
18 views

importing data into Amazon RDS extremely slow

I need to import a PostgresSql db from an old server into a new Amazon RDS. I created a db dump file, connected to my RDS via pgAdmin, and started to import pgAdmin console (\i dump_file.sql). ...
0
votes
1answer
57 views

Importing Bulk Users from .csv file leads to user logon name and domain being blank

I have the following issue when adding bulk users through a .csv file: the user logon name and the domain are blank, however the user logon name (Pre windows 2003) is showing ok. Because of this, I am ...
0
votes
1answer
176 views

Importing ExtensionAttribute via CSV with Powershell

I am trying to populate the attribute ExtensionAttribute7 with a CSV file. The CSV file has two columns: samAccountName and ExtensionAttribute7 I import the Active Directory module and have been ...
0
votes
1answer
16 views

Mysql Import - You have a error in your Syntax - Workarround

i use a exporter for some mysql data. At first it will create the table and after that insert the data into it. Example Code DROP TABLE IF EXISTS `dbc_Item-data`; CREATE TABLE `dbc_Item-data` ( ...
0
votes
3answers
8k 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
72 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
337 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
842 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
646 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 the ...
0
votes
1answer
714 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
139 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
868 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 --execute="...
0
votes
2answers
900 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
718 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
7 views

Piping a tar file into Docker fails

I am very new to Docker. I am using RHEL 7.2 I am trying to import a tar file to docker repository with this command "cat rootfsfile.tar" | docker import - rootbase But I am getting this error: ...
0
votes
0answers
13 views

Where are stored phpMyAdmin SQL import files?

When a data file (SQL, CSV, XML…) is imported with phpMyAdmin, is it in volatile or non-volatile memory? If it stored on hard disk, is it temporary? When the file is deleted and what is the default ...
0
votes
0answers
27 views

OpenFire: Import my SSL certificates

I use Openfire 3.10.3. I have 3 certificates: ad-wildcard.key (PRIVATE) ad-wildcard-123123123.crt ad-wildcard-CA-gd_bundle-g2-g1.crt I've tried many ways and have read many forums and blogposts ...
0
votes
1answer
419 views

Export/Import Active Directory Permissions Delegations

I have an OU in AD, which has delegated permissions assigned to it. Is there any way/tool to export delegated permissions (or just all security permissions) for an OU and then apply the very same ...
0
votes
1answer
464 views

New-AdUser : The specified account already exists

I am trying to import some AD Users using a powershell script and a file.csv but I am getting this error: New-AdUser : The specified account already exists Here is the script: Import-Module ...
0
votes
2answers
805 views

Importing database in LDAP creates error

I have exported my database using the following function slapcat > ldif While I am importing database in other LDAP server it creates error. I am using the following function slapadd -l ldif. ...
0
votes
0answers
63 views

Debugging Ansible's support for compressed database imports?

The documentation for Ansible's mysql_db module says, "Uncompressed SQL files (.sql) as well as bzip2 (.bz2), gzip (.gz) and xz compressed files are supported." However, when I try to import a .gz ...
0
votes
1answer
348 views

Can't connect to AWS instance after import with stock Centos7

I am trying to import a Centos7 based VM into Amazon AWS. The VM was created with the Centos7 minimal ISO installed into VirtualBox. Networking in the VM works fine locally before trying to do the ...
0
votes
1answer
421 views

Importing bacpac file with 25000 tables on SQL Server fails with timeout

I'd like to import a bacpac file that was exported from an 500MB DB that however has around 25000 tables. The bacpac itself is around 18MB. Importing through the UI of SQL Server Management Studio ...
0
votes
1answer
3k views

Importing available module into PowerShell v2.0 results in error

I'm trying to import a PowerShell module to do some SSH work. I've unlocked all of the files I'm trying to import in the module. The module itself is located in a directory where modules are to be ...
0
votes
2answers
181 views

VPS - root - shell: tweaking php to import 20mb file with phpMyAdmin

System: VPS, 1GB RAM, 1.2GHZ Access: root, shell, anything Versions: PHP 5.4.16,phpMyAdmin 4.2.7, 5.5.37 MariaDB, Apache/2.4.6 (CentOS 7) Task: Import a 20mb (300k rows, 20 columns) sql dumb into ...
0
votes
1answer
246 views

Parallel mysqlimport Syntax Wrong? [duplicate]

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: ...
0
votes
1answer
1k 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
48 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
462 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
259 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
129 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
2k 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
487 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
364 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
1k 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
31 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
145 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 ...