SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2009
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Backup Website on Shared Server

    What is the best (or any) strategy for backing up a database on my website, which is hosted at an ISP on a shared server. I don't have full access to the MySql server because that is also shared. ISP provides C-Panel and phpMyAdmin, although these are not the latest versions.

    I used one backup feature I could find but I think it generated SQL code to rebuild the tables and do Inserts. One concern here is that I have some auto-increment columns, so a new insert would probably mean new (different) values. I imagine that would take a very long time to execute as well.

    Is there any true backup and restore in this situation? What's the best I can do?
    Or, will Mysql require a private server?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    phpmyadmin uses mysqldump (which you should look up in da manual), and yes, the backup does generate CREATE TABLE and INSERT statements
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Mar 2009
    Posts
    36
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well Mr. Database Guru that was helpful!
    You provided NO useful information and responded to NONE of my questions.
    What was it you wanted me to look up, that the manual knew what I already told you?

    Anyway, if anyone else knows the best backup strategy for a database hosted on a shared server where I am under some restrictions, I would be very interested - even if they're not in the "Official" Mysql manual.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    wow, who pissed in your cornflakes this morning?

    here ya go...


    One concern here is that I have some auto-increment columns
    the generated INSERT statements preserve those values

    Is there any true backup and restore in this situation?
    yes, using mysqldump

    What's the best I can do?
    use phpmyadmin

    Or, will Mysql require a private server?
    no, it won't
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Guru ripcurlksm's Avatar
    Join Date
    Aug 2004
    Location
    San Clemente, CA
    Posts
    859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wow... what a jerk...

    the first thing you do jerk is log in to phpmyadmin, click on the 'Export' tab, check the 'Save File As' box at the bottom and hit Alt+F4.


Tags for this Thread

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
  •