[Phpmyadmin-git] [SCM] phpMyAdmin branch, master, updated. RELEASE_3_3_2RC1-1405-g5309444
The branch, master has been updated via 5309444bba069bab9e744dd4a42d329bd1e54169 (commit) from a4c00596fc16f51e4fbc20ddf00220253d1fad8f (commit) - Log ----------------------------------------------------------------- commit 5309444bba069bab9e744dd4a42d329bd1e54169 Author: Michal Čihař <mcihar@novell.com> Date: Fri Apr 9 14:59:53 2010 +0200 EOL / EOF cleanup (bug #2983922). ----------------------------------------------------------------------- Summary of changes: documentation-gsoc/Synchronization_User_Manual.htm | 714 ++++++++++---------- pmd/scripts/ajax.js | 2 +- pmd/styles/default/style1.css | 2 +- print.css | 2 +- robots.txt | 4 +- 5 files changed, 362 insertions(+), 362 deletions(-) diff --git a/documentation-gsoc/Synchronization_User_Manual.htm b/documentation-gsoc/Synchronization_User_Manual.htm index 1e49d7f..840a25f 100644 --- a/documentation-gsoc/Synchronization_User_Manual.htm +++ b/documentation-gsoc/Synchronization_User_Manual.htm @@ -1,357 +1,357 @@ -<html> - -<head> -<meta http-equiv=Content-Type content="text/html; charset=windows-1252"> -<meta name=Generator content="Microsoft Word 11 (filtered)"> -<title> �Synchronize� feature in </title> -<style> -<!-- - /* Font Definitions */ - @font-face - {font-family:Tahoma; - panose-1:2 11 6 4 3 5 4 4 2 4;} -@font-face - {font-family:Cambria; - panose-1:2 4 5 3 5 4 6 3 2 4;} -@font-face - {font-family:Calibri; - panose-1:2 15 5 2 2 2 4 3 2 4;} - /* Style Definitions */ - p.MsoNormal, li.MsoNormal, div.MsoNormal - {margin-top:0in; - margin-right:0in; - margin-bottom:10.0pt; - margin-left:0in; - line-height:115%; - font-size:11.0pt; - font-family:Calibri;} -h1 - {margin-top:24.0pt; - margin-right:0in; - margin-bottom:0in; - margin-left:0in; - margin-bottom:.0001pt; - line-height:115%; - page-break-after:avoid; - font-size:14.0pt; - font-family:Cambria; - color:#365F91;} -h2 - {margin-top:10.0pt; - margin-right:0in; - margin-bottom:0in; - margin-left:0in; - margin-bottom:.0001pt; - line-height:115%; - page-break-after:avoid; - font-size:13.0pt; - font-family:Cambria; - color:#4F81BD;} -h3 - {margin-right:0in; - margin-left:0in; - font-size:13.5pt; - font-family:"Times New Roman";} -strong - {font-family:"Times New Roman";} -p.MsoAcetate, li.MsoAcetate, div.MsoAcetate - {margin:0in; - margin-bottom:.0001pt; - font-size:8.0pt; - font-family:Tahoma;} -span.Heading3Char - {font-family:"Times New Roman"; - font-weight:bold;} -span.BalloonTextChar - {font-family:Tahoma;} -span.Heading1Char - {font-family:Cambria; - color:#365F91; - font-weight:bold;} -p.NoSpacing, li.NoSpacing, div.NoSpacing - {margin:0in; - margin-bottom:.0001pt; - font-size:11.0pt; - font-family:Calibri;} -span.IntenseEmphasis - {font-family:"Times New Roman"; - color:#4F81BD; - font-weight:bold; - font-style:italic;} -span.Heading2Char - {font-family:Cambria; - color:#4F81BD; - font-weight:bold;} -@page Section1 - {size:8.5in 11.0in; - margin:1.0in 1.0in 1.0in 1.0in;} -div.Section1 - {page:Section1;} ---> -</style> - -</head> - -<body lang=EN-US> - -<div class=Section1> - -<p class=MsoNormal><b><span style='font-size:13.0pt;line-height:115%; -font-family:Cambria;color:#4F81BD'><img width=22 height=21 id="Picture 45" -src="Synchronization_User_Manual_files/image001.jpg" -alt=""></span></b><span -class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>��Synchronize�</span></span> -feature in <img width=134 height=23 id="Picture 44" -src="Synchronization_User_Manual_files/image002.gif" -alt=""></p> - -This feature is helpful for developers who need to replicate their databases� structure as well as data. -Moreover, this feature not only helps replication but also facilitates the user to keep his/her database in sync with another database. Other than the full database, certain tables of the databases can also be synchronized. - -<h3><span class=IntenseEmphasis><span style='font-size:12.0pt;font-weight:normal; -font-style:normal'><strong>How to Synchronize:</strong></span></span></h3> -The synchronize tab is visible upfront in the right pane, the last link on the top of the home page. - -<p class=MsoNormal><img width=682 height=421 id="Picture 1" -src="Synchronization_User_Manual_files/image003.gif"></p> - -<p class=MsoNormal>Press on the Synchronize tab and a form will be displayed.</p> - -<p class=MsoNormal><img width=666 height=398 id="Picture 46" -src="Synchronization_User_Manual_files/image004.jpg"></p> -<p class=MsoNormal>�<span -class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>Db Authentication Form?</span></span></p> -<p class=MsoNormal> You need to fill in the host name of the server, the -username and password of an user account already there in MySQL. Port is by default populated with 3306 (MySQL default port). Then the name of the -database should be mentioned at the end.All the information other than the port needs to be filled explicitly for the source as well as target servers.</p> - -<p class=MsoNormal>A filled form is displayed underneath:</p> - -<p class=MsoNormal><img width=653 height=394 id="Picture 7" -src="Synchronization_User_Manual_files/image005.jpg"><span -class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>�</span></span></p> -<p class=MsoNormal><span -class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>Invalid entries - during DB Authentication:</span></span></p> -<p class=MsoNormal>The user will not be allowed to by pass this page if any of -the values like Host name, Username and Database name remain unfilled and the -user presses �Go� button. An alert� would occur as follows, not allowing the user to -move to the next page. On the other hand, the password field can remain empty. -</p> - -<p class=MsoNormal><img width=640 height=384 id="Picture 10" -src="Synchronization_User_Manual_files/image006.jpg"></p> - -<p class=MsoNormal>If any wrong information is provided by the user like wrong -password, username or hostname then the connection is not established with the -corresponding database and an error message is seen as follows.</p> - -<p class=MsoNormal><img width=653 height=394 id="Picture 13" -src="Synchronization_User_Manual_files/image007.jpg"></p> - -<p class=MsoNormal>If the user enters a database name that does not exist, then -even an error message occurs as follows and the user needs to re-enter all the -information.</p> - -<p class=MsoNormal><img width=653 height=391 id="Picture 16" -src="Synchronization_User_Manual_files/image008.jpg"></p> - -<p class=MsoNormal></p> - -<h2>After passing DB Authentication:</h2> - -<p class=MsoNormal>After successfully by passing authentication phase, the source and -target database table names will be displayed. It will be a tabular -representation like this.</p> - -<p class=MsoNormal><img width=614 height=368 id="Picture 19" -src="Synchronization_User_Manual_files/image009.jpg"></p> - -<h2>Left Column:�Source Database�</h2> - -<p class=MsoNormal>On the left, are listed the source database table names.� -Some of the names have a �+� plus sign preceding them. This shows that these -tables are only present in source database and they need to be added to the -target database in order to synchronize the target database.While those table name that are not preceded by a �+� sign -are also present in target database.</p> - -<h2>�Middle Column:�Difference�</h2> -The column in the middle shows the difference between the source and target corresponding tables.The difference is depicted by the red and green buttons. - -<p class=MsoNormal><img width=35 height=35 id="Picture 26" -src="Synchronization_User_Manual_files/image010.gif" -alt="">The -presence of this button against any source table name shows that there is a -structure difference between the corresponding source and the target tables. If -at the same time, the source table name is preceded by a �+�plus, then the -presence of this button shows that the table needs to be created in target -database.� </p> - -<p class=MsoNormal><img width=35 height=35 id="Picture 24" -src="Synchronization_User_Manual_files/image011.jpg" -alt="">�The -presence of this button against any source table name shows that there is a -data difference between the corresponding source and target table. If at the -same time, the source table name is preceded by a �+�plus, then the presence of -this button shows that the table needs to be created and populated in target -database.� </p> - -<p class=MsoNormal> </p> - -<p class=MsoNormal><img width=33 height=31 id="Picture 27" -src="Synchronization_User_Manual_files/image012.jpg" -alt="">�After -clicking the red button with S printed on, it turns to grey showing that the structure difference -of that particular table has been selected by the user.</p> - -<p class=MsoNormal><img width=33 height=31 id="Picture 25" -src="Synchronization_User_Manual_files/image013.jpg" -alt="">�After -clicking the red button with a D printed on, it turns to grey showing that the data difference of -that particular table has been selected by the user.</p> - -<h2>Right Column: �Target Database�</h2> - -<p class=MsoNormal>On the right, are listed the target database table names. -There are few table names that have �(not present)� appended after their names. -This means that these tables are to be created in target database in order to -synchronize target database with source database. Some tables� names have a �-� -minus sign preceding them. This shows that these tables are only present in -target database and they will remain unchanged in the target database. </p> - -<p class=MsoNormal>While those table names that are not preceded by any sign, -or do not have �(not present)� appended after them are already synchronized.</p> - -<p class=MsoNormal><img width=678 height=408 id="Picture 28" -src="Synchronization_User_Manual_files/image014.jpg"></p> - -<h2>Detailed Difference Table:</h2> - -<p class=MsoNormal>�The above view shows that for those tables whose structure -or data differences have been selected (depicted by grey buttons <img width=18 -height=17 src="Synchronization_User_Manual_files/image015.jpg" -alt="">�or -<img width=17 height=16 src="Synchronization_User_Manual_files/image016.jpg" -alt="">),� -there exists a description in the second table underneath the table showing -source and target database table names.� The description becomes visible only -when a red or green button against any table is pressed.</p> - -<h2>Table:</h2> - -<p class=MsoNormal>Displays the <b>Table Name</b> column only to show the name -of the table.</p> - -<h2>Structure Difference:</h2> - -<p class=MsoNormal>�It elaborates the difference in structure like</p> - -<p class=MsoNormal><b>Create Table: </b>When the table needs to be created in -the target database, then only a <img width=16 height=16 id="Picture 31" -src="Synchronization_User_Manual_files/image017.gif" -alt="">�tick is -seen in the create table column of the description table.� </p> - -<p class=MsoNormal><b>Add Column(s):</b>� Shows the number of columns to be -added.</p> - -<p class=MsoNormal><b>Remove Column(s):</b> Shows the number of columns to be -removed.</p> - -<p class=MsoNormal><b>Alter Column(s):� </b>Shows the number of columns to be -altered.</p> - -<p class=MsoNormal><b>Apply Index(s): </b>�Shows the number of indexes to be -applied.</p> - -<p class=MsoNormal><b>Remove Index(s):</b>� Shows the number of indexes to be -removed.</p> - -<h2>Data Difference:</h2> - -<p class=MsoNormal>It elaborates the difference in data like </p> - -<p class=MsoNormal><b>Update Row(s):</b> Shows the number of rows to be -updated.</p> - -<p class=MsoNormal><b>Insert Row(s): </b>Shows the number of rows to be -inserted. </p> - -<p class=MsoNormal>When the selected buttons (depicted by grey buttons <img -width=18 height=17 src="Synchronization_User_Manual_files/image015.jpg" -alt="">�or<img -width=17 height=16 src="Synchronization_User_Manual_files/image016.jpg" -alt="">) -are pressed again, the buttons become deselected (depicted by colored buttons <img -width=23 height=23 src="Synchronization_User_Manual_files/image019.jpg" -alt="">�or<img -width=23 height=23 src="Synchronization_User_Manual_files/image020.jpg" -alt="">) and the -description from the second table regarding those table has been removed.</p> - -<h2><span style='font-weight:normal'><img width=666 height=416 id="Picture 41" -src="Synchronization_User_Manual_files/image021.jpg"></span></h2> - -<h2>Check Box in Footer:</h2> - -<p class=MsoNormal>A checkbox is also visible in the above view. It has a �<b>Would -you like to delete all the previous rows from the target tables?</b>�</p> - -<p class=MsoNormal>By checking this check box, the user assures the deletion of -any previous rows residing in the target tables that are to be synchronized. -This means that before any value gets inserted or updated in the target tables, -any previously residing rows will be deleted.</p> - -<h2>Apply Selected Changes Button in Footer: </h2> - -<p class=MsoNormal>The �Apply Selected Changes� button, as it is clear from the -name, applies only selected tables� changes i.e. it allows user to synchronize -selective tables between the source and the target databases.</p> - -<p class=MsoNormal>After pressing �Apply Selected Changes� button, the view -becomes� </p> - -<p class=MsoNormal><img width=666 height=401 id="Picture 35" -src="Synchronization_User_Manual_files/image022.jpg"></p> - -<p class=MsoNormal>The �course� table in the above view, now only shows data -difference depicted by<img width=23 height=23 -src="Synchronization_User_Manual_files/image020.jpg" -alt="">. This -shows that the previously selected structure difference in that table has been -applied in target database table �course� because we pressed the �Apply -Selected Changes� button after selection. </p> - -<p class=MsoNormal>�Apply Selected Changes� button allows the user to synchronize -tables� data and structure according to his/her requirement or desire.</p> - -<p class=MsoNormal>Whenever �Apply Selected Changes� button is pressed and the -page is reloaded, the checkbox becomes unchecked. This means that the user gets -a choice to delete the previous rows of a certain set of tables and not from -all the tables. </p> - -<h2>Synchronize databases button in Footer:</h2> - -<p class=MsoNormal>�Synchronize databases� button in the footer completely -synchronizes the target database with the source database irrespective of which -tables are selected for which type of synchronization.</p> - -<p class=MsoNormal>��Synchronize databases� button if pressed after �Apply -Selected Changes� button has been pressed once or twice or several times, will -apply all the remaining changes that have not been selected earlier.</p> - -<p class=MsoNormal>The view after �Synchronize databases� button has been -pressed look like this:</p> - -<p class=MsoNormal><img width=666 height=399 id="Picture 49" -src="Synchronization_User_Manual_files/image023.jpg"></p> - -<p class=MsoNormal>The lower half of the page displays the list of queries that -have been executed in order to synchronize the databases while the upper half -displays the source and target database table names.</p> - -</div> - -</body> - -</html> +<html> + +<head> +<meta http-equiv=Content-Type content="text/html; charset=windows-1252"> +<meta name=Generator content="Microsoft Word 11 (filtered)"> +<title> �Synchronize� feature in </title> +<style> +<!-- + /* Font Definitions */ + @font-face + {font-family:Tahoma; + panose-1:2 11 6 4 3 5 4 4 2 4;} +@font-face + {font-family:Cambria; + panose-1:2 4 5 3 5 4 6 3 2 4;} +@font-face + {font-family:Calibri; + panose-1:2 15 5 2 2 2 4 3 2 4;} + /* Style Definitions */ + p.MsoNormal, li.MsoNormal, div.MsoNormal + {margin-top:0in; + margin-right:0in; + margin-bottom:10.0pt; + margin-left:0in; + line-height:115%; + font-size:11.0pt; + font-family:Calibri;} +h1 + {margin-top:24.0pt; + margin-right:0in; + margin-bottom:0in; + margin-left:0in; + margin-bottom:.0001pt; + line-height:115%; + page-break-after:avoid; + font-size:14.0pt; + font-family:Cambria; + color:#365F91;} +h2 + {margin-top:10.0pt; + margin-right:0in; + margin-bottom:0in; + margin-left:0in; + margin-bottom:.0001pt; + line-height:115%; + page-break-after:avoid; + font-size:13.0pt; + font-family:Cambria; + color:#4F81BD;} +h3 + {margin-right:0in; + margin-left:0in; + font-size:13.5pt; + font-family:"Times New Roman";} +strong + {font-family:"Times New Roman";} +p.MsoAcetate, li.MsoAcetate, div.MsoAcetate + {margin:0in; + margin-bottom:.0001pt; + font-size:8.0pt; + font-family:Tahoma;} +span.Heading3Char + {font-family:"Times New Roman"; + font-weight:bold;} +span.BalloonTextChar + {font-family:Tahoma;} +span.Heading1Char + {font-family:Cambria; + color:#365F91; + font-weight:bold;} +p.NoSpacing, li.NoSpacing, div.NoSpacing + {margin:0in; + margin-bottom:.0001pt; + font-size:11.0pt; + font-family:Calibri;} +span.IntenseEmphasis + {font-family:"Times New Roman"; + color:#4F81BD; + font-weight:bold; + font-style:italic;} +span.Heading2Char + {font-family:Cambria; + color:#4F81BD; + font-weight:bold;} +@page Section1 + {size:8.5in 11.0in; + margin:1.0in 1.0in 1.0in 1.0in;} +div.Section1 + {page:Section1;} +--> +</style> + +</head> + +<body lang=EN-US> + +<div class=Section1> + +<p class=MsoNormal><b><span style='font-size:13.0pt;line-height:115%; +font-family:Cambria;color:#4F81BD'><img width=22 height=21 id="Picture 45" +src="Synchronization_User_Manual_files/image001.jpg" +alt=""></span></b><span +class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>��Synchronize�</span></span> +feature in <img width=134 height=23 id="Picture 44" +src="Synchronization_User_Manual_files/image002.gif" +alt=""></p> + +This feature is helpful for developers who need to replicate their databases� structure as well as data. +Moreover, this feature not only helps replication but also facilitates the user to keep his/her database in sync with another database. Other than the full database, certain tables of the databases can also be synchronized. + +<h3><span class=IntenseEmphasis><span style='font-size:12.0pt;font-weight:normal; +font-style:normal'><strong>How to Synchronize:</strong></span></span></h3> +The synchronize tab is visible upfront in the right pane, the last link on the top of the home page. + +<p class=MsoNormal><img width=682 height=421 id="Picture 1" +src="Synchronization_User_Manual_files/image003.gif"></p> + +<p class=MsoNormal>Press on the Synchronize tab and a form will be displayed.</p> + +<p class=MsoNormal><img width=666 height=398 id="Picture 46" +src="Synchronization_User_Manual_files/image004.jpg"></p> +<p class=MsoNormal>�<span +class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>Db Authentication Form?</span></span></p> +<p class=MsoNormal> You need to fill in the host name of the server, the +username and password of an user account already there in MySQL. Port is by default populated with 3306 (MySQL default port). Then the name of the +database should be mentioned at the end.All the information other than the port needs to be filled explicitly for the source as well as target servers.</p> + +<p class=MsoNormal>A filled form is displayed underneath:</p> + +<p class=MsoNormal><img width=653 height=394 id="Picture 7" +src="Synchronization_User_Manual_files/image005.jpg"><span +class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>�</span></span></p> +<p class=MsoNormal><span +class=Heading2Char><span style='font-size:13.0pt;line-height:115%'>Invalid entries + during DB Authentication:</span></span></p> +<p class=MsoNormal>The user will not be allowed to by pass this page if any of +the values like Host name, Username and Database name remain unfilled and the +user presses �Go� button. An alert� would occur as follows, not allowing the user to +move to the next page. On the other hand, the password field can remain empty. +</p> + +<p class=MsoNormal><img width=640 height=384 id="Picture 10" +src="Synchronization_User_Manual_files/image006.jpg"></p> + +<p class=MsoNormal>If any wrong information is provided by the user like wrong +password, username or hostname then the connection is not established with the +corresponding database and an error message is seen as follows.</p> + +<p class=MsoNormal><img width=653 height=394 id="Picture 13" +src="Synchronization_User_Manual_files/image007.jpg"></p> + +<p class=MsoNormal>If the user enters a database name that does not exist, then +even an error message occurs as follows and the user needs to re-enter all the +information.</p> + +<p class=MsoNormal><img width=653 height=391 id="Picture 16" +src="Synchronization_User_Manual_files/image008.jpg"></p> + +<p class=MsoNormal></p> + +<h2>After passing DB Authentication:</h2> + +<p class=MsoNormal>After successfully by passing authentication phase, the source and +target database table names will be displayed. It will be a tabular +representation like this.</p> + +<p class=MsoNormal><img width=614 height=368 id="Picture 19" +src="Synchronization_User_Manual_files/image009.jpg"></p> + +<h2>Left Column:�Source Database�</h2> + +<p class=MsoNormal>On the left, are listed the source database table names.� +Some of the names have a �+� plus sign preceding them. This shows that these +tables are only present in source database and they need to be added to the +target database in order to synchronize the target database.While those table name that are not preceded by a �+� sign +are also present in target database.</p> + +<h2>�Middle Column:�Difference�</h2> +The column in the middle shows the difference between the source and target corresponding tables.The difference is depicted by the red and green buttons. + +<p class=MsoNormal><img width=35 height=35 id="Picture 26" +src="Synchronization_User_Manual_files/image010.gif" +alt="">The +presence of this button against any source table name shows that there is a +structure difference between the corresponding source and the target tables. If +at the same time, the source table name is preceded by a �+�plus, then the +presence of this button shows that the table needs to be created in target +database.� </p> + +<p class=MsoNormal><img width=35 height=35 id="Picture 24" +src="Synchronization_User_Manual_files/image011.jpg" +alt="">�The +presence of this button against any source table name shows that there is a +data difference between the corresponding source and target table. If at the +same time, the source table name is preceded by a �+�plus, then the presence of +this button shows that the table needs to be created and populated in target +database.� </p> + +<p class=MsoNormal> </p> + +<p class=MsoNormal><img width=33 height=31 id="Picture 27" +src="Synchronization_User_Manual_files/image012.jpg" +alt="">�After +clicking the red button with S printed on, it turns to grey showing that the structure difference +of that particular table has been selected by the user.</p> + +<p class=MsoNormal><img width=33 height=31 id="Picture 25" +src="Synchronization_User_Manual_files/image013.jpg" +alt="">�After +clicking the red button with a D printed on, it turns to grey showing that the data difference of +that particular table has been selected by the user.</p> + +<h2>Right Column: �Target Database�</h2> + +<p class=MsoNormal>On the right, are listed the target database table names. +There are few table names that have �(not present)� appended after their names. +This means that these tables are to be created in target database in order to +synchronize target database with source database. Some tables� names have a �-� +minus sign preceding them. This shows that these tables are only present in +target database and they will remain unchanged in the target database. </p> + +<p class=MsoNormal>While those table names that are not preceded by any sign, +or do not have �(not present)� appended after them are already synchronized.</p> + +<p class=MsoNormal><img width=678 height=408 id="Picture 28" +src="Synchronization_User_Manual_files/image014.jpg"></p> + +<h2>Detailed Difference Table:</h2> + +<p class=MsoNormal>�The above view shows that for those tables whose structure +or data differences have been selected (depicted by grey buttons <img width=18 +height=17 src="Synchronization_User_Manual_files/image015.jpg" +alt="">�or +<img width=17 height=16 src="Synchronization_User_Manual_files/image016.jpg" +alt="">),� +there exists a description in the second table underneath the table showing +source and target database table names.� The description becomes visible only +when a red or green button against any table is pressed.</p> + +<h2>Table:</h2> + +<p class=MsoNormal>Displays the <b>Table Name</b> column only to show the name +of the table.</p> + +<h2>Structure Difference:</h2> + +<p class=MsoNormal>�It elaborates the difference in structure like</p> + +<p class=MsoNormal><b>Create Table: </b>When the table needs to be created in +the target database, then only a <img width=16 height=16 id="Picture 31" +src="Synchronization_User_Manual_files/image017.gif" +alt="">�tick is +seen in the create table column of the description table.� </p> + +<p class=MsoNormal><b>Add Column(s):</b>� Shows the number of columns to be +added.</p> + +<p class=MsoNormal><b>Remove Column(s):</b> Shows the number of columns to be +removed.</p> + +<p class=MsoNormal><b>Alter Column(s):� </b>Shows the number of columns to be +altered.</p> + +<p class=MsoNormal><b>Apply Index(s): </b>�Shows the number of indexes to be +applied.</p> + +<p class=MsoNormal><b>Remove Index(s):</b>� Shows the number of indexes to be +removed.</p> + +<h2>Data Difference:</h2> + +<p class=MsoNormal>It elaborates the difference in data like </p> + +<p class=MsoNormal><b>Update Row(s):</b> Shows the number of rows to be +updated.</p> + +<p class=MsoNormal><b>Insert Row(s): </b>Shows the number of rows to be +inserted. </p> + +<p class=MsoNormal>When the selected buttons (depicted by grey buttons <img +width=18 height=17 src="Synchronization_User_Manual_files/image015.jpg" +alt="">�or<img +width=17 height=16 src="Synchronization_User_Manual_files/image016.jpg" +alt="">) +are pressed again, the buttons become deselected (depicted by colored buttons <img +width=23 height=23 src="Synchronization_User_Manual_files/image019.jpg" +alt="">�or<img +width=23 height=23 src="Synchronization_User_Manual_files/image020.jpg" +alt="">) and the +description from the second table regarding those table has been removed.</p> + +<h2><span style='font-weight:normal'><img width=666 height=416 id="Picture 41" +src="Synchronization_User_Manual_files/image021.jpg"></span></h2> + +<h2>Check Box in Footer:</h2> + +<p class=MsoNormal>A checkbox is also visible in the above view. It has a �<b>Would +you like to delete all the previous rows from the target tables?</b>�</p> + +<p class=MsoNormal>By checking this check box, the user assures the deletion of +any previous rows residing in the target tables that are to be synchronized. +This means that before any value gets inserted or updated in the target tables, +any previously residing rows will be deleted.</p> + +<h2>Apply Selected Changes Button in Footer: </h2> + +<p class=MsoNormal>The �Apply Selected Changes� button, as it is clear from the +name, applies only selected tables� changes i.e. it allows user to synchronize +selective tables between the source and the target databases.</p> + +<p class=MsoNormal>After pressing �Apply Selected Changes� button, the view +becomes� </p> + +<p class=MsoNormal><img width=666 height=401 id="Picture 35" +src="Synchronization_User_Manual_files/image022.jpg"></p> + +<p class=MsoNormal>The �course� table in the above view, now only shows data +difference depicted by<img width=23 height=23 +src="Synchronization_User_Manual_files/image020.jpg" +alt="">. This +shows that the previously selected structure difference in that table has been +applied in target database table �course� because we pressed the �Apply +Selected Changes� button after selection. </p> + +<p class=MsoNormal>�Apply Selected Changes� button allows the user to synchronize +tables� data and structure according to his/her requirement or desire.</p> + +<p class=MsoNormal>Whenever �Apply Selected Changes� button is pressed and the +page is reloaded, the checkbox becomes unchecked. This means that the user gets +a choice to delete the previous rows of a certain set of tables and not from +all the tables. </p> + +<h2>Synchronize databases button in Footer:</h2> + +<p class=MsoNormal>�Synchronize databases� button in the footer completely +synchronizes the target database with the source database irrespective of which +tables are selected for which type of synchronization.</p> + +<p class=MsoNormal>��Synchronize databases� button if pressed after �Apply +Selected Changes� button has been pressed once or twice or several times, will +apply all the remaining changes that have not been selected earlier.</p> + +<p class=MsoNormal>The view after �Synchronize databases� button has been +pressed look like this:</p> + +<p class=MsoNormal><img width=666 height=399 id="Picture 49" +src="Synchronization_User_Manual_files/image023.jpg"></p> + +<p class=MsoNormal>The lower half of the page displays the list of queries that +have been executed in order to synchronize the databases while the upper half +displays the source and target database table names.</p> + +</div> + +</body> + +</html> diff --git a/pmd/scripts/ajax.js b/pmd/scripts/ajax.js index 0f47bab..ffaea81 100644 --- a/pmd/scripts/ajax.js +++ b/pmd/scripts/ajax.js @@ -131,4 +131,4 @@ function PrintXML() } } } -} \ No newline at end of file +} diff --git a/pmd/styles/default/style1.css b/pmd/styles/default/style1.css index ff6e48f..b4f7ec3 100644 --- a/pmd/styles/default/style1.css +++ b/pmd/styles/default/style1.css @@ -377,4 +377,4 @@ a.M_butt:hover { cursor: nw-resize; width: 16px; height: 16px; -} \ No newline at end of file +} diff --git a/print.css b/print.css index 54543dc..632a755 100644 --- a/print.css +++ b/print.css @@ -66,4 +66,4 @@ th { font-weight: bold; background-color: #e5e5e5; } -} \ No newline at end of file +} diff --git a/robots.txt b/robots.txt index c2aab7e..1f53798 100644 --- a/robots.txt +++ b/robots.txt @@ -1,2 +1,2 @@ -User-agent: * -Disallow: / \ No newline at end of file +User-agent: * +Disallow: / hooks/post-receive -- phpMyAdmin
participants (1)
-
Michal Čihař