synchronize database structure

2001-05-25 Thread Dorthe Luebbert
Hi, I am looking for an easy way to synchronize two mysql-databases (only the sql-structure). I want to compare two structure dumps, find out the differences and get alter table statements as result. CU Dorthe - Before postin

Wanted: Convert Mysql-Logfile to Plain SQL

2001-05-25 Thread Dorthe Luebbert
Hi, I am looking for a script that reads a mysql-logfile, removes all non-sql-stuff (like the DB-INIT-Number) and creates a sql-file from it. The perfect tool could handle different databases stored in the mysql-logfile. It seems not to be that problem to write a perl-script on myself but I don'

Unlock table without restarting

2001-02-19 Thread Dorthe Luebbert
Hi, how can I unlock a table/process with mysqladmin etc. without restarting the server? Thanx Dorthe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the