Long absence and mysqldump
Long time without posting, you might be wondering why (assuming that someone actually reads this :-)).
Well, I think that the technologies are widely used (maybe JSF is the less trendy one, but I’m interested in Shale…).
And what about the result? What will it become? I only have a very blurry picture right now… but it will be something like a comunity-driven map. A “social map” if you want, with tagging and all that stuff.
Enough about that… after all it is only vaporware right now.
As you might have guessed from the title, I’m using MySQL as the database, and I’m playing for the first time in my live with thie mysqldump tool (I need to export my schema, as I work incrementally on it directly on the database).
If you don’t know this little utility (it is command line, and comes standard with MySQL), here is a quick reference:
Export a database schema without data:
mysqldump your_database –single-transaction -d -u your_user
Export a database schema including data:
mysqldump your_database –single-transaction -u your_user
Export a single table schema with data:
mysqldump your_database –single-transaction -u your_user –tables your_table
Export the schema (*.sql) and tab-separated text data (.txt) on a path:
mysqldump your_database –single-transaction -u your_user -T export_path
Export the schema with data and semicolon-separated text data:
mysqldump your_database –single-transaction -u your_user -T export_path –fields-terminated-by=”;”
And last, but not least, you can also export a database in Xml format:
mysqldump your_database –single-transaction -u your_user -X
And that’s all folks! See you later.