tech . greg milsted . com

recursive diff

gregmilsted — Thu, 29 Jul 2010 16:31:07 +0000

How to see differencies in different folders recursively.

diff -u -r -B -N -s FOLDER1 FOLDER2

[http://linux.devquickref.com/linux-recursive-diff.html]

Perl arrays within arrays

gregmilsted — Tue, 09 Mar 2010 16:10:20 +0000

http://www.suite101.com/article.cfm/perl/94552

http://www.misc-perl-info.com/perl-array-length.html
EXAMPLE

# Parts and Programme Codes

@PSUB01 = (’PSUB01′,[”Part A”,”Part B”,”Part I”]);
@PSUB02 = (’PSUB01′,[”Part A”,”Part B”]);
@PSUB03 = (’PSUB03′,[”Part A”,”Part B”]);
@PSUB12 = (’PSUB12′,[”Part A”,”Part B”,”Part I”]);
@PSUB13 = (’PSUB13′,[”Part B”,”Part I”]);

@programmecodes = (\@PSUB01,\@PSUB02,\@PSUB03,\@PSUB12,\@PSUB13);

Useful information on getting files (local/urls/etc)

gregmilsted — Wed, 24 Feb 2010 15:52:47 +0000

http://www.php-mysql-tutorial.com/wikis/php-tutorial/reading-a-remote-file-using-php.aspx

EAccelerator - max your PHP

gregmilsted — Fri, 19 Feb 2010 15:05:15 +0000

http://www.geektips.net/105/how-to-install-eaccelerator.html

Setting up Yum on FC2

gregmilsted — Sat, 06 Feb 2010 14:20:58 +0000

http://forums.spry.com/centos-fedora-redhat/201-setting-up-yum-fc2.html

Upgrade to PHP 5 on Plesk 7.5.4

gregmilsted — Sat, 06 Feb 2010 14:19:53 +0000

http://forums.serverbeach.com/showthread.php?t=6125

Upgrading plesk mysql database

gregmilsted — Wed, 03 Feb 2010 13:26:51 +0000

Great article thanks Jeff:

http://jeffbaier.com/articles/how-to-upgrade-mysql-on-a-server-with-plesk/

Restoring a MySQL replication slave (linux)

gregmilsted — Wed, 27 Jan 2010 15:54:57 +0000

If you find the slave you are using is out of sync too much to skip and ignore you really need to do a rebuild. Sometimes this isn’t possible as the database is a live system and cannot be stopped.

Best to open two windows as the next couple of steps need to be done quickly.

On the master server login to mysql and type; show master status;

Make a note of the file and position (masterserver-bin.00000001, 123321123)
Stop the mysql service on the slave server, service mysqld stop

Now you need to copy the live database (MYI, etc.) files from the master server to the slave:

cd /var/lib/mysql/databasename

scp -pr * 192.168.0.1:/var/lib/mysql/databasename/
(p is to copy permissions and r is to copy recursive just in case)

When the copy finishes restart the service on the slave; service mysqld restart

stop slave;

change master to master_log_file=’servername-bin.0000001′, master_log_pos=101010101010;

Now start the slave (start slave;) and run `show slave status;` you may have to skip a couple of files (depending on your db size and how quick you were in the first couple of steps)
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; slave start; show slave status;

Repeat the last step until the database reports no duplicate entries (we also had to repair a table or two - easy `repair table tablename;`)

Deleting incorrectly submitted assignments

gregmilsted — Wed, 27 Jan 2010 10:27:47 +0000

Open the submitted assignments grading page and hover over the file that has been submitted

At the bottom left hand corner of your browser it should give you the full url to that file including after the word assignment the assignment id (i.e. 201) and the student id (i.e. 56), e.g. /assignment/201/56/submittedfile.doc
Open the files directory in a new tab or window and navigate into moddata/assignment/201/56/

Right click on the submitted file and save to desktop (just incase something goes wrong)

Now delete the folder and the file in it (/56/)

There is still a row in the database that says the student has submitted a file so open the database and the assignment_submissions table, search for the assignment id (201) and userid (56)

Delete the row

Go back and log in as the student to check they can now upload a file.

How to identify the file extension of an uploaded file PHP

gregmilsted — Wed, 11 Nov 2009 13:26:49 +0000

$ext = strtolower(substr(strrchr($file[’name’], ‘.’), 1));