Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [import]

144 questions
1
vote
1 answer

getting syntax error while importing database backups in mysql

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) at line 1: You have an error in your SQL syntax;…
Mahdi Mohammadzadeh Laki
  • 11
  • 3
1
vote
1 answer

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 more into the user (lets assume all the emails to…
Pure.Krome
  • 6,338
  • 17
  • 72
  • 86
1
vote
2 answers

Looking to migrate from 2003 to Exchange 2010, what are best practices for importing PSTs?"

I'm looking at ways to import PST files into Exchange (specifically Exchange 2010) during an Exchange 2003 to 2010 migration. Any handy tips and tricks anyone?
Michael Francis
  • 26
  • 3
1
vote
4 answers

Error importing PSTs into Exchange 2010 SP1

I created a PST at the location c:\pstfiles\user.pst to test importing PSTs into Exchange 2010 via PowerShell. I'd already installed 64bit outlook on the server, and added import export roles to the account I was using. I was then using the…
user50729
  • 11
  • 2
1
vote
2 answers

Merging two SQL Server databases

I'd like to import data from one SQL Server DB to another. Both DBs have the same table definitions, etc. but different data. The primary keys are auto-incrementing, so the same primary key will refer to different data in both DBs. I'd need the…
BlueRaja
  • 986
  • 1
  • 10
  • 17
1
vote
3 answers

Exchange 2010 Where did import go

I see a ton on articles on importing PST files in Exchange 2010, but I do not have the option. I need to import PST files, can anyone shed some light. I added the administrator to the “Mailbox Import Export” role using the following at the exchange…
Dustin Laine
  • 433
  • 4
  • 13
1
vote
1 answer

Mysql 5GB file import stalls (consequently, it is practically failed)

I am using the Macbook for my develpoment and I need a big file imported to my Mysql DB. I am importing a 4.87GB file to my SQL. I have around 20GB free on the drive. Should be enough? I am importing it through mysql through Mac terminal. It does…
Vladimir Despotovic
  • 121
  • 2
1
vote
1 answer

fail2ban txt list creation of banned IP

using fail2ban for years, working nice, would like to automate and harden the security for my router. So I would like that fail2ban created a local file, example, list.txt file with a list of banned IP addresses. Something similar to this…
Johnny
  • 19
  • 1
1
vote
1 answer

Wordpress import process ends in 502 Bad Gateway error

I have a Wordpress website which have been working flawlessly for a while now in a LEMP with Ubuntu. However, today I had to import a previously exported XML from another Wordpress and in the middle of the process I get the 502 Bad Gateway…
Alain Alemany
  • 135
  • 2
1
vote
2 answers

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 output: 10:47:14 Restoring C:\myfolder\localhost.sql…
Aaron Bush
  • 237
  • 1
  • 2
  • 10
1
vote
0 answers

Import contacts into Office 365 public folder contacts folder by powershell

We've got a PBX that is able to synchronize its company phonebook with a shared contacts group from an office 365 public folder. Now we're looking for a way to create an automated task which automagically imports contacts from a local csv-file into…
user7005951
  • 11
  • 2
1
vote
2 answers

export from Oracle into SQL Server/mySQL

I have an Oracle database which we will be removing shortly. But I would like to store some of the data somewhere else so if can be accessed if required. Is there a standard/recommended method of doing this? Was thinking export into XML then XML…
user31119
  • 11
  • 1
0
votes
0 answers

mysqlimport -- stack smashing detected and segmentation fault

We are importing a large batch of records with mysqlimport tool. We have ~800 files prepared for importing all in one directory with names such…
That Realtor Programmer Guy
  • 223
  • 2
  • 8
0
votes
1 answer

How to export/import local groups with domain user members from/to a Windows server

What is the recommended way of cloning local group memberships (local groups, domain users) from one Windows server to another (script, tool, utility)? Servers are at version 2008 and later. Thanks.
Alek Davis
  • 153
  • 1
  • 1
  • 6
0
votes
0 answers

MySQL Packet Size -- dump -- restore -- Bug or configuration?

I'm taking backups using mysqldump -u root -p${THEPASSWORD} --max-packet-size=250M db > db.sql on all my systems and all the databases are being unloaded successfully. However, when I try to restore the same dump to the same system, I get an error…
Nasir Mahmood
  • 21
  • 2
1 2 3
…
9 10