opencart export/import 60,000 products

Hello,

I am having trouble import/export my xmls file for opencart.
I search and search but no luck how to do.
I think i have too many products. I have about 60,000 products to import to my opencart.

Below is my information.
Bluehosting plan: Platinum pak (share hosting)
My opencart version: 1.5.6
Export/Import tool: export/import tool by JNeuhoff (http://www.opencart.com/index.php?route ... sion_id=17)

If I import about 2,000 products, it works. but I need to import about 60,000 products.

Before I upload my xmls file, I edit php.ini file at /public_html/php.ini
I change;
memory_limit from 128M to 128000000M
max_execution_time from 60 to 60000000
max_input_time from 60 to 60000000

And I change php.ini file at opencart root folder;
memory_limit from 64M to 64000000M
max_execution_time from 36000 to 36000000000
upload_max_filesize from 999M to 999000000
mysql.connect_timeout from 20 to 20000000

And I change php.ini file at opencart admin folder;
memory_limit from 64M to 64000000M
max_execution_time from 18000 to 18000000000
upload_max_filesize from 999M to 999000000
mysql.connect_timeout from 20 to 20000000

I think it works about 25,000 products but I need 60,000 products import.

Is there anybody know how to do this?
Help me~~~~ please~~~~~~

You'll never have the resources to run that large an import on a shared host. Run the import on a local machine then export the resulting SQL to your store.

thank you for the idea.
i haven't thought about that.

now i need to find out how to set up on local computer first.
do you have any idea where i can find the manual or instruction how to install opencart on local computer?

thank you~~~

Try http://www.bloghunk.com/opencart.html . Instead of XAMP I use AMPPS (or Vagrant, but that's a whole different beast) but it's the same concept either way.

i follow your advice and set up local host.
i set up oc at local host. it works fine.
after i test it is working, i change the php.ini file (3 files)
one at php folder, one at oc root folder, one at oc admin folder.
and i got this error message. what should i do?

Edit php.in and increase the size of post_max_size and upload_max_filesize. You may also want to increase max_execution_time.

i am still having trouble.

this is what i am trying to do.
on bluehost.com, i have about 25,000 products in my opencart. and i want to import 60,000 products xmls file using extension.
as you mention before, i set up local host.
everything seems ok. working fine. i install opencart on local host. works fine.
i want to set up exactly same opencart with 25,000 products on my local host so i can import 60,000 products. so i download sql file from bluehost containing 25,000 products. file size is about 11mb.
now i am trying to import to my local host phpmyadmin.
but it keep error.
is this something to do with php.ini file? increase the limit?
because i increase all the php.ini file that i can find.
but still getting error.

once i set up same opencart on my local host, i will export 25,000 products to xmls file and add more to complte 60,000 products. and i import to my opencart on local host.
and i download sql file from db, and upload opencart on bluehost.com

below is what i trying to do. i made it as list so you can understand easy.
i am having trouble at step 2.

1. download sql file from phpMyAdmin at bluehost.com (i try to download it as xmls file using export/import extension by JNeuhoff but i keep getting error. i think file is too big) --- DONE
2. import (upload) to phpMyAdmin at local host
3. export xmls file
4. edit xmls file (from 25,000 products to 60,000 products)
5. import xmls file (60,000 products) to opencart at local host
6. download (export) sql file at local host
7. upload (import) sql file to opencart at bluehost.com

What's the error?

i try xampp and xmpps. both of them has same error.

Did you apply the changes I told you to and restart the server? Did you check the changes with phpinfo()?

i follow your instruction.
still getting error.
i attach both of server that i am getting phpinfo().

one is for xampp (phpinfo()-xampp.pdf) and other is ampps (phpinfo()-ampps.pdf) and also i attach the my step.
maybe max file limit. under FILE TO IMPORT: it has Max: 8,192KiB). I change all the instruction.
i change php.ini file at program files (x86)\ampps\php folder. post_max_size from 8M to 8000000M, upload_max_filesize from 32M to 32000000M, max_execution_time from 3 to 3000000. I didn't change memory_limit. because if i change the number from 128M to 128000000M, i can not login to admin page (http://localhost/ampps/). so i leave it as is.
this screenshot is ampps local host. still getting error

Don't run two AMPs stacks at once. Don't use absurd numbers for limits.

yes, you are right. it works.
THANK YOU THANK YOU THANK YOU~~~~

below is what i did.
I delete all the ampp and re-install only one ampp (xampp)
and i change to 9000 instead of put 000000 at the end.
(i change php.ini file at program files c:\xamp\php\ folder. post_max_size from 8M to 9000M, upload_max_filesize from 32M to 9000M, max_execution_time from 3 to 9000)
i restart apache, mysql and import sql file at phpmyadmin.
it is workging. i import sql file.

now i made same opencart on local host with same db (step 2 is done)
now I am trying to step 3. export xmls file.
i increase memory_limit from 128M to 128000M
now i am getting this error.
so look at mysql.php on line 36 what should i do?

thank you~~~

Export/import individual tables e.g. (oc_product, oc_product_description) one at a time rather than the entire database.