When you have a mysql table with lot’s of attributes, it’s hard to read the output of a statement like this in mysql: select * from table limit 1; The data is folded very ugly. Easy Solution: select * from table limit 1 \G Mysql is showing one “Fieldname: Value” per line.
A small mysqldump hint: You can use mysqldump –skip-opt to get proper insert statements in the SQL dump. But –skip-opt disables –quick which means mysqldump buffers full tables before writing -> Out of memory. In this case I use: mysqldump –skip-opt –quick <DBNAME>