Skip to navigation

Archive for the 'mysql' Category

My first RMySQL session

Thursday, January 21st, 2010

# ‘fai1′ is an empty MySQL database for which ‘mpromber’ has all privileges mycon

MySQL settings in ~/.my.cnf

Thursday, January 21st, 2010

You can specify default settings for MySQL in the file ~/.my.cnf (create it if it doesn’t exist). E.g., you could spare yourself typing your password each time you connect with an entry in that file like this: [client] password=’mypassword’ This gets loaded in addition to the system configuration file, which for me is at /etc/mysql/my.cnf.

How to run a web server off a usb flash drive

Monday, November 19th, 2007

Actually, turns out to be really easy: Install Slax on the USB flash drive. Here’s how I did it. Download the Xampp module for Slax. I got version 1.6.2 from here. Copy the Xampp_1_*_.mo file that you downloaded to the modules folder on your USB flash drive. Boot off the USB flash drive. Open a [...]

Drupal: how to disable broken module manually

Wednesday, November 14th, 2007

I did something wrong applying a patch to a module. This resulted in a broken site — I wasn’t able to see the Administration page anymore to disable the module (or any page for that matter). Log on to your server via SSH. mysql -p Gets you into mysql. To see your databases: show databases; [...]

Importing mysql database from the commandline

Wednesday, July 4th, 2007

I’ll be moving this blog to a different host (unfortunately, because it isn’t easy to get German ISPs to change the DNS settings, I will also move it to the domain promberger.info at the same time). I can export the database using phpmyadmin, but on the new server I’ll have to import them from the [...]