Maybe you do not use innodb tables, in that case there would be no data loss.
On Thursday, August 27, 2009, Jia Chen <chen.1...@gmail.com> wrote: > Thanks for the tips. Where can I find more details about the ibdata file? > > After I changed the data dir, hese file did get recreated. So far, I have not > noticed any data loss yet. > > Best, > Jia > > Eric Bergen wrote: > > That procedure is horribly incorrect. You should simply move the > ib_log and ibdata files with the rest of the datadir. The ibdata1 file > contains innodb's system tables and depending on your setting of > innodb_file_per_table it also contains your data! > > On Thu, Aug 27, 2009 at 7:56 AM, Jia Chen<chen.1...@gmail.com> wrote: > > > Chen, Did you really delete ibdata1 ? > > > Yes, I did. > > Best, > Jia > > > Claudio Nanni wrote: > > > 2009/8/26 chen jia <chen.1...@gmail.com <mailto:chen.1...@gmail.com>> > > Hi there, > > I am using MySQL on ubuntu 8.04. > > I followed this link > > http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive > to change the data directory of MySQL. > > After stopping MySQL: sudo /etc/init.d/mysql stop > > I make a new directory: sudo mkdir /media/disk/MySQL_data > > then change the ownership of new directory, sudo chown mysql:mysql > /media/disk/MySQL_data > > and copy all data to the new directory, cp -r -p /var/lib/mysql/* > /media/disk/MySQL_data/ and deleted all files like ibdata1, > > > Chen, Did you really delete ibdata1 ? > > > > > > > ib_logfile0, and ib_logfile1. > > I then edit /etc/mysql/my.conf and update the "datadir" to my new > directory. I also update /etc/apparmor.d/usr.sbin.mysql so that news > lines with /var/lib/mysql replaced by /media/disk/MySQL_data are > added. > > However, after sudo /etc/init.d/apparmor reload > > I try sudo /etc/init.d/mysql start > > I got > * Starting MySQL database server mysqld > [fail] > > If I change the "datadir" line in /etc/mysql/my.conf back to the > original one, I can start MySQL successfully. > > I think I have done everything needed to change MySQL data directory. > > Why am I still getting this error? Where can I start to look for > the causes? > > Thanks. > > Jia > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com > > > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
