mysql database extract 500,00 codes?

Discussion in 'Databases' started by rtyhgn85, Apr 21, 2011.

  1. #1
    My friend need to save 500,000 codes from his database, but viewing the page is crashing for his because he changed it from showing 30 to 100,00 at once and he cant view that page now it wont stop loading.. he has not got a clue what to do... pleaseeeee help!

    Thanks in advance
     
    rtyhgn85, Apr 21, 2011 IP
  2. Sepehr

    Sepehr Peon

    Messages:
    568
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #2
    not sure what you mean by codes but what are you using to do this? PHPMyAdmin? if so you can use the export feature on your query which will provide you a zip file containing the info in your desired format(PDF, CSV, Excel and ...) to download.
     
    Sepehr, Apr 21, 2011 IP