That is likely the case. As you said, I do not use innodb tables.
Best,
Jia
On Fri, Aug 28, 2009 at 8:25 AM, Johnny Withers<johnny@stripped> wrote:
> Maybe you do not use innodb tables, in that case there would be no data loss.
>
> On Thursday, August 27, 2009, Jia Chen <chen.1002@stripped> 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.1002@stripped> wrote:
>>
>>
>> Chen, Did you really delete ibdata1 ?
>>
>>
>> Yes, I did.
>>
>> Best,
>> Jia
>>
>>
>> Claudio Nanni wrote:
>>
>>
>> 2009/8/26 chen jia <chen.1002@stripped
> <mailto:chen.1002@stripped>>
>>
>> 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=1
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>>
>>
>
> --
> -----------------------------
> Johnny Withers
> 601.209.4985
> johnny@stripped
>
--
Ohio State University - Finance
248 Fisher Hall
2100 Neil Ave.
Columbus, Ohio 43210
Telephone: 614-292-2979
http://www.fisher.osu.edu/~chen_1002/
