uploading large amount of data to mysql

[c-chan]

---

@nullpointer: nope. I sent an email to yahoo today, but I'll be receiving their reply within 24 hrs. and i don't know how that would work T^T (ssh i mean)

[dodie]

@ sir dodie: is that possible if your host is yahoo?
and is there a step-by-step tutorial that would help me achieve my goal? what specific softwares should i download? i've done some research and downloaded PUTTY but i still don't know how to use it.

thank you.

there is an alternative solution to it. If you are using PHPMYADMIN locally, then you are using PHPMYADMIN on the domain.

Simple!!!
Just use EXPORT, use the command LIMIT and sort them by their Primary Keys. (Literally exporting them by batch.. you have to generate several SQL files.)

[yhokz101]

OT: nosebleed nko

[c-chan]

@sir dodie: we're currently using that option right now. but dugay kaayu mi mahuman if magpadayun mi. so we're looking for an alternative way to upload large files. T^T

[montevince]

are you using ftp to upload files?

[psyd_1]

maskin telnet,phpmyadmin, o spaceship-hinimo-sa-alien pa ang gamiton if we're talking about huge data transfered as bulk over wire naa jud na chance magkaproblema. imagine gud ang dinasaur muagi over cable.

im suggesting not a 100% problem-free, but at least minimize the problemos!

[c-chan]

@montevince: we're using ftp for uploading files (php, html etc.) qnd phpmyadmin for uploading data to our database.

@sir psyd_1: so you're suggesting we should change our net connection? O.o is that it?

[nullpointer]

since you don't have ssh access to your server, i think you should follow dodie's suggestion or if you're capable of writing a script you can follow what psyd_1 told you...

[c-chan]

@nullpointer: but if yahoo give us that ssh access. will uploading large files possible?

[nullpointer]

@nullpointer: but if yahoo give us that ssh access. will uploading large files possible?

its possible, you just upload your mysql data using ftp then you import it using command lines inside ssh

mysql -u USER -p DBNAME < dump.sql