You can change the mysql prompt client so you know where you are. Very usefull when you manage a lot of mysql databases and you forget which one :-)
To import a local CSV file into MySQL, use the syntax below : LOAD DATA LOW_PRIORITY LOCAL INFILE '/path/tofile.csv' INTO TABLE database.
To export a mysql results in CSV format, use the syntax below : SELECT field1, field2, ... FROM table WHERE condition INTO OUTFILE '/tmp/toto.
Just in case you absolutely have to insert a date in MySQL that does’nt exist, eg 2014-02-30, you can run MySQL server in a special mode that authorizes such dates :