עמוד:320
mysqldump -u root -X –p test > d : / friends . xml האפשרויות הכלולות בתכנית זו : – u root משתמש בשם root – p בקש סיסמה אחרי שלחמצו ENTER – test שם בסיס הנתונים – friends שם טבלה – friends . xml שם קובץ XML לסיום פתחו את קובץ friends . xml התבוננו בתוכנו . xml version = " 1 . 0 " ?> < field Field = "Name" Type = "varchar ( 20 ) " Null = "YES" Key = "" Extra = "" /> - < table–structure name = "friends" > - < database name = "test" > - < mysqldump xmlns : xsi = "http : // www . w 3 . org / 2001 / XMLSchema-instance" > table–structure > "" Comment = "InnoDB free : 11264 kB" /> Create–time = " 2009-02-03 14 : 17 : 33 " Collation = "utf 8–general–ci" Create–options = Avg–row–length = " 4096 " Data–length = " 16384 " Max–data–length = " 0 " Index–length = " 0 " Data–free = " 0 " < options Name = "friends" Engine = "InnoDB" Version = " 10 " Row–format = "Compact" Rows = " 4 " < field Field = "Sisma" Type = "varchar ( 10 ) " Null = "YES" Key = "" Extra = "" /> - < row > row > < field name = "Sisma" > 1234 field > < field name = "Name" > Noa field > - < row > - < table–data name = "friends" > < field name = "Sisma" > nadavKampf field > < field name = "Name" > Nadav field > - < row > row > < field name = "Sisma" > 3424 field > < field name = "Name" > Adi field >
|