Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Mar 2011
    Posts
    164
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Back Up MySQL Databases

    Hi - how do you guys backup your MySQL databases?

    I have a few programs that have an auto-back up that make an .sql file which is great (for example OpenCart) but I also use OpenX which runs on PHP and has a database. That does not have an auto-back-up feature so do I just download the database and that's it?

    Any tool or program you guys recommend?

    Thanks

  • #2
    Regular Coder
    Join Date
    Mar 2011
    Posts
    164
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Basically using phpMyAdmin is the easiest way right? Just go in and download?

  • #3
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,028
    Thanks
    75
    Thanked 4,325 Times in 4,291 Posts
    If you can, the best way is just using the command line interface. I have heard the phpMyAdmin has a limit on how large a database it can restore (no idea if that is true or not--just something somebody here complained about once). I have used the command line interface to backup and restore DBs as large as 20GB. Not a pleasant thing to do, but it works.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #4
    Senior Coder
    Join Date
    Jun 2008
    Location
    New Jersey
    Posts
    2,535
    Thanks
    45
    Thanked 259 Times in 256 Posts
    The phpMyAdmin restore is only limited by the PHP file upload limit. Its usually pretty small, like a meg or two, which isn't enough for a lot of database restoration. Change the ini or runtime values to something higher and you're fine.

  • #5
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,028
    Thanks
    75
    Thanked 4,325 Times in 4,291 Posts
    Still, I doubt you could upload a 20GB file with PHP. But why couldn't you use FTP and then , once the file is uploaded, just use it from phpMyAdmin??
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #6
    New Coder
    Join Date
    Sep 2011
    Posts
    80
    Thanks
    0
    Thanked 13 Times in 12 Posts
    PHPMyAdmin imports make me want to shoot myself, if your database allows remote connections use a light weight tool such as HeidiSQL for manual backups and restorations.

    Using PHPMyadmin you have to contend with:

    - Max post request limits
    - PHP execution time limits
    - The fear you have to start from the very beginning.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •