Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: how to move the data directory?

Posted on 2008-04-20 05:40:56 by boll

I would like to know the correct way to move the mysql data directory to
a different disk partition, so that the data can be accessed by mysql
under linux or windows. I'm using Ubuntu 7.1 and Windows XP.

I copied the data directory to a separate partition.
I then changed the datadir in my.cnf, but Mysql would not start, warning:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock'

I'd appreciate your suggestions.
-B.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Report this message

#2: Re: how to move the data directory?

Posted on 2008-04-26 05:39:14 by Raj Shekhar

boll wrote:

> I would like to know the correct way to move the mysql data directory to
> a different disk partition, so that the data can be accessed by mysql
> under linux or windows. I'm using Ubuntu 7.1 and Windows XP.

I wrote these steps for 4.0, I think they should work for you
<http://rajshekhar.net/blog/archives/90-Moving-the-MySQLs-datadir-directory..html>

Make sure you do a clean shutdown of mysqld before doing the steps (i.e. no
kill -9 business)


>
> I copied the data directory to a separate partition.
> I then changed the datadir in my.cnf, but Mysql would not start, warning:
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock'

Check mysqld.err file to see your errors.

--
raj shekhar
facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog
Yoda of Borg are we: Futile is resistance. Assimilate you, we will
'Borg? Sounds Swedish.' - Lily, Star Trek First Contact


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Report this message