Re: Create and Restore

[Umesh Shastry]

Doug,

nope, mysql (C:\Program Files\MySQL Server 4.1\bin>mysql -uroot -pxxxxx Online_Store < db_store-20051004022039.sql) command won't add any such features it simply runs the query instead you can play with mysqldump utility when taking dump by adding options

mysqldump has several options that makes the update/dump very faster, when taking database dump you include the --opt option which give you a fast dump operation and produce a dump file that can be reloaded into a MySQL server quickly, at the same time if you have to update/dump only data then you can also include the -t(no database structure creation info) option so that it will only dump data.

Pls go thru this mysqldump utility..

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221