shaza4061

i dont understand what you mean by not using text file. Usually table is imported by running a set of SQL statement with INSERT statement containing data. are you talking about the data files holding the data? the binary file?

rockarolla

Yes the .frm file ... but I would like to concatenate an existing table ...


The other hitch I stumbled in is to use phpmyadmin in order to import a table - but it only imports one querry despite that the table was exported using the same delimiters and terminatins...

Anyway at this moment I'm running all the scripts producing data on the server - untill they cut my CPU usage - but I don't see how to restore a lost table from the backups...

sujith.it

You must be talking about mysql dump file. Mysql dump file is a text file with set of sql commands. If there is a error when importing dump check the error message to get error line no and open text editor and edit sql command accordingly. Its a easy thing.

_______________
I Search Click Info Web Search Engine

shaza4061

Don't understand.. what do you mean by concatenate an existing table?

rockarolla

Concatenate an existing table merely means that I want to add new rows to an existing table. The way I preferred to do this was to implemet my own python code via mysql statement

LOAD DATA INFILE ...

this however is impossible unless you have a host that permits you to set file_privs to Y...


Now that that can't be done by scripting I resorted to what phpmyadmin offers - there you can import table from a text file - but it only imports my forst row - I don't have any mysql statements in it nor anything like coding ... only my data - formatted accordin to the import settings of your phpmyadmin panel ... the matter now is that it only imports the first row from my text file - that is it executes only one querry.