MySQL :'(
Out of context: Reply #18
- Started
- Last post
- 21 Responses
- enobrev0
sp could have something.. depends on your db limitation..
also phpmyadmin is still restricted to file transfer limitations. If your 4 tables are 50MB altogether, the browser is not going to do it. Whether it's supposed to otr not, it will fail miserably.
Also, not only do you have to wait for the browser to upload, you have to wait for mysql to flip thorugh all the inserts, which can take time if it's a lot of text (which i presume it is)
I had the same situation, and went the tedious route (phpBB and hte guy had been hacked a couple times so no ssh - bastard).
Basically cut up the import files into 2 - 5 MB chnks (whatever you can get to work) and import them one by one. It's a pain in the ass, but it works.
You could also dig through their code to find their code that does the actual importing via a file. Grab that code, change it up to open up your files from the local file structure, ftp them up and run your script.