Pinned Loading

1. Backup Enhance control panel server ... Backup Enhance control panel server assets that are needed in the event of a server disaster

   1

   #!/bin/bash

   2

   3

   ##############################################################################

   4

   # At the least you will need to set the remote transfer credentials and paths.

   5

   # This script will keep 14 days of backups on your destination host.

2. default site setup default site setup

   1

   #!/bin/bash

   2

   3

   wp language core install en_AU

   4

   wp site switch-language en_AU

   5

   wp rewrite structure '/%postname%/'

3. Find all MyISAM database tables and ... Find all MyISAM database tables and output the .sql needed to convert them to InnoDB

   1

   # You will need to login to mysql/mariadb (possibly as root user, or a user with access to all databases) first, usually: mysql

   2

   3

   SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.', table_name, ' ENGINE=InnoDB;') AS sql_statements

   4

   FROM information_schema.tables

   5

   WHERE TABLE_SCHEMA NOT IN ('mysql', 'information_schema', 'performance_schema', 'innodb', 'sys', 'tmp')

4. enhance-related enhance-related Public

   Shell 13 1