Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Mar 2009
    Posts
    221
    Plugin Contributions
    1

    Default Backup MYSQL Plugin vs phpMyAdmin

    I've been performing manual backups via phpMyAdmin, but just found out about the Backup MYSQL Plugin. It's quicker to use the plugin, but I noticed some differences in the backup sql file.

    When I backed up my database via phpMyAdmin, the file size of the .sql (after uncompressing it) was 6.32 MB

    When I used the Backup MYSQL Plugin, the file size (after uncompressing it) was 5.99 MB

    Total lines in sql made by phpMyAdmin backup: 33776
    Total lines in sql made by Backup MYSQL: 3019

    There are also a lot of commented out lines that don't exist in the phpMyAdmin backup, such as:
    /*!40101 SET character_set_client = @saved_cs_client */;
    LOCK TABLES
    UNLOCK TABLES

    It would appear all the data is present but the formatting is completely different. Is this anything to worry about?

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

    Default Re: Backup MYSQL Plugin vs phpMyAdmin

    If you check the "Skip Lock Tables" box when using the addon, those extra lines won't show.

    Additionally, the addon prepares its output similar to how the "extended inserts" option in phpMyAdmin would do it. This keeps the file size smaller and processing time faster.
    If your phpMyAdmin backup is done using the options suggested in this Tutorial, your results will likely be more similar: https://www.zen-cart.com/tutorials/i...hp?article=103

    Given that all the data is present, it's just a formatting/efficiency difference.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. MySql backup with phpMyAdmin
    By DML73 in forum General Questions
    Replies: 4
    Last Post: 16 Jan 2016, 04:42 PM
  2. v150 Backup MYSQL Plugin 2005: Unknown MySQL server host 'localhost:3306' (1)
    By nuganics in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 10 Mar 2012, 08:09 AM
  3. Backup MYSQL Plugin
    By zmtak in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 18 Nov 2011, 03:55 AM
  4. Backup MYSQL Plugin - no backup button
    By mrtorrez in forum All Other Contributions/Addons
    Replies: 30
    Last Post: 29 Jun 2007, 11:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg