ti sei fatto prendere dall' > che ho erroneamente messo

io NON devo esportarlo in un file.sql ma IMPORTARLO da file sql, rimpiazzando tutto..

ho trovato questo in rete

codice:
To export/backup a database

cd to whatever directory you wish to store the data, and enter:

mysqldump --default-character-set=latin1 -C -u USERNAME -p --opt --lock-tables=false --skip-add-locks --skip-extended-insert DATABASE > DATABASE.sql

Make sure you replace the values in CAPS with the correct info for your account (you can also change the character set if you wish).

To tgz compress the file DATABASE.sql for easier transportation:

tar czvf DATABASE.tgz DATABASE.sql

To import/restore a database:

cd to wherever the sql data is stored, and enter:

mysql -uUSER -pPASSWORD DATABASE < DATABASE.sql

Again, make sure to replace the values in CAPS.
ma credo che manchi un parametro ( -v )?


@joker