Unbelievable backup and upgrade nightmare

First of all - I do like CS Cart. As a product it’s constantly improving and the support staff are generally great, if overstreched (24 hour reply cycles can be a little frustrating).



The key factor that made us choose CS Cart was being told that it could easily handle 1200 products and 40,000 customers. We were told [[“CS-Cart can work with such amount of products and number of customers. CS-Cart definitely allows to maintain unlimited inventory products. CS-Cart does not have any limits.”]]



I’ve been trying to backup my store (version 1.3.4 sp4) in order to begin the upgrade to version 2.0.8 without success. The backup hangs partway through. I do not know why - although the helpdesk has suggested it has something to do with the size of my database.



CS Cart support had the following to say about the problem:



[[“As we can see, at the moment most part of your memory is occupied by the cscart_page_descriptions (36.8 MiB), cscart_product_descriptions (95.0 MiB) and cscart_sessions (85.4 MiB) tables. Now the data in the cscart_sessions table are stored during one month, after that they are deleted automatically, we can reduce the number of days during which the cscart_sessions table stores the user’s data, for example, by a few days. In this case the size of the cscart_sessions table will be reduced. However, we do not see a necessity to do it, because the size of the database will still remain quite big and it will be impossible to make a backup of the database using CS-Cart standard facilities. If you do need to make a backup of your database, we think that the best way out in this situation will be to develop a backup script we mentioned”]]



I have been quoted a price for the custom development service to create a backup and/or carry out the upgrade procedure, but do not feel comfortable paying for something that was sold as an integral part of CS Cart in the first place. I am not trying to do anything esoteric - simply create a backup of my store and upgrade to the latest, excellent looking version of CS Cart.



Any, suggestions about what to do to solve this backup problem and get things moving as quickly as possible would be appreciated… freelance developers please PM me, helpful people please post any adivice you think may help! I just need to get the upgrade done in time for the Christmas rush, and am willing to consider all options at this stage.



Thanks in advance :idea:

A) Your upgrade will not work with a standard webhosting account;

B) Your database size is not relative to CS-Cart, what they claim is true; however this is limited to operating enviroments (See A)

C) You can export your database from a database facility that your hosting provider provides; commonly used is PHPMyAdmin.

D) If you would like to have your store upgraded I can assist via CS-Cart USA: [url]Ecommerce Solutions and Software for all types of business - CS-Cart



I should mention that you should upgrade as soon as possible if you plan to have sufficient seo/google crawling prior to Christmas.



Jesse-Lee

Cygnus Books,



I understand your frustration.



However, in this case I would not blame CS cart.



I think that all PHP MySql shopping carts beyond a certain size would be better off with more resources.



I used to have a shared account and never had a problem then as the number of photographs on our site grew - admittedly not all optimized we switched to a VPS account.



Last night we upgraded to 2.08 and we had a 250MB database that we downloaded. No problems at all.



Down the road as we grow we will upgrade to a dedicated server.



The moral of the story is that it is probably not the shopping cart that is at fault it could very well be your web host resources.



Let us know more about your hosting account.

Cygnus Books,



Did you try to upgrade on your own desktop PC?



It seems to me, your at 1 & 1 Internet Ltd, United Kingdom, right?



[url]http://toolbar.netcraft.com/site_report?url=cygnus-books.co.uk[/url]



Maybe 1 & 1 is not the perfect hosting company for heavy CS-Cart user…





Lee Li Pop

[quote name=‘Lee Li Pop’]Cygnus Books,



Maybe 1 & 1 is not the perfect hosting company for heavy CS-Cart user…



Lee Li Pop[/QUOTE]



Heh, I tried and they are c.r.a.p!

Thanks for your advice all. I certainly share your sentiments about 1and1…


[QUOTE]A) Your upgrade will not work with a standard webhosting account;-

B) Your database size is not relative to CS-Cart, what they claim is true; however this is limited to operating enviroments (See A)

C) You can export your database from a database facility that your hosting provider provides; commonly used is PHPMyAdmin.

D) If you would like to have your store upgraded I can assist via CS-Cart USA: [url]Ecommerce Solutions and Software for all types of business - CS-Cart

[/QUOTE] I’ve got a dedicated server with 1and1 - of course until they completed a demanded upgrade today, it was only an ancient Pentium box, but still. 1and1 are far from perfect, but I’ll see how things go now the server’s been upgraded to a dual processor dual core with 4 gig of RAM- moving from our last host was a headach.



Although if someone can recommend a great UK based host and a way move seamlessly, I’d like to move in the near future.



Mikhail from CS Cart was kind enough to provide me with a backup of the database. Unfortunately the ‘restore’ into a local/ remote clean copy of version 1.3.4 sp3 produces the following error:


Database error: 1062 : Duplicate entry '857b74785c22651e595aca409e091350' for key 'PRIMARY'
Invalid query: INSERT INTO cscart_sessions (session_id, expiry, data) VALUES ('857b74785c22651e595aca409e091350', '1256655245', 'a:9:{s:12:\"partner_data\";s:0:\"\";s:12:\"notification\";s:0:\"\";s:4:\"auth\";a:3:{s:7:\"user_id\";i:0;s:13:\"membership_id\";i:0;s:10:\"tax_exempt\";s:1:\"N\";}s:17:\"insecure_password\";s:0:\"\";s:4:\"cart\";a:2:{s:6:\"amount\";i:0;s:8:\"subtotal\";i:0;}s:24:\"recently_viewed_products\";s:0:\"\";s:15:\"comparison_list\";s:0:\"\";s:12:\"continue_url\";s:43:\"index.php?target=categories&category_id=504\";s:19:\"current_category_id\";i:504;}')




Any ideas how to make it work? Apologies if I’ve missed something simple - I’m a bit of a n00b at this.

cscart-db-restore-error.jpg

delete the sessions and remove all statistics data if you have the addon enabled, optimize the database, this alone should decrease the database size significantly, I’ve upgraded sites about as large if not larger then yours, it took a very long time but it worked, if you need help let me know - Sno

Only way to upgrade a website via 1and1 is via an offsite upgrade.

As you are coming form 1.3.4sp4 it’s a lot of upgrades that are required to accomplish 2.0.8

I’m trying a database backup right now. The database section of my admin panel says that my database is 50 MB. This is after cleaning the logs and optimizing the database (it was 75 MB before that).



The backup gets to



Backing up data for: cscart_stat_banners_log…



and then it just keeps producing more lines of periods…



I’ve run through this a few times now and have started to watch the dump file in an FTP program. Before it gets to the stat_banners_log backup the dump file is about 10 MB. Then it keeps growing as more periods are displayed in my browser.



What are these banner stat logs and how can I get rid of them? As I write this the dump file is up to 23 MB and it’s still on cscart_stat_banners_log.



Help!



Thanks.

Do the dump from your hosting control panel. If you have cPanel, you can either backup the database or do an export from phpMyAdmin.



Bob

Bob, I already tried that, but when I went to restore it to my clean install I got an error.

Did you do the import in the cart or in phpMyAdmin? If you have SSH access to your server, you can bypass all the php stuff that frequently times out with big import files. After logging in via SSH, you can execute the following command:

mysql -u username -ppassword database_name < sql_filename



Bob

I’m importing into localhost…a clean installation on my desktop computer.

[quote name=‘kingsleypress’]I’m importing into localhost…a clean installation on my desktop computer.[/QUOTE]

Same thing, you just don’t need to login via SSH. Just execute the command in your terminal.



Bob

OK, can you give me the exact line of terminal code needed with a username of root, no password, database name of cscart and a filename of dump_05042010.sql.tgz…?



Thanks!

[quote name=‘kingsleypress’]OK, can you give me the exact line of terminal code needed with a username of root, no password, database name of cscart and a filename of dump_05042010.sql.tgz…?[/QUOTE]



First, unpack your sql file.



In the terminal, cd to the directory containing your sql file (or else provide the path to your file in the command below). Then execute the following:

mysql -u root -p cscart



Bob

OK thank you very much!

now we’re just dealing with all the bugs in 2.0.12, with which it is riddled. i’d really like to see CS Cart release a version that isn’t basically an untested beta with little functional documentation. It would also do them good to spend more time on this forum, seeing what’s causing people the most trouble and posting official solutions.

[quote name=‘cygnusbooks’]now we’re just dealing with all the bugs in 2.0.12, with which it is riddled. i’d really like to see CS Cart release a version that isn’t basically an untested beta with little functional documentation. It would also do them good to spend more time on this forum, seeing what’s causing people the most trouble and posting official solutions.[/QUOTE]



Been requested for forever… Doesn’t seem to be a part of the culture to engage with your customers…

[quote name=‘tbirnseth’]Been requested for forever… Doesn’t seem to be a part of the culture to engage with your customers…[/QUOTE]



A good observation.



It quite possibly is just part of their culture how else to explain the lack of concern for their customers.



If we had a fraction of their problems we would never take a day and work late nights every night until our customers were happy end of story.