| |

Unable to determine the TCP port number used by Microsoft SQL server ‘.\MSSQLSERVER2016

The warning “Unable to determine the TCP port number used by Microsoft SQL server ‘.\MSSQLSERVER2016′” indicates that the SQL Server instance is either not configured to use TCP/IP, or it is configured to use dynamic TCP ports. To resolve this and enable automatic firewall configuration for remote access, the SQL Server instance needs to be…

Get current plesk admin password or reset plesk admin password

Retrieving the current Plesk administrator password depends on the operating system and Plesk version. For Windows servers: Connect to the server via Remote Desktop. Open Command Prompt: From the Start menu, select “Run…” and type cmd. Navigate to the Plesk bin directory: Code cd “C:\Program Files (x86)\Plesk\admin\bin” (Note: The path might vary slightly depending on…

| |

How can I BACKUP a MySQL database from the command line?

Performing a MySQL Database Dump From your SSH command prompt type … mysqldump -u {username} -p {password} {databasename} > {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql} – the file to…

| |

How can I RESTORE a MySQL database from the command line?

Importing a MySQLDUMP From your SSH command prompt type … mysqladmin -u {username} -p {password} create {databasename} mysql -u {username} -p {password} < {databasename.sql} Replace the parameters with the appropriate values {username} – this is your database username {password} – this is the password for your database {databasename} – the name of your database {databasename.sql}…

How to run a PHP script using a custom PHP executable in Plesk Scheduled Tasks?

https://support.plesk.com/hc/en-us/articles/12377377419287-How-to-run-a-PHP-script-using-a-custom-PHP-executable-in-Plesk-Scheduled-Tasks- Log into Plesk. Go to Tools & Settings > Scheduled Task > Add Task; At Script Path, specify the full path to the PHP script on the server. If arguments are needed, specify that accordingly in the with arguments field; At Run field, specify the desired frequency the task should be run; Choose the Run a PHP…