Re: Could somebody tell me how to get the time of a database?
I mean database,not table. thank you all the same. On Mon, May 12, 2008 at 1:55 PM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: show table status; On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED] wrote: I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Could somebody tell me how to get the time of a database?
Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- Iñigo Medina García Librería Díaz de Santos Madrid (Spain) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could somebody tell me how to get the time of a database?
Thanks for your reply very much. I know this way. Could you know how to get this just by sql? On Mon, May 12, 2008 at 2:57 PM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- Iñigo Medina García Librería Díaz de Santos Madrid (Spain) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn
Re: Could somebody tell me how to get the time of a database?
Thanks for your reply very much. I know this way. :-) Could you know how to get this just by sql? Mmmhh, no idea right now. I think unless you logged the CREATE DATABASE I don't think the creation date is stored anywhere. Anybody could check that? Iñigo On Mon, May 12, 2008 at 2:57 PM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- Iñigo Medina García Librería Díaz de Santos Madrid (Spain) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Iñigo Medina García Librería Díaz de Santos Madrid (Spain) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could somebody tell me how to get the time of a database?
show table status; On Mon, May 12, 2008 at 11:19 AM, Moon's Father [EMAIL PROTECTED] wrote: I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]