#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    65
    Rep Power
    15
    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?
    Thanks,
    Ben
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    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).
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    65
    Rep Power
    15
    When I added it back in to test it, the "NULL"s did show up again.
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    65
    Rep Power
    15
    Wait, sorry, I was doing something stupid on this end. It does come out properly.

Similar Threads

  1. Linux C/C++ winsock & thread question
    By beholder242 in forum C Programming
    Replies: 3
    Last Post: January 28th, 2004, 06:31 AM
  2. PHP data retrieval question with MySQL
    By gursharn in forum PHP Development
    Replies: 7
    Last Post: December 31st, 2003, 09:43 AM
  3. dumb question
    By zayin7232 in forum Perl Programming
    Replies: 4
    Last Post: December 29th, 2003, 06:38 AM
  4. Javascript question mark question?
    By tajmiester in forum JavaScript Development
    Replies: 3
    Last Post: November 30th, 2003, 05:36 PM
  5. Radio Buttons
    By Ulysses Freeman in forum HTML Programming
    Replies: 4
    Last Post: November 15th, 2003, 09:57 PM

IMN logo majestic logo threadwatch logo seochat tools logo