Zymic Forums

Webmaster resources

Zymic IRC Server

Chat in real time at irc.zymic.com - Learn More

Welcome

Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.

In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.

left Zymic Webmaster ForumsZymic Free Web HostingDatabases & MySQL right
  Reply to this topic Start new topic
left right
Peeki
post May 13 2009, 01:36 PM
Post #1


Member
**

Group: Members
Posts: 49
Joined: 11-April 09
From: Australia
Member No.: 90,947



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.
Go to the top of the page 
 
  + Quote Post
Arcolina
post May 14 2009, 10:31 AM
Post #2


Newbie
*

Group: Members
Posts: 3
Joined: 11-May 09
Member No.: 94,666



U can use a script of php which multi-query.. example..

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);
?>


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 wink.gif
Go to the top of the page 
 
  + Quote Post
 Reply to this topic Start new topic
left right
0 Members:
left right
 


Lo-Fi Version Time is now: 21st November 2009 - 09:36 AM