mysql issues

the mysql service file and mysql-post script from the Systemd/Services wiki page have been moved to the package and you created them manually before, that's why you get this error.

I have two instances of mysql running on a server. I need two different init.d scripts. The two instances have different configuration files /etc/my.cnf and /etc/my-slave.cnf. I copied the /etc/init.d/mysql files to /etc/init.d/mysql-slave and changed the conf parameter to /etc/my-slave.cnf but the mysql-slave service is still controlling the first instance of mysql.

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them --

$ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07

$ ps -ef | grep -i mysqld | grep -v grep mysql 2364 1 0 16:17 ?

I am getting following error:

error: Found option without preceding group in config file: /etc/my.cnf at line: 1 Fatal error in defaults handling.

I have a standard MySQL Server running on Red hat 5.7. I have edited /etc/my.cnf to specify the bind address as my server's public IP address.

MySQL 5.5 on Ubuntu 10.10 used to work well until yesterday but today whenever I start MySQL using mysqld_safe as root user it shows

Starting mysqld daemon with databases from /var/lib/mysql

and then shows pid ended

I havent run any updates recently but I used the MySQL administrator to connect to a remote database but MySQL administrator was installed one month ago.

I then examined the error

I am trying to change the data directory for mysql in a LAMP setup. The partition that LAMP is installed in cannot support the size of a .sql dump I am trying to import. I have another hardrive with plenty of room on it that I want all the data to live on.

I have changed the datadir to my new directory and moved the /var/lib/mysql folder and content to it.

I have an external HD and i'd like to run a 2nd mysql instance on it. I used the windows installer to install/configure mysqld as a service on windows7. I took the my.ini from

C:\Program Files\MySQL\MySQL Server 5.5\my.ini

Then edited the port (client and mysqld), datadir and innodb_data_home_dir.

Hello.

Running 10.04 server and mysql 5.01.

I experimendted innobackup which made a one backup file of all databases.

Tested restoring the database by first stopping mysql service (stop mysql), extracting the backup to a new dir (/var/lib/data), modified the /etc/mysql/my.cnf to point there and to check the mysqld.sock to point to /var/run/mysqld/mysqld.sock .

Code: [client] port