Question Where will be the wordpress database?

[Avaneesh b]

I have a wordpress website hosted in the plesk control panel. When i do the sqldump for the database of my wordpress i received the error saying access denied. When i checked the wordpress config file the username and the password i used are correct. I used the following command to run sqldump

"C:\Program Files (x86)\Plesk\MySQL\bin\mysqldump.exe" -u administrator -ppassword wordpress_0>"D:\backup\wordpress.sql"

For further checking i logged in to the mysql database but i did not find my wordpress database. I am little confused, actually where can i find my wordpress database?

 

[IgorG]

Correct command should be like:

"%plesk_dir%\Mysql\bin\mysqldump.exe" -uadmin -p<plesk_admin_password> -P8306 DATABASE_NAME > C:\FULL\PATH\TO\FILE_NAME.sql

 

[Avaneesh b]

Correct command should be like:

"%plesk_dir%\Mysql\bin\mysqldump.exe" -uadmin -p<plesk_admin_password> -P8306 DATABASE_NAME > C:\FULL\PATH\TO\FILE_NAME.sql

Thank you for the quick reply. I tried the command you gave but i am receiving the error

mysqldump: Got error: 1049: Unknown database 'wordpress_0' when selecting the database

 

[IgorG]

Are you sure that you really have MySQL database with name 'wordpress_0'?

 

[Avaneesh b]

Are you sure that you really have MySQL database with name 'wordpress_0'?

yes since the wordpress is running in the same server...

when i checked by loged in i only found the following databases

+--------------------+
| Database |
+--------------------+
| information_schema |
| apsc |
| mysql |
| performance_schema |
| psa |
| test |
+--------------------+
6 rows in set (0.02 sec)

 

[Monty]

Check your wp-config.php file and see which database server and database name your are actually using. Maybe your Wordpress instance is connecting to a remote database server....?

 

[AndrewN]

mysqldump: Got error: 1049: Unknown database 'wordpress_0' when selecting the database

Kindly check your database and user details twice in wp-config.php file, there might be issue with wrong database details provided.

 

[Sumesh]

Hi

Do you have any other mysql server added in the Data bases section in the plesk ? Also are you sure you are seeing this wordpress name in the plesk databases section for that domain in plesk and able to take dump from front end plesk section ?

 

[Avaneesh b]

My wp-config is

/** The name of the database for WordPress */
define('DB_NAME', 'wordpress_0');

/** MySQL database username */
define('DB_USER', 'administrator');

/** MySQL database password */
define('DB_PASSWORD', 'password');

/** MySQL hostname */
define('DB_HOST', 'localhost:3306');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

I don't have any other wordpress hosted in this server and no other mysql database as well.

 

[Sumesh]

Is the Domain working fine ? Also can you see if there is any other mysql server listed other than localhost ?

Tools & Settings > Database Servers

 

[Avaneesh b]

Domain is working fine with no error. No there is only one sql serer listed in the mentioned place

 

[Sumesh]

Are you able to export a dump from plesk interface ? If not then the db may have some how got removed but still I wonder if that is the case then how the site is working.

To save a copy of a database:

1. Go to Websites & Domains > Databases > Export Dump in the database tools pane.
2. Save a dump:
   • To save a dump in a certain directory on the server, select the directory. The home directory of your subscription is used by default.
   • To save a dump on your local computer as well as on the server, select Automatically download dump after creation.

 

[Avaneesh b]

Ok ran the dump from the UI as mentioned. Dump created successfully but i doesn't contain all the data!!.. Dump only contain one of my page rested of the page is not present in Post table

 

[Sumesh]

So some database inconsistency may have happened. It may require a detailed investigation and better to contact your server administrator or service provider for the same

 

[llugguss]

Hey! I had a similar problem, I decided to use those support from a specialist, but at the moment the answer has not come. I hope the information you provided will help me. I have looked at some examples of the databases created, as uscompanieslist.com, and would like to create something similar. I want to distribute it on the Internet and constantly update it to help users. Basically, my database will be a great source that provides information on various companies looking for new employees. I try to collect all the necessary data so that the user can compare the provided options and choose the most suitable one for himself.