Auto MySQL database backup

Page 2 of 2 FirstFirst 12
Results 26 to 43 of 43
  1. #26
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by joopie View Post
    Well, that article has some points I agree with.
    However it's flexible and easy to understand and (in my opinion) a good way to introduce in other languages.

    But you have to understand that PHP is designed for "WEB DEVELOPMENT" and not to write programmes with it, like database backups or servers.


    And, take a look at this wiki page...
    HipHop for PHP - Wikipedia, the free encyclopedia ...
    Thanks for the HipHop for PHP tool.
    And yes im aware that PHP is mainly for web development, but PHP was the only language I could code it properly! Thats why I used PHP

  2. #27
    No, Just no. Matthew is offline
    MemberRank
    Jul 2008 Join Date
    United KingdomLocation
    1,408Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by joopie View Post
    Well, that article has some points I agree with.
    However it's flexible and easy to understand and (in my opinion) a good way to introduce in other languages.

    But you have to understand that PHP is designed for "WEB DEVELOPMENT" and not to write programmes with it, like database backups or servers.


    And, take a look at this wiki page...
    HipHop for PHP - Wikipedia, the free encyclopedia ...
    Yes. But the issue is, is that it promotes bad programming practices from the beginning. As any real language wouldn't let you do half the stupid stuff PHP does let you do. And on the PHP manual its self it promotes bad programming in it's comments.

  3. #28
    Member XenoGFX is offline
    MemberRank
    May 2010 Join Date
    97Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by Oleaa View Post
    Thanks for the HipHop for PHP tool.
    And yes im aware that PHP is mainly for web development, but PHP was the only language I could code it properly! Thats why I used PHP
    use a batch file :( i'm sad because people should know copying files would consume less i/o than creating text files with each subsequent insert statement.

  4. #29
    Apprentice Releastixx is offline
    MemberRank
    Oct 2012 Join Date
    AustraliaLocation
    12Posts

    Re: Auto MySQL database backup

    Thanks i will use it for my hotel :D

  5. #30
    Enthusiast Wilou is offline
    MemberRank
    May 2011 Join Date
    36Posts

    Re: Auto MySQL database backup

    The link is dead can you reupload please - goob job it's very useful :) Sorry for my english i'm frensh

  6. #31
    Account Upgraded | Title Enabled! mohje is offline
    MemberRank
    Dec 2008 Join Date
    NLLocation
    651Posts

    Re: Auto MySQL database backup

    Nealty ! Top

  7. #32
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by mohje View Post
    Nealty ! Top
    Should be up now, btw guys there is a like and rep button if you liked the release :)

  8. #33
    Lurking around Clawed is offline
    MemberRank
    Jun 2012 Join Date
    RaGEZONELocation
    785Posts

    Re: Auto MySQL database backup

    May i just point out that the download link is down.

  9. #34
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by Clawed View Post
    May i just point out that the download link is down.
    The download link is working perfectly fine.

  10. #35
    *lurks* WJJ is offline
    MemberRank
    May 2007 Join Date
    United KingdomLocation
    1,589Posts

    Re: Auto MySQL database backup

    Thanks for this Oleaa.

    Too many users dont backup their databases and then cry when it goes wrong and they loose all their users. Theres no excuse now! lol.

    Will

  11. #36
    Chasing 99 Red Balloons Jordan is offline
    MemberRank
    Jan 2008 Join Date
    UKLocation
    1,763Posts

    Auto MySQL database backup

    Use a crontab instead of keeping the process running your wasting cycles and memory :)

  12. #37
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by Jordan View Post
    Use a crontab instead of keeping the process running your wasting cycles and memory :)
    Poor visitor that triggers the cron, its gonna take ages from them toload up:/ But I do get your point

  13. #38
    Chasing 99 Red Balloons Jordan is offline
    MemberRank
    Jan 2008 Join Date
    UKLocation
    1,763Posts

    Auto MySQL database backup

    Quote Originally Posted by Oleaa View Post
    Poor visitor that triggers the cron, its gonna take ages from them toload up:/ But I do get your point
    Use a unix crontab not a PHP one.

  14. #39
    Account Upgraded | Title Enabled! r63 is offline
    MemberRank
    Jan 2012 Join Date
    apt-get GPSLocation
    430Posts

    Re: Auto MySQL database backup

    How can I make it work when the file path contains a space? :L

  15. #40
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by r63 View Post
    How can I make it work when the file path contains a space? :L
    You should replace the space with underscore (_)

  16. #41
    1 + 3 + 3 = 7 EvilCoder is offline
    MemberRank
    Jul 2009 Join Date
    /home/mvdworpLocation
    334Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by Jordan View Post
    Use a unix crontab not a PHP one.
    Nobody except for people knowing what they are doing is running their hotels on Linux. For example im running it on 3 servers. Kind of fun.... We all know that linux is way more stable, and your database is much safer on a linux machine... Well some of us do...

    Good advice btw,,,

    Code:
    1  3  * * * root /usr/bin/php PATHTOPHPFILE
    1  3  * * * root /usr/bin/php /usr/local/bin/mySQLbackup.php
    Good luck.

    Quote Originally Posted by Oleaa View Post
    You should replace the space with underscore (_)
    %20 is space char

    Example:
    "c:\program%20files\backups\open%20backup%20file.bat"

    Make sure thats between these 2 chars; " "

    instead of:
    C:\program files\backups\open backup file.bat

    ~~ Mikey

  17. #42
    Member CtarikC is offline
    MemberRank
    Feb 2012 Join Date
    63Posts

    Re: Auto MySQL database backup

    Thanks!

  18. #43
    ☮TAKU???? seanrom is offline
    MemberRank
    Nov 2009 Join Date
    1,004Posts

    Re: Auto MySQL database backup

    Quote Originally Posted by Mister. M View Post
    Nobody except for people knowing what they are doing is running their hotels on Linux. For example im running it on 3 servers. Kind of fun.... We all know that linux is way more stable, and your database is much safer on a linux machine... Well some of us do...

    Good advice btw,,,

    Code:
    1  3  * * * root /usr/bin/php PATHTOPHPFILE
    1  3  * * * root /usr/bin/php /usr/local/bin/mySQLbackup.php
    Good luck.



    %20 is space char

    Example:
    "c:\program%20files\backups\open%20backup%20file.bat"

    Make sure thats between these 2 chars; " "

    instead of:
    C:\program files\backups\open backup file.bat

    ~~ Mikey
    I also run my MySQL and HTTP on Linux, then my Phoenix on Windows. works great.
    Thanks for the cron



Page 2 of 2 FirstFirst 12

Advertisement