Hello guys! I have been having some major problems since Amarok changed to version 2. I even switched to Listen for a while, but it just does not compare.

I used a script to backup my old Amarok 1.4 database to a .mysql text file. Now I want to import it into Amarok 2. I tried installing MySQL and importing the database before, but it would use my old Ubuntu username and all the files were in a different home folder. I tried doing a find and replace with my username on the database, but that also did not work. That's when I gave up.

Is there any simple way I can just import my old MySQL database in text format easily without having to import it to MySQL? Any help on this matter would be greatly appreciated since I have been lost here for a while.

My current Amarok version is 2.0.2 and I am using Ubuntu 9.04 Jaunty Jackalope. My MySQL is version 5.0.

Here is the script I used to make the backups (the 'Insert Code' button is not working...) :



######### CHANGE SETTINGS HERE #########
# Location to place Amarok-database backups:
BACKUP_BASE_DIR=~/.amarok-db

# Name of MySQL-database:
AMAROKDB_NAME=amarok

# Username and password for Amarok-MySQL-database:
AMAROKDB_USER=amarok
AMAROKDB_PW=123456

# Location of amarokrc:
AMAROKRC=~/.kde/share/config/amarokrc
######### END OF SETTINGS SECTION #########

BACKUP_SUBDIRECTORY=`date +%Y-%m-%d`

if [ ! -w $BACKUP_BASE_DIR -o ! -d $BACKUP_BASE_DIR ]
then
  printf %b "\n\n $BACKUP_BASE_DIR doesn't exist or is not writable!\n\n"
  printf %b "STOP.\n\n"
  exit 1;
fi

if [ ! -r $AMAROKRC ]
then
  printf %b "\n\n $AMAROKRC doesn't exist or Amarok is not installed!\n\n"
  printf %b "STOP.\n\n"
  exit 1;
fi

mkdir -p $BACKUP_BASE_DIR/$BACKUP_SUBDIRECTORY

                #using a temporary file in order not to overwrite an existing copy when the script is
                #manually invoked a second time (e.g. right before restoration of existing backup of same date!)
mysqldump -u $AMAROKDB_USER -p$AMAROKDB_PW $AMAROKDB_NAME -c -e --hex-blob > /tmp/amarok.mysql

tar --remove-files -C /tmp -cvvjf /tmp/amarok.mysql.tar.bz2 amarok.mysql

mv -i -v /tmp/amarok.mysql.tar.bz2 $BACKUP_BASE_DIR/$BACKUP_SUBDIRECTORY

# The config file amarokrc will also be secured:
cp -i -v $AMAROKRC $BACKUP_BASE_DIR/$BACKUP_SUBDIRECTORY

P.S. I also have not been able to find the answer to this question on Google: Where does Amarok 2 store its MySQL database? Is it in the .kde folder so that when I copy my home directory, it will also copy over?

Don't know if you are still having problems with this, but the way I did it was to back up my 1.4 database with phpMyAdmin, and then use the import function in the configuration dialog.

Amarok 2 uses embedded mysql, so the database is in ~/.kde/share/apps/amarok/mysqle... as its a different system, don't think simply copying the old one is going to do the trick for the "upgrade" to 2.

Looks like you might be able to make use of your old database after all:
http://amarok.kde.org/blog/archives/106 ... vered.html