0
votes
1answer
55 views

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: ...
1
vote
1answer
189 views

MySQL import slowing, jbd2 high disk I/O

I'm importing a large .sql file into my servers MySQL Database, However the import has only so far imported a few tables and is currently on record ~17mill of one table. However the import pauses ...
0
votes
1answer
107 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 ...
1
vote
1answer
56 views

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the ...
0
votes
0answers
186 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
94 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
1answer
423 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
3answers
4k 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
1k 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 ...
3
votes
2answers
3k views

Maximum execution time of 300 seconds exceeded error while importing large MySQL database

I'm trying to import 641 MB MySQL database with a command: mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql but I got an error: ERROR 1064 (42000) at line 2351406: You have an error ...
1
vote
1answer
133 views

Running mysqlimport on a MyISAM table for hours, Data_length stays at 0 [closed]

I'm trying to import a fairly large file (5Gb, ~130M records) into a MyISAM table (mysql 5.1.61). It's been running for more than 5 hours now with no errors displayed, and I can see "LOAD DATA INFILE ...
1
vote
3answers
552 views

10 gig MySql database import stalls and doesn't finish

I am trying to import a 10 gig database to my local installation of mysql. I'm using Ubuntu 11.10. I am using the command line to do it. mysql -u root -p database < database.backup.sql I left ...
0
votes
1answer
474 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. ...
1
vote
2answers
1k views

Importing large data into MySQL (MyISAM)

I am using the 64-bit version of MySQL 5.5 on a Windows 7 machine. I am trying to import some very large geospatial data files from geonames.org into MySQL so that I can run queries against it and ...
0
votes
1answer
842 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
3answers
643 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 > ...
1
vote
1answer
195 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
2answers
205 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 ...
1
vote
2answers
4k views

Error importing large MySQL dump file which includes binary BLOBs in Windows

I'm trying to import a MySQL dump file, which I got from my hosting company, into my Windows dev machine, and i'm running into problems. I'm importing this from the command line, and i'm getting a ...
2
votes
1answer
2k views

File not found error with mysqlimport

I'm setting up a local database for gene annotation following the instructions on this page. They provide an .sql file to create some MySQL table structures (step 4) and several data files to populate ...
0
votes
2answers
637 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 ...
1
vote
1answer
3k views

mysqldump doesn't create tables or import any data

I am trying to import a mysqldump into a new database. When I run: mysqldump -umydbuser -p --database testimport < database.dump I get the following output: Enter password: -- MySQL dump 10.11 ...
0
votes
2answers
4k 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 ...
1
vote
2answers
693 views

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 ...
8
votes
3answers
9k views

How does one list warnings from the 'mysqlimport' utility?

To start off, this is not about loading data from within mysql itself, but using the command-line tool "mysqlimport". I am using it to load a CSV directly into a table and need to see the warnings ...