R-Ts NetWorks

Server the Best

MySQL database not listed in Plesk interface


A MySQL database was created and still does exist but it is not being listed in the Plesk interface.

Solution :

This usually happens when the database is not created via Plesk. Instead, it might have been created via SSH.

To get around this, there are two ways :

1. This is the simpler of the two.

Just take a dump of the database.

mysqldump -u <username> -p <password> databasename > databasename.sql

Drop the database.

mysql -u <username> -p <password>
drop database <databasename>

Create the database via Plesk.
Plesk Control Panel >> Domains >> Mysql Database >> Add Database

Restore the database.

mysql databasename < databasename.sql

2. Another method is a bit complex one and is advised for expert users only.

After taking a backup of the current psa database, you will have to edit it from the backend and add the database details in the database table manually.

Advertisements

October 13, 2012 - Posted by | Linux

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: