SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: back up DB

  1. #1
    SitePoint Guru hisham777's Avatar
    Join Date
    Dec 2005
    Posts
    802
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question back up DB

    hi everybody am trying to make a back for the database, iknow it can be done using PHPMyAdmin.

    with a click it will be downloaded in a text file that incloude the tables
    structure and the content.

    and he can importet and uploaded.

    i know for some it may sound silly and simple.

    i need i directione on how to go about it.

    thanks
    Never be shy to ask silly Qs
    An answer is always better than none

  2. #2
    SitePoint Mentor silver trophy
    Rubble's Avatar
    Join Date
    Dec 2005
    Location
    Cambridge, England
    Posts
    2,443
    Mentioned
    82 Post(s)
    Tagged
    3 Thread(s)
    Select your database.

    Go to export.

    Click Go at the bottom of your page.

    Copy and past the result into a blank page and save.

    There are a load more options about if you want to have the database structure or just the data etc. Just give it a go with different settings.

    To put the data etc. back just to to the SQL section and cut and past your code into the "Run SQL" box and press go at the bottom of the box.

    Thats the simplest way I think; you can get other code which you can have on your server where when you visit a page it will backup you database to a folder on the server.

  3. #3
    SitePoint Guru hisham777's Avatar
    Join Date
    Dec 2005
    Posts
    802
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Rubble for the replay and info.

    i had a diffrent idea.

    Features
    with a click (or may be on weeklly basis) the database will be backed up
    in a text file and emailed to the admin.

    restore the file.
    admin need to download the text file from his email and go to the admin
    page and upload the databse structer and the data in the tables.

    i know its very simple to do in PHPMyAdmin as you have mansioned earllyer.
    but its not whats on my mind.

    i know there are few on line like

    http://restkultur.ch/personal/wolf/scripts/db_backup/

    http://www.phpguru.org/

    and hotscript ofcourse

    but i wanted a thing build from scrach.
    am in the learning of PHP process.
    Never be shy to ask silly Qs
    An answer is always better than none


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
  •