I want to access my server and look for a specific sql table but I have 40,000 tables in teh sql db so when i load up phpmyadmin and open the db it takes like 10 mins to load to get to one table.

Your DB maybe needs to be optimized...

Which SQL server are you using??

Originally posted by almahdi
Your DB maybe needs to be optimized...

Which SQL server are you using??

mysql, phpmyadmin in cpanel works its just time consuming cause it loads everything.

He said he is using phpMyAdmin... that would naturally lead one to assume he is also using MySQL.

It's interesting that you have 40,000 tables... I'm kind of curious what your usage is that you decided to organize it in that way.

Try this, available for Linux and Windows:

http://www.mysql.com/products/administrator/index.html

Originally posted by inimino
He said he is using phpMyAdmin... that would naturally lead one to assume he is also using MySQL.

It's interesting that you have 40,000 tables... I'm kind of curious what your usage is that you decided to organize it in that way.

Try this, available for Linux and Windows:

http://www.mysql.com/products/administrator/index.html

Its a free forum hosting service.

Access your server via SSH

And run this:
mysqlcheck -o -u root -p --all-databases

To optimize your databases and have faster access time.....

You may try using mysqlfront from http://www.mysqlfront.de/ on your windows PC and access your linux server. You will need to allow external access to mysql server though. It's just another way, but if your database is too large, it will still take delays to show anything. Your best bet is using command line, but will take some learning of the mysql commands. mysql.com for reference.

Originally posted by thomor25
Its a free forum hosting service.

Ah, I see. Well try the link I provided, or log in over SSH and use mysql client directly if you are comfortable with SQL.

Actually I have seen discussions on PHPBuilder from dreamweaver users arguing over a bulletin board type program -- at issue: whether it's easier to create a new table for each new user, or a new database for each new user. The poster wanted code to create a new database for a new user on the fly, as dreamweaver didn't do this automatically.

Those of us suggesting one record per user got blown off.

40,000 databases or 40,000 tables would not be inconceivable.

What on earth could be the rationale for using a table per user?

Falls into the obvious database misuse category if you ask me.

As for creating a database per user, it leads me to wonder if I have misunderstood. You are talking about per user of a forum, right?

Yes, like for Joe Blow
"CREATE DATABASE Joeblow"
Then for Mary Doe
"CREATE DATABASE Marydoe"

etc.

vs "CREATE TABLE Joeblow" , "CREATE TABLE marydoe", etc.

It was astonishing to read: "I need a new database for each user", and have the answer be: "No, you just need a new table for each user", and then a variety of opinions about whether a new table or new database was the preferable approach.

Wow.

<Puts on his DBA hat and reaches for his LART>

It was astonishing to read: "I need a new database for each user", and have the answer be: "No, you just need a new table for each user", and then a variety of opinions about whether a new table or new database was the preferable approach. [/B]
that's what you get when you ask DB question on marijuana lovers' forum.

Check out mysqlfront.

www.mysqlfront.de

Originally posted by jerzy
that's what you get when you ask DB question on marijuana lovers' forum.

I'd say that's insulting to potheads everywhere ;)

is there something web based you can put on your server like phpmyadmin?

Did you read the original post??

I'm the one who made it.

LOL.

Sorry about that :)

I guess (besides not noticing who you were) I didn't understand the question.

Do you mean something like phpmyadmin, but somehow different?

yeah, i want something that i can enter a table and it with fetch it. I don't want it to load all the tables. And since i'm using cpanel the sql connection isn't open i believe.I'm not sure but correct me if I'm wrong guys.

is there something web based you can put on your server like phpmyadmin?

Why yes...There is a flash based one that I like, and it's $5.00!

PHPFlashMyAdmin (http://www.tufat.com/script.php?id_num=7)

Live demo. Buy it, and like it.

Well something you might try with PHPMyAdmin is to write the URL yourself.

Maybe this sounds strange, but try it :)

For example:

http://domain.com/phpMyAdmin/tbl_properties_structure.php?table=dspam_signature_data&db=dspam

All you really need are the db and table arguments. Type that in and hit enter, and there you are. Try that and let me know if it works for you.