Auto MySQL database backup

[seanrom]

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

[Matthew]

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.

[XenoGFX]

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.

[Releastixx]

Thanks i will use it for my hotel :D

[Wilou]

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

[mohje]

Nealty ! Top

[seanrom]

Nealty ! Top

Should be up now, btw guys there is a like and rep button if you liked the release :)

[Clawed]

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

[seanrom]

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

The download link is working perfectly fine.

[WJJ]

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

[Jordan]

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

[seanrom]

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

[Jordan]

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.

[r63]

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

[seanrom]

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

You should replace the space with underscore (_)

[EvilCoder]

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,,,

1  3  * * * root /usr/bin/php PATHTOPHPFILE
1  3  * * * root /usr/bin/php /usr/local/bin/mySQLbackup.php

Good luck.

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

[CtarikC]

Thanks!

[seanrom]

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,,,

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