I'm pretty sure alot of people are having this problem atm, the phpmyadmin pages seem to take forever to load. For all my web hosting accounts. When i first joined (not to long ago) there wasn't too much problems with the phpmyadmin, but now its just ridiculously slow, say 20+ seconds to even load the first page, and thats if the page doesnt time out and display a "The Webpage cannot be displayed" message.
not sure whats wrong, i just wanted to make you guys aware of the issue.
Full Version: Extreamly Slow Phpmyadmin Loading
U can use a script of php which multi-query.. example..
You need to upload the script.php and file.sql in the same carpet, or u can change the path
I do the sql file in a localhost in my home with wamp server, and when it's done, i upload and execute with this script, more fast than phpmyadmin, 0.02 seconds
CODE
<?php
$file_content = file_get_contents('file.sql');
$link = mysqli_connect(localhost, database_user, password, database_name);
/* execute multi query */
if (mysqli_multi_query($link, $file_content)) {
do {
/* store first result set */
if ($result = mysqli_store_result($link)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s\n", $row[0]);
}
mysqli_free_result($result);
}
/* print divider */
if (mysqli_more_results($link)) {
printf("-----------------\n");
}
} while (mysqli_next_result($link));
}
/* close connection */
mysqli_close($link);
?>
$file_content = file_get_contents('file.sql');
$link = mysqli_connect(localhost, database_user, password, database_name);
/* execute multi query */
if (mysqli_multi_query($link, $file_content)) {
do {
/* store first result set */
if ($result = mysqli_store_result($link)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s\n", $row[0]);
}
mysqli_free_result($result);
}
/* print divider */
if (mysqli_more_results($link)) {
printf("-----------------\n");
}
} while (mysqli_next_result($link));
}
/* close connection */
mysqli_close($link);
?>
You need to upload the script.php and file.sql in the same carpet, or u can change the path
I do the sql file in a localhost in my home with wamp server, and when it's done, i upload and execute with this script, more fast than phpmyadmin, 0.02 seconds
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.