Jump to content

borfast

Members
  • Posts

    3,271
  • Joined

  • Last visited

Everything posted by borfast

  1. www.gimp.org has a better deal: you get The GIMP for $0...
  2. madmoose, it seems you are not a google illiterate after all. My apologies Could you please be a little more specific about your problem? Are you setting the right column types in MySQL? Are you sending the MIME type in the headers when retrieving the image from the database and sending it to the browser? Actually, are you having problems getting the images from the database or storing them there? As for natimage's questions, by "kill your database" I meant that it could hog the server down, making it slow or even unavailable. As for the size, it's actually more a matter of how much will the image be requested. For instance, you can have one single big image with one megabyteor you can also have lots of small images with just a few Kb each and only one person viewing each of them but if you have thousands of visitors to your site... Basically, one big image loaded once isn't any better/worse than lots of smaller images loaded several times. The key is the traffic the images are going to generate on the server. You have to think in terms of how much data will the MySQL server have to transfer, either with big images or small ones. Raul
  3. PHP is the king, no doubt about it About the companies always using ASP, I don't know about other coutries but here in Portugal there's probably less than 1% of all companies using Open Source software. I can also understand the kind oh worries that matman described. But I really think people should start thinking a little more about all this, because just like matman had MS engineers to go and help them, companies can have contracts with other companies who provide support for Open Source software! And no, I'm not talking about little stores that have a crappy webpage and have a problem with a PHP script, I'm talking about corporations as big as Yahoo, which moved all it's database servers to MySQL. MySQL is Open Source but the same guys who make it also provide technical support for a fee. I also read somewhere that Yahoo was planning on converting their backend system from C to PHP. And MySQL is not the only company providing support for Open Source products. There are lots of companies who do that! Also, Yahoo is not the only big company using Open Source products in their business. What I'm trying to say is that the technical support is no longer an excuse (actually, it stopped being an excuse at least 3 years ago) for spending thousands on MS software and then spending MORE thousands on their support. OK, enough rambling, I'll just shut up
  4. Yes, it is possible. Do keep in mind that it may kill your database, if the images are big and are going to be fetched many times. As for how to do it, I could explain you how to do it since I've done it several times but instead, I'll just tell you "learn to use google" http://www.google.com/search?q=storing+ima...start=0&start=0
  5. I'd love to know that too, since I'm using zoneedit for my reselled accounts' nameservers.
  6. Thanks guys. I figured out the SQL REPAIR TABLE stuff but only after Rick replaced the DB with the one in the backup. Since everything was still the same, I thought that the table was already corrupted at the time of the backup, like Lianna noticed.That's when I thought about goig to phpMyAdmin and play around with the REPAIR/CHECK stuff and voilá! It was all OK Thanks anyway
  7. Straight from the phpMyAdmin FAQ: So now we just have to find a way correct all the lines with more than two followed dashes. This shouldn't be hard and since I don't suppose we'll need to import backups everyday, it should't be a bother
  8. OK, after taking a look at the mysqldump man page, I found that the --opt argument that the script uses is what's causing the LOCK TABLES error (it implicitly adds the --lock-tables option to the command line). So I opened up the script and changed this line (67): passthru("mysqldump --opt -h$dbhost -u$dbuser -p$dbpass $dbname >$filename"); into this: passthru("mysqldump -a -e -h$dbhost -u$dbuser -p$dbpass $dbname >$filename"); and now it works like a charm. I now have a cron job with the following command: php -q /path/to/script/dbsender.php and it works just fine. I received the file in my e-mail and it looks OK but I didn't try it with the FTP option, though. But anyway, now I understand your problem with the '---' I wasn't understanding your problem before but once I opened the .sql file, I realized that I wouldn't be able to import that data with phpMyAdmin. mysqldump's man page says we can read the backup back into mysql with one of the following commands: mysql database < backup-file.sql or mysql -e ’source /patch-to-backup/backup-file.sql’ database I tried both commands and none of them worked. The second even has something wrong in its syntax, since MySQL output the whole 'how-to-use' stuff. So right now I'm trying to get a way to either have mysqldump output ## instead of -- or a way to import the file with -- into MySQL. If I find something, I'll post it here.
  9. Yes, that sure is a nice idea! If only I'd have the money to spend on a plane ticket to fly from Portugal to the US... Seriously, it's a really cool idea and it had already crossed my mind but I didn't give it much thought preciselly because of the distance. Anyway, go ahead and do it. I would go for sure, if I'd live closer
  10. Well, if you actually made it to the part where you have a gzip file with an actual database backup in it, you've gone farther than I did. The script says everything is ok but the file is actually empty. So I tried executing the mysqldump command directly and got this: mysqldump: Got error: 1044: Access denied for user: 'best-alm@localhost' to database 'bestalm_ipb' when using LOCK TABLES It's not the same problem you have but I don't know how to fix any of them
  11. borfast

    Site Map

    Nothing like the good old folks at the World Wide Web Consortium (W3C - w3.org) to provide us with nice tools Seriously, if you only need a link checker, try this: http://validator.w3.org/checklink or even this: http://www.linklint.org/
  12. Is the contest limited to residents of the US or can anyone enter, regardless of where they live?
  13. Hi everyone. I have an IPB webboard installed on a client's account in my reseller account (server 15). A few weeks ago, we had a problem with the database: one of the tables (the file itself) got corrupted and we had to drop the table and create it again. It was no big deal since the table contained only session information, so nothing important was lost. But today it happened again and this time, the Topics table went belly up. As you can imagine, this is not good... Anyway, my question is: is it normal that this happens twice in such a short time? Could it be a problem with the server? And since I'm writing here I take the chance to ask: do you guys make backups of the reseller accounts' databases? I'd like to be able to put the database back without loosing all the data in the table I mentioned. Raul
  14. Give this one a try. http://www.phpfreaks.com/script/view/11.php
  15. Well, assuming you're using windows, Mach5 FastStats Analyzer handles that kind of files quite well. www.mach5.com
  16. You can do that with a redirection. Look it up in your CPanel.
  17. Try this: http://xe.com/ucc
  18. You can also turn on hotlink protection so they won't be albe to get the image to their servers - that's the kind of situation hotlink-protection is meant to prevent.
  19. You can delete them but I'd do it from CPanel with the option of uninstalling the Frontpage extensions, otherwise some unwanted files might remain there.
  20. I didn't say it was a huge security bug, I only asked that because I was curious. Anyway, it would indeed be a violation of the EULA, as Rickvz said, so we can all forget about that
  21. That error is appearing because you have something that is outputting something to the browser before sending out the HTTP headers - HTTP headers must be sent before everything else. I don't think it's a domain related problem. PHP says the problem is on line 8 of your script: >output started at /home/nthulee/public_html/102/hausaufgaben.php:8 Check out that line on that file, you'll probably find something there that's outputting some stuff you don't want. By the way, I like your spirit of putting up a webpage for your students. I whish there were professors like you here in Portugal... at least on my university... most of them do have a webpage for their classes but they're all very crappy pages... Anyway, good luck
  22. Just a little clearing: there's no such thing as "Windows ZIP" or "UNIX/Linux Zip". ZIP is a compressed file format, it doesn't care what operating system you use as long as you have a program that knows how to read/write the ZIP format. GZIP (GnuZIP) has builtin support for both GZIP (of course) and ZIP files - I'm not absolutely sure about this but I believe there are some differences between the two formats. What's the meaning of all this? It means that it doesn't matter where the file was created as long as you have a program that knows how to read/write it. If you compressed it on Windows, you can decompress it on UNIX/Linux and vice-versa, as long as you have software that understands the format of the file you want to open or write to. And this applies to every file format there is. There's no such thing as an operating system-specific file format, a file format that can only be opened under one Operating System. To give you another example: MS Office files - people get really surprised when they hand me over some Word or Excel files and then see that I'm using Linux but open the files anyway. Some people have even asked me "What's that version of windows you're running?" and I explain them that it's not Windows. Then they ask me "Then if it's not Windows, how can you open those files?" and... well, I give them this explanation I'm writing here... I hope this cleared things up a bit BTW, the program I use to open MS Office files under Linux is OpenOffice.org -> http://openoffice.org Which, by the way, I recommend to everyone, even Windows users who'd prefer to have something a little lighter than MS Office - OpenOffice.org full download weighs a little under 72 MB while MS Office... well, I don't think that anyone would even consider downloading it from the internet...
  23. Hmm... it should be available... at least phpinfo() reports the '--with-zlib' configuration option, so the zip functions should work. Are you using the right functions? Take a look at http://php.net/zip
  24. Isn't yahoogroups just an interface for mailing lists? You have that (mailman) on your CPanel, I believe...
  25. Hi guys. Bill, I understand bubba_nuts' worries - wouldn't it be so simple as changing the HTML to something like <input type="password" ..... > in the login form? Or is that a violation of the PerlBill license agreement? I suppose it is or you guys would have already changed it...
×
×
  • Create New...