Plesk 12.x / Linux :: Copy Database To Other Domain
Jul 7, 2015
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...
After 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.
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:
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?
When 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.
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'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?
After 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?
We 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.
I 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?
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.