Need my db tables and headers remotely.

Discussion in 'PHP' started by liam1412, Sep 6, 2007.

0
  1. #1
    Hi

    I am at work at the mo and need to do some work on my website. The port that my CPANEL is on :)2083) is blocked in the office. Is there anyway that I can get a full list of my db tables and column headers to output to the screen using php (i don't need the data) I know the db pass and username.

    Any help would be great.

    Thanks
     
    liam1412, Sep 6, 2007 IP
  2. liam1412

    liam1412 Active Member

    Messages:
    387
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Thanks for everyone's help lol.


    Oni kidding. Just a quick bumb as I really need to find out what I have called a column in my DB

    Cheers
     
    liam1412, Sep 6, 2007 IP
  3. sea otter

    sea otter Peon

    Messages:
    250
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Because you have cpanel, you probably also have phpmyadmin, which is a complete mysql database management frontend. You access it from your browser using regular port 80, so you won't run into any blocked port issues.

    Not sure where the login page resides in your directory hierarchy, though.
     
    sea otter, Sep 6, 2007 IP
  4. liam1412

    liam1412 Active Member

    Messages:
    387
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Thanks for the reply

    Yeah I do have phpmyadmin but I think it still runs on the silly port when I try to access it from work. Grrrrr

    Oh well im at home now anyway. Would be handy to be able to get into it at work tho. I asked one of the techies to unblock it for me but apparently it was blocked because someone was accessing CPANEL through it and the management didn't like it lol.
     
    liam1412, Sep 7, 2007 IP
  5. sea otter

    sea otter Peon

    Messages:
    250
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You could install a second copy of phpmyadmin and use that. You could configure it to listen on port 80 and then just access it normally. However, your traffic would be insecure, so if you were worried about someone sniffing your info on the corporate intranet (or elsewhere, I suppose) this could be a problem.

    With some work you could probably get it to work with the certificate you use to log into cpanel.
     
    sea otter, Sep 7, 2007 IP
  6. liam1412

    liam1412 Active Member

    Messages:
    387
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #6
    Still need a solution to this please. All I need is a little script that I can access my DB's at work. Don't need all the functions etc just want my db's printed to screen.
     
    liam1412, Sep 10, 2007 IP
  7. ErectADirectory

    ErectADirectory Guest

    Messages:
    656
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Ok so this is not an elegant solution but why not just do a dump then save the sql file in a password protected folder. This way you won't have any security issues (due to .htaccess protection) and you won't have to go through cpanel to get it.

    If your db changes regularly, you could write a cron to overwrite the sql dump daily. fresh updates, while you work
     
    ErectADirectory, Sep 10, 2007 IP