MySQL Forums
Forum List  »  Backup

Re: Create and Restore
Posted by: Umesh Shastry
Date: October 21, 2005 09:30AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
4242
October 19, 2005 01:03AM
2895
October 20, 2005 07:59AM
2624
October 21, 2005 05:31AM
2908
October 21, 2005 05:39AM
2561
October 21, 2005 05:43AM
2784
October 21, 2005 07:33AM
2644
October 21, 2005 07:39AM
2579
October 21, 2005 07:45AM
2531
October 21, 2005 07:49AM
2670
October 21, 2005 08:33AM
Re: Create and Restore
2809
October 21, 2005 09:30AM
2498
November 24, 2005 10:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.