Step-7: In the drop down box you will get “ with selected:”, here you have to select “Optimize Table”. Step-6: Select the tables which you want to optimize by checking the check box in front of each one or just clicking on Select All if you want to optimize all the tables. Step-5: Now select the database which you want to optimize from the list in the left column of phpMyAdmin. Step-4: Login into your phpMyAdmin account. Step-3: Now click on MySQL under Databases drop down section. Step-2: Click on Launch button of web hosting. Step-1: First log-in into your Godaddy account. Just follow the process to optimize and analyze a MySql database tables. If a lot of changes have been made to a table then optimizing the table can sometimes significantly improve dramatic performance of the database. You can use “ Optimize Table” option to reclaim un-used space and de-fragment the data file for optimal performance of your database. When you delete the rows then they are maintained in the linked list and further insert operations reuse the old row positions of the table. Find and select the file you want to import and then select Open. Phpmyadmin godaddy windows#Note: If you see only informationschema, you should create a database in your Linux or Windows hosting account. If you have deleted a large amount of data from a table or if you have made so many changes to a table with variable length rows such as TEXT, VARCHAR, BLOB or VARBINARY columns. In phpMyAdmin, on the left menu, select the name of the database you want to use.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |