Transfer via phpMyAdmin

  • jfambrini

    (@jfambrini)


    8 years ago

    This site of mine is soaking up CPU and memory. Have moved the site three times and still host is throttling CPU usage which is causing the site ranking to drop as it becomes tediously slow and finally becomes inaccessible. I have tried everything from adding Cloudflare, minimizing Css/Js to installing Caching but no effect. Have also changed template and uninstalled all but basic plugins.

    The only thing I can think of now is to do a fresh install of WordPress and then instead of importing the entire SQL dump, I would like to only import posts, categories and menu. Is that possible? If yes which table would I have to export from the existing site and import into the new installation.

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • ixlhosting

    (@ixlhosting)

    8 years ago

    Hi,

    Dit you try to cache with Memcached or Redis? I think your WrdPress site is heavy on the database. So if you cache your database (for example with w3 total cache with redis or memcached) I think you site will be much faster!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    8 years ago

    I think that level of surgery would be difficult at the SQL level. You’d do better with dedicated export/import plugins like WPALLEXPORT and WPALLIMPORT.

    However, before going down that track, you have given us the really important information. What sort of traffic are you getting on that site? Have you optimized your database using a plugin like WP-OPTIMIZE? Are you using shared hosts or have you looked into VPS solutions (managed or self-managed)?

    Thread Starter jfambrini

    (@jfambrini)

    8 years ago

    Thanks IXLhosting and Steve. Right now the only plugins remaining are: WP Smush, Yoast, LiteSpeed Cache (recommended by the host), Themezee Toolit (to display header and footer), Jetpack, Autoptimize and Akismet. Not using WP-optimize, will it supplement LiteSpeed? The Joomla site in the root is getting five time more hits than the WordPress in the folder yet is not encountering any problems even though the content is more in the Joomla site. Will take a at WP-OPTIMIZE.

    There were two menus. I have now removed the larger menu so there is now only one stripped down menu.

    I tried exporting just the posts but it remains incomplete because of CPU/memory issues. I have tried both on shared professional and semi-dedicated. The blog is getting less than 300 hits a day so not sure I can convince the clients to go for VPS.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Transfer via phpMyAdmin’ is closed to new replies.