Results 1 to 10 of 327

Hybrid View

  1. #1
    Join Date
    Nov 2012
    Posts
    13
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Is there a way to use Backup MySQL Database tool to actually backup the true data files as well? ie. Customer, Order, etc. ?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Backup MySQL Database

    Quote Originally Posted by rgriese View Post
    Is there a way to use Backup MySQL Database tool to actually backup the true data files as well? ie. Customer, Order, etc. ?
    There are many ways to interpret your question, depending on what technical angle one reads it from, but most of those angles would never ask that question.

    So, perhaps you can rephrase your question, being more specific about what you actually meant?
    .

    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.

  3. #3
    Join Date
    Nov 2012
    Posts
    13
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Sorry for not being more specific. When I download the .sql file after creating the backup using the plugin, it appears that there is no customer order date, address data, etc. As opposed to when I use MYphpAdmin to create a backup in which when I open the sql file I can see all the customer data. I thought that this plug in would backup the order, address, etc information. (I am just opening the file in TextWranger)

  4. #4
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Backup MySQL Database

    You didn't say whether the file was empty. but, if the .sql file is actually empty, then that suggests you've got errors occurring which are preventing any backup from happening at all.

    I find it hard to believe that it doesn't contain the data that it backed up. It takes a backup of the entire database specified in your admin configure.php file ... ya, the same database that you're logging in to when you login to your admin, the same database that stores the orders and is used to display the orders.

    I suspect you're misreading the data. Maybe the data is on very long lines (which makes for smaller sizes because it removes excessive repetition) and you're not scrolling far enough to the right to see the rest of the info.
    .

    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.

  5. #5
    Join Date
    Nov 2012
    Posts
    13
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    My apologies! The file is not empty, however as you suspected it was a case of my misreading the data. The file is just formatted differently from when I do the backup from myPHPadmin and you are correct.... I wasn't scrolling far enough to the right. I saw only the parts of the file where the SQL tables were being established etc, but did not scroll right far enough to see the actual data within the tables... ie customer orders etc. Thanks for responding so quickly!

  6. #6
    Join Date
    Nov 2012
    Posts
    13
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Dr. Byte, on a different and unrelated note... I am doing work for the client who has the Zen Cart installation. She would like to add some additional fields that do not already exist in the installation. (primarily product and date related) I do not have enough experience to add these fields myself. Do you or are you aware of someone who does this for a reasonable price?

  7. #7
    Join Date
    Aug 2005
    Location
    Trujillo Alto, Puerto Rico
    Posts
    1,550
    Plugin Contributions
    9

    Default Re: Backup MySQL Database

    DrByte, would you please check this error I'm having after installing FEC for Zen Cart 1.3.9 and let me know how to fix it:
    http://www.zen-cart.com/showthread.p...51#post1236051

    Post #1741.
    IDEAS Girl
    IDEAS Creative Group
    = Your image... our business!

 

 

Similar Threads

  1. Backup MySQL Database vs using cPanel backup option?
    By IronMan101 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 30 Jul 2007, 08:46 AM
  2. Database Backup Manager - MySQL
    By sicness in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 7 Aug 2006, 09:42 PM
  3. Backup MySQL Database failure
    By JFD in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 3 Jun 2006, 06:55 AM

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