How can I edit phpmyadmin exported 1gb database?

Discussion in 'MySQL' started by SkyNet, Sep 29, 2008.

  1. #1
    I've exported the database with phpmyadmin to my comp. It's 1.2gb in size. I would need to delete some tables in it and then import it back on the server.
    The problem is I don't know which program/tool to use to edit the database! Any help will be appreciated!
     
    SkyNet, Sep 29, 2008 IP
  2. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    1) Install a local Mysql server on your computer (preferably same version as your hoster).
    2) Import the data into your local Mysql server
    3) Login to Mysql
    4) Delete/drop the tables that need to go.
    5) Export the database on your local computer
    6) Upload and restore this dump in your hosted Mysql server
    7) Finished
     
    chisara, Sep 29, 2008 IP