Views in database are not saved !

  • Resolved Thierry D.

    (@terrysxm)


    1 month, 2 weeks ago

    Hi,

    I use the free version of this plugin.

    I really like this plugin because I’ve tried several restores and each time everything worked perfectly. However, recently I had a problem with my site that erased all my views created directly in the database (within the WordPress database). These views interact perfectly with the Wpdatatables plugin.. When I restored using WPvivid Backup, I realized the views weren’t there! …what a disappointment.

    So I wanted to know if the paid version of the module Wpvivid backs up the entire database (including the views)?

    Best regards 🙂

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support tonyrobins

    (@tonyrobins)

    1 month, 2 weeks ago

    Hello @terrysxm

    Thank you for your kind words. We are happy to hear that you find WPvivid helpful.

    Please note that unlike standard database tables, views do not hold actual structural data or physical records, they are essentially saved queries that point to existing tables. Because views often contain environment-specific permissions, user privileges, or hardcoded database references, attempting to back them up and restore them automatically (especially across different server environments) carries a very high risk of database failure or corruption.

    As a backup solution, reliability and stability are always our top priorities. To ensure the absolute safety of your data, our plugin is designed to skip views entirely.

    In your case, we recommend keeping a separate text backup of the SQL queries used to create your views. After performing a WPvivid restoration, you can quickly recreate them by running those queries directly in your database manager (such as phpMyAdmin).

    All the best,

    Thread Starter Thierry D.

    (@terrysxm)

    1 month, 2 weeks ago

    Hi Tony,

    Thanks for your answer !

    Ok, so i did an export from phpmyadmin of all my views (about 35). Like that if i had to do one day a restoration, i could restore too the views.

    Best regards 🙂

    Plugin Support tonyrobins

    (@tonyrobins)

    1 month, 2 weeks ago

    You are welcome. Please feel free to reach out if you need any assistance using WPvivid in the future.

    All the best,

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Tags