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 â–º
Joomla Training Cohort â–º https://cybersalt.com/jtc
Add comment