It may be time for a rebuild

joomlaIf you've uninstalled and installed lots of software or if you've performed one too many upgrades, you might find that you need to rebuild your Joomla site from scratch.

Old site

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.


New site

Start by installing your new Joomla 3.x site.


Exporting tables

Now you need to export tables.  Here's how to do it using phpMyAdmin...

  1. Select the table and choose the Export tab.
  2. Do a simple CSV export and then click Go.

Using phpMyAdmin export the following tables from your old database:

  • abcd_categories
  • abcd_content
  • abcd_content_frontpage
  • abcd_menu
  • abcd_menu_types
  • abcd_modules
  • abcd_modules_menu

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...

  1. Select the new table and choose the Import tab.
  2. 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.