Top "Mysqlimport" questions

The mysqlimport client provides a command-line interface for the MySQL database to the LOAD DATA INFILE SQL statement.

Disabling foreign key checks on the command line

I have a backup script for my MySQL database, using mysqldump with the --tab option so it produces a .sql …

mysql command-line foreign-keys mysqlimport
MySQL import database but ignore specific table

I have a large SQL file with one database and about 150 tables. I would like to use mysqlimport to import …

mysql mysqldump mysqlimport
Mysql ERROR: ASCII '\0' while importing sql file on linux server

I am getting following error while importing sql file ERROR: ASCII '\0' appeared in the statement, but this is …

mysql phpmyadmin mysqldump mysqlimport
mysqlimport: Error: 1045, Access denied

Does anyone know why I get this error when running mysqlimport? mysqlimport -u someone -pwhatever --columns=a,b,c,d,…

mysql mysql-error-1045 mysqlimport
How to use mysqlimport to read in result of mysqldump --databases

I have successfully dumped an entire MySQL database using mysqldump --databases generating a nice .txt file. However, I can't see …

mysql mysqldump mysqlimport
MySQL Invalid column count in CSV input on line 1

Ok row 1 consists of the following names in my CSV file: id username password email fname lname organization add_1 add_2 …

csv import mysqlimport
MySQL Incorrect DateTime Value for Date older than 1980

While, trying to import a .sql file into my database, I am getting the following error for one of the …

mysql timestamp mysqlimport
Importing data from xls,csv to Mysql using Yii 2.0 Framework

I need to import data from XLS,CSV file into MySql database using YII 2.0 Framework, XLS, CSV files contains datas …

import yii2 mysqlimport
Using mysqlimport where the filename is different from the table name

I've been playing with mysqlimport and I've run into the restriction where the filename has to be the same as …

mysql filenames restriction mysqlimport tablename
MySQL data export changes times

I have some backup and restore scripts that I am using for my database. The table has a timestamp field. …

mysql timezone mysqldump mysqlimport