title: Changing database in already exported .sql.gz file
body: <p>So I have an exported database <code>database.sql.gz</code> from a database I can't access personally. Simply uploading it into PHPMyAdmin gives errors, and uploading it with <code>zcat {directory} | mysql -u {user} -p {database}</code> also gives an error &quot;Row size too large (&gt; 8126)&quot;. After reading through the file with Vi, I realize I can't simply change some row file formats around to make it fit, as the specific table has 67 rows. I also found out this table (along with others) don't get filled at all and get dropped at the end of the document. I tried commenting out the CREATE TABLE of the too large table, and there don't seem to have been any related errors from that, but I did run into some different errors at CREATE ALGORITHM commands.</p>
  <p>Long story short, is there a better way to remove this giant table from my file that doesn't include exporting it again (as I don't have direct access to the database) or commenting out every bit that has to do with that table.</p>