Apache MySQL Backup Tool Sphinx - Free open-source SQL full-text search engine Which Sphinx version are you? Let us help you pick. Beta release. Now with complete JSON support, GROUP <N> BY extensions, HAVING clause, online ALTER, ATTACH into existing RT indexes, even more ranking signals, English and German moprhology, RLP Chinese segmenter support, and more! Please note that some features might not be production stable. If you managed to hit a bug in Sphinx Beta release please submit all the details to our Bug Tracker. What is a Sphinx Beta? most features are production-quality stable;most features come with additional improvements or fixes;newly added features did not have any known major bugs at the time of release;newly added features might be incomplete and/or less tested. Core indexing and searching functionality does, of course, fall into the "existing features" category and should be rock solid at all times. Download Sphinx Beta now! Generally recommended release. “Sphinx Stable Release” means that: Download Sphinx Stable release now!
CentOS 10 Ways to Automatically & Manually Backup MySQL Database Mar 15 2009 MySQL is one of the most popular open source database management system for the development of interactive Websites. If your site stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (we all have been there). There are several ways to backup MySQL data. In this article we’ll look at how to backup your databases using different methods, we will also learn how to achieve an automatic backup solution to make the process easier. 1. Many of users use Amazon S3 to backup their mysql databases. 2. 15 2 * * * root mysqldump -u root -pPASSWORD --all-databases | gzip > /mnt/disk2/database_`data ' %m-%d-%Y'`.sql.gz This post will show you how to backup MySQL Database automatically if you are a linux user. 3. 4. mysqldump ---user [user name] ---password=[password] [database name] > [dump file] 5. Here’s a PHP snippet that outputs your database as XML. 6. 7. 8. 9. 10. 11. Worth Reading
Creating MySQL UDFs with Microsoft Visual C++ Express Some time ago, I announced the MySQL UDF Repository. In short, the MySQL UDF Repository tries to be a one stop place to obtain high quality LGPL licensed libraries containing MySQL UDFs, including documentation and binaries. Since the announcement, our Google Group has grown to a 22 members (including a number of MySQL employees and prominent community members), and we've gained a few interesting new UDF libraries: lib_mysqludf_preg A library authored by Rich Waters providing PERL compatible regular expressions. lib_mysqludf_xql A library authored by Arnold Daniels with many useful functions to map and export relational data from MySQL to XML. Another thing that we see happening now is that people are starting to ask for windows binaries. I want to make a start now by explaining how to create and run MySQL UDFs on Windows using the Express Edition of the popular Microsoft Visual C++ IDE. Preparation Installing Visual C++ 2005 Express Edition Installing the Microsoft Platform SDK USE test; .
70 Things Every Computer Geek Should Know. | Arrow Webzine The term ‘geek’, once used to label a circus freak, has morphed in meaning over the years. What was once an unusual profession transferred into a word indicating social awkwardness. As time has gone on, the word has yet again morphed to indicate a new type of individual: someone who is obsessive over one (or more) particular subjects, whether it be science, photography, electronics, computers, media, or any other field. A geek is one who isn’t satisfied knowing only the surface facts, but instead has a visceral desire to learn everything possible about a particular subject. How to become a real computer Geek? Little known to most, there are many benefits to being a computer geek. You may get the answer here: The Meaning of Technical Acronyms 1. One of the best list of default passwords. 1A. 2. If you rolled your eyes here, that is a good thing. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21.
MySQL User Defined Functions. Free source code and programming help This tutorial explains what an User Defined Function (UDF) is, what it does and why/when they are useful. 1. What is an User Defined Function? Basically an User Defined Function (UDF) is a piece code that extends the functionality of a MySQL server by adding a new function that behaves just like a native (built-in) MySQL function like abs() or concat(). 2. As implied by the name UDFs are useful when you need to extend the functionality of your MySQL server. And by "slow" I mean: "slower than the others"! A little explanation on native functions: The code you have to write here is essentially the same as the one for an UDF. 3. This part is really easy. 4. Now let's get started on writing our first UDF in steps: 5. Now some words to aggregate functions. Now let's look at the new functions needed for the aggregate function. 6. Here are some things you should know when you write more complex UDFs: 7. Do not call any other applications or processes inside an UDF! 8. 9. MySQL Online Manual
Technibble SQL Project: MySQL User Defined Functions. Free source code and programming help Download source files - 10 Kb Download tester - 17 Kb This tutorial explains what an User Defined Function (UDF) is, what it does and why/when they are useful. 1. What is an User Defined Function? Basically an User Defined Function (UDF) is a piece code that extends the functionality of a MySQL server by adding a new function that behaves just like a native (built-in) MySQL function like abs() or concat() . 2. As implied by the name UDFs are useful when you need to extend the functionality of your MySQL server. Method Speed Language Development Stored Procedures slow ~minutes (for small functions) fast ~hour Native Function major pain in the *** And by "slow" I mean: "slower than the others"! A little explanation on native functions: The code you have to write here is essentially the same as the one for an UDF. 3. This part is really easy. 4. Now let's get started on writing our first UDF in steps: Create a new shared-library project (in the example I used VC++ 6.0 with a standard DLL) Type Description