Β 
The Joomla Training Cohort has been launched!

Please send any feedback or bug reports to [email protected] (opens new link)  

A client encountered a problem while trying to work on a staging copy of the Joomla site because some of the table names in their database were too long. Here is a fix/work around I used to help them move forward beyond their "WARNING! Unable to clone table Structure" error.

00:00 - Introduction and Sponsor Message

00:33 - Overview of the Issue: Long Table Names in Joomla

01:06 - Using StageIt for Site Cloning

01:45 - Error Encountered: Unable to Clone Due to Long Table Names

02:20 - Proposed Solution: Changing Table Prefix

02:55 - Exporting the Database

03:32 - Cleaning Up the Database

04:08 - Preparing to Change the Prefix in Global Configuration

04:47 - Editing Configuration.php with FileZilla

05:34 - Navigating phpMyAdmin

06:05 - Renaming Table Prefixes

07:27 - Verifying the Renamed Tables

09:37 - Updating Configuration.php with New Prefix

10:31 - Rebuilding the Staging Area with StageIt

11:18 - Conclusion: Successful Workaround

Summary

 

Introduction and Sponsorship: Tim Davis introduces the video, sponsored by CyberSalt's Joomla training cohort and mysites.guru.

Overview of the Issue: A client faces an issue where the names of some Joomla database tables are too long, preventing them from cloning their site using the StageIt extension.

Using StageIt: StageIt is an extension that creates a copy of the Joomla site in a subfolder for testing changes without affecting the live site.

Error Encountered: The cloning process fails due to long table names when a prefix is added by StageIt, exceeding the maximum length allowed by the server.

Proposed Solution: Tim decides to change the current table prefix (mod30) to a shorter one (J) to accommodate the additional prefix added by StageIt.

Exporting the Database: He backs up the database using phpMyAdmin to ensure no data is lost during the process.

Cleaning Up the Database: Tim removes unused entries from the redirects table to reduce the database size.

Preparing to Change the Prefix: He opens the configuration.php file in FileZilla to change the database prefix after renaming the tables.

Editing Configuration.php: Tim shows how to edit the configuration.php file to update the prefix from mod30 to J.

Renaming Table Prefixes: Using phpMyAdmin, he renames the table prefixes in three steps due to the large number of tables.

Please send any feedback or bug reports or queries to;

Contact Tim Davis β–Ί This email address is being protected from spambots. You need JavaScript enabled to view it.

Joomla Training Cohort β–Ί https://cybersalt.com/jtc

JTC has been launched and is now accepting members https://cybersalt.com/services/subscriptions
mySites.guru β–Ί https://mysites.guru
Backing Up Your Joomla Site with Akeeba β–Ίhttps://www.youtube.com/watch?v=4Xu4o0g2-RY&t=0s
FOLLOW US ON X(TWITTER!) β–Ί https://x.com/basicjoomla
LIKE US ON FACEBOOK! β–Ί https://www.facebook.com/basicjoomla
SUBSCRIBE US ON YOUTUBE β–Ί//www.youtube.com/@Basicjoomla

#basicjoomla

#cybersalt

database


Interesting blog? Like it on Facebook, Post it or share this article on other bookmarking websites.

Written by:
Log in to comment

Add comment

Submit