Professional Web Applications Themes

Full MySQL Database Backup - PHP Programming

Hello again guys. Can someone give me an example / script of how to perform a full MySQL backup in PHP? I've done a Google search and a lot of tutorials, etc look way more complicated than I think they should be. I just want someone to show me how I can get the same results if I were doing an export / dump in PHPMyAdmin. In the end, I will have the script send the data / file to the browser as a download, but I know how to do that. Just show me how to do it using ...

  1. #1

    Default Full MySQL Database Backup

    Hello again guys.

    Can someone give me an example / script of how to perform a full MySQL backup in PHP? I've done a Google search and a lot of tutorials, etc look way more complicated than I think they should be. I just want someone to show me how I can get the same results if I were doing an export / dump in PHPMyAdmin.

    In the end, I will have the script send the data / file to the browser as a download, but I know how to do that. Just show me how to do it using all those mysql functions.

    Thanks in advanced!
    trytertqwr is offline Banned
    Join Date
    Aug 2011
    Posts
    23

  2. #2

    Default Re: Full MySQL Database Backup

    You can backup a MySQL database using the following PHP code:

    PHP Code:
    $backupFile $databasename '.gz';

    $command "mysqldump --opt -h $databasehost -u $databaseuser -p $databasepass $databasename | gzip > $backupFile";

    system($command); 
    Ravish is offline S U P E R U S E R
    Join Date
    Aug 2006
    Location
    Internet
    Posts
    21

Similar Threads

  1. Replies: 0
    Last Post: August 24th, 10:13 AM
  2. MySQL Database not retrieving the full database
    By geetha.veeraiah@gmail.com in forum MySQL
    Replies: 4
    Last Post: July 21st, 09:34 PM
  3. php Mysql Backup
    By Roger in forum PHP Development
    Replies: 0
    Last Post: January 5th, 06:22 PM
  4. [PHP] Backup Database
    By Viraj Kalinga Abayarathna in forum PHP Development
    Replies: 2
    Last Post: September 2nd, 07:09 PM
  5. Backup MySQL DB
    By Jeffrey Silverman in forum PHP Development
    Replies: 5
    Last Post: July 16th, 02:46 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139