MySQL - 40,000 tables - PHPMyAdmin freezes - Alternative applications ???

I have about 40,000 MySQL tables and I am trying to export about 20 of those tables. Everytime I try to access my database in phpmyadmin it eventually locks up.

What are some alternative applications that support huge databases?

Thanks in advance for any advice.

 

phpMyAdmin should handle that

But only if the "Resource Limits" are set high enough in the "/etc/php.ini" file.

Ran in to that myself with one big table (700 x 500000) a while ago.

 

Maybe you can try this:
http://www.ozerov.de/bigdump.php

 

There is an HTTP timeout set - that prevents phpMyAdmin working with large databases.

You may want to try something like MySqlFront or software from EMS SQL that break up the SQL into Chunks.

 

I think the reason why phpMyAdmin seems to lock up is because it tries to display all 40000 table names on the left panel, thus taking quite a long time to pass all those strings down the line and takes up alot of memory in IE/Firefox/whatever.

If you have shell access(SSH) the best way of all would be to use the mysql client at the command line.

 

I've been using MySQLCC for years now, but when I do a search MySQL is plugging this as the new flavor: http://www.mysql.com/products/tools/administrator/index.html

I am still happy with MySQLCC, but I'll be trying this bad boy soon.

later,

tom

 

why have so many tables in one DB?

 

The new tools like Administrator and MySQL query browser is quite cool, but still I feel Control Center is going to give the same problem as phpMyAdmin as it must retrieve the whole list of tables from the server, which is going to take a while.

Also, if you run Control Center on your local machine and trying to connect to your server, most web servers, if shared hosting, does not give you access from outside.

Tom, what server your running on, some more info would be helpful.

 

I have a shared account too. Most people cannot access their accounts outside, because on the MySQL page for cPanel, there is ip address filter. You have to put in your current ip address, or a wildcard.

hth,

tom

 

cool, and SirTom, what are you running on..?

 

Errr, 40,000 tables? I would in your place go through your database design :\

 

hope this helps.It works very fine for me for 3 months now.
Try it.
http://www.navicat.com/

 

I recommend this as well...I was able to recently get my database, when phpadmin and doing via ssh didn't work.

 

Why not just do it on the SSH command line?

mysqldump --databases DB1 DB2 DB3 -u root -p > filename.sql

Easy!

Owen