Title: Transfer via phpMyAdmin
Last modified: May 1, 2018

---

# Transfer via phpMyAdmin

 *  [jfambrini](https://wordpress.org/support/users/jfambrini/)
 * (@jfambrini)
 * [8 years ago](https://wordpress.org/support/topic/transfer-via-phpmyadmin/)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftransfer-via-phpmyadmin%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [ixlhosting](https://wordpress.org/support/users/ixlhosting/)
 * (@ixlhosting)
 * [8 years ago](https://wordpress.org/support/topic/transfer-via-phpmyadmin/#post-10235434)
 * 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)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [8 years ago](https://wordpress.org/support/topic/transfer-via-phpmyadmin/#post-10235700)
 * 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](https://wordpress.org/support/users/jfambrini/)
 * (@jfambrini)
 * [8 years ago](https://wordpress.org/support/topic/transfer-via-phpmyadmin/#post-10238029)
 * 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.

## Tags

 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [jfambrini](https://wordpress.org/support/users/jfambrini/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/transfer-via-phpmyadmin/#post-10238029)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics