It's time to create new or re-design your websites to bring it to the next level.

Check out Top 110+ Best Free Joomla! templates Listing of 300+ Best Free WordPress themes

Database dump engines

  • Native MySQL Backup Engine: This engine will take a backup of your MySQL database using nothing but PHP functions in order to accomplish that.
  • Native MySQL Backup Engine

MySQL Compatibility
This option controls the MySQL version compatibility when creating the database SQL dump file.The available options are:

  • If you are backing up tables with large chunks of binary data or if you have very large chunks of text stored in the         database, the default value – 1000 rows – may cause a PHP memory or MySQL buffer exhaustion.
  • Number of rows per batch:
  • Size for split SQL dump files : Akeeba Backup is able to split your MySQL database dump to smaller files. This allows for an improved compression ratio and also helps avoid several problems with certain cheap hosts which put a restriction on the maximum size a file generated by PHP code can have.
  • Dump PROCEDUREs, FUNCTIONs and TRIGGERs: By default, Akeeba Backup will only back up database tables and VIEWs.
  • Max packet size for extended INSERTs: 
  1. If the previous setting is enabled, this setting defines the maximum length of a single INSERT statement. Most MySQL servers have a configured limit of maximum statement length and will not accept an INSERT statement over 1Mb.
  2.  When this is not checked, Akeeba Backup will create one INSERT statement for each data row of each table.
  3. .When this option is enabled, the dump engine will create a single INSERT statement for multiple rows of data, reducing the overhead and resulting into significantly smaller backup archives.
  • MySQL 4.1: Akeeba Backup will request from your database server to provide definitions (CREATE commands) in a MySQL 4.1 friendly format.
  • Default: This is the recommended option.
  • Blank out username/password: When enabled, Akeeba Backup will not include the username and password of database connections in the backup.
  • Generate extended INSERTs: If you get memory outage errors during the table backup, it is advisable to lower this setting. This is especially true if    your MySQL and PHP combination does not allow a cursor to be effectively created and all data has to be transferred  in PHP’s memory.
  • No dependency tracking: When this option is enabled, Akeeba Backup’s database dump engine will no longer try to figure out table and VIEW dependencies.
  • Blank out username/password: When enabled, Akeeba Backup will not include the username and password of database connections in the backup.
  • Generate extended INSERTs:
  1.  When this is not checked, Akeeba Backup will create one INSERT statement for each data row of each table.
  2. When you have lots of rows with insignificant amount of data, such as banner and click tracking logs, the overhead of the INSERT statement is much higher than the actual data.
  3. When this option is enabled, the dump engine will create a single INSERT statement for multiple rows of data, reducing the overhead and resulting into significantly smaller backup archives.
  • Max packet size for extended INSERTs: If the previous setting is enabled, this setting defines the maximum length of a single INSERT statement.
  • Size for split SQL dump files: Akeeba Backup is able to split your MySQL database dump to smaller files. This allows for an improved compression ratio and also helps avoid several problems with certain cheap hosts which put a restriction on the maximum size a file generated by PHP code can have.
  • Number of rows per batch: Dumping table data happens in “batches”, i.e. a few rows at a time. This parameter defines how many rows will be fetched from the table at any given time.
  • Dump PROCEDUREs, FUNCTIONs and TRIGGERs: By default, Akeeba Backup will only back up database tables and VIEWs. If your host supports this, you can also back up and restore advanced aspects of your database: stored procedures, stored functions and triggers.

Are you Web Freelancer or Web Design Company? Join our Club and Access our Resource!

Access 500+ PRO Premium Joomla! and WordPress themes with $19,200 just $149, Quickstart Package included!

Huge Spring Sale with 50% Discount!

Access Life-time All-In-One Membership with 500+ Premium WordPress themes and Joomla templates just $199.50 (instead of $399) after discounted! Life-time Access, Download and Support, One-time Payment, No Renewal. Coupon code: SPRING2020

Join All-In-One Club with 50% OFF for Spring Sale!

eskişehir escort izmit Escort bursa escort bayan ankara escort bayan van escort bayan elazığ escort bayan erzurum escort bayan
[November Released] LT Hotel Booking - Booking platform for Hotel/Resort Wordpress theme | Support Elementor & WP Hotel Booking plugins Check it out
Happy Spring 2020 Sale with 50% Discount for your purchase! Just put Code: SPRING2020 during checkout! How to use this discount?