Just tried another one and it is more effective because it selects a given Database in mySQL host, and optimizes it. Best about it is, it also provides results for every table in the database that how much of size was that table and how much it was optimized. Great PHP script to optimize single […]
Just tried it and its great. Give this script hostname, user and password and it will optimize all the databases in given host. Here it is:
Create a file index.php and insert.php. Also create a DataBase with some name lets say mydb in mysql. After creating database named as mydb add a table named as mydbtb in it with four fields. If you do not know about mysql then just open it and create a database mydb in it and run […]
After execution of mysql query its appropriate (even essential) to close mySQL connection. Use the following script to close mySQL connection.