how to transfer data (records) to the new website ?

Because Joomla3 is outdated I started with a new Joomla 5 website,
updated my existing component (1 table) and now it’s running fine there, but empty.
So, how can I transfer all the old data records to the new website ?
Copy and paste, one by one is possible.

Hope you can help me to find a better way.
Christian

You're right, manually copying and pasting data from a Joomla 3 database to a Joomla 5 database is extremely inefficient. Thankfully, there are several much better ways to transfer your data. Here's a breakdown of the most common and effective methods:

1. Direct Database Transfer (Recommended for Simple Components):

Understanding the Process: readworks teacher login
Since your component uses only one table, this is likely the quickest approach.
You'll essentially be exporting the data from your Joomla 3 database and importing it into your Joomla 5 database.
Steps:
Backup: Always back up both your Joomla 3 and Joomla 5 databases before making any changes.
Identify the Table: In your Joomla 3 database, identify the table your component uses. You can use phpMyAdmin or a similar database management tool.
Export the Data:
In phpMyAdmin, select the table.
Go to the "Export" tab.
Choose "SQL" format.
Select "Custom" export, and make sure that "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" is unchecked.
Click "Go" to download the SQL file containing your data.
Import the Data:
In your Joomla 5 database, open phpMyAdmin.
Select the database.
Go to the "Import" tab.
Choose the SQL file you exported.
Click "Go" to import the data.
Check for Table Prefix:
If your Joomla 3 and Joomla 5 databases have different table prefixes (e.g., jos_ vs. abc_), you'll need to edit the exported SQL file.
Use a text editor to find and replace the old prefix with the new prefix.