On Wed, 30 Jul 2003, Paul DuBois wrote: > > What I'd do if it were me in your situation: > > - Remove the innodb_data_file_path line from your my.cnf file
done > - Restart the server; it should come up normally now done > - Perform a complete dump of all your databases (just in case) > (use mysqldump) done > - Perform a complete dump of your InnoDB tables > (use mysqldump) how do I do this ? this is where I am stuck > - Remove your InnoDB tables > - Shut down the server > - Remove the default InnoDB data file and log files (these will > be the files that begin with "ib" in your data directory) > - Shut down the server > - Add the innodb_data_file_path line to your my.cnf file > - Start the server > - Load the dump file back into the server to recreate your InnoDB > tables > > > > >Thanks > > > >-- > >Asif Iqbal > >http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 > >There's no place like 127.0.0.1 > > > -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]