suggestions for moving a huge osc database

[Rachael w.]

I've been moving sites to a new dedicated server. I've found that the database on one store is timing out during the import. I've broken the imports up but just importing the product table times out. There are about 7,500 products. I've even resorted to copying the inserts into a query and doing that way but its so time consuming.

 

Is there a better way?

 

Does anyone have a suggestion on how to get this huge database moved successfully?

[Rachael w.]

here's the error I get importing the products table:

 

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 91

[lstra]

here's the error I get importing the products table:

 

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 91

 

You need to ask your host to allow you to have a longer execution time - this is NOT an oscommerce problem!!!

[Jack_mcs]

I've been moving sites to a new dedicated server. I've found that the database on one store is timing out during the import. I've broken the imports up but just importing the product table times out. There are about 7,500 products. I've even resorted to copying the inserts into a query and doing that way but its so time consuming.

 

Is there a better way?

 

Does anyone have a suggestion on how to get this huge database moved successfully?

Phpmyadmin doesn't work well for large databases. The new version is supposed to reconect for large databases but it doesn't always work. Assuming your host won't load the database for you, you should be sure you have the latest version of phpmyadmin. If that still doesn't work, then you will need to use mysql shell or one of the free mysql loaders.

 

Jack

[genome]

try using a cpanel database bacup

[crash3903]

try using a cpanel database bacup

 

if you can afford it then buy navicat mysql (As long as you are able to connect using remote database connections) - it deals with large databases a lot better quicker and smoother - I have gone away from phpmyadmin due to what jack said as it is not very good at handling large databases

 

hth

[Rachael w.]

I was finally able to get it moved, had to do it in very small segments.

 

I didnt have cpanel on the old server so I wasnt sure how to do the move that way. It all worked out in the end, I guess, just needed a little more time to do it. :) Thanks for all your suggestions!