MySQL DataBase automatic reset after 24 hour for Demo Mode

[Asheni21]

I wish to create a demo mode for my CMS and is there anyway with which I can set my MySQL database automatically reset after 24 hour of time.(all my customer data should remove within 24h but without remove my demo data to)

 

[NostraDamus]

Foe example! Add task in you hosting panel for auto recovery your database in date how you want!
Thats all

 

[ha2000]

You can use cron job to set a job for 24 hours. That job will have to remove all your database tables & recreate with demo content.

 

[alexmisaila]

I wish to create a demo mode for my CMS and is there anyway with which I can set my MySQL database automatically reset after 24 hour of time.(all my customer data should remove within 24h but without remove my demo data to)

here is a sample script in PHP that could be used to reset the MySQL database after 24 hours of time using a cron job:

<?php

// Connect to MySQL server
$db_host = "localhost";
$db_user = "username";
$db_pass = "password";
$db_name = "database_name";

$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

if (!$conn) {
  die("Connection failed: " . mysqli_connect_error());
}

// Delete all customer data from database
$delete_customer_data = "DELETE FROM customers WHERE is_demo = 0";

if (mysqli_query($conn, $delete_customer_data)) {
  echo "Customer data deleted successfully" . PHP_EOL;
} else {
  echo "Error deleting customer data: " . mysqli_error($conn) . PHP_EOL;
}

// Close connection to MySQL server
mysqli_close($conn);

?>
To set up the cron job, you would need to add this script to your server and configure the cron daemon to run it at a specific time every day. For example, to run the script at midnight every day, you could add the following line to the crontab file:

0 0 * * * /path/to/reset_database.php

This is just a sample script and may need to be modified to fit the specific needs of your CMS