View create_emails_from_txt.sh
#!/bin/bash
echo '[Create multiple email addresses in Plesk from a text file easily]'
echo
# ZARZA | A HEAD OF OUR TIME
# https://zarza.com
FILE='mails.txt'
if [ -f $FILE ]; then
while read p; do
View gist:75b907583ecef3c46531
#Try 'REPAIR TABLE postparsed;' first.
DROP TABLE `postparsed`;
CREATE TABLE IF NOT EXISTS `postparsed` (
`Postid` int (10) unsigned NOT NULL default '0',
`Dateline` int (10) unsigned NOT NULL default '0',
`Styleid` smallint (5) unsigned NOT NULL default '0',
`Languageid` smallint (5) unsigned NOT NULL default '0',
`Hasimages` smallint (6) NOT NULL default '0',
`Pagetext_html` medium text,