It may be time for a rebuild
Make a note of any extensions that you are using on the old site. Depending on how familiar you are with the extension, you may need to install it from scratch on the new site.
Start by installing your new Joomla 3.x site.
Now you need to export tables. Here's how to do it using phpMyAdmin...
- Select the table and choose the Export tab.
- Do a simple CSV export and then click Go.
Using phpMyAdmin export the following tables from your old database:
These are the main tables, and depending on your site you may decide to export more.
Import the tables
Now you can import the tables to your new database...
- Select the new table and choose the Import tab.
- Click the Choose file button to browse to your downloaded csv file and click Go.
Images and CSS
You will also typically want to migrate the entire /images folder.
If you've made custom CSS changes (e.g. user.css in Protostar) you will need to migrate them manually.
Updating the Author
If you're installing a fresh install of Joomla, the author id may have changed for your articles. You can run the following SQL in phpMyAdmin to change the Author for all articles in one go, where the user id is 614.
UPDATE abcde_content SET created_by = 614 WHERE 1;
UPDATE abcde_content SET modified_by = 614 WHERE 1;
UPDATE abcde_categories SET created_user_id = 614 WHERE 1;
UPDATE abcde_categories SET modified_user_id = 614 WHERE 1;
Thanks for visiting.