I just tried to uninstall MySQL on Debian via apt-get remove –purge mysql-server apt-get remove –purge mysql-client apt-get autoremove and wondered that the directories /var/lib/mysql /etc/mysql still existed after the commands. Then I recognized, that a apt-get remove –purge ‘mysql-server.*’ is doing better and removes everything. Note: if you get a /etc/init.d/mysql: WARNING: /etc/mysql/my.cnf cannot [...]
Posts Tagged ‘mysql’
Save SQL result into file
Often it is useful to export a SQL query result into a file. Especially CSV files are nice for this task. The following SQL query saves the result in a file called output.csv into the /tmp directory: SELECT * FROM my_table INTO OUTFILE ‘/tmp/output.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’;
uninitialized constant MysqlCompat::MysqlRes
I just had the following problem when trying to start a Ruby on Rails application on a fresh installation of Mac OS X Snow Leopard after I installed the mysql gem via gem install mysql: uninitialized constant MysqlCompat::MysqlRes I searched a bit and found a solution here. It was a problem with a buggy version [...]
New Amazon RDS features
Nice replication features in Amazon’s RDS Management Console – You can now use the web-based AWS Management Console to launch Database Instances (including highly available and reliable Multi-AZ deployments), take real-time snapshots of a DB Instance, and view important database statistics. Multi-AZ Deployments – With a single API call, you can create a MySQL Database [...]
Exporting and importing database using utf8 encoding
Export the data mysqldump -p –default_character-set=utf8 -u USERNAME –skip-set-charset database_name > DUMPFILE.sql Create the database you want to import in CREATE DATABASE database_name CHARACTER SET utf8 COLLATE utf8_bin Import the data: mysql -u USERNAME -p –default-character-set=utf8 –max_allowed_packet=64M database_name < DUMPFILE.sql
Jena2 Preview 3
Und es ist wieder ein neues Preview der Jena RDF API veröffentlicht worden – die Nummer 3! In dieser Version wird auch persistentes Speichern unterstützt (vorerst aber nur MySql). Download unter [1] und diskutiert werden kann unter [2]. [1] http://prdownloads.sourceforge.net/jena/Jena-2p3.zip?download [2] http://groups.yahoo.com/group/jena-dev/
Follow me on the following platforms if you like: