My first RMySQL session
Thursday, January 21st, 2010# ‘fai1′ is an empty MySQL database for which ‘mpromber’ has all privileges mycon
# ‘fai1′ is an empty MySQL database for which ‘mpromber’ has all privileges mycon
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.
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 [...]
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; [...]
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 [...]