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
4282
October 19, 2005 01:03AM
2927
October 20, 2005 07:59AM
2648
October 21, 2005 05:31AM
2931
October 21, 2005 05:39AM
2579
October 21, 2005 05:43AM
2808
October 21, 2005 07:33AM
2672
October 21, 2005 07:39AM
2604
October 21, 2005 07:45AM
2554
October 21, 2005 07:49AM
2690
October 21, 2005 08:33AM
Re: Create and Restore
2835
October 21, 2005 09:30AM
2518
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.