If you use default configuration (meaning all innodb data in one idata file) you just deleted your data. If you have a recent dump, drop all innodb tables and use the dump to restore
On 8/24/07 3:20 PM, "Adriano Ceccarelli" <[EMAIL PROTECTED]> wrote: > Hi, > > I removed accidentaly the files : > /var/lib/mysql/ibdata1 > /var/lib/mysql/ib_logfile0 > /var/lib/mysql/ib_logfile1 > > how can I remover them from data files > > note >> show tables > list all tables OK > >> desc wiki_text > ERROR 1146 (42S02): Table 'intranet.wiki_text' doesn't exist > this erro in all tables type innodb > > > # ls -la /var/lib/mysql/intranet/ > list all files .frm OK > > > > thanks > Adriano -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
