SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Zealot nyyanks's Avatar
    Join Date
    Jan 2002
    Location
    USA
    Posts
    143
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    What is a database dump

    A guy I work with has asked me to "Email him a dump of the database." . Can someone explain to me what this means, and how I would go about doing so? Thanks.

  2. #2
    SitePoint Member
    Join Date
    Mar 2005
    Location
    Los Angeles, USA / London, UK
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, that depends what database and operating system you're working with...
    If it is MySQL , and if you have CPanel on some hosting account (maybe too many assumptions here...) then dump means basically export of all database tables.
    This can be done with phpMySqladmin, which is in Databases options.

    Other than that you can do it from the shell... look at http://dev.mysql.com/doc/mysql/en/mysqldump.html



    BR
    Konrad

    ---------------------------------
    aNETus Limited - www.anetus.com

    Web design, editable content,
    powerful CMS solutions.
    ---------------------------------

  3. #3
    SitePoint Wizard gold trophysilver trophybronze trophy dc dalton's Avatar
    Join Date
    Nov 2004
    Location
    Right behind you, watching, always watching.
    Posts
    5,431
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah a dump just means "dumping out" the data (and sometimes structure) of the db into either SQL type file, comma or tab delimited file or other such thing.

    As anetus said it kind of depends on what db you are using but all of them either have a gui to do it or it can be done from the command line. If you have a GUI (such as phpMyAdmin, or phpPgAdmin 'postgres") its a lot easier and these things even zip it for you because they can be HUGE ..... I used to know how to do it in Oracle but man its been years!


Bookmarks

Posting Permissions

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