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 terminal and type:
/opt/lampp/lampp start

Open Konqueror [...]

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;
To pick the drupal database:
use drupal;
Then, [...]

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 [...]