> > -- > help please > > please tell me how to extract a script file of a database from mysql commandprompt. > > s.deepak > > > This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger > > Swami Vivekananda >
Are you looking for mysqldump?? If you want to produce a dump file of a table: mysqldump -u yourusername -p --add-drop-table dbname tablename > tablename.sql to do the whole database: mysqldump -u yourusername -p --add-drop-table dbname > dbname.sql also do "man mysqldump" or see http://dev.mysql.com/doc/mysql/en/mysqldump.html The "--add-drop-table" will add a "DROP TABLE IF EXISTS tablename" to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
