Zen Cart 1.5.1 Server Host www.example.com/ Server OS: Windows NT
Database Host: Local Host/ Database MySQL 4.1.14-nt
PHP Version: 5.0.5/ HTTP Server: Apache/2.0.54(Win32)
NotePad was used to carry out editing.
I needed to make a local copy of my Zen Cart v1.5.1, and I used the tutorial from ZC wiki ‘Making a Local Copy’, the original Zen Cart manual by Goh Koon Hoek was also indispensible, Dr Byte also gave advice. The latest XAMPP was first downloaded, and successfully installed. I then downloaded a copy of the files from the remote site using FTP. This I then followed with phpMyAdmin on the remote web host site, and downloaded the SQL file. So far, and so good.
This was then followed by downloading Zen Cart v1.5.1 and that was set that up, now I had a brand new website, which worked both with ‘store’ display and ‘admin’ display. The next step was dropping the files from the new database, this was successful and I then selected the downloaded SQL file from the remote site, and using the copy of phpMyAdmin on my Windows PC, I began importing it. The import failed with a message saying that the file was too large, it was a tad just over 10Mb and the limit was 8192Kb. Much reading later, I knew that this was a problem with phpMyAdmin, and there was a ‘work around’ called Bigdump.
Before going down the Bigdump route I wished to satisfy myself that phpMyAdmin did work having never used it before, so I downloaded a smaller SQL file (7Mb) which had lain dormant from my predecessors days. The phpMyAdmin worked perfectly on the smaller file, and I was able to set up and complete the installation of the website on my PC. The substituted SQL gave me a PC based website which was in the early stages of development, and was not what I wanted.
Returning to Bigdump I downloaded a copy of the software unzipped it, and opened it in Notepad and made the modifications as follows:
$db_server = 'localhost';
$db_name = 'storecart'; //The database name was created in phpMyAdmin**
$db_username = 'root';
$db_password = '';
$db_connection_charset = 'utf8';
$filename = 'mydb_zc151.sql'
**When I created a new database ‘storecart’I had to select a setting from a dropdown list, and I choose ‘utf8 bin’ there was no ‘utf8’ without the bin on the end.!!!
Closing the bigdump.php document I saved it. I then created a new folder inside the htdocs folder called Dump and saved bigdump.php and the SQL file into it.
Typing into my browser, the pathway:
www.example.com/Dump/bigdump.php and I got the following
BigDump: Staggered MySQL Dump Importer v0.35b
Start Import from mydb_zc151.sql into storecart at localhost
Note: The current mySQL connection charset is utf8. Your dump file must be encoded in utf8 in order to avoid problems with non-latin characters. You can change the connection charset using the $db_connection_charset variable in bigdump.php
© 2003-2013 Alexey Ozerov
I clicked on Start Import and the following occurred
BigDump: Staggered MySQL Dump Importer v0.35b
Can't open mydb_zc151.sql for import
Please, check that your dump file name contains only alphanumerical characters, and rename it accordingly, for example: mydb_zc151.sql.
Or, specify $filename in bigdump.php with the full filename.
Or, you have to upload the mydb_zc151.sql to the server first.
Start from the beginning (DROP the old tables before restarting)
© 2003-2013 Alexey Ozerov
I removed the underline character ‘_’ leaving me with mydbzc151.sql and I did the same by opening bigdump.php and changing $filename to mydbzc151 and then ran again, but still no joy.
1. I checked for ‘only alphanumeric characters’ and corrected.
2. I specified $filename in bigdump.php.
3. I DO NOT UNDERSTAND ‘upload to server first’, what does it mean? Have I placed the SQL file in the incorrect place?
So I am at a standstill. I sweated blood for weeks getting this far (I’m sure there are New Zenners out there that can identify with me). I am so close to completing this project, so please if anyone can help, contact me. Kind regards and thanks in advance.
Bookmarks