Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Jan 2005
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Exporting CSV or Excel files without direct access?

    I'm using phpmyadmin to manage a database and a client would like access so they can download a user generated list from time to time. I know phpmyadmin has that functionality, but is there some other type of program or a way to give them access without worrying about them accidently deleting records/tables while they're in there? An app that just exports the database even?
    Last edited by a4udi; 05-18-2011 at 03:00 PM.

  • #2
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    A PHP (or other server language) script can do this sort of thing pretty easily. You could probably even set up a MySQL command to export, but the level of control you have on the output format is limited to what MySQL offers.

  • #3
    Regular Coder
    Join Date
    Jan 2005
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts
    I've searched for some ideas and thought about just programming something in PHP that spits out the database in a table format on a password protected page, but that just seemed like a lot of work considering MS Excel export is built right into phpmyadmin. I'm surprised there isn't some kind of basic option to be able to just export files without messing around with the tables.

  • #4
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    It's built right into phpMyAdmin because someone coded it. Since PHP isn't compiled you can even look at how that code works; phpmyadmin\libraries\export\csv.php is the csv export module.

    You may also want to look into using mysqldump for this job:

    http://dev.mysql.com/doc/refman/5.0/...ited-text.html


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •