Re: Copying InnoDB files to remote server - remote server won't start

2007-09-12 Thread Baron Schwartz
Whil Hentzen wrote: Baron Schwartz wrote: Whil Hentzen wrote: Michael Dykman wrote: if you see no errors, check your config... are you sure InnoDB is enabled ? I can create a new database and add InnoDB tables to it without problems. Ack, I lied. No error in the /var/lib/mysql, but

Copying InnoDB files to remote server - remote server won't start

2007-09-11 Thread Whil Hentzen
Hi gang, After reading through two years of 'how do I back up my database' threads, I'm trying out the various backup mechanisms offered up. I've read through these steps: http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html Running a local box and a remote box, both with Fedora 6,

Re: Copying InnoDB files to remote server - remote server won't start

2007-09-11 Thread Whil Hentzen
Michael Dykman wrote: if you see no errors, check your config... are you sure InnoDB is enabled ? I can create a new database and add InnoDB tables to it without problems. Ack, I lied. No error in the /var/lib/mysql, but there IS an error file in /var/logs, and it contains: ./ibdata1:

Re: Copying InnoDB files to remote server - remote server won't start

2007-09-11 Thread Baron Schwartz
Whil Hentzen wrote: Michael Dykman wrote: if you see no errors, check your config... are you sure InnoDB is enabled ? I can create a new database and add InnoDB tables to it without problems. Ack, I lied. No error in the /var/lib/mysql, but there IS an error file in /var/logs, and it

Re: Copying InnoDB files to remote server - remote server won't start

2007-09-11 Thread Whil Hentzen
Baron Schwartz wrote: Whil Hentzen wrote: Michael Dykman wrote: if you see no errors, check your config... are you sure InnoDB is enabled ? I can create a new database and add InnoDB tables to it without problems. Ack, I lied. No error in the /var/lib/mysql, but there IS an error file in