jamesstacyjones

grant all privileges on *.* to root@localhost identified by 'the password' with grant option;
flush privileges;

jamesstacyjones

:1,$d

jamesstacyjones

Find top 20 largest files starting at root directory
du --exclude=/proc* -a / | sort -n -r | head -n 20

List the size of of the folders in the current directory
du -hsx * | sort -rh | head -10

Checks processes that are keeping deleted files open
lsof -s | grep deleted | sort -k 8

Check rotation of error logs ... as it is not working large files are being created

jamesstacyjones

find / -type f -perm /a+x -exec chmod 0644 {} \;
find / -type d -perm /a+x -exec chmod 0755 {} \;

jamesstacyjones

Copy this Regular Expression into Find / Replace:

\r\n|\n|\r

Then click 'Replace All' and bye bye line breaks.

[note] make sure there is no white space before or after the expression

jamesstacyjones

sudo find foldername -type d -exec chmod 775 {} ";"
sudo find foldername -type f -exec chmod 664 {} ";"

jamesstacyjones

UPDATE wp_options SET option_value = ' a:0:{}' WHERE option_name = 'active_plugins';

jamesstacyjones

echo  Propel::getConnection()->getLastExecutedQuery();

jamesstacyjones

.clearfix:before,
.clearfix:after {
  content: "";
  display: table;
}
 
.clearfix:after {
  clear: both;
}
 

jamesstacyjones

SELECT constraint_name, table_name FROM information_schema.table_constraints WHERE constraint_type = 'FOREIGN KEY' AND table_schema = DATABASE() ORDER BY constraint_name;