Associating New Wordpress Installation With Old Database
Jun 30, 2009
I recently had to uninstall WordPress from a blog of mine. The whole thing was down for a while and then I reinstalled WordPress but I'm trying to get the new install to recognize the prior install's database. I have done a lot of poking around and haven't been able to find the answer. I have also contacted the hosting service's customer support and they did respond with a quick answer but it was also a little too vague (or I might just not be understanding it right... but I think I am; I think it was good information they sent but probably just not enough good information).
I found out a easy way to update the Database name of a WP installation through phpmyadmin panel, However I can't seem to update or refresh the Parallels WP Settings with correct information. Is this a bug?
This is how to reproduce:
From phpMyAdmin select the database you want to select, in the tabs there's one called Operations, Go to the rename section.
Update the user privileges to the new Database name and remove the old privileges (save) Then manually update the wp-config file which contains the 'Database name' (save) Then goto Parallels Plesk > Websites & Domains> WordPress Installations > Change Settings
Here you should notice the Change Settings for the WordPress Installation still contains the old Database name.
Windows setup: Plesk Panel 11.5 - Server 2012r2 - IIS 8.5 - PHP 5.3/5.4/5.5 - mySQL/MSSQL. Server runs behind firewall (NAT). Setup with local DNS pointing all A records towards public IP.
Situation: Installed Wordpress through Plesk applications. (mysql). URL....Installs themes in WP console. Everything ok. Installs theme from file, site gets an 500 error. Sometimes installation of theme goes fine, but once activated or previewed it shows 500 error.
Error: Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.
I have installed the Wordpress application. The wordpress url is "server.com/wordpress", but I want to change it to something like "server.com/myblog".
In Plesk, the installation path cannot be changed (at least, it is not under "Change Settings").
Changing the Wordpress installation itself is not that difficult (renaming the folder in httpdocs and changing the siteurl and home parameter in the database), however, in Plesk still the old installation path is shown, and the Plesk interface to Wordpress obviously does not work any more.
How can I change the Wordpress installation path in Plesk?
Version Parallels Plesk v12.0.18_build1200140606.15 os_Ubuntu 12.04 OS Ubuntu 12.04.5 LTS
On server are many Wordpress installations after scan all these were added however about 90% have this tool-tip message "A WordPress installation was previously detected at this path, but it is not operating properly now." How to correct and manage these installations
I have a clean installation of Parallels Plesk on my server, and I installed wordpress on two of my domains. I'm scanning for installations through Plesk Admin, and it shows two installations with empty name and the toolkit is not functional at all. Check the attached screenshot.
When using `plesk bin --update domain.example.com -certificate-name 'certificate'`, Plesk always returns `Unable to find certificate`, I have verified the certificate exists using `plesk bin certificate -l -admin` and the spelling of the certificate name is correct. I can use the WebUI to associate the certificate to the site and have verified it works, however I need to automate this task.
Also, the online documentation for the `plesk bin site` command does not mention the `-certificate-name` option, however it is listed when running `plesk bin site -h`.
The documentation missing the information is found here: [URL] ....
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm ...done. done -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started. ===> Cumulative upgrade of APS controller database has been completed. ===> Cumulative Plesk database upgrade (revertable stage) has been started. ===> Preparing Plesk database upgrade (revertable stage). ===> Cumulative upgrade of Plesk database (revertable stage) has been completed. Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.