I have a large SQL file with one database and about 150 tables. I would like to use mysqlimport to import that database, however, I would like the import process to ignore or skip over a couple of ...

I have been using mysqlimport without problems for a long time, now as mysql 5.7 added json data type support, I'm trying to use mysqlimport with rows containing json data. Here is an example of a...

Does anyone know why I get this error when running mysqlimport? mysqlimport -u someone -pwhatever --columns=a,b,c,d,e bar /var/tmp/baz.sql mysqlimport: Error: 1045, Access denied for user 'someone...

I have a backup script for my MySQL database, using mysqldump with the --tab option so it produces a .sql file for the structure and a .txt file (pipe-separated) for the content. Some tables have ...

We are using MySQL 8.0.* and .csv file for the importing data into Amazon RDS. We are executing this command from the app server command line. Error: mysqlimport: Error: 1227 Access denied; you n...

I am getting following error while importing sql file ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive...

I was facing an issue during import SQL file on MySql database which is on AWS RDS, during import SQL file initial table was imported then suddenly it shows an error. I know this error and I can...

Im trying to import a mysql table with data that has html code in it and it generates syntax error. Can someone tell me how to properly import mysql with html code Sytanx error : You have an err...

I have an export from a MYSQL database on a linux machine however when importing that database into MYSQL on windows all of the table names that were camel cased are now all lower case. The sql dum...

This article: http://www.linuxask.com/questions/how-to-show-the-warnings-during-mysqlimport says it is not possible to show warnings when using mysqlimport: When you use mysqlimport to import d...

I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as the table name. Is there any way to work round this? I can't rename the file as it is ...

While, trying to import a .sql file into my database, I am getting the following error for one of the insert statements - ERROR 1292 (22007) at line 31504: Incorrect datetime value: '1936-01-31 00...

I asked this question before and I am just coming back to the issue. I have a backup script for my MySQL database, using mysqldump with the --tab option so it produces a .sql file for the struct...

I have some backup and restore scripts that I am using for my database. The table has a timestamp field. The backup script looks like this: mysqldump -u user -ppass database --tab="../" --fields-t...

I'm using mysqlimport to replace data in a table with values from a TSV file. Everything is working fine (importing data using the DB superuser name and password), so now I want to lock it down so ...

I have a php script that parses XML files and creates a large SQL file that looks something like this: INSERT IGNORE INTO table(field1,field2,field3...) VALUES ("value1","value2",int1...), ("value...

I need to import largish (24MB) text files into a MySQL table. Each line looks like this: 1 1 0.008 0 0 0 0 0 There are one or more spaces after each field, and the last field is tailed by abou...

I have successfully dumped an entire MySQL database using mysqldump --databases generating a nice .txt file. However, I can't see how to read the whole file back into MySQL in one go; mysqlimpor...

I'm importing some data from a .txt file into a MySQL database table, using mysqlimport. It seems to import OK (no error messages) but looks very odd when displayed, and can't be searched as expect...

As the title says: I've got a bunch of tab-separated text files containing data. I know that if I use 'CREATE TABLE' statements to set up all the tables manually, I can then import them into the ...