The Joomla Training Cohort has been launched!

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

 

00:00 - Introduction and Sponsor Message

00:32 - Overview of Database Size Issue

01:01 - Accessing phpMyAdmin or Database Tools

02:13 - Sorting Tables by Size in phpMyAdmin

03:25 - Importance of Backing Up Database

04:04 - Exporting and Importing Database

05:10 - Analyzing Large Tables and Their Contents

06:24 - Examples from Tim's Own Sites and Clients

08:43 - Handling Joomla Versioning and Extensions

10:37 - Specific Examples and Recommendations

 

Summary

 

Introduction:

Tim Davis discusses managing a Joomla site with a large database and offers practical solutions.

Using phpMyAdmin:

Recommends phpMyAdmin for effective database access and management.

Sorting and Backing Up:

Suggests sorting tables by size to identify large ones and backing up the database to prevent data loss.

Handling Large Data:

Explains exporting and importing data through phpMyAdmin and adjusting extension settings for better data control.

Practical Examples and Caution:

Provides examples of managing large tables and advises caution, such as emptying rather than dropping tables to avoid site issues.

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

Monday Maintenance 203


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

Written by:
Tim Davis is the founder and owner of Cybersalt.
Log in to comment

Add comment

Submit