How do I open cPanel on the staging site?

Hello @jeffmcml

if you want to edit your database you need to open it with phpmyadmin or other database administration software. This is available from your cpanel account.

Beside of that, I do not recommend working on the database if there is no experience in doing that.

What do you want to see in the database? Maybe I can help?

I know that I need to use phpmyadmin. To get to it, I need to open cPanel. My question is, how to get to cPanel on the staging site, which has a copy of the database?

I’m not sure if I understand your question.

Cpanel is web hosting administration tool. cpanel also has an integrated FTP file manager. This file manager allows you to edit files on your website. You can use this file manager to access your complete website. It also allows you to edit the entire subfolder of your staging website. Beside of that you can use any other FTP client to access your production and your live website.

If you mean you use a file manager plug-in then you need to install that file manager plugin on your production website. It will show you the sub folder of your staging website and allows you to edit any files in it.

Note: Installing a file manager plug-in on your staging website will not show you the main parent folder of the staging site. It will only show you the underlying folder structure of your staging websit, one level down.

• This reply was modified 6 years, 3 months ago by Rene Hermenau.
• This reply was modified 6 years, 3 months ago by Rene Hermenau.
• This reply was modified 6 years, 3 months ago by Rene Hermenau.

Rene,

My question has nothing to do with files or ftp.

As you know, WP Staging copies the database to the staging site, as well as files. This is one of the reasons I use your plugin. Some of the code I’m developing will make changes in database tables, and I don’t want to affect the main site database. I need to look at the tables to verify that the code is working properly. Thanks for your concern, but I do know how to view and update the tables though phpmyadmin as well as other tools.

But how do I get to the database ON THE STAGING SITE? That’s my question.

Jeff

Hello Jeff,

WP Staging uses the same database as the production site. All database tables of the staging site begin with the prefix wpstgX_

So to change data in the tables of the staging site you use the $wpdb `database object as usual when you work in the staging site. This will not affect any of the tables of the main database because the table prefix is different in the wp-config of the main site.

Check the wp-config of both sites and you will see that the $tbl_prefix value is different in both site configs.

Thanks, Rene. I get it now. This answers my question.