is there any other script like phpmyadmin?

Discussion in 'PHP' started by baris22, Dec 2, 2007.

0
  1. #1
    Hello all,

    I am using phpmyadmin but i can not do what i want to do with it.

    I am trying to do this:

    List the entries by name and delete the id field which is set to auto_increment and export the table.

    When i do this with phpmyadmin it does not list the entries by name. it saves the old way which was sorting by id.

    Thanks
     
    baris22, Dec 2, 2007 IP
  2. serialCoder

    serialCoder Guest

    Best Answers:
    0
    #2
    you can actually do this in phpmyadmin, what version are you using?

    on table view, you can just click browse, click on the name of the field to order it accordingly, there is a link there that says export, and it will export it according to how you order it :)
     
    serialCoder, Dec 2, 2007 IP
  3. baris22

    baris22 Active Member

    Messages:
    543
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #3
    I do exactly the way you say. After I export it i check the new database and it is not saved the way i listed. It saves the old way.

    I am using phpMyAdmin - 2.10.2.
     
    baris22, Dec 2, 2007 IP
  4. serialCoder

    serialCoder Guest

    Best Answers:
    0
    #4
    hehe, you're actually using a newer version than mine, but that's quite odd as i tested on mine and it saves accordingly based on how i ordered it.
     
    serialCoder, Dec 2, 2007 IP
  5. baris22

    baris22 Active Member

    Messages:
    543
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #5
    Ok. i managed to save it. I was pressing export the one at the top not the one above the table.

    But i have got the same problem. When i import the database i saved it lists the old way.

    This is the original one

    id-color-country
    1-red-france
    2-yellow-england
    3-black-germany

    I sort by country and save it

    2-yellow-england
    1-red-france
    3-black-germany

    When i import the saved database it goes back to

    id-color-country
    1-red-france
    2-yellow-england
    3-black-germany
     
    baris22, Dec 2, 2007 IP
  6. serialCoder

    serialCoder Guest

    Best Answers:
    0
    #6
    i thought you want to delete the auto increment value?
     
    serialCoder, Dec 2, 2007 IP
  7. CaseyC

    CaseyC Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I have never been able to export a table sorted on anything other than the order that the records are physically in the table. For some reason after sorting on any column and then saving, it reverts back to the original order. I always download in Excel CSV mode and then do my sorting in Excel. Saves a lot of grey hair.....
     
    CaseyC, Dec 2, 2007 IP
  8. CaseyC

    CaseyC Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Well, I learned something new......I never saw the additional "Export" button...but that one does keep everything in sorted order. I guess all you will have to do to keep this order when importing is to get rid of the index and replace it with a placeholder.......

    ' '-yellow-england
    ' '-red-france
    ' '-black-germany
     
    CaseyC, Dec 2, 2007 IP
  9. baris22

    baris22 Active Member

    Messages:
    543
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #9
    oK. i SORTED.

    I deleted id. I sorted by country.

    color-country

    yellow-england
    red-france
    black-germany


    I exported. I checked the Complete inserts box.

    I created my old database. I imported the new table.
     
    baris22, Dec 3, 2007 IP