[wp-trac] [WordPress Trac] #20821: DB Restore

[WordPress Trac]

#20821: DB Restore
--------------------------+-----------------------------
 Reporter:  Juggy69       |      Owner:  Stuart Giles
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:  3.3.2
 Severity:  critical      |   Keywords:
--------------------------+-----------------------------
 Hi Not sure if this is a bug or not

 I have been backing up a site daily for the last 4 months, due to a
 "corruption" i have tried to restore the DB but keep getting errors that
 "Null" can not be used

 I have tried 2 separate hosts also just in case DB server was the issue, i
 am using MYPHPAdmin to restore the DB

 I have also had to recreate the site from sratch and again have been
 backing up so again as a test i have tried to restore the DB to a new DB
 and again getting errors

 Error

 SQL query:

 INSERT INTO wp_acplinks
 VALUES (
 "1", "http://codex.wordpress.org/", "Documentation", NULL , NULL , NULL ,
 "Y", "1", '0', "0000-00-00 00:00:00", NULL , NULL , NULL
 );

 MySQL said: Documentation
 #1048 - Column 'link_image' cannot be null

 The main DB i started with is 13mb

 the new DB is 2mb

 Regards

 Stuart

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/20821>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software