[ridwank]

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

[nd2]

you could try a raw mysql table dump, some scripts use this method, if not there is a bit about it in the mysql manual about dumping the database.

where are you moving the table to ? the same host?

in the program you are using click operations and you can move the table faily easily and it should work on the blob.

however that will only work if it's on the same server.

[ridwank]

Hi nd2,
thx for your response.

But I want to move the table into different host

and yes, there's "MOVE" feature in "OPERATION" page.
(it could be found in newest version of phpMyAdmin).
and offcourse it'll only work if the table is in the same server.

and I hope...in the next version of phpMyAdmin
there will be a feature to SAVE and UPLOAD table
as 3 (three) those table data file,
such as: mytable.frm; mytable.MYD; mytable.MYI

Then for now, I just have to insert the table contents
all over again

anyway... thx for the reply...

[nd2]

np.

[gizmoitus]

If you can't export and input one row sucessfully, then your problem with trying to export/import a large data set seems besides the point.

Any ways, your problem with a large query can only be fixed to my knowledge by adding a new setting to the mysql my.cnf file, which would have to be done by your hosting company.

The setting is: set-variable=max_allowed_packet=15m


In this example, I've increased the max_allowed_packet to be 15 megabytes in size. This would need to be roughly the size of whatever your insert statement from your export is.