I moved to a new Server ... but my Customers didnt!

[arames]

Hi everyone and thank you in advance for your support.

 

I had a working Oscommerce Shop, but unfortunaltey my OLD server company used to bug me weekly with emails that I am OVER CROWDING their server. :'(

 

So I have to move to a new company.

 

Unfortunately the Oscommerce Backup Solution does NOT work with my old server. :(

 

So I couldnt backup....

 

My main concern is 2 things:

 

1/ How do I backup the customers via MySQL (phpadmin), and take them to the new server?

 

I dont want them to register again in the new server .... I want them to keep their login.

 

2/ How do I backup the ALSO purchased items list?

 

Since my webstore has been online for over 3 years now, a lot of products have been purchased and this is why when you click on a product you get a lot of "Customers who boought this, also purchased!"

 

 

 

Thank you a MILLION for your help!

 

Regards,

Arames from Germany

[spax]

Use the Export tab in phpMyAdmin and download your database as a .sql file. Create a blank db on the new server, go to phpMyAdmin and import the .sql file.

If it a really big db, you may have to do it all in bite size pieces. Just make sure you have the new one running properly before you close the old one.

[arames]

Thank you so much Peter

 

But unfortunately my Database is as you said over 380 MB ... how do I cut it in pieces to upload it ?

 

Again thank you in advance for your help!

[♥Vger]

If you have access to your site via SSH then you can upload the whole database in one go, because the normal limits do not apply. However you have to be proficient with working from a command line terminal - it's vastly different to FTP. Also your new hosts may not provide SSH access.

 

I've just finished work on a website that was 4 years old, very active, thousands of customers, and their database was only 180Mbs in size. I cut it down by 50% by separating out the forum tables, and then cut it down even more by cutting out affiliate click-throughs (which you don't need to store). This made it a manageable size.

 

Basically you need to cut out all of the dross, everything you don't actually need, then put the rest of it into files about 1Mb in size.

 

phpMyAdmin, by default allows files of 2Mb, but 2Mb files will probably time-out by exceeding the maximum execution time.

 

Vger

[arames]

Than you for your prompt answer.

 

In deed my knowledge in SSH is 0%.

 

And cutting the 380 MB to many 2MB is unthinkable...

 

My question remains though, by uploading via SSH, do you have ALL the products description as well?

 

Is the new store then immediately ready to be run?

 

Because I have in the description of each of my products a lot of images, files, and description ... and was wondering by uploading via SSH if ALL this description is also uploaded?

 

Regards,

Arames T.

 

p.s: This is why I wanted just to take with me just the CUSTOMERS table since I thought it will NOT be too much trouble ...

[♥Vger]

If it can be uploaded via SSH then the whole 380Mb's can be uploaded - provided you have the MySQL space to do so.

 

But even without it it should be possible to upload Customers, Orders, Products and Product Descriptions etc. just by chunking up the files into proportions that phpMyAdmin can manage.

 

Vger