Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //koneksi
- $con= new mysqli("localhost","root","","my_db");//mysqli
- //coba bikin database sendiri dan isi table2 terserah kamu. anggap ada 5
- // masukkan view didalamnya anggap ada 2
- // Check connection
- if ($con->connect_errno) {
- echo "Failed to connect to MySQL: " . $mysqli->connect_error;
- }
- //LIST ALL TABLE
- $sql= "show full tables FROM my_db where Table_Type != 'VIEW'";
- $result = $con->query($sql);
- while ($row = $result->fetch_row()) {
- echo "Table: {$row[0]}\n";
- //repair table using MYISAM Only. tested and work!
- $sql="REPAIR TABLE $row[0] USE_FRM";
- $con->query($sql);
- echo "\nRepair:$row[0]";
- var_dump($con->query($sql));
- }
- /****
- buatlah fungsi
- extract semua table (only) dalam database..
- masukkan dalam array $aTable yg isinya hanya 5 (jgn 2)
- *****/
- //===lakukan proses repair/optimize
- /*
- Buatlah sesingkat mungkin
- */
Advertisement
Add Comment
Please, Sign In to add comment