Archive

Archive for November, 2009

Transfer database between domains in Plesk

November 30th, 2009 admin No comments

If you are moving the database from one domain to another on the same server, and you want to keep the database name the same, you just need to change the owner of the database in the ‘data_bases’ table in the psa database.

The table uses the field ‘dom_id’ as a reference to the owner. Look in the ‘domains’ table to find the ‘id’ of the domain you are using and the one you wish to move to then make the change in the ‘data_bases” table.

Once changed, you will see the database listed under the new domain in Plesk. You can then add/change usernames and passwords through Plesk as normal.

You can do all the above through the command interface (SSH) or you can do it the easy way with a tool like phpMyAdmin installed.

Source: http://forums.serverbeach.com/showthread.php?t=164

Categories: plesk Tags:

How to search for a string in a selection of files

November 30th, 2009 admin No comments
find . -exec grep "www.athabasca" '{}' \; -print

This command will search in the current directory and all sub directories. All files that contain the string will have their path printed to standard output.

Source: http://www.athabascau.ca/html/depts/compserv/webunit/HOWTO/find.htm

Categories: unix / linux Tags:

Pulls FTP password out of Plesk database

November 27th, 2009 admin No comments
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "use psa; select accounts.password from accounts INNER JOIN sys_users ON   accounts.id=sys_users.account_id WHERE sys_users.login='xxxx';"

Categories: plesk Tags:

Reconfigure vhost in Plesk

November 27th, 2009 admin No comments
/parallels_plesk_panel_installation_directory/admin/sbin/websrvmng --reconfigure-vhost  --vhost-name=

On Centos 5

/usr/local/psa/admin/sbin/websrvmng -u --vhost-name=domain.com

Categories: plesk Tags:

MySQL root can be viewed with

November 24th, 2009 admin No comments
cat ~mysql/.my.cnf

Categories: mysql Tags:

kill do_backup process for 4PSA Total Plesk Backup

November 22nd, 2009 admin No comments

To debug kill the do_backup process:

killall -9 do_backup

and run it with debugging:

/usr/local/tbackup/do_backup -d

You should see exactly what happens.

Categories: unix / linux Tags: