roondog Posted July 3, 2007 Share Posted July 3, 2007 I'm re-designing a site for someone and i'm putting in an admin area. I'm used to using PHPMyAdmin but the host doesn't use it. I want to see what is already on the database that exists, how could i do this. I have the user name and password. Link to comment Share on other sites More sharing options...
houssam_ballout Posted July 4, 2007 Share Posted July 4, 2007 I'm re-designing a site for someone and i'm putting in an admin area. I'm used to using PHPMyAdmin but the host doesn't use it. I want to see what is already on the database that exists, how could i do this. I have the user name and password.Use Select statment in mysql Link to comment Share on other sites More sharing options...
roondog Posted July 4, 2007 Author Share Posted July 4, 2007 Use Select statment in mysqlI don't know what is in the database i.e tables. Can I use select on its own to see everything. Link to comment Share on other sites More sharing options...
houssam_ballout Posted July 4, 2007 Share Posted July 4, 2007 use the command:SHOW TABLES Link to comment Share on other sites More sharing options...
justsomeguy Posted July 5, 2007 Share Posted July 5, 2007 Ask the host if they have another DB admin program. It would be pretty unusual if they had no admin program at all available. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.