Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...
View 5 RepliesAfter the micro update, the database copy function started to hung even just for copying database with 4 tables with less than 10 rows of recrods. Although I followed the link below to remove the hung database copy and remove the unfinished database copied. URL....However, no successful database was copied at all even after the timeout was adjusted.
View 1 Replies View RelatedI've created a database through SSH and give it a user so no problem.
But when i came back in Plesk Panel i don't see this database connected to the domain i want.
So how can i do to "indicate" my server this database must be going with this domain ?
In previous thread we made few manual transfer of our domains.
We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.
All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."
When I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?
View 1 Replies View RelatedWhen I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
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.
I've got a problem to migrate A user from one server to another.
I tried to use the migration manager, but if I start the migration manager the migration will be started but after 2 seconds it has finished and no migration has be doen.
or should I moove the data manually?
Plesk 12.x
CentOS 6.5
Any method for copying the Firewall (extension) rules from one server to another.
Under plesk 12.0.18, I would like to create thousand email address with redirect and send copy to. Its a long work to do.
Is there a solution to create all these email via an import csv, xls or else ?
Ok, new to Plesk, trying to move from ispconfig. So I have Plesk 12 running on Centos 6 64bit in a VPS. I figured out how to upgrade PHP and now I have installed my first website. The website is joomla based but I am getting the below error when installing components:
Warning
Copy failed.
JInstaller: :Install: Failed to copy file /var/www/vhosts/virtual-sim-racing.com/httpdocs/home/tmp/install_55081e65af5fe/pkg_kunena.xml to /var/www/vhosts/virtual-sim-racing.com/httpdocs/home/administrator/manifests/packages/pkg_kunena.xml
Package Install: Could not copy setup file.
This suggest to me a permissions issue - but what to do with it. I have checked all of the relevant Joomla folder permissions and they are all showing as writeable, so it looks like something outside of that?
I don't want to have to stick with ispconfig much longer ...
I am having problems with two accounts, I get the following errors:
Code:
Failed to copy files storage to destination path. stderr: filemng: Cannot open destination file '/var/www/vhosts/domain.tld/httpdocs/index.html.Chn3rn' System error 122: Disk quota exceeded stdout: filemng: Cannot open destination file '/var/www/vhosts/domain.tld/httpdocs/index.html.Chn3rn' System error 122: Disk quota exceeded
I have run the command
Code:
quotacheck -avugfm
And the output from the command
Code:
df -i
is:
Code:
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/vzfs 20000000 1542375 18457625 8% /
/dev/simfs 20000000 1542375 18457625 8% /tmp
/dev/simfs 20000000 1542375 18457625 8% /var/tmp
none 1415577 113 1415464 1% /dev
I am at a loss, I don't know what else to try.
I'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade.
The DB structure
table forum_msgs
It contains a column called "topic_id".
Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id"
I tried this but it doesn't seem to work correctly. Any ideas how it should be done?
insert current.forum_msgs
( topic_id
)
select topic_id
from old.forum_msgs
I've a backup on another server and wish to copy that database onto the new server.
Is there any easy way of doing so?
I can only access the VPS (backup) via it's IP and SSH is working fine. PhpMyAdmin on the server is playing up, as well as a lot of other php-mysql applications.
I added a mail resource and a database resource to the "branding" service template, and made sure the provisioning attributes match up to an actual node. I also made sure that under the resources for the branding template the "Branding Hosting (management node)" -> "Number of MySQL databases" is "1" and the "MySQL Database" is unlimited.
Ive made a primary branded domain assigned to the administrator account. When I then login to the account, I see that the mail resource is added and I can add email accounts. However, the database resource does not seem to be activated. Indeed, if I try to add a application in the domain that requires a database, it fails because there is not a database resource available.
The database server is a separate node from the management server.
I do not see any running tasks waiting, and the events log doesnt mention anything about provisioning a database.
Separately but tangentially related, once the account is up, I dont see it listed as an active subscription under the service template. I should see it there, right?
When I hit my server's domain it redirects me to one of the hosted sites' domain with a 302 redirect. It used to return the default plesk server page. How can I cancel the redirect?
View 2 Replies View RelatedAfter upgrade 11.5 to 12, my panel works fine but nos subscription in the panel.Websites are working well...Is it possible to reconstruct the psa database (no backup :-( ) ?Some backups of psa database are done before the upgrade?
View 2 Replies View RelatedThe SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?
View 1 Replies View RelatedWe are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
View 4 Replies View RelatedERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)
View 3 Replies View RelatedI have a script which checks the mailboxes of all clients to notify them when they're reaching capacity.
This does so by checking the psa database for their set limit and matching that to the maildirsize file within the user's Maildir directory.
After upgrading, though, my SQL query no longer works - it was:
Code:
SELECT clients.email as owner_email, domains.id, domains.name, Limits.value AS domain_quota, mail.mail_name, mail.mbox_quota from Limits, clients, domains, mail WHERE mail.postbox='true' AND limit_name = 'mbox_quota' AND domains.limits_id = Limits.id AND mail.dom_id = domains.id AND clients.id = domains.cl_id ORDER BY domains.name ASC
However, on closer inspection, all values in the domains table for limit_id are NULL.
Has this changed in 11.5? Is there an alternative way to quickly get all limits for domains?
Any way to backup every SQL Databases at once ?
At the moment i need to configure each subscription on my backup program to backup each sql database.
there is any way to set a login that back's up all the databases?
And for the ftp files?
When copy a database, plesk would copy it but hung at creating the db user, therefore, the database cloning message keeps on showing
Cloning the database xxxxxx to the database xxxxx. You will be notified of the progress by email (xxxxxxx).
*I checked if the database was copied, it showed it did but the user was not created for that newly copied one.
I have a virtual server with CentOS 6.4 (Final) and Plesk 11.5.30 and I would like to increase the database size to import because right now it's only 2MB and I have to put online a website with 10MB.
View 5 Replies View Relatedif I can install plesk panel with a dedicated database server... and how.
View 3 Replies View Related1 have to create a new user, for example "webmaster" with ftp access, plesk access and database access.
My problem is: after i make all, this user can see all database for this domain. Can i show him only 1 database (him database)? If yes, how i can do?