[Help] Convert the SQL dump developed in Joomla 1.3 to Joomla 5.0

Discussion & Solutions
1

A friend asked me to rebuild a website built in Joomla 1.3. I am an expert in building WordPress websites.
Unfortunately I only have basic knowledge of Joomla. I installed localhost Joomla 5, but when I imported the SQL dump of the website I got a lot of errors.
How can I convert the SQL dump developed in Joomla 1.3 to Joomla 5.0?
Otherwise, about 15 years of information loaded into the database will be lost.
Can I convert it to use it in WordPress?
Otherwise, what solution do I have to avoid losing the information?
I read online that I need to upgrade from 1.3 to 1.5, 2.5, 3.x, 4.x, 5.x but I CAN’T FIND VERSION 1.5 TO INSTALL IT.

2

I don’t know if this is helpful or not, but I usually use https://rolandd.com/products/ro-csvi to migrate data from one Joomla website to another.
Oh, btw, there is no Joomla 1.3, but Joomla 1.0
If the Ro CSVI doesn’t work or you don’t have the money to subscribe to it, just try using ChatGPT codex to make Joomla 1.0 export plugin and Joomla 5.4 import plugin

3

Thanks, but neither of the 2 solutions are viable.
For the first solution, I won’t give $75.
What about the 2nd solution, AI, suggested an unclear solution to me.
Anyway, thanks for the reply.

4

I can try it, if you give me sql

6

I have an archive containing SQL dump joomla.sql and configuration.php files.

7

Hey @teodor11 — breathe. Your 15 years of data isn’t going anywhere.

:zombie: First, the plot twist

Joomla 1.3 doesn’t exist. Never did. What you actually have is Joomla 1.0.x (or possibly Mambo, its weird uncle). The forums just mislabel it constantly.

That’s why importing directly into Joomla 5 exploded. You’re trying to feed a 2024 engine fuel from 2004. It’s not compatible. At all.

:wrench: Before anything else — fix your SQL file

Open your .sql dump in any text editor. Find and replace:

TYPE=MyISAM → ENGINE=MyISAM

Modern MySQL literally won’t accept the old syntax. Skip this step = enjoy cryptic errors forever.

:railway_track: Your actual options (all free)

🥇 Option 1: jUpgradePro — Skip the bullshit chain entirely

Forget the 1.0 → 1.5 → 2.5 → 3.x → 4.x → 5.x nightmare.

jUpgradePro on GitHub is free and does Joomla 1.0 → 3.x directly via database connection.

Steps:

  1. Install fresh Joomla 3.10 locally
  2. Install jUpgradePro component
  3. Point it at your old database
  4. Migrate
  5. Then upgrade 3.10 → 5.x using Joomla’s built-in updater

No $75. No hunting for ancient installers. No PHP 5 requirement.

Important: Use “Database Method” in the settings, not RESTful. Your old site doesn’t need to be running.

🥈 Option 2: Escape to WordPress (you said you're a WP expert)

The famous FG Joomla to WordPress plugin? Free version doesn’t support Joomla 1.0. That’s a €40 feature. Fuck that.

Free workaround:

  1. Export your content with this SQL query:
SELECT id, title, alias,
CONCAT(IFNULL(introtext,''), IFNULL(`fulltext`,'')) AS content,
created, modified, state
FROM jos_content ORDER BY created;
  1. Export as CSV
  2. Use WP All Import (free) to import into WordPress
  3. Map columns: title → Post Title, content → Post Content, created → Post Date

Your table prefix might be mos_ instead of jos_ — check your actual dump.

🥉 Option 3: The step-upgrade path you read about (if you hate yourself)

Yes, those old versions still exist:

The catch: Joomla 1.5 requires PHP 5.x. Modern servers run PHP 8. You’ll need XAMPP or MAMP with legacy PHP enabled locally.

Honestly? Use Option 1 or 2 instead. Life’s too short.

:file_folder: Don’t forget your images

Whatever method you pick — manually copy your /images/stories/ folder to the new site. No tool migrates the actual image files, just the database references to them.

:bullseye: Summary for your situation

You’re a WordPress expert. Your data is stuck in ancient Joomla.

Fastest path: CSV export → WP All Import → done. You’re on WordPress in an hour.

Want to stay Joomla: jUpgradePro database method → J3.10 → upgrade to J5.

Both are free. Both work. Pick one and stop stressing.

8

@teodor11 — Done. Your data is rescued. :tada:

:package: Download your fix

joomla_migration_package.zip — everything ready to import

:card_index_dividers: What’s inside

File Use it for
wordpress_import.xml WordPress — easiest for you :star:
joomla5_migration.sql Joomla 5
wordpress_migration.sql WordPress (SQL method)
data_export.json Raw data backup

:white_check_mark: What got saved

  • 20 articles (MEDING, REPARATII, LOCURI DE MUNCA — all your 2004-2008 content)
  • 11 categories
  • 4 sections
  • 1 user (admin)
  • 35 menu items

All dates, all metadata — preserved.

:rocket: For WordPress (recommended — you’re a WP expert!)

  1. Install fresh WordPress
  2. Go to Tools → Import → WordPress → Upload wordpress_import.xml
  3. Map authors
  4. Copy your old /images/ folder to wp-content/uploads/
  5. Install plugin “Better Search Replace” — fix image paths
  6. Reset passwords (old ones won’t work)

Done in 10 minutes.

:wrench: For Joomla 5

Click here for Joomla 5 steps
  1. Install fresh Joomla 5 locally
  2. Import the SQL file:
mysql -u root -p yourdatabase < joomla5_migration.sql
  1. In admin: System → Maintenance → Database → Fix (rebuilds categories)
  2. Reset admin password (MD5 from 2004 won’t work)
  3. Copy your old /images/ folder

:warning: Important

  • DON’T import your old sql.zip directly — it will fail
  • DO use these new converted files
  • Passwords must be reset — old Joomla 1.x used MD5, modern systems don’t accept it
  • Images — copy manually from old server’s /images/stories/ folder

No more upgrade chain hell. No $75 tools. Just import and go.

Let me know if anything breaks! :clinking_beer_mugs:

9

If anyone has not said so, you are awesome for going that extra step to help this fellow 1hacker! Highfive :hand_with_fingers_splayed:

10

Sarah,

THANK YOU VERY MUCH!***
I will try the migration after the New Year holidays.

Once again THANK YOU!