How do i make a copt of a data base

Discussion in 'Programming' started by cosmos, Jan 17, 2008.

0
  1. #1
    I have a cpanel i want to make a copy of my data base for security purpose
    like have DB and copy DB on DB1
    Is it someone can explain or help
    Thank you
     
    cosmos, Jan 17, 2008 IP
  2. awatson

    awatson Active Member

    Messages:
    112
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Really depends on what kind of database you have, and what kind of tools you have on your server... For example if it's MySQL and you have command line access, mysqldump is pretty much all you'd need.
     
    awatson, Jan 17, 2008 IP
  3. cosmos

    cosmos Peon

    Messages:
    441
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    it is MYSQL ,
    command line access? where is that
     
    cosmos, Jan 17, 2008 IP
  4. sagasw

    sagasw Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I think you could use an application "phpMyAdmin", install it in your host.
     
    sagasw, Jan 17, 2008 IP
  5. rkquest

    rkquest Well-Known Member

    Messages:
    828
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    140
    #5
    Since you're using cPanel:
    1. Go to "Backup Wizard".
    2. Click/select "Backup".
    3. Under "Partial Backup", select "MySQL Databases".
    4. Click the database name you wish to duplicate. You will be asked to download an archive file (*.gz). Download it.
    5. Now, create a new database. I'm sure you already know how to do this.
    6. Go to phpMyAdmin and select the new database.
    7. Click "Import".
    8. Upload the archive file (*.gz) using the file-upload form.
     
    rkquest, Jan 17, 2008 IP