September 27th, 2000, 09:57 AM
I'm using mysqldump to backup all of the data in a database I have. However, where there are blank fields in the table, it puts a "NULL" in the backup. Is there a way to prevent it from doing that, and just leave it blank?
September 27th, 2000, 10:14 AM
NULL is a key word for MySQL, when you restore from your backups you won't see it in your tables (they'll just be empty again).
September 27th, 2000, 10:36 AM
When I added it back in to test it, the "NULL"s did show up again.
September 27th, 2000, 10:48 AM
Wait, sorry, I was doing something stupid on this end. It does come out properly.