/    Sign up×
Community /Pin to ProfileBookmark

alter table on host computer.

Copy linkTweet thisAlerts:
Sep 28.2007

Hi,

I am working on hosting server, I want to alter table on that server(administrator have given me right to modify table design).

I tried phpmyadmin but not working. What other tools can i use?

  • 1. Do I have to download phpmyadmin on my local machine or sever administrator has to do it?

    • I read somewhere that phpmyadmin is web based tool so will it be on my local computer or I will be simply accessing url on hosting server?

  • 2. Which file exactly I have to download to work on windows?

    • 3.Any step by step tutorial about it?

  • 4.

    I have php & mysql or local computer but it’s not configured properly so does phpmyadmin is trying to connect to local MySQL / php but I want it to help me to modify remote table.

  • 5.

    Is alter table query possible with linked microsoft access database (incase phpmyadmin didn’t work for me.)

    • Thank you.

    to post a comment
    PHP

    6 Comments(s) ↴

    Copy linkTweet thisAlerts:
    @aussie_girlSep 29.2007 — If your hosting server has a database, then normally they would have tools to edit it on their servers. Do they PhpMyAdmin as an installation option?
    Copy linkTweet thisAlerts:
    @NightShift58Oct 01.2007 — If nothing else helps, you can write a PHP script that will do it for you, using:

    [b]mysql_query("ALTER TABLE xxx ... etc")[/b]
    Copy linkTweet thisAlerts:
    @NightShift58Oct 02.2007 — If you want to go that route, try SQLyog as well.

    Navicat and I never got friendly.
    Copy linkTweet thisAlerts:
    @SH100authorOct 02.2007 — NightShift58 's idea to fire query from PHP worked for me.

    Thank you everybody for your response.
    Copy linkTweet thisAlerts:
    @MrCoderOct 02.2007 — Navicat just came out with a new version, but I'll have to give SQLyog a go before I look at upgrading.
    ×

    Success!

    Help @SH100 spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 4.28,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,

    tipper: @Samric24,
    tipped: article
    amount: 1000 SATS,
    )...