Ubuntu Servers :: Changing The Datadir In My.cnf Stops Mysql To Restart On 9.10
Feb 9, 2010
I am trying to change the datadir in my.cnf and try to point it to different location where my database are residing.I have the permission to write on this directory.
datadir = /home/glucose/mysql
#datadir = /var/lib/mysql
if I do ls on my database location.Here is the result
root@bilal-laptop:~# ls -la /home/glucose/mysql
total 20512
drwxr-xr-x 7 mysql mysql 4096 2010-02-09 16:30 .
[Code]....
Because of which I am not able to start mysql. I am not able to locate actual log file as well.I looked at few log files they don't seem to tell me anything.But I am not sure which one I should be looking at as there are quite a few related to mysql.
View 3 Replies
ADVERTISEMENT
Aug 16, 2009
Has anyone been able to successfully change MySQL's default datadir in Fedora? I've tried on two machines now (F7 and F11), but run into the same problem on both. Here is what I did:
1. shutdown MySQL (service mysqld stop)
2. create new mysql directory (e.g. ~/mysql/) and set ownership to mysql:mysql
3. move tables from /var/lib/mysql to the new directory (I've tried moving only one user-created table, and also moving system tables with same result).
4. edit my.cnf and change "datadir" to point to new location
5. start MySQL (service mysqld start)
[Code]...
View 7 Replies
View Related
Dec 22, 2010
After several hours of searching web I give up. Problem: I want to run mysqld with datadir option.When I run it manually without --datadir everything is fine I have added required lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor
Quote:
/sys/devices/system/cpu/ r,
/disk0/mysql r,
/disk0/mysql/** rwk,
Then I copy /var/lib/mysql to my location, carefully, 10 times checking all the permissions and run. But daemon exits immediately after running.
[Code]...
View 2 Replies
View Related
Jun 22, 2010
I was running Ubuntu 9.10 and had the MySQL datadir moved to a different directory, /store/mysql. Due to a filesystem problem on the upgrade to Ubuntu 10.04, I was forced to reinstall. My /store/mysql was copied back over, changes to /etc/mysql/my.cnf and /etc/apparmor.d/usr.sbin.mysqld, but MySQL hangs when I go to start it and nothing is showing up in any of the logs. How do I get MySQL to recognize the datadir from the previous install?
View 1 Replies
View Related
Feb 19, 2010
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies
View Related
Aug 13, 2010
I upgraded to the newest version of Ubuntu a few months ago, and ever since then, the ethernet connection to my router stops working when I restart the machine. It eventually comes back, but after varying amounts of time. Sometimes 20 minutes, sometimes 2 days.
Restarting the computer and cycled reboots of the router don't seem to have any beneficial effect, at least that I can detect.
The light for the slot on the router does not light up like it normally would, so it's almost like the OS doesn't even recognize the network card.
Ubuntu 10.4,64-bit. Dell XPS 410.
View 9 Replies
View Related
Mar 21, 2011
Named has been working fine for months on Fedora core 14 with updates current.a few days ago it stopped working. I tried a service named restart and received the error message: stopping named: umount:/var/named/ chroot/var/named: device is busy.I tried using kill process, which did not work. However if I use kill 9 <named process>, followed by service named stop, I can then restart the service and it works for a number of hours (less than a day), then stops again and produces the error message above when I try to restart it.I can get it working again using the procedure above, but only temporarily.
View 7 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Mar 23, 2010
I did these steps to change my username: I like to directly edit /etc/passwd and /etc/groups
First open a terminal, become root
Code:
sudo -i
Now:
Code:
usermod -d /home/new -m old
sed -i -e 's_old_new_g' /etc/passwd
sed -i -e 's_old_new_g' /etc/group<-
sed -i -e 's_old_new_g' /etc/shadow
My computer shut down after I did the second step and now my password isn't working! I cannot open my home folder or get back to root!
View 9 Replies
View Related
Aug 10, 2010
I have an HP Deskjet D1460. I am using Ubuntu 10.04 and HPLIP 3.10.2 that came with the distro. I am in a plan of moving my windows PC to ubuntu in my bussiness, and this is the first of them. Trying to solve all the problems before converting a second one. All seems to work quite well and almost out of the box... and that is a huge step from the last distro i tryied 2 years ago. So, my difficulty now resides on the printing. I am using a small VFox program that manage some of the aspects of the bussiness, in wine. It works without problems, but... when I print, all the pages get printed like 1cm below than when it was printed under windows. The problem is, that I use the printer to fill some forms that came pre-printed, and now, I am printing over the other text instead of the white spaces. I read a little, and try to adjust the HWMargins and the ImageableArea in the ppd of /etc/cups/ppd/ but it was like if I was doing nothing. Do I miss a step? Do I need to restart a service or something after changing the ppd? The margings when using the printer gui from Ubuntu are all in 0, and for that i need like a minus something.
View 3 Replies
View Related
Jan 17, 2010
ver: 9.10 how do I restart dhcp3 after changing dhcpd.conf?
View 3 Replies
View Related
Jul 15, 2015
Today I installed debian-8.1.0-amd64 on my older Samsung Laptop (Model r560). The installation without a desktop environment worked fine and the system booted without any problems into the virtual console. There was however one problem: when I was away from keyboard for some time, the screen turned black and when I came back and hit a button to wake the system up, the laptop immediately restarted. Later I installed the gnome desktop environment. This also worked fine.
But whenever I try to change the screen brightness in the gnome-shell, my system immediately restarts and successive attempts to boot debian fail. Some time later and after countless attempts to boot debian, it finally does boot again. By "debian fails to boot" i mean the following: The initial ram disk is loaded and fschk runs. Usually the system suddenly reboots at this point. SOmetimes, however, the video mode changes, the console font is changed and some services are getting started, but then at some point the system also restarts. I don't reach the point where a login prompt appears, or the graphical environment starts up.
Assuming, it has something to do with buggy acpi implementation of my hardware, I tried the following:
I tried to disable acpi completely by using the kernel parameter "acpi=off". This doesn't work and causes the kernel to hang
I tried to start debian without using a GUI using the single parameter. This also didn't work.
acpi_backlight=vendor also did not fix the problem.
View 0 Replies
View Related
Jul 8, 2010
I was playing with the mysql my.cnf file yesterday, trying to move my database files to my dropbox folder so I can use the database on my other machine. All I changed was the datadir setting to point to my dropbox folder. I also moved my mysql data files there.
When I tried to restart mysql and test the new location it said my mysqld.sock was missing. I searched and searched the web and my filing system for it but I have no idea what's happened to it?? I have even tried changing the datadir path back and reinstalling mysql but that doesn't seem to work either.
View 2 Replies
View Related
Jul 19, 2011
I'm trying to change the default mysql port with no success. I looked at my.cnf file and there's no reference to port. I also looked at the iptables and mysql is running on 3306 (default).I've changed the iptable file but mysql fails to restart.If I add port = [my port number] to the my.cnf file, mysql fails to start.
View 4 Replies
View Related
Feb 2, 2009
I want to change my MySQL default port(3306) as 80 how can i do this on centOS 5.2? I tired to add
[client]
port=80
to /etc/my.cnf and different command in this file. But mysql didn't start. How can do this? I'll use server only as mysql and ftp server.
View 13 Replies
View Related
Jul 23, 2010
I'm using debian 5 x64 with xfce.Is there a way to configure (start/stop/restart) services (especially Apache2, mySQL and PHP) using a graphical or cli tool? I tried to use sysv-rc, sysv-rc-conf, rcconf and rc-conf in the terminal but Bash didn't find them (Although Synaptic show that sysv-rc is installed).
View 9 Replies
View Related
Jul 28, 2009
I am trying to get mysql to start at boot without any success.
The mysqld scripts works fine when run from the command line, but it does not work when i use the links created by chkconfig. I checked the boot.log and found that mysql starts but then it stops or gets shutdown. This is the log message:
Starting mysqld daemon with databases from /data/mysql [ OK ]
Starting cups: [ OK ]
STOPPING server from pid file /var/run/mysqld/mysqld.pid
starting DenyHosts: /usr/bin/denyhosts.py --daemon --config=/usr/share/denyho
sts/denyhosts.cfg
090727 04:35:47 mysqld ended
The same init script works fine in Ubuntu.
View 2 Replies
View Related
Apr 6, 2010
I recently decided to install Ubuntu and I went through all of the steps to set up a subversion server using svnserve. It all works except for one thing: it stops responding to remote computers after a while.I have the server on a 4 port wireless router/switch in my dorm room. I set up port forwarding so that the server receives all traic over the correct ports. The subversion server AND the default http server on Ubuntu work fine always as long as I access them from a computer connected to the switch in my room.The problem is that if I try to access it from anywhere else, it won't respond at all unless it has been accessed by a computer on the switch recently (something like 30-60 minutes). So to fix it I have to go back to my room and access it from a computer on the switch. Then it will work from anywhere for another 30-60 minutes.
View 2 Replies
View Related
Feb 25, 2010
I have an old dell server that I decided to try to install ubuntu server on. My problem is that my keyboard stops working after making my initial selection of installer language and install option. As soon as I select install, I receive a message stating that IRQ 14 has been disabled. Next, I am faced with a screen asking me to select my installation language using the tab, space, and enter keys. But to no avail, my keyboard no longer works. No arrows, no tab, no space, no enter, he num lock key will not toggle it's respective LED.
I should note that I'm using a PS/2 mouse (there are no USB ports on this server). I've also tried multiple PS/2 keyboards, and all act the same. I've looked in my BIOS settings, and the only option I see is for enabling/disabling the on-board PS/2 keyboard. I have not tried disabling that, because I have a funny feeling I would lock myself out of the server for good. I also tried non-graphical mode (at least I think that's what I did). I held in the shift key while booting the CD, and selected no to using graphics. At the "boot:" prompt, I just hit enter.
View 1 Replies
View Related
Nov 29, 2010
On a whim vsftpd seems to stop working randomly and any attempted connection times out while waiting for the welcome message.It'll take a couple reboots and a couple "sudo service vsftpd restart" 's and it'll eventually start working again.AFIIK everything is at the most currant version. It just started doing this a few weeks ago.Here is my config file:
Code:
# Example config file /etc/vsftpd.conf
#
[code]...
View 9 Replies
View Related
Nov 17, 2010
I have a small network of an Ubuntu server 10.4 , Debian server, Win XP, and an ubuntu desktop 10.4. I have configured a DNS server and DHCP server successfully on my ubuntu server, also a slave DNS server on Debian. I recently configured apache2 as part of LAMP on ubuntu server, but when I type my ServerName in the URL of my Win XP browser, I get this response: The webpage "mansour.net" cannot be found DNS error occurred. Server cannot be found. The link may be broken.
I have an A Record in my DNS zone file for mansour.net and have that as my ServerName in apache2 Definition file, but I don't know why it is not working. I am trying to learn to install and configure various servers on ubuntu.
View 8 Replies
View Related
Mar 16, 2011
I have succesfully installed Ubuntu 10.10 server and want to install a virtual machine with the same OS.
For installation purpose, I mounted a cdrom drive, keyboard and monitor.
On my attempt to do the installation, I get the following sequence:
Code:
sudo virt-install
> --connect qemu:///system
> --name sweb
> --ram 512
> --disk path=/var/lib/libvirt/images/sweb.img,size=20
> --network bridge=br1
> --cdrom /dev/cdrom
[sudo] password for karelv:
code....
I have tried the procedure from the physical console as well as from remote (using Putty on a windows machine) in a SSH window.I also tried to install from an iso file on disk in stead of the cdrom. All with the same result.
View 4 Replies
View Related
Oct 8, 2010
I have an ubuntu server virtual machine with a webhost. I am trying to configure the firewall. I am having a problem with sendmail and the required firewall configuraiton If I type the command:
iptables -F
Then sendmail works perfectly. I can see the emails sent in my googlemail inbox. I then configure my firewall as follows:
iptables -F
iptables -A INPUT -m conntrack --ctstate ESTABLISHED,RELATED -j ACCEPT
iptables -A INPUT -i lo -j ACCEPT
iptables -A INPUT -p tcp --dport 2252 -j ACCEPT
iptables -A INPUT -p tcp --dport 80 -j ACCEPT
[Code]....
(I have moved SSH to a diffrent port) Once this is setup sendmail no longer works. I had assumed that sendmail will establish a tcp connection and the first rule will allow all established connections to pass. why this iptables/netfilter config stops sendmail from working.
View 5 Replies
View Related
Apr 24, 2011
I'm not sure if this belongs in the Server or Networking section of the forums. Anyway, last month I upgraded my server to Ubuntu 10.04 LTS. Since then, I've had a recurring problem wherein after a certain period of time, the server stops accepting network connections. Ubuntu 10 will continue to reject network connections until someone logs into the server locally, after which time network connectivity is restored and the cycle begins anew. Essentially, the server goes into a "half sleep mode". I say half because the computer is still on and the fans are running.
I've done some searching around various forms and initially figured this issue was related to problems with the Network Manager service (https://bugs.launchpad.net/ubuntu/lu...er/+bug/524454), so I removed the service altogether. However, this problem is still occurring.
I've poured over /var/log/messages and /var/log/syslog, but have noticed no irregular behavior. Has anyone else experienced this issues? I'd rather not resort to downgrading back to Gusty Gibbon if I can help it.
I am happy to provide more information if its needed
View 4 Replies
View Related
Feb 20, 2009
I can't seem to figure this out. I've got a DOS disc that loads up a network share (my Samba server running Fedora 10) - connects to the share, runs ghost.exe from there. Everything runs perfect for about 2 minutes, then my thoroughput drops to 0. Sometimes, after about 40 seconds, it'll resume imaging. Most of the time, after about 40 seconds, Ghost gives me an error stating 'not enough free space on the destination disc' - This is a raid 5 3TB array that I'm ghosting a 6.0Gb HDD to!
lanman auth = yes and client lanman auth = yes are already set up - I can connect fine, but it's almost like Samba hiccups and drops my connection!
View 6 Replies
View Related
May 11, 2010
Any time I try and restart the Shorewall it takes forever. Sometimes I have to reboot the File Server as its faster.In the shorewall-init.log it seems to stick on the loading modules and goes no further. Anyone come accross this before.I have Ubunut 8.04LTS - everything seemed to be working OK until I installed NFS, NIS, AUTOFS - but I can't be 100% sure.
View 1 Replies
View Related
Oct 13, 2010
I recently installed Server 10.10 64-bit. After installation, I set up my config file (/etc/samba/smb.conf), and tried to restart Samba:
Code:
/etc/init.d/samba restart
There was nothing to restart though - the file /etc/init.d/samba wasn't there!
Purged the package and re-installed. Tried reformatting and adding Samba as a pre-installed package. Trying to find the server guide for 10.10, but no dice. Did something change for Samba in 10.10?
View 1 Replies
View Related
Oct 29, 2010
When ever I restart ssh
Quote:
/etc/init.d/ssh restart
I see following line in auth.log
Quote:
sshd[5678]: error: Bind to port 22 on :: failed: Address already in use.
That is a headless server. What does the above line signify or tell and why am I seeing that? Ubuntu 10.04 64 bit server edition
View 9 Replies
View Related
Nov 29, 2010
This was working perfect and all of a sudden stops. Now when I try and start this service it simply hangs. I have searched and found a ton of reasons why this could be. No fix yet as worked.
View 8 Replies
View Related
