Backup Scheduler
restoration of databse - problem (2 posts)

  1. taby
    Posted 3 years ago #

    Hi, I have a problem with the restoration of backup that was made with the Backup Scheduler. I followed you step-by-step tutorial but there is a problem with the import of database. Here is what I did. I have a zip file that is clone of the entire webpage that I have (FTP content and database). I unpacked the zip into one folder and all the files uploaded to the FTP server – same structure as previously installed site. Then I tried to upload the database files and it crashed. First of all, the zip file contains two sql databases (.sql1 and .sql3) that I was trying to upload via myPHPadmin. Here is the problem and maybe I make the mistake somewhere but I really need help: When I try to upload the sql files to my database that is empty, internal error occurs.

    .sql1 gives:
    SQL query:
    -- ----------------------------- -- CREATE wp_sd_pdft_customizations -- ----------------------------- CREATE TABLE wp_sd_pdft_customizations ( id int(11) NOT NULL AUTO_INCREMENT COMMENT 'Row ID', t_id int(11) NOT NULL COMMENT 'ID of template used', user_id int(11) NOT NULL COMMENT 'User that created this customization', created datetime NOT NULL COMMENT 'When the customization was created', name text NOT NULL COMMENT 'Name of customization', editable tinyint(1) NOT NULL DEFAULT '1' COMMENT 'C may be edited', printable tinyint(1) NOT NULL DEFAULT '1' COMMENT 'May be printed by the user', data text COMMENT 'Field data', PRIMARY KEY (id), KEY user_id (user_id), KEY printable (printable), KEY editable (editable), KEY t_id (t_id), CONSTRAINT wp_sd_pdft_customizations_ibfk_1 FOREIGN KEY (t_id) REFERENCES wp_sd_pdft_templates (id) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customiz[...]
    MySQL said:
    #1005 - Can't create table 'member_134570.wp_sd_pdft_customizations' (errno: 150)

    .ql3 gives:
    SQL query:
    -- ----------------------------- -- INSERT INTO wp_sd_pdft_customizations -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_sd_pdft_moderation_requests -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_sd_pdft_template_fields -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_sd_pdft_template_group_moderators -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_sd_pdft_template_groups -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_sd_pdft_templates -- ----------------------------- -- ----------------------------- -- INSERT INTO wp_statcomm -- ----------------------------- INSERT INTO wp_statcomm VALUES(1, '20120813', '07:17:10', '', '', 'Mozilla/5.0 (Windows NT 6.1; rv:14.0) Gecko/20100101 Firefox/14.0.1', '', '', '', 'Windows 7', 'Firefox', '', '', '', '', '1344842230', 'en-us', 0, [...]
    MySQL said:
    #1146 - Table 'member_134570.wp_statcomm' doesn't exist

    I really need help. This is frustrating. The content of the webpage is very important for me and the only backup I have on my computer is the one from Backup Scheduler – the webpage is not working. Is there a chance that the BS did not create proper backup. Please help!



  2. Sed Lex
    Plugin Author

    Posted 2 years ago #

    Does your sql installation give any other error than
    Can't create table 'member_134570.wp_sd_pdft_customizations' (errno: 150)

    Would be helpful.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Backup Scheduler
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic