Refer to the documentation Changing Database Administrator’s Credentials to change it if needed. Ports 84 should be opened to run the installer. A browser window will be opened with an authorization form requesting the Administrators credentials. Download and run the Plesk Installer ( plesk-installer.exe ) on the server. Note: The password for MySQL admin user is required. Plesk Installation via browser Plesk Installer. To get a list of all database tables sorted by a database name:Ĭ:\> "%plesk_dir%MySQL\bin\mysql.exe" -u admin -p -P 3306 -e "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (table_schema) ASC " To get a list of all database tables sorted by size:Ĭ:\> "%plesk_dir%MySQL\bin\mysql.exe" -u admin -p -P 3306 -e "SELECT table_schema as 'Database', table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES ORDER BY (data_length + index_length) DESC " To get a list of all databases sorted by size:Ĭ:\> "%plesk_dir%MySQL\bin\mysql.exe" -u admin -p -P 3306 -e "SELECT table_schema AS 'Database', ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)' FROM information_schema.TABLES GROUP BY table_schema ORDER BY ROUND(SUM(data_length + index_length)) DESC " Start a command prompt as an Administrator. Unable to clone or backup MSSQL database in Plesk: Property TextHeader is not available for StoredProcedure. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |