amanar17

Fine, but I really do not think the problem is at my end. I had in there TLE datasets https://www.celestrak.com/NORAD/elements/ converted to csv files. They are public time-indexed records of measurements of orbital positions in a compact format. There was around half a gigabyte of those, stored in a few thousand tables with one table per trackable object. Then, I cycled through all the days in the last few years and for each particular day I defined a view that extracted the data for that day from the whole dataset and queried that view as a test. This is where something went wrong. Yes, it is a lot of views - one per day for several years, each involving a search of every table in the database. Still, it should not have caused this much downtime, and certainly not created 3GB extra data, because if one considers the views as temp tables, the total amount of those temp tables should be at most equal to the size of the database (and in reality much much less because my script did not run to the end).

Thanks very much! There is one small problem however: I am still locked out of phpMyAdmin and still have remote access blocked. I deleted the database again and created it, and I still do not have access. Btw, I had all the data backed up on my hard disk already, so once I have access I can just recreate it. EDIT: I get message mysqli_connect(): (HY000/3118): Access denied for user 'amanar17'@'localhost'. Account is locked. when trying to log in to php.

The cPanel disk usage tool says ~543.03MB for mysql when I checked it for his account hence my response. Where is the other 3GB that I'm missing? That is surely not possible, I never had that much data in there. I created half a gigabyte worth of tables and then ran a script to define some views. That's when it got suspended. From what I know of views, they do not take up 3GB on their own.

a. amanar17 b. johnny@heliohost c. not sure - I only had a single (amanar17_tle) database which I used to practice MySQL and managing a database