Hi, All MySQL server installations ships with some client tools. Try executing the following statement on your server
mysqldump -uUSERNAME -p DATABASENAME > dump.sql After this operation "dump.sql" will include all information needed. The information can be loaded into another server issuing the following command mysql -uUSERNAME -p DATABASENAME < dump.sql (the option -p makes the client ask for the password for the user USERNAME) kostas -----Ursprüngliche Nachricht----- Von: Nathan Coast [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 6. November 2004 03:40 An: [EMAIL PROTECTED] Betreff: extracting ddl Hi, is it possible to extract the ddl for a table or whole db? ie the ddl that would be needed to re-create that table. JBoss automatically creates some tables during ejb deployment and I want to move this to a manual process. cheers Nathan -- Nathan Coast Managing Director codeczar ltd mobile: (852) 9049 5581 email: mailto:[EMAIL PROTECTED] web: http://www.codeczar.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
