Database (PhpMyAdmin) empty trash post

  • Resolved Robye

    (@robye)


    8 months, 4 weeks ago

    I’ve noticed that using additional CSS, this is saved all on databases.
    However, i have seen that even by deleting it, in the database, on PhpMyAdmin, all that data remains, rows labeled as post_status = Trash. No longer being a utility , doesn’t the database have an automatic function that, like trash, permanently deletes these files, for example, after 30 days?

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

  • The default value for deleting entries in Trash is set to 30 days. However, it can also be changed and the function can also be switched off. See: https://codex.www.ads-software.com/Trash_status

    Thread Starter Robye

    (@robye)

    threadi?(@threadi)
    20 hours, 23 minutes ago

    The default value for deleting entries in Trash is set to 30 days. However, it can also be changed and the function can also be switched off. See: https://codex.www.ads-software.com/Trash_status

    Thanks a lot ??

    Nice if I could help. You are welcome to set the topic to solved.

    Thread Starter Robye

    (@robye)

    Sorry, I thanked you too quickly ??

    I didn’t understand if you’re talking about the WordPress trash can or the MySQL database trash can

    Or maybe we’re talking about the same thing,
    just that on WP 6.4.3. i can’t find trace of the trash can.

    And on the database, on PhpMyAdmin there is no information about the permanent deletion of trash files after 30 days

    I’m talking about additional CSS, which is saved in the post database tables, not articles

    MySQL has no trash can. What has been deleted is deleted. It may be possible to add this as a module in some database systems, but I am not aware of this and it has nothing to do with WordPress.

    The function I mentioned above is within WordPress, controlled by WordPress. You won’t find anything about this in MySQL. Only data records are stored there, but no functions.

    Additional CSS is a single input field in the Customiser of classic WordPress themes. Its data is stored in the posts table in the same way as posts or pages and is therefore subject to the same rules that I described above for automatic. However, you cannot move Additional CSS to the trash. The data record is either published or does not exist. It has no other status. If you empty the field for Additional CSS, the corresponding data record will also be deleted – without any trash.

    Thread Starter Robye

    (@robye)

    threadi?(@threadi)
    18 minutes ago

    … If you empty the field for Additional CSS, the corresponding data record will also be deleted – without any trash.

    precisely with regard to this last point.
    i was afraid because doing various tests, after deleting all the Additional CSS on WordPress and saving everything,
    on the database the post records containing that Additional CSS were still visible.
    I was afraid that those records would not be deleted and would remain to occupy space and database resources.
    But maybe it’s a matter of cache and delay in updating the database..
    I’ll have to do some more tests to see if in fact they are permanently deleted once they are removed on WordPress
    thanks aniway

    If the data record does not disappear for you, this may also be due to a theme or plugin you are using. These could influence the behaviour. I tested it earlier with a standard WordPress theme and without any plugins as described.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database (PhpMyAdmin) empty trash post’ is closed to new replies.