Support » Fixing WordPress » Database errors and random issues

  • Ok, my site is OLD. I’ve been using it since 2007 and back then I really didn’t know what I was doing. I’m currently on shared hosting but I’m fixing to move to a VPS. My site has random weird issues. sometimes links won’t work but a few minutes later they will. The menu on my mobile theme won’t load, pages load slowly I’m just not happy. I’ve gon into PHPMyAdmin and repaired and optimized my database and also reinstalled WordPress but I’m still having these issues.

    When I migrate is my best bet to just start a new database, do a fresh install of WordPress and somehow migrate all or some of my data over?

    I looked at my daughter’s site and she had 21 tables in her DB mine has 54 so I feel like there is a lot of old crap in there that could just be messing things up. If I start over what the best route to make it simple and not lose my posts, site structure etc…

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hello @bmtrnavsky,
    I will help you with steps and you will not lose any of your posts.

    1. Take backup of your old site database from phpmyadmin
    2. Copy all the source code from your hosting
    3. In new hosting create new database and import the old database
    4. Upload all your old source code to new hosting site
    5. Now goto wp-config.php file and change DB_NAME, DB_USER,DB_PASSWORD and DB_HOST
    6. Once your done with this. If your website url is changing then download this plugin https://wordpress.org/plugins/velvet-blues-update-urls/. Which replace all the website old link with new link.
    7. Now goto admin panel and inside settings menu then permalinks and click on save changes that will generate new .htaccess.

    After doing this steps everything will work fine.

    How do I get rid of all of those old database tables? I can see things in there from themes I installed and no longer use. What will happen if I just export my blog in the dashboard, export Yoast settings, then create a new database install WordPress, import the content from the export I did, import Yoast settings and then start fresh by setting up all my plugins manually? I have a TON of extra database tables and I am not sure why menus and whatnot are not working but I’d like to start as fresh as possible without losing posts and comments.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database errors and random issues’ is closed to new replies.