15 {{ upvoteCount | shortNum }}
15 {{ upvoteCount | shortNum }}

Joomla 300GB MYSQL Database Migration to Wordpress,

by BBAkwe
13 replies
I need help with this challenge.
We've been running a Joomla website with over 5000 articles and thousands of images in the database. Our challenge is to migrate this huge mysql database to our new wordpress website.
What should we do? My team doesn't seem to know how to transfer the database. Is there a script we can use? Can someone here help? Thanks
#300gb #database #joomla #migration #mysql #wordpress
  • Profile picture of the author mywebwork
    That would be a formidable task considering the difference in the table structure between the two databases!

    You've probably seen it already but there is a WordPress plugin that claims to be able to move your posts between Joomla and WordPress.

    WordPress › Joomla/Mambo To WordPress Migrator « WordPress Plugins

    But 300GB? That's an incredibly large MySQL database!

    Best of luck with it.

    Bill
    {{ DiscussionBoard.errors[7470028].message }}
  • Profile picture of the author WPcrew
    Something's not right here. DB can't be that big with only 5000 articles. I'll give you rough examples, my friend has joomla + virtuemart, with 1000 products, and lot's of images. DB is around 20mb. I had smf forum with 25000 posts, thousands of images, and db was not much bigger, let's say 100mb, Anyway, images are not saved into into DB, only their urls.

    Try out plugin mywebwork mentioned above on your localhost. See what happens.
    {{ DiscussionBoard.errors[7471161].message }}
  • Profile picture of the author SteveSRS
    300GB database?? Are you sure??

    That is way to big for what you are describing unless you are saving very big pictures as binary data in the database which would be something REALLY wrong (wanna say stupid but don't want to insult just in case)...
    Signature
    {{ DiscussionBoard.errors[7473563].message }}
  • Profile picture of the author digitalquilluk
    I suspect he means 300Gb with the images/attachments and not just the database.

    mywebwork is right the best solution is WordPress › Joomla/Mambo To WordPress Migrator « WordPress Plugins

    However, in my experience that will just move over the articles, you will have issues with image paths, link paths etc

    The bigger issue you will have is maintaining the 'permalink' structure in the new site, or doing re-directs from old to new content. Critical for your SEO

    Advice, setup a test install of Wordpress first and run your imports into that first

    Matt
    Signature

    Matt Houldsworth
    Digitalquill Custom Wordpress Development

    Import XML, RSS and CSV Datafeeds into Wordpress | Import Amazon Products Into Wordpress | Post Automatically Categories in Wordpress

    {{ DiscussionBoard.errors[7474653].message }}
  • Profile picture of the author torrao
    THere are many plugins out there once i shifted my site database from joomla to wordpress by a plugin but that was not more than 20 MB, 300 GB will have same procedure but requires more effort and attention
    {{ DiscussionBoard.errors[7475317].message }}
  • Profile picture of the author Mkj
    Sounds like a 'why bother' scenario. Maybe a typo and the poster meant 300mb? I really can't see how a database could be so big. After all you don't store images in a database. Must be a mistake.
    {{ DiscussionBoard.errors[7477079].message }}
  • Profile picture of the author FirstSocialApps
    Yea no way that its 300GB, has to be 300MB .. 300MB is not really that big,
    Signature
    Create Facebook deals, sweepstakes, contests, polls, custom pages and more without a monthly fee!

    Generate thousands of leads in any niche in under 60 seconds!
    {{ DiscussionBoard.errors[7477522].message }}
  • Profile picture of the author Terry Crim
    It is possible to store images directly inside MySQL database using binary fields and not just links to images stored elsewhere. 300GB could be a typo. If the OP has a dedicated server it is possible to have that size database. You wont find it on a shared hosting plan anywhere though.

    Just wanted to say that it is possible to store images, files, exe's, PDF's inside a MySQL database directly. Some people assume it's not possible but it is if you store directly in a Binary field.

    - T
    {{ DiscussionBoard.errors[7491755].message }}
  • Profile picture of the author SteveSRS
    yes Tim that is what I said... although it is possible it is not very smart to do.. I can't think of any reason why that would be a smart think to do..
    Signature
    {{ DiscussionBoard.errors[7496356].message }}
  • Profile picture of the author TanYaV
    The question was how to migrate a DB to WordPress, not the discussion of its size. You can use import plugins (there are a lot available) and my recommendation is CMS2CMS tool. You'll have to pay, but for a site like yours it would be much faster than fussing with scripts.
    Signature

    regards!

    {{ DiscussionBoard.errors[7820149].message }}
  • Profile picture of the author Rakgan
    As discussion above it seems good, DB is contains only articles and other option setting in My sql. the images stores in hosting space. i think you have to check that properly and, transferring joomla to wordpress is not hard task, but the 300 GB is huge.
    {{ DiscussionBoard.errors[7820301].message }}
  • Profile picture of the author Andrew H
    yes Tim that is what I said... although it is possible it is not very smart to do.. I can't think of any reason why that would be a smart think to do..
    Storing files (as Blob) in the DB is used when security is a primary concern (Criminal record checks)
    Signature
    "You shouldn't come here and set yourself up as the resident wizard of oz."
    {{ DiscussionBoard.errors[7820536].message }}
  • Profile picture of the author DesignPromote
    Backup to small size of files (I have no experience but should be easy to do) and restore with SQL (SQL is supported by all DB)
    Signature
    Website design in Edinburgh
    {{ DiscussionBoard.errors[7822303].message }}

Trending Topics