I do have a backup of the original log files from the original server. When the InnoDB tables weren't working, I took the old ibdata1 file and uploaded it to the new server. That fixed a portion of the problem, but not everything.
Things are being done too inconsistently. If you want to download the files via sftp, login to mysql first and lock all tables as mentioned in the previous email. You'll want to download everything, including the innodb transaction logs, innodb data files (ibdata* if using default naming), and the actual database directories.
The ideal solution would be to take a mysqldump. You can actually do that through phpmyadmin.
If binary logging is enabled, you don't need to download those. -Matt _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
