Re: [PHP-DB] Back up database - UNIX-docs
Unix from the ground up, thats a toughie. I work with many flavors of unix (AIX, HP UX, Solaris, Linux Red Hat primarily) and I can tell you that there are some significant differences in all of them. There are of course many similarities as well. If I had to recommend something, I would say go for a specific book on the OS you need to learn. I personally started with AIX, wich many consider an odity in the unix world but I wont get into an OS war here. IBM however, does offer all of their unix manuals in pdf format as well as a whole other publishing group which specializes in more specific manuals as well. Thier readily available manuals made AIX much easier to learn from the ground up. If you are truely a "unix newbie", perhaps see if there is one of those "dummies" titles available for your OS (please, no offense intended). They can be very basic, but often contain some good starter information. Larry H. "Bart A. Verbeek" wrote: > > Hello, > > Interesting discussion... > I've been fiddling with cron for a while now, but can't get it to work as I > would. > > Do you know a good website where Unix is explained? I've been looking around > on the internet but can't find a website that describes Unix from the ground > up... > > I'm just a beginner and only work with telnet on a remote unix-machine and > like to know more about the apps on the server, how to check what software > is installed and so on. Just the basics. I know "man [command]" gets you in > the manual, but on my telnet-client the man-pages are difficult to read. > > Hope you know some resources. > mlz > Bart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql and LIKE
I am in the process of setting up some searches in php for a database. Currently my test data consist of about 10k records. I am unsure what the operational total will be but I would bet less than 1 million records. The table in question has 13 fields and of these 13 fields I would like to allow the user to be able to search on 7 of them. To complicate things I would like to allow the user to use multiple colums to do the search. I accomplish this by displaying a form where the user can enter search criteria into all or none of the 7 fields. Obviously the more accurate the returned data the faster and more correct the search will be. In order to allow for the user to enter partial data I use a lot of "like" in the search. I realize that in mysql LIKE uses indexes if it is not prepended with a wildcard so performance should not be too big of an issue there, but what if wildcards are used at the beginning of search criteria? My searches are very acceptable with 10k records, but what can I expect when I hit the 500,000 or even million mark? Please note, I also use offset and limit to limit the returned records and supply prev/next links at bottom of returned data. Anyways, I am just looking for some ideas on a good compromise between allowing users flexability without sacrificing performance. All input welcome -- Larry Hotchkiss http://www.unicap.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql --> Commercial DBs, When will I need to upgrade?
Your DB needs sound more hardware intensive than anything. Your queries sound simple and I would bet you would never need to use anything but mysql. Also keep in mind that mysql/php/apache etc run on more than just PC's. There is some serious hardware out there that can handle unbelieveable amounts of trafficof course non of it is intel based :) If an Intel box can no longer handle the load, you can split your servers so you have one running a web server and another handling the DB, or simply move to some real hardware. (ie HP/Sun/IBM unix boxes). Larry H. Doug Schasteen wrote: > > I've been programming PHP w/ mysql for almost 2 years now for my company. We develop >online testing and surveying software. We are currently running operations for a few >specific companies where maybe 20-30 tests will be taken online per day (it requires >pulling the test questions out of the database in random order, and then putting all >of their answers into the database at the end of the test.) This is currently running >on a shared webserver using php3 and mysql. Recently we've been talking about some >projects that will require a lot more use. (Could be 100 people taking a test at once >or it could be 1000 people taking a test at once. We don't know yet.) > > If anyone has had some experience with upgrading as your operations grow, I'd >appreciate if you could answer ANY of the following questions: > > 1. At what point will mysql blow up (how many tests could be taken at once? How many >rows of results could be stored in a table before it bogs down?) > > 2. At what point will we need a dedicated server instead of shared-hosting? > > 3. How fast of a server do we need? Will a 1ghz server outperform a 500mhz server >when using apache-php-mysql? > > 4. If we need a new database, what is the next step above mysql? I have some >experience with Oracle but it is too expensive. Is there anything inbetween that is >friendly to PHP? > > 5. If MS-SQL is an option for a database-upgrade. What are the implications of >switching our server to a win32-based server? Will we have problems with PHP on >windows when all of our scripts were programmed for unix? > > I realize these are a lot of questions and that we probably need some consulting >work done, but if any of you could share your knowledge on any one of those topics I >would really appreciate it. I just need something to give me a head start in my >research. Point me in the right direction! > > - Doug Schasteen > [EMAIL PROTECTED] > > P.S. - if you know of any good articles online that compare different servers or >databases please share. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP On Linux
Much of the "how to" will depend on the linux you go with. For example, on red hat 7 its all there and installable via RPM's so many of the tutorials on setting it up dont apply unless you dont use the available RPMs and you install via source. If your new to Linux, you may want to just find one that does the install for you and then you dont really have to worry about it. One of the biggest obstacles to overcome comming from a windows environment is making sure your hardware is fully supported. Some devices can make installing linux a pain. Most linux distributions will have hardware compatability lists as well. Larry H Ben Cairns wrote: > > I have nearly 18 Months devel on Windows, but we are now moving to Linux, > > I have never installed PHP On Linux before, so could someone pls give me an > 'Installation Guide' to follow for PHP With MySQL Support, on Linux, > > Also, I would like to know what I have to do with MySQL: You know, what files > go where etc... > > Thanks. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Providing additional information such as the OS your useing as well as your mysql version can be a big help as well. franky wrote: > > I have this error > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > (111) > > what appening? > > AND I CANT connect to mysql for html page why?? > I'm comming crazy! > > -- > --- > -= franky =- > [EMAIL PROTECTED] > --- > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Larry Hotchkiss Universal Capital 612-551-9309 http://www.unicap.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]