Scripting mysql database backups on phpMyadmin with CURL

17 Responses to Scripting mysql database backups on phpMyadmin with CURL

1. Robert says:

   18/07/2007 at 5:32

   Ever come across:

   Missing parameter: what
   Missing parameter: export_type

   I get it even using your script. No matter what I try, export.php complains exactly the same but it works fine from a browser.
2. Olivier Berger says:

   15/04/2008 at 11:26

   @Robert, you may wish to check the new version if it works for you now.
3. Matt says:

   2/05/2008 at 4:00

   Thank you very much!
   I have been using wget to accomplish the same thing for a few months but after my hosting provider upgrade phpMyAdmin and mySQL, my script no longer worked and would give “missing parameter” errors like Robert experienced. I spent many hours trying to update my script and searching the internet for a solution. Your script worked like a charm and saved my more time wasted!
4. marcoc assisa says:

   6/09/2008 at 17:49

   thank you very much, Olivier!!!
   btw your blog is very nice

   I dropped a note linking to your website here: http://wiki.cihar.com/pma/FAQ_6.4 where an older, no more working script is suggested.
   Hope you’ll appreciate

   marco
5. JimmyJam says:

   8/12/2008 at 23:41

   Very useful indeed.
   I tried to run this script from my Windows system + Cygwin. I had to modify this:
   result=$(tempfile)
   to
   result=$(mktemp)
   Now it works as advertised!
6. obones says:

   1/01/2009 at 23:56

   Hi,

   First of all, many thanks for this script, it looks very promising. I also had to change tempfile for mktemp, but it does not solve all my problems
   I must be doing something wrong as I do not get any dump file, but an error message from mv complaining that it cannot find the export.php file.
   Any idea as to what could be the source of this?

   Thanks
   Olivier
7. niknah says:

   17/01/2009 at 19:24

   I too had my own script and that was working but it stopped working recently with a “missing parameter” problem.
   This script works great, thanks!

   The only thing I had to change was to move the login entry_params to the curl statement(I’m not using basicauth), like…

   curl -d “pma_username=$user&pma_password=$password&server=1″ -s -k -D curl.headers -L -c cookies.txt $server/index.php >$result

   Don’t know why, it wouldn’t login with entry_params as a variable, using bash 3.2.39 (ubuntu 8.10)
8. thomas says:

   18/12/2009 at 13:52

   great script! now my headache are over…

   is there any easy way to exclude tables from the backup?
9. Olivier Berger says:

   24/12/2009 at 15:53

   Thanks @JimmyJam. I’ve updated the version in SVN
10. Olivier Berger says:

    24/12/2009 at 15:58

    @niknah : did you notice I had a condition on the value of the auth variable (=basicauth by default), to support both auth methods ?
11. Olivier Berger says:

    24/12/2009 at 15:58

    @thomas: Dunno… but any patch would be welcome
12. Olivier Berger says:

    22/07/2010 at 9:25

    FYI, I’ve updated the script in SVN to adjust to a more recent phpmyadmin for which it would no longer work.
13. Martin says:

    9/06/2011 at 12:16

    Got the same as Robert 4 years ago:

    Missing parameter: what
    Missing parameter: export_type

    Using phpmyadmin 2.9.1.1-3 (debian) and [curl-backup-phpmyadmin.sh] – Rev 10

    To extract the token I needed one more grep to get only one line to write into $token:

    old:
    
token=$(grep link $result | grep token | sed "s/^.*token=//" | sed "s/&.*//")


    new:
    
token=$(grep link $result | grep 'phpmyadmin.css.php' | grep token | sed "s/^.*token=//" | sed "s/&.*//" )


    Now it is easy to get a backup of my database.

    Thanks Olivier,

    Martin
14. Olivier Berger says:

    12/12/2011 at 18:04

    @Martin : thanks. I’ve integrated your suggestion in the SVN version.

    I’ve also updated it to work with PhpMyAdmin 3.4.5.

    Hope this helps.
15. klara says:

    11/01/2012 at 14:17

    to get the script working for certain hosting providers, the following modification was needed:

    # Then we can reuse these cookies and tokens to prepare a POST for actual login

    entry_params=”-d \”phpMyAdmin=$cookie&phpMyAdmin=$cookie&pma_username=$user&pma_password=$password&pma_servername=$remote_host&server=1&phpMyAdmin=$cookie&lang=en-utf-8&convcharset=utf-8&collation_connection=utf8_general_ci&token=$token&input_go=Go\”"
16. klara says:

    11/01/2012 at 14:20

    The update above did not catch all changes correctly, hopefully this does.
    In essential: to the login entry, pma_servername=$remote_host has to be added:
    # Then we can reuse these cookies and tokens to prepare a POST for actual login

    entry_params="-d \"phpMyAdmin=$cookie&phpMyAdmin=$cookie&pma_username=$user&pma_password=$password&pma_servername=$remote_host&server=1&phpMyAdmin=$cookie&lang=en-utf-8&convcharset=utf-8&collation_connection=utf8_general_ci&token=$token&input_go=Go\""

17. Olivier Berger says:

    7/02/2012 at 12:03

    https://github.com/michaelfraser/remote-backup seems to be very much like what I propose… haven’t had the time to check more (via marco cassisa)