Can I edit post through FTP or phpMyAdmin or...?

by Kavfka
4 replies
Hello,

I have a client who currently migrated an old website to a new one. However, there are still some old pages which appear online.

Two different looks show up online for one domain.
Old posts are from 2009, 2010. The content is not a duplicate.

There are two themes in HTML folder.

I have access to both of them however, I can edit within WordPress Dashboard only new one. The other one is there in a folder and I have no idea how to edit it.

It looks like this:

https://websitename.com

https://websitename.com/folder-with-old-posts/

These posts have some broken links, broken images, duplicate titles etc. and I need urgently edit them.

I've tried through FTP but can't see files with posts, titles, meta descriptions, etc.

I 've read somewhere that all these data is in a database and can be accessed through phpMyAdmin.

Is it the only way to do that?

Does anybody know how to do that?

Could you point me to some resources on how to do that?

Thank you in advance.

Kind regards,
Kavfka
#edit #ftp #phpmyadmin #post
Avatar of Unregistered
  • Profile picture of the author Peter89
    If you only have ftp access download the full site and try to search for keywords. If you can't find the content in any files then it should be in a database.
    To access a database you need to ssh into the server and use mysqldump command to export the database or mysql command to update it in real time. Or if it's shared hosting usually they provide a control panel where you can do these "visually" like phpMyAdmin.
    {{ DiscussionBoard.errors[11224185].message }}
  • Profile picture of the author sunpeaks589
    You must go through below step

    Log into your cPanel interface.
    select phpmyadmin toolOnce inside the cPanel, find the Databases category and click on the phpMyAdmin tool icon.
    select new databaseYou are now on the main phpMyAdmin page. Find the newly added database and click on its name from the left-hand sidebar.
    select database tableThis opens the database and the screen refreshes with a list of the tables. Using the sidebar again, find and click on the wp-posts table.
    click the SQL buttonLook to the top of the screen and you will see several tabs that run across the page. Click on the SQL tab.
    enter the SQL code and run it
    You are now on a MySQL editor screen. In the code area, copy the following bit of MySQL
    {{ DiscussionBoard.errors[11225574].message }}
  • Profile picture of the author Tony Marriott
    WordPress posts are stored in the database. If you cannot see them in your WP admin page editor then they are probably not in the database.

    However you say they have broken links etc. so you must be viewing them somewhere. How and where exactly are you viewing the old posts?

    If you have a folder with 'old' posts and you cannot see then with FTP they will not be in a standard text file format.

    Possibly that folder contains either and .sql file which is a database export file that may be possible to re-import that via phpMyAdmin.

    Alternatively you may have an .xml file which could be a WordPress export file. This can be imported via the WP admin panel (tools/import)

    For either of the above I would install a fresh WP site and import to that. If you can get them back live it is a simple task to migrate them to your original/new site.

    Trying it on the live site could cause real problems. Especially using phpMyAdmin.

    If the posts are not showing in the admin dashboard then that would need fixing in the database as well. Theoretically possible but for a novice almost impossible.

    As for the suggestions to edit through MySql/PhpMyAdmin. Please don't. If your not 100% sure of what your doing you could break the database and lose everything.

    You could create a clone of the current site and work on that to recover your files without endangering your live site.
    {{ DiscussionBoard.errors[11226527].message }}
  • Profile picture of the author ChrisBa
    Originally Posted by Kavfka View Post

    Hello,

    I have a client who currently migrated an old website to a new one. However, there are still some old pages which appear online.

    Two different looks show up online for one domain.
    Old posts are from 2009, 2010. The content is not a duplicate.

    There are two themes in HTML folder.

    I have access to both of them however, I can edit within WordPress Dashboard only new one. The other one is there in a folder and I have no idea how to edit it.

    It looks like this:

    https://websitename.com

    https://websitename.com/folder-with-old-posts/

    These posts have some broken links, broken images, duplicate titles etc. and I need urgently edit them.

    I've tried through FTP but can't see files with posts, titles, meta descriptions, etc.

    I 've read somewhere that all these data is in a database and can be accessed through phpMyAdmin.

    Is it the only way to do that?

    Does anybody know how to do that?

    Could you point me to some resources on how to do that?

    Thank you in advance.

    Kind regards,
    Kavfka
    If it's Wordpress then the posts are stored in the database.

    You can access this through cpanel then phpadmin.

    This might help - http://www.wpbeginner.com/wp-tutoria...ress-database/
    {{ DiscussionBoard.errors[11226808].message }}
Avatar of Unregistered

Trending Topics