If I try to create a table in mysql and the db is full what error will I get? I'm making a system where each table that grows gets a database and only that table. I'll query multiple tables for data. I know the table full error, but I'm not sure what error is returned if the db is maxed out of table space. Is this the right way to look at it, or can one DB hold an infinite amount of tables until my Google Cloud Disk is full?
If the MySQL database is full, you may get the error ERROR 1114 (HY00): The table 'xyz' is full Code (markup): . This error occurs when the disk memory is full.
Thanks Sumit. So it's the same error. I find disk confusing. Is this something to do with the database, or the drive phpmyadmin is on?
@Jeremy Benson phpmyadmin has nothing to do with how much storage space mysql database has. Your hosting space is the total space available to all your files plus databases. So if you have a total of 10GB hosting space, then this is the amount shared between your files and your database. If you are on a VPS or dedicated server, then softwares installed on the VPS or server will also share the same space. Softwares like apache, php, etc etc. Also, if you start getting the table is full error on any one table, then it will happen on all tables in your entire hosting account. It means that your entire hosting disk space is full. You will not be able to write in any table, doesn't matter which database it is in. Think of this like folders in your laptop's hard disk. If you get the error "not enough space to copy file", then it means the whole disk is full, not just that particular folder. What are you trying to do anyways? What do you mean by: "each table that grows gets a database and only that table" Who makes a new database for every table? Your script will spend so much time connecting and disconnecting between databases that it will become a headache to open a webpage. You cannot link tables using join statements also. This is a really bad idea.
If you try to create a table in MySQL and the database is full, you will get an error message stating "The table is full." Each table growing into a separate database may not be the best solution, as there is a limit to the number of databases MySQL can handle based on system resources. It is possible for one database to contain many tables until the disk space allocated for that database is reached.