Re: Auto MySQL database backup
Re: Auto MySQL database backup
Quote:
Originally Posted by
Makarov
Cron job for CM$.
That would make the load time to long when its acctuly going to backup, if your database is 200MB it will take ages to load up the website for that 1 poor user.
Also I forgot the set_time_limit, Its updated now.
Re: Auto MySQL database backup
There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.
Re: Auto MySQL database backup
Quote:
Originally Posted by
Matthew
There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.
It works, its better than nothing, plus this is opensource so everyone can see that its has no exploits or some random shit that deletes your database.
So if PHP is so terrible I would like to see you release something better and faster in another language.
Re: Auto MySQL database backup
I have been searching for this for hours.
You can't imagine my excitement and cheers when I saw you post this.
Quote:
Originally Posted by
Matthew
There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.
Please release your method then, since you're so high and mighty this morning.
jks Matthew is the only guy I like to hear criticism from.
Re: Auto MySQL database backup
Re: Auto MySQL database backup
Fix.zip
Fix for IIS users, who use a different path.
NOTE: You MAY need to edit "AutoBackup.bat". Open it in Notepad, CTL+F, type "cd v5.3" and edit it to your correct PHP version. We use PHP V5.3, but if you're using 5.4, you'll need to change it to "cd v5.4".
Re: Auto MySQL database backup
Quote:
Originally Posted by
Oleaa
It works, its better than nothing, plus this is opensource so everyone can see that its has no exploits or some random shit that deletes your database.
So if PHP is so terrible I would like to see you release something better and faster in another language.
PHP: a fractal of bad design - fuzzy notepad
^ Why PHP is bad.
As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible. If you release your work, you might win over the 13 year olds who have no idea about programming and how things scale, that's fine. But there's going to be critics and skeptics. Me being one of them.
Re: Auto MySQL database backup
Quote:
Originally Posted by
Matthew
PHP: a fractal of bad design - fuzzy notepad
^ Why PHP is bad.
As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible.
W/E
I gotta agree that PHP dosent make sence sometimes, things that are not supose to work acctuly works.
PHP works great for me and I hope it always will :)
Re: Auto MySQL database backup
Quote:
Originally Posted by
Matthew
PHP: a fractal of bad design - fuzzy notepad
^ Why PHP is bad.
As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible. If you release your work, you might win over the 13 year olds who have no idea about programming and how things scale, that's fine. But there's going to be critics and skeptics. Me being one of them.
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 ...
Re: Auto MySQL database backup
Quote:
Originally Posted by
joopie
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
Re: Auto MySQL database backup
Quote:
Originally Posted by
joopie
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.
Re: Auto MySQL database backup
Quote:
Originally Posted by
Oleaa
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.
Re: Auto MySQL database backup
Thanks i will use it for my hotel :D
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