borfast

eheh I imagined you guys would prefer to keep it unknown and I totally understand. I just asked because I was really curious And your dad's words are as true as truth can be true...errr... watever that means Seriously, I totally agree with your phillosophy. That's how I treat my customers too because that's how I like to be treated. Honest service, no lies, good relationship between client and customer... what can I say? Thank you for your wonderful service! Rock Sign

Just for curiosity: how many new family members did we get, anyway? Rock Sign

I'm not sure if this will work on TCH's servers but usually you can put some PHP configuration options in .htaccess . For what you want to do, you need to have a .htaccess file in the directory where your .php files live, with (at least) the following content: ><IfModule mod_php4.c> php_value short_open_tag 0 </IfModule> For more information on this, go here: http://www.php.net/manual/en/configuration.changes.php

<tease> If you didn't hate Linux, you could use sendmail and you wouldn't even need to use an SMTP server... Goof </tease>

Yep, that's the script I found some time ago and posted somewhere here at the forums. After changing the variables to suit your needs, you can set up the cron job with a command such as this: php -q /home/best-alm/public_html/mysql_backup/dbsender.php and the timing you find appropriate. Remember to set the appropriate permissions to the folder where you want the script to save your backups. Oh, and you might want to change line 67 from this: passthru("mysqldump --opt -h$dbhost -u$dbuser -p$dbpass $dbname >$filename"); into this: passthru("mysqldump --add-drop-table --add-locks --all --extended-insert --quick -h$dbhost -u$dbuser -p$dbpass $dbname >$filename");

You need to put something like this in .htaccess: ><Files *.html> ForceType application/x-httpd-php </Files>

Bill, you found it by yourself: GIMP for Windows. But the post was actualy there because it irritates me that everyone (and not only here) seems to think Windows is the only operating system there is. For example, when someone asks about an application to do this or that, everyone pops in with sugestions of Windows' programs, without even knowing what's the operating system the person has installed in in's computer... Anyway, never mind, it just irritates me the fact that Microsoft has managed to stupidify the whole computer user world in a way that people no longer know what a computer is anymore. Oh, and no, I'm not one of those people who franticaly defend Linux. I hate those stupid Linux vs Windows flame wars. I believe that people should use whatever fits their needs. So please, no windows vs linux flame wars, ok?

15

15 (you know, a quick reply hack would be much appreciated for this kind of thing )

I like the new icons and I love the new emoticons (although some of them are just too big for the table they're in ) but there's something about the new buttons that doesn't go along with all the rest... at least I dont think they have much to do with the rest of TCH's image... unless, of course, that's your objective and you have new graphics for the rest of the webboard Anyway, nice to see some changes, keep up the good work!

www.gimp.org has a better deal: you get The GIMP for $0...

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

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

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

I'd love to know that too, since I'm using zoneedit for my reselled accounts' nameservers.

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

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

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.

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

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

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/

Is the contest limited to residents of the US or can anyone enter, regardless of where they live?

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

Give this one a try. http://www.phpfreaks.com/script/view/11.php

Well, assuming you're using windows, Mach5 FastStats Analyzer handles that kind of files quite well. www.mach5.com