Results 1 to 10 of 327

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    10,532
    Plugin Contributions
    127

    Default Re: Backup MySQL Database

    Have you looked at the file you are importing and confirmed it contains what you think it does? (i.e. that it actually is a database and not just a few error messages?)
    That Software Guy. My Store: Zen Cart Support
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  2. #2
    Join Date
    Oct 2009
    Posts
    440
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Yes, SWGuy, I had the same thought, and have opened it and it does contain all of the info! Goo thought, though!

  3. #3
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,835
    Plugin Contributions
    31

    Default Re: Backup MySQL Database

    After importing via phpmyadmin, does phpmyadmin show the data you are expecting?
    Steve
    github.com/torvista: BackupMySQL, Structured Data, Multiple Copy-Move-Delete, Google reCaptcha, Image Checker, Spanish Language Pack and more...

  4. #4
    Join Date
    Oct 2009
    Posts
    440
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Hi Torvista,

    Thanks for your reply! No, PhpMyAdmin tables show nothing in the database.

    Do you have any other ideas??

    Thanks,

    Jeff

  5. #5
    Join Date
    Oct 2009
    Posts
    440
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    After Importing the database through phpMyAdmin is says 1517 processed and that it is all OK, but still no information has been imported into my new database.

    I then just for a shot in the dark tried using backup_mySQL plugin to backup the database just to see or confirm its size. I received this error:

    Result code: 1
    0 => '"mysqldump"' is not recognized as an internal or external command,
    1 => operable program or batch file.
    Failure: The database has NOT been saved.

    Does this information help to solve my problem??

    Thanks again for the help,

    Jeff

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

    Default Re: Backup MySQL Database

    It's starting to really look like you can't run it in your current configuration.
    IIRC the readme and/or the language file contain instructions on specifying the correct mysql binary/application for your computer. NOTE: If you change that to suit your local PC it will NOT match what's on your server.

    Perhaps you should just do your backup with phpMyAdmin, and then take that backup and import it to the new database also using phpMyAdmin.
    .

    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.

  7. #7
    Join Date
    Oct 2009
    Posts
    440
    Plugin Contributions
    0

    Default Re: Backup MySQL Database

    Ok Thank you for your reply Dr.Byte..... I will try this!

 

 

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