Unable to migrate embedded db to external mysql.

[tris_r]

>Sharing a DB between two machines is not currently supported;

Thanks for the heads up. I'll have a look into backing up the db before
testing it too much.  I'll let you know how it goes if I get up and running.  

>Have you checked permissions on the my.cnf file/mysqle directory? Both
>the first error (not being able to open the my.cnf file) and the last
>one ("mysqld does not have access rights to the directory") seem to
>pretty clearly indicate that there's a permissions problem.

Yeah that is one of the things I tried, went through it again in a more
systematic way.  

When ever I give my.cnf global write access
sudo chmod 777 my.cnf or 
sudo chmod 772 my.cnf

It comes up with this error at the start.

Warning: World-writable config file
'/home/tris/.kde/share/apps/amarok/my.cnf' is ignored
091226 22:58:50 [Warning] Can't create test file
/home/tris/.kde/share/apps/amarok/mysqle/vostok.lower-test

Any run without global write access 
sudo chmod 770 my.cnf or 
sudo chmod 775 my.cnf

Errors with...

Could not open required defaults file:
/home/tris/.kde/share/apps/amarok/my.cnf

I tried halting the mysql daemon, deleting and recreating the file, amarok
running/not running, running the command as sudo (which halted with security
errors) none of which changed the original warning errors.

Also gave full privileges to ./mysqle/ but still had an error with... 
Can't create test file
/home/tris/.kde/share/apps/amarok/mysqle/vostok.lower-test

Had a bit more of a look around and tried not having any defaults (if my.cnf
is empty anyway) and the error with InnoDB shouldn't matter using Myisam.

$ /usr/sbin/mysqld --no-defaults --default-storage-engine=MyISAM
--datadir=/home/foouser/.kde/share/apps/amarok/mysqle
--socket=/home/foouser/.kde/share/apps/amarok/sock --skip-grant-tables
--skip-innodb

091227  0:05:11 [Warning] Can't create test file
/home/foouser/.kde/share/apps/amarok/mysqle/vostok.lower-test
091227  0:05:11 [Warning] Can't create test file
/home/foouser/.kde/share/apps/amarok/mysqle/vostok.lower-test
091227  0:05:11 [Note] Plugin 'FEDERATED' is disabled.
091227  0:05:11 [Note] Plugin 'InnoDB' is disabled.
091227  0:05:11 [ERROR] Can't start server : Bind on unix socket: Permission
denied
091227  0:05:11 [ERROR] Do you already have another mysqld server running on
socket: /home/tris/.kde/share/apps/amarok/sock ?
091227  0:05:11 [ERROR] Aborting

091227  0:05:11 [Warning] Forcing shutdown of 2 plugins
091227  0:05:11 [Note] /usr/sbin/mysqld: Shutdown complete

or when the mysql service was running.
091227  0:17:07 [ERROR] Can't start server: Bind on TCP/IP port: Address
already in use
091227  0:17:07 [ERROR] Do you already have another mysqld server running on
port: 3306 ?

Seems a step in the right direction but still no success.  I've re-tried a
bunch of permissions changes from this point and even chown mysql:mysql
./mysqle after reading one post.  I'm still lost any further help would be
greatly appreciated. 

Cheers

-- 
View this message in context: http://old.nabble.com/Unable-to-migrate-embedded-db-to-external-mysql.-tp26925775p26927223.html
Sent from the Amarok - Main mailing list archive at Nabble.com.