SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2000
    Location
    Grand Rapids, MI
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quirky question on my mind...

    can I backup a remote hosted mysql db? I can't access the .db (or whatever mysql extensions are) file itself... is there a way that I can dump all the data into a delimited file, download it... and if there's a problem later, upload it and read it back in?

    Thanks,

    Mike

  2. #2
    RAGE
    SitePoint Community Guest
    mysql has a "dump" function which u can utilize,. the easiest way is that mysql has a shell program called "mysqldump" .. which will do the query stuff for you, u just need your mysql password + database... telnet to the server, find out where mysqldump is (the same place where the mysql binary is) and run it with --help to see its options, you can dump specifi tables or whole databases..

    ------------------
    Vinay Sahni (vinay@kryogen.com), Coder .. specializing in php/mysql
    ( Realmz ) ( ReviewDepot ) ( . . : : k r y o g e n : : . . )

  3. #3
    SitePoint Wizard silver trophy Karl's Avatar
    Join Date
    Jul 1999
    Location
    Derbyshire, UK
    Posts
    4,411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you have PHP installed on your web server you could use phpMyAdmin from http://www.phpwizard.net to do the job for you. This way is much easier if you don't like messing about with telnet. It also has many other functions that you will probably find useful.

    ------------------
    Karl Austin
    KTech Design Associates - No URL Because It's Not Finished


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
  •