matfish
-
Posts
242 -
Joined
-
Last visited
Posts posted by matfish
-
-
With the above in mind, is it possible to FTP from the local Intranet images to the external website in PHP? So when something is updated internally, it posts everything externally too?
Many thanks
-
Hi there,
What I'm looking to do is when a contact on my local Intranet is updated, it then posts the query to a script running on my website so it updates the contact externally on my website as well as internally.
Is there any way to post a string to an external script? When I use the "header ();" function, it jumps off the internal system to the external system. Any way of doing this without it going off to another site?
Many thanks
-
Thanks all.
There were only a few files chmodded to 0 - this was to stop users viewing these old pages but I didn't want to delete them.
I've backed them up so the site is chmod 0 free and the scripts work fine now.
Thanks for your help
-
Hi there,
Is there a way of .zipping or .taring up /srv/www/htdocs in a .sh script? I can then add it to a cron on a weekly basis as a backup routine?
I've tried a few but if they hit a file which is CHMODed to 0 then it stops.
Many thanks
-
Hi there,
My hosting company is giving me an ear bashing after sending out a huge amount of emails from the server (a newsletter) because of the amount of bounce backs the server is getting.
I tried a few desktop applications which were supposed to check valid email addresses by using DNS/MX however some ISPs block such testing (BT / Hotmail etc..) therefore it filtered out all hotmail email addresses which is obviously incorrect.
I'm currently sending out another newsletter as I type... but this time set up a bounce mailbox.
Is there any way of a script to check this mailbox and strip out the "To: [email@address.com]" so I can then remove all the bounce email addresses from my database?
Any help would be appreciated.
Many thanks
-
Hi there, thanks for your reply. Sorry I have had to remove some of the information below for security reasons!
mysql_back.sh (this works when run in SSH)
#!/bin/bash today=`date '+%Y_%m_%d'` mysqldump [DBname] -h[iPAddress] -P[Port] -u[user] -p[Password] > /var/lib/mysql5dumps/$today.sql
Is this what you mean by listing the crontab?
0 2 * * * /shell_scripts/domain.co.uk/mysql5_backup.sh
Many thanks
-
Hi there, after the great help of my last post ... I'm back again!
For a while now I have had a database backup script (.sh) running (not set up by myself) running every night and placing a backup on the server. However I have never seen a crontab set up for it in Plesk.
Anyhoo - recently the backups have stopped working for no reason - no change on the server. But still no cron tab to check. I set up a cron tab manaully in plesk but the script still will not run.
Its fine if I run it manually in SSH?
Any ideas
Many thanks
-
Hi thorpe,
Yes I read the link, as I mentioned - I'm a newbie I guess and just went back to basics to tail the last 10 lines, It only through a wobbley on the server for a bit then server loads came back down anyhoo.
I'm going to just move them all for now onto some reserved space and see what happens. I can always put them back if things go tits up.
Hours of googling didnt give me the answers you have helped me with.
Thanking you all for your help.
-
I tailed one of the files which was a big mistake, however found it is storing all the query's made on the databases. Its stored all the inserts, updates etc...
Just wondering what would happen if they got deleted?! Would it just start again?
Thanks
-
Hi, Many thanks for everyones help - Seem to be getting somewhere now.
I found:
-rw-rw---- 1 mysql5 mysql5 93M May 20 09:59 mysql-bin.000001 -rw-rw---- 1 mysql5 mysql5 18M May 22 08:40 mysql-bin.000002 -rw-rw---- 1 mysql5 mysql5 386M Jul 3 09:15 mysql-bin.000003 -rw-rw---- 1 mysql5 mysql5 185M Jul 21 11:45 mysql-bin.000004 -rw-rw---- 1 mysql5 mysql5 182M Aug 8 08:45 mysql-bin.000005 -rw-rw---- 1 mysql5 mysql5 3.6M Aug 8 12:46 mysql-bin.000006 -rw-rw---- 1 mysql5 mysql5 117 Aug 8 13:49 mysql-bin.000007 -rw-rw---- 1 mysql5 mysql5 101M Aug 18 10:18 mysql-bin.000008 -rw-rw---- 1 mysql5 mysql5 974K Aug 18 11:58 mysql-bin.000009 -rw-rw---- 1 mysql5 mysql5 4.6M Aug 18 17:17 mysql-bin.000010 -rw-rw---- 1 mysql5 mysql5 19M Aug 20 11:30 mysql-bin.000011 -rw-rw---- 1 mysql5 mysql5 137M Sep 1 10:20 mysql-bin.000012 -rw-rw---- 1 mysql5 mysql5 26M Sep 3 10:08 mysql-bin.000013 -rw-rw---- 1 mysql5 mysql5 529M Oct 14 23:44 mysql-bin.000014 -rw-rw---- 1 mysql5 mysql5 103M Oct 21 16:22 mysql-bin.000015
Which are the logs you refer too. I'm not that advanced to be moving the data folder to a new location. Can these files be deleted or the contents deleted or what do these files actually do and store?
Thanks again
-
Last files modified:
/usr/local/psa/admin/logs/ssl_log: 858K /usr/local/psa/admin/logs/httpsd_access_log: 1.3M /usr/local/psa/admin/logs/ssl_cache.pag: 8.0K /usr/local/psa/admin/sessions/sess_079e5b5c34da2d09e06b7be3c6a65aa1: 1.2K /usr/local/psa/var/log/maillog: 777K /usr/local/psa/var/lock/files/336d5ebc5436534e61d16e63ddfca327: 0 /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table1].MYI: 212K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table2].MYD: 35M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table3]p.MYD: 1.3M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table4].MYD: 15M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table5].MYD: 68M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table6].MYD: 1.4M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table7].MYD: 1.3M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table8].MYI: 22M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table9].MYI: 2.4M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table10].MYD: 9.7M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table11].MYI: 6.0M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table12].MYI: 347K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table13].MYI:1.4M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table14].MYD:15M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table15].MYI: 697K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table16].MYI: 892K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table17].MYD: 11M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table18].MYI: 571K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table19].MYD: 46K /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/[table20].MYD: 2.4M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000015: 102M
Seems they are the tables in the database?
Many thanks
-
Hi rhodesa,
The hosting company will not help me as it was purchased as a dedicated server and should be maintained by myself. They will not even let us purchase more disk space unless we move everything to a completely new server - which I really do not want to do at the moment.
Many thanks
-
Hi Thorpe,
This shows:
/usr/local/psa/var/lib/webalizer/webalizer.cache: 80M /usr/local/mysql-standard-5.0.22-linux-i686/data/[DB-name]/clicktracker.MYD: 68M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000001: 93M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000003: 386M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000004: 185M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000005: 182M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000008: 101M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000012: 137M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000014: 529M /usr/local/mysql-standard-5.0.22-linux-i686/data/mysql-bin.000015: 102M /usr/lib/locale/locale-archive: 51M
What are they related too?
Many thanks for your help!
-
Thanks for the replies.
The server is purchased as a dedicated server with a hosting company, therefore I can only access via Plesk and SSH.
Its only use is the main website and several smaller micro sites. As I said, the database is huge and collects a lot of customer details, registration forms and statistics using PHP and MySQL 5.
Apart from the websites and database, I have no idea what else could be happening on here.. Where would access logs be stored? Since my first post, /usr has used another 8M.
I really don't want to come to the point where it displays "Run out of disk space" across the sites and not knowing what to delete?
Any help would be appreciated.
Many thanks
-
Hi there, bit of a "systems maintenance" newbie.
I have a server, running a big database, with lots of little mico-sites showing the disk space usage below:
Filesystem Size Used Avail Use% Mounted on /dev/md1 989M 412M 526M 44% / /dev/md5 4.9G 4.1G 898M 83% /usr /dev/md7 100G 50G 50G 51% /var /dev/md6 4.9G 126M 4.8G 3% /home none 997M 36K 997M 1% /tmp
I don't really know what is used where, but /dev/md5 lately is on the rise - is this where the database is stored? Will it all come to a stop when /dev/md5 is full?
Many thanks
-
Thanks for the reply.
I will give it a go and let you know.
Thanks again.
-
-
Hi again,
I have a script that runs on Cron which backs up my database every night with a filing format of: 2008_09_10.sql
I want to keep the last 30 days and remove everything previously. I was hoping to put this in a script kinda loop thing and run once a week to delete everything prior to the last 30 days.
Any ideas?
Many thanks
-
-
-
Hi, The problem Iv got is that when searching the site - it brings back different results or sometimes no results.
For example: "i026", "i 026" and "026" do not bring back results for "I-026" which is the correct model number. Any ideas on how to make it search more variations or of a "Did you mean... I-026" script?
Currently does a:
SELECT * FROM table WHERE model_no="%I-026%"
Many thanks
-
-
-
Hi, iv opened it up so there is access for now
http://hardbyte.com/djsdanceschool/
Iv got this problem where there is a weird padding/spacing at the bottom of the page (IE6 only) FF and IE7 is ok.
Any ideas? I though it was a padding/margin issue - you know how FF handles then differently to IE - but I just cant get rid of it in IE6.
Any help would be appreciated before I make the site FF&IE7 users only!
People should only use FF anyway... lol
Post hidden string?
in PHP Coding Help
Posted
Hi, many thanks for the reply.
Yes they share the same database schema, but I'm having trouble with my website hosts - some security issue crap. Which is why I could only find a "work around" by posting a string which would be the local query to a script which would run the query.
Many thanks