[MERGED] phpMyAdmin - Slow: (Resolved)

[tjbond]

Quick question.

Is it just me, or does the mysql "phpmyadmin" run very slow?


Also, is their a way someone can import some data into the mysql database for me
(backup from previous forum)

[Victor01469]

No, It's not you, phpMyAdmin runs a bit slow, the reason being the amount of databases that run on the server. It really has nothing to do with server resources, as they aren't too high. I've reserched the issue myself, and the less databases running on a server, the faster it is, which makes sense.

But we also have to remember the amount of members using the service, and the amount of databases they may have. This can certainly add up.

You need to make an SQL backup of your pevious forum. With the SQL backup, in phpMyAdmin, click "import". It then prompts you to browse for the SQL backup file on your computer, and then you upload.

If you are using a free forum host, that gives you no access to your database, most likely they will prevent you from making a backup. (Reason: They don't want you moving). In that case, you may just want to start over, or keep the current forum.

[wwe]

Hahaha I had this issue just last night LOL

I was trying to do a backup of my database via phpMyAdmin and WOW I just shut down the comp because it took way too long LOL

Usually it takes pretty long anyways, but I'm ok with it. Last night though it was taking WAY too long. Timed out last night.

[tjbond]

Originally Posted by victor01469

No, It's not you, phpMyAdmin runs a bit slow, the reason being the amount of databases that run on the server. It really has nothing to do with server resources, as they aren't too high. I've reserched the issue myself, and the less databases running on a server, the faster it is, which makes sense.

But we also have to remember the amount of members using the service, and the amount of databases they may have. This can certainly add up.

You need to make an SQL backup of your pevious forum. With the SQL backup, in phpMyAdmin, click "import". It then prompts you to browse for the SQL backup file on your computer, and then you upload.

If you are using a free forum host, that gives you no access to your database, most likely they will prevent you from making a backup. (Reason: They don't want you moving). In that case, you may just want to start over, or keep the current forum.

Thanks for your response, but I am aware of how to do the mysql import, export ... etc.

My problem is, that everything is pretty much timing out before i get to the location.

For example if i go to click the "phpbb3_forums" table, I'll time out.

[wwe]

That's the usual place it either takes for ever to load or times out.

Getting to phpMyAdmin isn't too long. When you want to get into the tables and what not of your DB is when it takes forever... Once it's loaded and you want to export, it doesn't take that long there either. It's just when loading the tables of your database that it takes a long time.

Just posting some notes for the Admins on this.

[UnlimitedMB]

We will check into this but it seems to be a phpmyadmin problem.

When the database is used with scripts its fast, it seems only phpmyadmin is slow, and only for some people.

On our control panel database we have tables with 10,000+ rows and it loads fast in phpmyadmin, i think it might be due to some pc firewalls.

[Victor01469]

Yes, it is definitely coming from phpMyAdmin, the thing is, it's not exactly a firewall on a user's PC that's slowing it down. There is something internally that is making it slow.

[tjbond]

Originally Posted by victor01469

Yes, it is definitely coming from phpMyAdmin, the thing is, it's not exactly a firewall on a user's PC that's slowing it down. There is something internally that is making it slow.

I'd have to agree that its not a firewall issue.

I have absolutely no firewalls turned on at the moment, and its still slow.

[wwe]

Also I tried it on Internet Explorer in case it was something with Firefox and got the same results..

Well, look into it when you can

[tjbond]

Originally Posted by wwe

Also I tried it on Internet Explorer in case it was something with Firefox and got the same results..

Well, look into it when you can

Same thing here aswell.