MySQL DataBase automatic reset after 24 hour for Demo Mode
- Thread starter ashi567
- Start date
-
Welcome to Original Babiato! All Resource are Free and No downloading Limit.. Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here! Support Our Work By Donating Click here!
NostraDamus
Active member
Foe example! Add task in you hosting panel for auto recovery your database in date how you want!
Thats all
Thats all
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:
Code:
<?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.phpSimilar threads
