For example:
I have a table, which one field type set to BlobImage.
The table already contains a lot of records.
The problem is:
when i created a dump query, to get the INSERT statement,
it's making a very large textfile, especially in the blob field.
(yes, the blob field contain an ASCII characters)
Then, when I want to restore that query into the other database.
PhpMyAdmin could not hold that large text file to execute the query, (maybe because of the not enough memory)
then i try to dump just one rows INSERT statement, to get a smaller size of dump text, ... and its works.
but when i browse / display that image on the web, it's give me an error image.
the QUESTION :
Is there any other way to move table, beside a QueryDump ?
But not "file transfering", because
Offcourse I don't have SSH / telnet access
to copy my table files into the mysql data folder.
the Host Company will kill me if it does
any answer ??? please reply
