title: Change limit for “Mysql Row size too large”
body: <blockquote>
  <p>Row size too large (&gt; 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.</p>
  </blockquote>
  <p>The following Error occurs while importing the SQL file
  [Error while importing the SQL file]</p>
  <p><img src="https://i.stack.imgur.com/fkKwN.png" alt="1" /></p>
  <p>There are many other queries in my SQL file too, maybe this problem is occurring because of them
  <a href="https://drive.google.com/file/d/1uEGRqrrlTS90mnNjba-7W4Zehh-iPAFd/view?usp=sharing" rel="nofollow noreferrer">Here is the Link to the SQL file</a></p>
  <h2>--
  -- Table structure for table <code>tbl_settings</code></h2>
  <pre><code>CREATE TABLE `tbl_settings` (
    `id` int(11) NOT NULL,
    `logo` varchar(255) NOT NULL,
    `favicon` varchar(255) NOT NULL,
    `footer_copyright` text NOT NULL,
    `footer_address` text NOT NULL,
    `footer_email` text NOT NULL,
    `footer_phone` text NOT NULL,
    `top_bar_email` varchar(255) NOT NULL,
    `top_bar_phone` varchar(255) NOT NULL,
    `send_email_from` varchar(255) NOT NULL,
    `receive_email_to` varchar(255) NOT NULL,
    `total_recent_news_footer` int(10) NOT NULL,
    `total_upcoming_tour_footer` int(10) NOT NULL,
    `total_featured_tour_footer` int(11) NOT NULL,
    `total_recent_news_sidebar` int(11) NOT NULL,
    `total_recent_news_home_page` int(11) NOT NULL,
    `home_title_service` varchar(255) NOT NULL,
    `home_subtitle_service` varchar(255) NOT NULL,
    `home_status_service` varchar(10) NOT NULL,
    `home_title_team_member` varchar(255) NOT NULL,
    `home_subtitle_team_member` varchar(255) NOT NULL,
    `home_status_team_member` varchar(10) NOT NULL,
    `home_title_testimonial` varchar(255) NOT NULL,
    `home_subtitle_testimonial` varchar(255) NOT NULL,
    `home_status_testimonial` varchar(10) NOT NULL,
    `home_photo_testimonial` varchar(255) NOT NULL,
    `home_title_news` varchar(255) NOT NULL,
    `home_subtitle_news` varchar(255) NOT NULL,
    `home_status_news` varchar(10) NOT NULL,
    `home_title_client` varchar(255) NOT NULL,
    `home_subtitle_client` varchar(255) NOT NULL,
    `home_status_client` varchar(10) NOT NULL,
    `home_title_destination` varchar(255) NOT NULL,
    `home_subtitle_destination` varchar(255) NOT NULL,
    `home_status_destination` varchar(10) NOT NULL,
    `home_title_featured_package` varchar(255) NOT NULL,
    `home_subtitle_featured_package` varchar(255) NOT NULL,
    `home_status_featured_package` varchar(10) NOT NULL,
    `newsletter_title` varchar(255) NOT NULL,
    `newsletter_text` text NOT NULL,
    `newsletter_photo` varchar(255) NOT NULL,
    `newsletter_status` varchar(10) NOT NULL,
    `banner_about` varchar(255) NOT NULL,
    `banner_faq` varchar(255) NOT NULL,
    `banner_service` varchar(255) NOT NULL,
    `banner_testimonial` varchar(255) NOT NULL,
    `banner_news` varchar(255) NOT NULL,
    `banner_contact` varchar(255) NOT NULL,
    `banner_search` varchar(255) NOT NULL,
    `banner_category` varchar(255) NOT NULL,
    `banner_terms` varchar(255) NOT NULL,
    `banner_privacy` varchar(255) NOT NULL,
    `banner_destination` varchar(255) NOT NULL,
    `banner_team` varchar(255) NOT NULL,
    `banner_payment` varchar(255) NOT NULL,
    `banner_payment_success` varchar(255) NOT NULL,
    `banner_payment_pending` varchar(255) NOT NULL,
    `banner_registration` varchar(255) NOT NULL,
    `banner_login` varchar(255) NOT NULL,
    `banner_forget_password` varchar(255) NOT NULL,
    `banner_reset_password` varchar(255) NOT NULL,
    `banner_reset_password_success` varchar(255) NOT NULL,
    `banner_verify_registration` varchar(255) NOT NULL,
    `banner_verify_subscriber` varchar(255) NOT NULL,
    `counter_1_title` varchar(255) NOT NULL,
    `counter_1_value` varchar(10) NOT NULL,
    `counter_2_title` varchar(255) NOT NULL,
    `counter_2_value` varchar(10) NOT NULL,
    `counter_3_title` varchar(255) NOT NULL,
    `counter_3_value` varchar(10) NOT NULL,
    `counter_4_title` varchar(255) NOT NULL,
    `counter_4_value` varchar(10) NOT NULL,
    `counter_photo` varchar(255) NOT NULL,
    `counter_status` varchar(10) NOT NULL,
    `front_end_color` varchar(20) NOT NULL,
    `paypal_email` varchar(255) NOT NULL,
    `stripe_public_key` varchar(255) NOT NULL,
    `stripe_secret_key` varchar(255) NOT NULL,
    `bank_detail` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  <p>What can be done in this case?</p>