SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    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)
    I use the Dump feature of phpMyAdmin for all my MySQL databases.

    ------------------
    Karl Austin
    KDA Web Services
    "Everyone has a photographic memory. Some just don't have film."

  2. #2
    SitePoint Zealot
    Join Date
    May 2000
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello,

    I was wondering how small websites backup their database. As far as I know, for a mySQL database, you could 'mysql'dump the info, and make the backup, what is the usual method though?

    Can you guys please give me a better idea?

    Thanks
    Arpith



  3. #3
    SitePoint Zealot
    Join Date
    May 2000
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Oh!

    I'll take a look at it.

    Arpith


  4. #4
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can also use it right from your command line. if you telnet in to your sevrer or if you have access already you can use
    mysqldump yourdatabsename > somefile.sql

    This will dump the structure and data of the whole database into a file called somefile.sql

  5. #5
    SitePoint Zealot
    Join Date
    May 2000
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Does the mysqldump work for individual users also, or is it restricted to the root user only?

    Arpith


  6. #6
    exit();
    Join Date
    Jul 2000
    Posts
    759
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use phpMyAdmin

    But instead of just having the file backup display on the screen, can you make it so it imports into a real file? thanks..

    ------------------
    Webmasters' Network
    WebDevHQ.com - The Web Developer Headquarters
    WebmasterChronicles.com - FREE online newsletter!

  7. #7
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To Arpith
    Yes if you have access to a shell account and a mysql account then you should have access to use mysqldump

    To Matt
    In PhpMyAmin when you use the dump you want to check structure and data and check the send checkobix this will send it to a file

  8. #8
    exit();
    Join Date
    Jul 2000
    Posts
    759
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh thanks a lot! I always froze my computer (almost) doing it the other way because I had to copy and paste all the data into a text file

  9. #9
    SitePoint Wizard TWTCommish's Avatar
    Join Date
    Aug 1999
    Location
    Pittsburgh, PA, USA
    Posts
    3,910
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So, dumping an SQL database to a file (like, say, database.sql) is basically making a copy for backup? If so, where is this file stored?

  10. #10
    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 do the dump from the commandline I believe the dump is done to whereever you specify as the output file.

    If you use phpMyAdmin then it gives you a save as dialog in your browser so it downloads it to your local machine.

    With the latest MySQL and MyISAM tables you can just copy the database files from the server straight over to you Desktop machine (Regardless of what OS you run on each of the machines), but most of the time the user you log into the server as will not have access to the database files on the server
    Karl Austin :: Profile :: KDA Web Services Ltd.
    Business Web Hosting :: Managed Dedicated Hosting
    Call 0800 542 9764 today and ask how we can help your business grow.


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
  •