I was having trouble importing one table in my huge Mysql import and it kept telling me that my table is too long.. After some research i found that in the Maria Db there is an ini file that you can set it to anything your little heart desires... So I changed it and all is well i can now load huge table widths with tons of colums.. no longer exceeding the 8,164 tables which is the normal setting but low and behold when i went to look for my ini file on the web so I could go live and not run on my localserver I am not able to find that same ini file... Can anyone help me with that... Thanks
Don't have the info you need but wow! that's a massive database. What info are you storing? Does it all need to be in the same database? Is it time to move to Oracle or SQL Server?
Real Estate data base like 40,000 homes.. over 200 tables in the data base and yes each table represents like Nr Bedrooms, 2 story.. etc.. of course i could put it into two rows but that would not help my speed... when its so simple (well should be simple) to find the ini for mysqldb on the web and change the number of tables allowed in a row.. its not actully a limint of 8,162 tables its all tables totaled cannot be more than 8162 characters.... mine is maybe 9,000 simply raising the innodb row width just a little on localhost maria db made it fine.. And breaking the row into two 4500 rows will double the time to access a fille... Cpanel has a limit of 1143 table width.. not sure how they are tricking mysql to stuff it in there but mysql is still working for cpanel to do it.. But as you can see cpanel is quickly running out of space as this project is growing in leaps and bounds... The mysql is running 865,000 bytes and still hanging in there. I am sure many folks know where it is.. will keep looking.... I did find an ini file but does not mention innoDB so afraid to just write it in.. but we will see.. Actually could not be two rows would need to be 2 data bases and that gets akward.. this data base have over 49,306 rows. When you have 50k urls the characters in a row add up fast..