Nothing happens after Restore

  • Resolved mackyangeles

    (@mackyangeles)


    1 year, 9 months ago

    This is first… After uploading my local backup to a new WP site then Restored it.. Nothing happens.. My plugin and theme is there but the pages, contents and images are not. So basically nothing is happening after Restore. Need help ASAP ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter mackyangeles

    (@mackyangeles)

    [2023-06-13 08:39:29][notice]Start restoring themes.

[2023-06-13 08:39:29][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:39:29][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip succeeded.

[2023-06-13 08:39:29][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_themes.zip index:0

[2023-06-13 08:39:30][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_themes.zip index:0 finished.

[2023-06-13 08:39:30][notice]End restore themes.

[2023-06-13 08:39:32][notice]Start restoring plugin.

[2023-06-13 08:39:32][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:39:32][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip succeeded.

[2023-06-13 08:39:32][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:0

[2023-06-13 08:39:35][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:0 finished.

[2023-06-13 08:39:35][notice]End restore plugin.

[2023-06-13 08:39:38][notice]Start restoring plugin.

[2023-06-13 08:39:38][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:1000

[2023-06-13 08:39:42][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:1000 finished.

[2023-06-13 08:39:42][notice]End restore plugin.

[2023-06-13 08:39:45][notice]Start restoring plugin.

[2023-06-13 08:39:45][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:2000

[2023-06-13 08:39:46][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_plugin.zip index:2000 finished.

[2023-06-13 08:39:46][notice]End restore plugin.

[2023-06-13 08:39:49][notice]Start restoring wp-content.

[2023-06-13 08:39:49][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:39:49][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip succeeded.

[2023-06-13 08:39:49][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_content.zip index:0

[2023-06-13 08:39:49][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_content.zip index:0 finished.

[2023-06-13 08:39:49][notice]End restore wp-content.

[2023-06-13 08:39:52][notice]Start restoring upload.

[2023-06-13 08:39:52][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:39:52][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip succeeded.

[2023-06-13 08:39:52][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_uploads.zip index:0

[2023-06-13 08:39:53][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_uploads.zip index:0 finished.

[2023-06-13 08:39:53][notice]End restore upload.

[2023-06-13 08:39:56][notice]Start restoring wp-core.

[2023-06-13 08:39:56][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:39:56][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip succeeded.

[2023-06-13 08:39:56][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_core.zip

[2023-06-13 08:40:05][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_core.zip succeeded.

[2023-06-13 08:40:05][notice]End restore wp-core.

[2023-06-13 08:40:09][notice]Start restoring databases.

[2023-06-13 08:40:09][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip

[2023-06-13 08:40:09][notice]Extracting file:enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_all.zip finished.

[2023-06-13 08:40:09][notice]Extracting file:/hermes/bosnacweb08/bosnacweb08al/b1476/ipg.mackyangelescom/enfmwatersynergy.com/wp-content/wpvividbackups/enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_db.zip

[2023-06-13 08:40:09][notice]Extracting file:/hermes/bosnacweb08/bosnacweb08al/b1476/ipg.mackyangelescom/enfmwatersynergy.com/wp-content/wpvividbackups/enfmwatersynergy.consyncdigital_wpvivid-6488214222f18_2023-06-13-07-56_backup_db.zip finished.

[2023-06-13 08:40:09][notice]End restore databases.

[2023-06-13 08:40:13][notice]Start restoring databases.

[2023-06-13 08:40:13][notice]Start restoring sql file offset:0

[2023-06-13 08:40:13][notice]The test to drop table succeeds.

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_submissions_actions_log

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_submissions_actions_log

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_submissions_actions_log is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_submissions_actions_log: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_notes_users_relations

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_notes_users_relations

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_notes_users_relations is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_notes_users_relations: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_submissions_values

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_submissions_values

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_submissions_values is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_submissions_values: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_term_relationships

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_term_relationships

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_term_relationships is complete. Start replacing row(s).

[2023-06-13 08:40:13][Warning]Skipping table tmpa7b317_term_relationships

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_events

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_events

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_events is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_events: 8

[2023-06-13 08:40:13][notice]Replacing the row in 0 line.

[2023-06-13 08:40:13][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:13][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_links

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_links

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_links is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_links: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_commentmeta

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_commentmeta

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_commentmeta is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_commentmeta: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_usermeta

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_usermeta

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_usermeta is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_usermeta: 30

[2023-06-13 08:40:13][notice]Replacing the row in 0 line.

[2023-06-13 08:40:13][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:13][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_terms

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_terms

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_terms is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_terms: 6

[2023-06-13 08:40:13][notice]Replacing the row in 0 line.

[2023-06-13 08:40:13][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:13][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_termmeta

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_termmeta

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_termmeta is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_termmeta: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_term_taxonomy

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_term_taxonomy

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_term_taxonomy is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_term_taxonomy: 6

[2023-06-13 08:40:13][notice]Replacing the row in 0 line.

[2023-06-13 08:40:13][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:13][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_users

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_users

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_users is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_users: 1

[2023-06-13 08:40:13][notice]Replacing the row in 0 line.

[2023-06-13 08:40:13][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:13][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_comments

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_comments

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_comments is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_comments: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_notes

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_notes

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_notes is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_notes: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_e_submissions

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_e_submissions

[2023-06-13 08:40:13][notice]Dumping table tmpa7b317_e_submissions is complete. Start replacing row(s).

[2023-06-13 08:40:13][notice]Counting of rows in tmpa7b317_e_submissions: 0

[2023-06-13 08:40:13][notice]Drop table if exist tmpa7b317_options

[2023-06-13 08:40:13][notice]Creating table tmpa7b317_options

[2023-06-13 08:40:14][notice]Dumping table tmpa7b317_options is complete. Start replacing row(s).

[2023-06-13 08:40:14][notice]Counting of rows in tmpa7b317_options: 198

[2023-06-13 08:40:14][notice]Replacing the row in 0 line.

[2023-06-13 08:40:14][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:14][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:14][notice]Drop table if exist tmpa7b317_posts

[2023-06-13 08:40:14][notice]Creating table tmpa7b317_posts

[2023-06-13 08:40:14][notice]Reading sql file completed offset:5253597

[2023-06-13 08:40:14][notice]End restore databases.

[2023-06-13 08:40:17][notice]Start restoring databases.

[2023-06-13 08:40:17][notice]Start restoring sql file offset:5253597

[2023-06-13 08:40:17][notice]The test to drop table succeeds.

[2023-06-13 08:40:18][notice]Reading sql file completed offset:10524167

[2023-06-13 08:40:18][notice]End restore databases.

[2023-06-13 08:40:20][notice]Start restoring databases.

[2023-06-13 08:40:20][notice]Start restoring sql file offset:10524167

[2023-06-13 08:40:20][notice]The test to drop table succeeds.

[2023-06-13 08:40:21][notice]Reading sql file completed offset:15772945

[2023-06-13 08:40:21][notice]End restore databases.

[2023-06-13 08:40:24][notice]Start restoring databases.

[2023-06-13 08:40:24][notice]Start restoring sql file offset:15772945

[2023-06-13 08:40:24][notice]The test to drop table succeeds.

[2023-06-13 08:40:24][notice]Dumping table tmpa7b317_posts is complete. Start replacing row(s).

[2023-06-13 08:40:24][notice]Counting of rows in tmpa7b317_posts: 1544

[2023-06-13 08:40:24][notice]Replacing the row in 0 line.

[2023-06-13 08:40:25][notice]Replacing row completed. Current row:5000

[2023-06-13 08:40:25][notice]{"result":"success","replace_row":5000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:25][notice]Drop table if exist tmpa7b317_postmeta

[2023-06-13 08:40:25][notice]Creating table tmpa7b317_postmeta

[2023-06-13 08:40:27][notice]Reading sql file completed offset:21022795

[2023-06-13 08:40:27][notice]End restore databases.

[2023-06-13 08:40:29][notice]Start restoring databases.

[2023-06-13 08:40:29][notice]Start restoring sql file offset:21022795

[2023-06-13 08:40:29][notice]The test to drop table succeeds.

[2023-06-13 08:40:30][notice]Reading sql file completed offset:26285808

[2023-06-13 08:40:30][notice]End restore databases.

[2023-06-13 08:40:33][notice]Start restoring databases.

[2023-06-13 08:40:33][notice]Start restoring sql file offset:26285808

[2023-06-13 08:40:33][notice]The test to drop table succeeds.

[2023-06-13 08:40:34][notice]Reading sql file completed offset:31551808

[2023-06-13 08:40:34][notice]End restore databases.

[2023-06-13 08:40:38][notice]Start restoring databases.

[2023-06-13 08:40:38][notice]Start restoring sql file offset:31551808

[2023-06-13 08:40:38][notice]The test to drop table succeeds.

[2023-06-13 08:40:39][notice]Reading sql file completed offset:36803249

[2023-06-13 08:40:39][notice]End restore databases.

[2023-06-13 08:40:42][notice]Start restoring databases.

[2023-06-13 08:40:42][notice]Start restoring sql file offset:36803249

[2023-06-13 08:40:42][notice]The test to drop table succeeds.

[2023-06-13 08:40:42][notice]Reading sql file completed offset:42047078

[2023-06-13 08:40:42][notice]End restore databases.

[2023-06-13 08:40:45][notice]Start restoring databases.

[2023-06-13 08:40:45][notice]Start restoring sql file offset:42047078

[2023-06-13 08:40:45][notice]The test to drop table succeeds.

[2023-06-13 08:40:46][notice]Dumping table tmpa7b317_postmeta is complete. Start replacing row(s).

[2023-06-13 08:40:46][notice]Counting of rows in tmpa7b317_postmeta: 12189

[2023-06-13 08:40:46][notice]Replacing the row in 0 line.

[2023-06-13 08:40:47][notice]Replacing the row in 5000 line.

[2023-06-13 08:40:48][notice]Replacing the row in 10000 line.

[2023-06-13 08:40:48][notice]Replacing row completed. Current row:15000

[2023-06-13 08:40:48][notice]{"result":"success","replace_row":15000,"max_replace_row":10000,"current_replace_table_finish":true}

[2023-06-13 08:40:48][notice]UPDATE tmpa7b317_options SET option_value="https://www.enfmwatersynergy.com" WHERE option_name="siteurl";

[2023-06-13 08:40:48][notice]update query len:105

[2023-06-13 08:40:48][notice]UPDATE tmpa7b317_options SET option_value="https://www.enfmwatersynergy.com" WHERE option_name="home";

[2023-06-13 08:40:48][notice]update query len:102

[2023-06-13 08:40:48][notice]Restore db success

[2023-06-13 08:40:48][notice]End restore databases.

[2023-06-13 08:40:51][notice]Restore db success,now start rename temp table name prefix to new site prefix.

[2023-06-13 08:40:51][error]Failed to drop table. Error:DROP command denied to user 'enfmwatersynergy'@'10.20.112.222' for table 'wp_commentmeta'

[2023-06-13 08:40:51][notice]Delete migration option failed.

[2023-06-13 08:40:51][notice]Restore database failed:Failed to drop table. Error:DROP command denied to user 'enfmwatersynergy'@'10.20.112.222' for table 'wp_commentmeta'

[2023-06-13 08:40:51][notice]Deleting temp files.
    Plugin Support tonyrobins

    (@tonyrobins)

    Hi @mackyangeles

    From the restore log, the restore failed because of an error ‘Error:DROP command denied’. This error appears usually because some settings on the server does not allow the DROP command to the database.

    So, it is recommended that you contact the server operator to check it out.

    All the best,

    WPvivid Support Team

    Thread Starter mackyangeles

    (@mackyangeles)

    Hi, already talked to the provider but according to him WordPress should be atleast 6.1 to fix it. Any idea why this is happening. I have several sites and this is a first to me… also, how do I fix it on my own? I don’t want to downgrade my wordpress.

    • This reply was modified 1 year, 9 months ago by mackyangeles.
    Thread Starter mackyangeles

    (@mackyangeles)

    Is this something to do with me unchecking the DROP on creating a sql user? But on my other sites when I install and create a new database I always uncheck DROP on the users.

    • This reply was modified 1 year, 9 months ago by mackyangeles.
    Plugin Support tonyrobins

    (@tonyrobins)

    Hi @mackyangeles

    but according to him WordPress should be atleast 6.1 to fix it. Any idea why this is happening.?

    Not sure why but for our plugin, the Drop command should be allowed for the plugin to restore the database.

    Is this something to do with me unchecking the DROP on creating a sql user??

    That could be the cause, it is recommended that you grant the Drop permission to the user and see if it solves the issue.

    All the best,

    Plugin Support tonyrobins

    (@tonyrobins)

    Hello,

    Since we haven’t heard from you for a while, I am going to mark the thread as resolved.

    Please feel free to start a new one if you need any further assistance.

    All the best,

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Nothing happens after Restore’ is closed to new replies.