{"id":103,"date":"2011-01-04T04:10:58","date_gmt":"2011-01-04T04:10:58","guid":{"rendered":"http:\/\/www.itcrumbs.com\/?p=103"},"modified":"2019-02-07T04:40:47","modified_gmt":"2019-02-07T04:40:47","slug":"migrating-plesk-windows-to-plesk-linux-a-more-simple-way","status":"publish","type":"post","link":"https:\/\/www.itcrumbs.com\/?p=103","title":{"rendered":"Migrating Plesk Windows to Plesk Linux, a more, simple way"},"content":{"rendered":"

http:\/\/blog.chriswalker.devnetonline.net\/2010\/04\/01\/migrating-plesk-windows-to-plesk-linux-a-more-simple-way?page=2<\/a><\/p>\n

 <\/p>\n

The right way<\/h5>\n

Plesk is pretty interesting in the way that is stores all of its information and handles things, I have to hand parallels that. If you change something on the system without doing it through plesk, its likely to get put back in 10 minutes, this happens because all of plesk’s data is stored in a mysql database. This makes it easy for us to get our passwords back. Trust me, the sigh of relief at the end of a migration and not having to deal with someone saying they cannot get access to something is much much better than having to reset passwords.<\/p>\n

So, first, before we create the account on the target system, we’ll login to the host system. This is targeted at windows to linux, so pull up your command prompt, and get to the mysql exe\/binary file.<\/p>\n

Note this assumes that you are using the default values for everything in plesk.<\/p>\n

Update:<\/h6>\n

I have recently discovered that the code here was actually to get the, now unsupported frontpage password in linux. I was under the impression that these were the same passwords. However, they are not. the FTP password is not viewable. Period.<\/i><\/b><\/p>\n

\/path\/to\/mysql -u admin -p
use psa; select domains.name, hosting.fp_adm,hosting.fp_pass from domains, hosting where domains.id = hosting.dom_id and domains.name = ':::DOMAIN NAME:::<\/strong>';
<\/code><\/p>\n

The above here will get you the FTP Password for the domain that is being migrated. Be sure to change :::domain name::: to the domain name.<\/p>\n

Again in MySQL we’ll be running another command to get the control panel password (Clients password, not the domain administrator)<\/p>\n

\/path\/to\/mysql -u admin -p
select clients.login, clients.passwd from clients where clients.pname = ':::CLIENT NAME:::<\/strong>';
<\/code><\/p>\n

Here, you’ll need to know the clients name (which can probably be gotten from the hosts control panel information if you do not know it already)<\/p>\n

So, we’ve got about half of the passwords we need now. Now we need the mail user passwords<\/p>\n

\/path\/to\/mysql -u admin -p
select domains.name, mail.mail_name, accounts.password from accounts, mail, domains where mail.account_id = accounts.id and mail.dom_id = domains.id and domains.name = ':::DOMAIN NAME:::<\/strong>';
<\/code><\/p>\n

Again, you’ll need to replace :::domain name::: with the actual domain name.<\/p>\n

You’ll now have a list of passwords for creating a good portion of the account on the target system. Put these in the system, you’ll now have the ability to get other passwords as well, such as web users, database users, and the domain users, which are not covered here. Database users can be grabbed from the clients web data.<\/p>\n

I hope this was informative, please feel free to leave questions in the comments section, I will either reply directly back or back on the comments page.<\/p>\n","protected":false},"excerpt":{"rendered":"

http:\/\/blog.chriswalker.devnetonline.net\/2010\/04\/01\/migrating-plesk-windows-to-plesk-linux-a-more-simple-way?page=2   The right way Plesk is pretty interesting in the way that is stores all of its information and handles things, I have to hand parallels that. If you change something on the system without doing it through plesk, its likely to get put back in 10 minutes, this happens because all of plesk’s […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-103","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=103"}],"version-history":[{"count":1,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/103\/revisions"}],"predecessor-version":[{"id":799,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=\/wp\/v2\/posts\/103\/revisions\/799"}],"wp:attachment":[{"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itcrumbs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}