mysqldump fails with “Skipping dump data for table 'table1', it has no fields”

31
January 12, 2019, at 02:50 AM

I'm running mysqldump from an older mysql database. The mysqldump is part of a mariadb distribution if it matters.

When I run mysqldump locally, it's fine. When I run it on a remote system, I get no data dumped. If I run it with mysqldump -v the last line is

Skipping dump data for table 'table1', it has no fields
Answer 1

From some googling and this reddit thread, I determined that you need to set the default locale.

So the command that worked for me was:

mysqldump --default-character-set=latin1 --lock-tables=false --single-transaction=TRUE --host=$HOST --user=$USER --password=$PASSWORD $DB 

I used both lock-tables and single transaction because I have a mix of myisam and innodb tables.

READ ALSO
Access denied for user 'root'@'localhost' Laravel / debian 18

Access denied for user 'root'@'localhost' Laravel / debian 18

I have a problem with laravel and mysqlIt is possible for me to php artisan migrate and seed my database

53
Getting non duplicate results from bridging table

Getting non duplicate results from bridging table

I have three tables, contact, contact_category and contact_categories

43
PHP While Statement Delete only one row from table Mysql PDO

PHP While Statement Delete only one row from table Mysql PDO

I have a while statement and a PDO statement to delete one row if someone clicks the delete button

23