Attention

If your Photo Cart is suddenly getting a 500 error or only displaying a blank page then you or your hosting company has updated the PHP (programming language) to PHP 7 which Photo Cart is not compatible with (and will not be compatible with) mainly because of the removal of the my_sql functions which are replaced with my_sqli functions. 

You would need to have the PHP version downgraded to 5.6 in order for Photo Cart to work. If downgrading the PHP doesn't work then you may have to update Photo Cart to the last version of 7. Download Photo Cart 7 upgrade files. Upgrade instructions.

Photo Cart was retired in 2015. Check out Sytist.

Please log in or Create an account to post or reply to topics.
You will still receive notifications of replies to topics you are part of even if you do not subscribe to new topic emails.

Moving Sql Database File To New Server

D
25 posts
Thu Feb 18, 16 2:42 PM CST
I'm moving Photocart from a VPS to a fully Dedicated server.

Reason, I've simply outgrown the VPS and the Dedicated Server offers 1TB of storage 8 cores and 8GB ram, Gigabit Pipeline so way more grunt

My SQL file is 300mb.

Using the suggested method of exporting via admin and importing via admin won't work, as the file size is too large, and I'm hitting the max file size limit on import.

Question:
1) Can I backup the SQL file via cPanel, and restore it via cPanel on the new server
2) Is the SQL backup file that photocart creates from its internal Admin Backup the same as the cPanel backup with the exception Photocart adds the date the the original file name?
3) Any other suggestions?

The Dedicated server support guys suggetsted a SQL file splitter, but I trying for a more direct route first
16,437 posts (admin)
Fri Feb 19, 16 5:46 AM CST
You will need to export the database from PHPMyAdmin in your hosting control panel then import it the same way on the new host.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
D
25 posts
Fri Feb 19, 16 2:26 PM CST
As I have already mentioned above, importing via PHPMyAdmin won't work, as the file size is too large, and the import fails
16,437 posts (admin)
Sat Feb 20, 16 10:27 AM CST
You will have to break down the export, only exporting so many tables at a time.

You could probably export all the tables except for pics, and pc_gallery_stats at one time and import those.

Then go back and export the pics table and pc_gallery_stats table individually.

When exporting those, change "Maximal length of created query" from 50000 to 10000 which may help them import.

If you can't get those to import, then you will have to manually edit those files and break them into smaller files.
Tim Grissett, DIA - PicturesPro.com
My Email Address: info@picturespro.com
4 total messages
Please log in or Create an account to post or reply to topics.
This post has been viewed 2,159 times
Category: Installation
 
Loading more pages
Loading more pages

Sign up for email promotions.

Your information is safe with us and won't be shared.

Thank you for signing up!

 
©2003 - 2021 Grissett, LLC. All Rights Reserved.

By continuing to browse or by clicking Accept Cookies, you agree to the storing of cookies on your device necessary to provide you with the services available through our website.

    Accept   Privacy & Cookie Policy
Loading More Photos
Scroll To Top
Close Window
Loading
Close