my 2 cents
From 6 to 7: export GEM_HOME=/opt/ruby_gems export LC_ALL=C gem1.8 uninstall mysql gem1.8 install mysql —version=2.8.1 From 7 to 8: export GEM_HOME=/opt/ruby_gems export LC_ALL=C gem1.8 uninstall passenger gem1.8 install passenger apt-get install apache2-dev /opt/ruby_gems/bin/passenger-install-apache2-module Plus adjustments in the corresponding module config … Read More »
currently just the commands: SELECT id,name FROM projects; SELECT * FROM wikis; SELECT * FROM wiki_pages limit 10; SELECT * FROM wiki_pages WHERE wiki_id = ‘1’ AND title = ‘Howtos’; SELECT * FROM wiki_pages WHERE parent_id = ‘34’; SELECT * … Read More »
Monitor All SQL Queries in MySQL is a very nice (though short) posting about how to debug and monitor what’s going on inside your DBMS. There’s supposed to exist a similar tool for MSSQL called “Profiler”.
to restore a dump from a MySQL database created on a debianish Linux system, just feed the dumped SQL to the command-line mysql client like this: mysql -u root -p < mysql-all-2010-03-28-0515.sql since the whole content of all MySQL databases … Read More »
NOTE: this posting is still very incomplete!! make sure the 32-bit variants of Java and the corresponding MySQL-connector are installed: sudo aptitude install ia32-sun-java6-bin libmysql-java then, adjust the install.properties to use MySQL: —- ds-server/install.properties.orig 2010-02-13 16:54:13.000000000 +0100 +++ ds-server/install.properties 2010-02-13 … Read More »
to create a user for doing automated backups of a MySQL installation that doesn’t have more than the necessary privileges, use the following statement: GRANT RELOAD, SELECT, LOCK TABLES ON . TO ‘backup’@‘localhost’ IDENTIFIED BY ‘some_reasonable_password’;