DB Dumping - Advanced

[zoomsan]

Hello,

I am having a real problem finding an answer to this question. I am sure the experts here can help:

I am trying to figure out a way to use mysqldump (table is too big for phpmyadmin) or another means to dump a file. Within the file, I don't want the insert syntax. What I would like to find out how to do is basically update each record (except for the field in the table that counts clicks) and then insert the records that are not in the database already.

Also, in some manner I must delete those records which are not in the new "update" sql file.

I need this in a file format because I upload the file to my server after building the 1 million record DB locally.

Any help would be greatly appreciated. Thanks very much in advance.

[nemonoman]

Are you very smart, clever, and careful? Answer sincerely. You are taking on a world of challenges.

If you have shell or exec access, it would much simple and MUCH MUCH FASTER to dump the clone database entirely and recreate using the output of mysqldump.

[zoomsan]

I can obviously do a mysqldump with inserts. I am wondering if there is some option to get it to use update instead. That would be a good starting point. I can make a clone, and upload it yes. But I am trying to conserve space by using update as I am on a shared server. In the process I am trying to figure out how to selectively use update to skip the column counting clicks (int) and perhaps even delete records not in the mysqldump'd file (hypothetically an sql file with update syntax).

I am not an idiot, to my knowledge. Although, I could be wrong.