Create script to verify the integrity of tables in MySQL DB

Create a script to verify the integrity tables in MySQL DBs.

I have several MySQL databases. Each one is a different name with different tables inside.

I want to have a PHP script that I can run (using Windows Task Scheduler) on an automatic basis, that would test the integrity of each table in each of my databases (one at a time) and email me a report that would show me each table (in each database) and if it is OK (or if it shows any sign of corruption or issues of any type).

So, I would create a copy of the script for each database. Then, the script would be launched (using Windows Task Scheduler) each day, and after it run, it would send me an email (using SMTP - with authentication required / or without authentication required - depending upon what I might need) to one or more email addresses, with a report in Text Format.

Question: Will this type of verification process actually help me keep tabs of tables that might start having a problem? Or is there something else I should also consider doing? I'm not interested in having the script automatically fix any problems. I just thought it made sense to be notified.



Beceriler: MySQL, PHP, Windows Sunucu

Daha fazlasını gör: php verify, mysql db, fix the problems, create table php, mysql test integrity script, i want to sign in, verify, verify email, php script create table, need help to fix my script, mysql test, mysql report, mysql copy, Gary, create report, create name, database copy script, report mysql php database, email verification process, create task scheduler, create report php using mysql, create script windows, create sign script, create report database php, create text

İşveren Hakkında:
( 4 değerlendirme ) Woolwich Twp., United States

Proje NO: #702865



I'm ready to start.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(47 Değerlendirme)