Top-Themen

AppleEntwicklungHardwareInternetLinuxMicrosoftMultimediaNetzwerkeOff TopicSicherheitSonstige SystemeVirtualisierungWeiterbildungZusammenarbeit

Aktuelle Themen

Administrator.de FeedbackApache ServerAppleAssemblerAudioAusbildungAuslandBackupBasicBatch & ShellBenchmarksBibliotheken & ToolkitsBlogsCloud-DiensteClusterCMSCPU, RAM, MainboardsCSSC und C++DatenbankenDatenschutzDebianDigitiales FernsehenDNSDrucker und ScannerDSL, VDSLE-BooksE-BusinessE-MailEntwicklungErkennung und -AbwehrExchange ServerFestplatten, SSD, RaidFirewallFlatratesGoogle AndroidGrafikGrafikkarten & MonitoreGroupwareHardwareHosting & HousingHTMLHumor (lol)Hyper-VIconsIDE & EditorenInformationsdiensteInstallationInstant MessagingInternetInternet DomäneniOSISDN & AnaloganschlüsseiTunesJavaJavaScriptKiXtartKVMLAN, WAN, WirelessLinuxLinux DesktopLinux NetzwerkLinux ToolsLinux UserverwaltungLizenzierungMac OS XMicrosoftMicrosoft OfficeMikroTik RouterOSMonitoringMultimediaMultimedia & ZubehörNetzwerkeNetzwerkgrundlagenNetzwerkmanagementNetzwerkprotokolleNotebook & ZubehörNovell NetwareOff TopicOpenOffice, LibreOfficeOutlook & MailPapierkorbPascal und DelphiPeripheriegerätePerlPHPPythonRechtliche FragenRedHat, CentOS, FedoraRouter & RoutingSambaSAN, NAS, DASSchriftartenSchulung & TrainingSEOServerServer-HardwareSicherheitSicherheits-ToolsSicherheitsgrundlagenSolarisSonstige SystemeSoziale NetzwerkeSpeicherkartenStudentenjobs & PraktikumSuche ProjektpartnerSuseSwitche und HubsTipps & TricksTK-Netze & GeräteUbuntuUMTS, EDGE & GPRSUtilitiesVB for ApplicationsVerschlüsselung & ZertifikateVideo & StreamingViren und TrojanerVirtualisierungVisual StudioVmwareVoice over IPWebbrowserWebentwicklungWeiterbildungWindows 7Windows 8Windows 10Windows InstallationWindows MobileWindows NetzwerkWindows ServerWindows SystemdateienWindows ToolsWindows UpdateWindows UserverwaltungWindows VistaWindows XPXenserverXMLZusammenarbeit
GELÖST

Mysql datadir ändern... geht nicht

Frage Entwicklung Datenbanken

Mitglied: solaris-ch

solaris-ch (Level 1) - Jetzt verbinden

29.09.2008, aktualisiert 30.03.2009, 7214 Aufrufe, 1 Kommentar

MySQL 5.1
RHEL 5
SE Linux ON

Hallo zusammen

seit 4 Stunden versuche ich das datadir per /etc/my.cnf auf ein iSCSI SAN umzubiegen.
Jedesmal wenn ich den MySQL Dienst starten will, kommt die folgende Meldung...:

01.
/etc/init.d/mysql start 
02.
Starting MySQL..Manager of pid-file quit without updating f[FAILED]
Das neue Datadir soll: /mnt/iscsi/dbstorage/
sein.

Das alte war: /var/lib/mysql/

Kopiert habe ich den gesamten Inhalt aus dem alten Datadir ins neue.
Habe den neuen Files den Besiter mysql:mysql zugewiesen.
Aber nix geht...

Mein my.cnf sieht so aus:
01.
# Example MySQL config file for very large systems. 
02.
03.
# This is for a large system with memory of 1G-2G where the system runs mainly 
04.
# MySQL. 
05.
06.
# You can copy this file to 
07.
# /etc/my.cnf to set global options, 
08.
# mysql-data-dir/my.cnf to set server-specific options (in this 
09.
# installation this directory is /var/lib/mysql) or 
10.
# ~/.my.cnf to set user-specific options. 
11.
12.
# In this file, you can use all long options that a program supports. 
13.
# If you want to know which options a program supports, run the program 
14.
# with the "--help" option. 
15.
 
16.
# The following options will be passed to all MySQL clients 
17.
[client] 
18.
#password       = your_password 
19.
port            = 3306 
20.
socket          = /var/lib/mysql/mysql.sock 
21.
 
22.
# Here follows entries for some specific programs 
23.
 
24.
# The MySQL server 
25.
[mysqld] 
26.
port            = 3306 
27.
socket          = /var/lib/mysql/mysql.sock 
28.
datadir         = /mnt/iscsi/dbstorage/mysql 
29.
skip-locking 
30.
key_buffer = 384M 
31.
max_allowed_packet = 1M 
32.
table_cache = 512 
33.
sort_buffer_size = 2M 
34.
read_buffer_size = 2M 
35.
read_rnd_buffer_size = 8M 
36.
myisam_sort_buffer_size = 64M 
37.
thread_cache_size = 8 
38.
query_cache_size = 32M 
39.
# Try number of CPU's*2 for thread_concurrency 
40.
thread_concurrency = 8 
41.
 
42.
# Don't listen on a TCP/IP port at all. This can be a security enhancement, 
43.
# if all processes that need to connect to mysqld run on the same host. 
44.
# All interaction with mysqld must be made via Unix sockets or named pipes. 
45.
# Note that using this option without enabling named pipes on Windows 
46.
# (via the "enable-named-pipe" option) will render mysqld useless! 
47.
48.
#skip-networking 
49.
 
50.
# Disable Federated by default 
51.
skip-federated 
52.
 
53.
# Replication Master Server (default) 
54.
# binary logging is required for replication 
55.
log-bin=mysql-bin 
56.
 
57.
# required unique id between 1 and 2^32 - 1 
58.
# defaults to 1 if master-host is not set 
59.
# but will not function as a master if omitted 
60.
server-id       = 1 
61.
 
62.
# Replication Slave (comment out master section to use this) 
63.
64.
# To configure this host as a replication slave, you can choose between 
65.
# two methods : 
66.
67.
# 1) Use the CHANGE MASTER TO command (fully described in our manual) - 
68.
#    the syntax is: 
69.
70.
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, 
71.
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ; 
72.
73.
#    where you replace <host>, <user>, <password> by quoted strings and 
74.
#    <port> by the master's port number (3306 by default). 
75.
76.
#    Example: 
77.
78.
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, 
79.
#    MASTER_USER='joe', MASTER_PASSWORD='secret'; 
80.
81.
# OR 
82.
83.
# 2) Set the variables below. However, in case you choose this method, then 
84.
#    start replication for the first time (even unsuccessfully, for example 
85.
#    if you mistyped the password in master-password and the slave fails to 
86.
#    connect), the slave will create a master.info file, and any later 
87.
#    change in this file to the variables' values below will be ignored and 
88.
#    overridden by the content of the master.info file, unless you shutdown 
89.
#    the slave server, delete master.info and restart the slaver server. 
90.
#    For that reason, you may want to leave the lines below untouched 
91.
#    (commented) and instead use CHANGE MASTER TO (see above) 
92.
93.
# required unique id between 2 and 2^32 - 1 
94.
# (and different from the master) 
95.
# defaults to 2 if master-host is set 
96.
# but will not function as a slave if omitted 
97.
#server-id       = 2 
98.
99.
# The replication master for this slave - required 
100.
#master-host     =   <hostname> 
101.
102.
# The username the slave will use for authentication when connecting 
103.
# to the master - required 
104.
#master-user     =   <username> 
105.
106.
# The password the slave will authenticate with when connecting to 
107.
# the master - required 
108.
#master-password =   <password> 
109.
110.
# The port the master is listening on. 
111.
# optional - defaults to 3306 
112.
#master-port     =  <port> 
113.
114.
# binary logging - not required for slaves, but recommended 
115.
#log-bin=mysql-bin 
116.
 
117.
# Point the following paths to different dedicated disks 
118.
#tmpdir         = /tmp/ 
119.
#log-update     = /path-to-dedicated-directory/hostname 
120.
 
121.
# Uncomment the following if you are using InnoDB tables 
122.
#innodb_data_home_dir = /var/lib/mysql/ 
123.
#innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend 
124.
#innodb_log_group_home_dir = /var/lib/mysql/ 
125.
#innodb_log_arch_dir = /var/lib/mysql/ 
126.
# You can set .._buffer_pool_size up to 50 - 80 % 
127.
# of RAM but beware of setting memory usage too high 
128.
#innodb_buffer_pool_size = 384M 
129.
#innodb_additional_mem_pool_size = 20M 
130.
# Set .._log_file_size to 25 % of buffer pool size 
131.
#innodb_log_file_size = 100M 
132.
#innodb_log_buffer_size = 8M 
133.
#innodb_flush_log_at_trx_commit = 1 
134.
#innodb_lock_wait_timeout = 50 
135.
 
136.
[mysqldump] 
137.
quick 
138.
max_allowed_packet = 16M 
139.
 
140.
[mysql] 
141.
no-auto-rehash 
142.
# Remove the next comment character if you are not familiar with SQL 
143.
#safe-updates 
144.
 
145.
[isamchk] 
146.
key_buffer = 256M 
147.
sort_buffer_size = 256M 
148.
read_buffer = 2M 
149.
write_buffer = 2M 
150.
 
151.
[myisamchk] 
152.
key_buffer = 256M 
153.
sort_buffer_size = 256M 
154.
read_buffer = 2M 
155.
write_buffer = 2M 
156.
 
157.
[mysqlhotcopy] 
158.
interactive-timeout
Weiss jemand Rat? Ich stehe kurz vor der verzweiflung.
Mitglied: keksdieb
30.09.2008 um 09:26 Uhr
Moin moin,

Man korrigiere mich, aber wird das pid File nicht vom init.d Script angelegt/geupdatet?
Kontrollier im Startscript mal die Pfade und passe die eventuell an.

Gruß Keks
Bitte warten ..
Ähnliche Inhalte
Notebook & Zubehör
gelöst Notebook Verbindung zum Router geht, aber kein Internet (7)

Frage von Headhunter4711 zum Thema Notebook & Zubehör ...

Windows Server
Computernamen von Sharepoint 2013 nachträglich ändern (1)

Frage von Philipp.S zum Thema Windows Server ...

Microsoft Office
gelöst Office365 - Anmeldung geht nicht (1)

Frage von maichinger zum Thema Microsoft Office ...

Neue Wissensbeiträge
RedHat, CentOS, Fedora

Fedora, RedHat, Centos: DNS-Search Domain setzen

(5)

Tipp von Frank zum Thema RedHat, CentOS, Fedora ...

Drucker und Scanner

Samsung SL-M4025ND, firmware update und (kompatible) Tonerkassetten

(1)

Erfahrungsbericht von markus-1969 zum Thema Drucker und Scanner ...

Router & Routing

PfSense auf Supermicro Intel Xeon D-15x8 SoC Bare Bone

Tipp von Dobby zum Thema Router & Routing ...

Heiß diskutierte Inhalte
Windows 10
Windows für Privatanwender "nicht mehr handhabbar" (26)

Frage von FA-jka zum Thema Windows 10 ...

LAN, WAN, Wireless
Brauche Hilfe: Mit (schnellem) WLAN Strecke überbrücken (23)

Frage von pierrehansen zum Thema LAN, WAN, Wireless ...

Basic
Programmierung von Windows Programmen (10)

Frage von Ghost108 zum Thema Basic ...