I have about 2000 users on a MySQL database - how to export?

Discussion in 'MySQL' started by Alvysyngr, Dec 10, 2011.

0
  1. #1
    I want to use a new script but want to carry over my users. I am no MYSql expert but I think this can be done - how might I get started?
     
    Alvysyngr, Dec 10, 2011 IP
  2. sMe76

    sMe76 Peon

    Messages:
    8
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    If you are running phpMyAdmin you select your database, click on the "Export" tab in the top, select the user table and descide what format you want to export it in. SQL, Excel, CSV, XML ...
     
    sMe76, Dec 11, 2011 IP
  3. Alvysyngr

    Alvysyngr Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I'll experiment - thanks
     
    Alvysyngr, Dec 11, 2011 IP
  4. unique-seo.biz

    unique-seo.biz Greenhorn

    Messages:
    56
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    18
    #4
    if the scripts dont use the same tables and columns, you have a problem and cant export.
     
    unique-seo.biz, Dec 11, 2011 IP
  5. sMe76

    sMe76 Peon

    Messages:
    8
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Not true. You can still export it.
    And if you export it as CSV, for example, you can import the data in to the new table to the new columns.
     
    sMe76, Dec 11, 2011 IP
  6. Alvysyngr

    Alvysyngr Peon

    Messages:
    26
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Time will tell - I may have a custom script created so that would probably help since they can copy the same structure I think
     
    Alvysyngr, Dec 11, 2011 IP
  7. beven

    beven Well-Known Member

    Messages:
    483
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #7
    use phpmy admin easy way to do this sort of tasks
     
    beven, Dec 15, 2011 IP
  8. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #8
    Your new script can use your old data. Alternatively you can just create another table (or even a new database) and write a trivial script to copy the data from the old table (or database) to the new one.
     
    Rukbat, Dec 15, 2011 IP