Making a Local Copy - Problems using Bigdump

[lewisasding]

Thanks picandnix I will follow this up and get back with my findings.

[DrByte]

This plugin has always allowed me to backup/restore in similar scenarios: http://www.zen-cart.com/downloads.ph...7-backup-mysql

[lewisasding]

I have searched through the Zen Cart files but cannot find any overt reference to ‘increasing file size’ for downloading SQL files using phpMyAdmin, but thanks ‘picandnix’. Dr Byte recommended using ‘Backup MYSQL’ , I will hold that one in reserve. While browsing through ZC forums I came across a thread by ‘lat9’ ‘Display Log files’ and a reference to ‘Plugins and Addons’ which ‘lat9’ had written for download into ZC150-151.
The word log prompted me to see if there were any errors recorded at the time and date I ran Bigdump. In pathway: htdocs>store>logs>myDEBUG-adm-1364565863-13212.log I found the following:

[29-Mar-2013 15:04:24] PHP Fatal error: 1146:Table 'zencart.admin_pages' doesn't exist :: SELECT page_key FROM admin_pages WHERE page_key = 'orders_export' in C:\xampp\htdocs\store\includes\classes\db\mysql\query_factory.php on line 120
Only the word ‘zencart’ comes across as meaningful for me. When I set up my new PC Zen Cart I used the name suggested in the ZC manual (old version) page 39 ‘Creating Your Stores Database’. I used this in my original new store, and then again when I DROPPED the files and set up the Store with the 7MB sql file. In both cases the completed Local Copy worked.

I then went back into phpMyAdmin and created a NEW database name called ‘storecart’ (this was the first time I had used phpMyAdmin to make a new database). When prompted I typed ‘storecart’ and next to it was a dropdown list with Collation in the window, when I dropped down the list the only one that was familiar was ‘utf8 – bin’ and I choose this. I did not add any files because the one sql I wanted to use was greater than the limit imposed by phpMyAdmin (see opening letter in this thread). I then began setting up Bigdump ( recorded in this opening thread).

Question: Did I create the ‘storecart’ database name correctly, or should I have dropped the files in ‘zencart’ database? Should I have inserted the ‘zencart’ word when I edited bigdump.php?

I would be very grateful if any one could help with interpreting the error message, and my creation of a new database name. Thanks in advance.