0

I have wampserver3.3.7, PhpMyadmin5.2.1, PHP8.2.2 and MySql9.1.

When I open PhpMyadmin into my Firefox browser and run a php script that will update and replace a large 500MB mysql table, this update can take 1 hour and during this time, I reload (refresh) my PhpMyadmin page to see if everything is going well because there are different steps in my update that allow me to see the number of entries in my table so that I know if everything is going well.

PhpMyAdmin: table view

PhpMyAdmin: all tables

But when I refresh my different tables into my PhpMyadmin page, it indicates me the number of entries of my old table, as if there was some kind of cache that does not take into account the update of my php script that is running. Do you know how to fix this so that PhpMyadmin tells me the number of entries in my table based on the progress of the update of my php script?

Thanks in advance for your help.

Improve this question
2
  • 1
    My guess is that phpmyadmin gets the row counts from mysql metadata views, which contain estimates and are not refreshed every time you insert data into a table. If this is the case, an analyse table statement can force mysql to update these row counts. Commented Dec 18, 2024 at 14:35
  • Thank you Shadow for your aswer, it work fine when I make into my php script an analyse mysql table statement. Commented Dec 19, 2024 at 10:11
Related questions
355
Setting up foreign keys in phpMyAdmin?
0
Is there any script available which update phpMyadmin table data without reload the browser
0
Phpmyadmin shows random number of rows in database
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.