<job version="4.2">
<syncjob>
<abortonerror abort="no" />
<fkcheck check="no" />
<source>
<host>localhost</host>
<user>root</user>
<pwd></pwd>
<port>3306</port>
<database>amici</database>
</source>
<target>
<host>localhost</host>
<user>root</user>
<pwd></pwd>
<port>3306</port>
<database>nuke</database>
</target>
<tables all="no">
<table>
<name>nuke_users</name>
<columns all="no">
<column>name</column>
<column>username</column>
<column>user_email</column>
<column>femail</column>
<column>user_website</column>
<column>user_avatar</column>
<column>user_regdate</column>
<column>user_icq</column>
<column>user_occ</column>
<column>user_from</column>
<column>user_interests</column>
<column>user_sig</column>
<column>user_viewemail</column>
<column>user_theme</column>
<column>user_aim</column>
<column>user_yim</column>
<column>user_msnm</column>
<column>user_password</column>
<column>storynum</column>
<column>umode</column>
<column>uorder</column>
<column>thold</column>
<column>noscore</column>
<column>bio</column>
<column>ublockon</column>
<column>ublock</column>
<column>theme</column>
<column>commentmax</column>
<column>counter</column>
<column>newsletter</column>
<column>user_posts</column>
<column>user_attachsig</column>
<column>user_rank</column>
<column>user_level</column>
<column>broadcast</column>
<column>popmeson</column>
<column>user_active</column>
<column>user_session_time</column>
<column>user_session_page</column>
<column>user_lastvisit</column>
<column>user_timezone</column>
<column>user_style</column>
<column>user_lang</column>
<column>user_dateformat</column>
<column>user_new_privmsg</column>
<column>user_unread_privmsg</column>
<column>user_last_privmsg</column>
<column>user_emailtime</column>
<column>user_allowhtml</column>
<column>user_allowbbcode</column>
<column>user_allowsmile</column>
<column>user_allowavatar</column>
<column>user_allow_pm</column>
<column>user_allow_viewonline</column>
<column>user_notify</column>
<column>user_notify_pm</column>
<column>user_popup_pm</column>
<column>user_avatar_type</column>
<column>user_sig_bbcode_uid</column>
<column>user_actkey</column>
<column>user_newpasswd</column>
<column>points</column>
<column>last_ip</column>
<column>karma</column>
</columns>
</table>
</tables>
</syncjob>
</job>
QUESTO è quello che viene scritto nel file creato da sqlyog!
la query non so dove andarla a capitare!
Grazie per la risposta!
