tag:blogger.com,1999:blog-69857425846732007912024-03-05T11:28:25.834-08:00What is MySQL , phpMyAdmin , MySQL commands , MySQL ServerAnonymoushttp://www.blogger.com/profile/09800365369089065223noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-6985742584673200791.post-736616290665857532013-09-09T09:51:00.000-07:002013-11-14T22:33:20.324-08:00Making Slave MySQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Making
Slave MySQL Server</span></b><br />
<div class="separator" style="clear: both; text-align: center;">
<b style="mso-bidi-font-weight: normal;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkGz4vcU6Z-19lvbWl67MWw9Ev74kBwQ2XuQzJh1wZc02vehuxaijcTSO9E-HvVuTmqvYUR2u6oBs4JY2X2WwejeFxzgZffcRUOQHXNQhNZEq-oV2QwUJW_C-2s9NBtvd5xayv0soHL-o5/s1600/my.jpg" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkGz4vcU6Z-19lvbWl67MWw9Ev74kBwQ2XuQzJh1wZc02vehuxaijcTSO9E-HvVuTmqvYUR2u6oBs4JY2X2WwejeFxzgZffcRUOQHXNQhNZEq-oV2QwUJW_C-2s9NBtvd5xayv0soHL-o5/s1600/my.jpg" /></a></b></div>
<br />
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Setting up a
slave MySQL server is a very easy process, that is, if you are aware of the
actual commands and the medium which is required to execute the commands.<span style="mso-spacerun: yes;"> </span>MySQL server is used to run different
commands through a suitable medium for carrying out different actions that cannot
be done otherwise. These commands are also useful for keeping the data on your
computer secure. It is important to keep a proper back up of the precious data
your system is holding. By having a backup it will become easy to restore the
data at any required point. </span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">These
points are going to be helpful for those who are basically working from home
and are unaware of the importance of the fact, that how important it is to keep
a backup and your information protected. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Most
of the workplace computers have data backup options that help prevent
accidental loss of data. In case it is lost it can be recovered easily with the
help of different commands that are used to activate the backup. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">This
tells us that the importance of MySQL<span style="mso-spacerun: yes;">
</span>database is quite strong if you want to make sure that your data can be
transferred from one place to another in any event of loss.<span style="mso-spacerun: yes;"> </span>Workplace managers make sure, that their employees
are aware of the importance of the MySQL server and how it can save from a
great loss. </span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<br /></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<b><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Working
of salve MySQL server </span></b></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Slave MySQL
server enjoys considerable popularity in terms of functioning and user
reliability. But it is more important to know the actual functions of the
server and how it acts a major backup tool. One important question which might
come in the mind of several programmers is that, will this server serve as an
online backup tool or an offline backup tool. There is an option to choose
online medium or offline medium for the protection of data. Most of the users
adopt the online backup strategy in order to deal with any downtime
issues.<span style="mso-spacerun: yes;"> </span>There are several advantages of
an offline backup system as it offers less number of errors and there is no
need to worry about the running transactions, orphaned processes or table locks
or anything else that can create errors and disrupt the normal functioning. </span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<b><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Characteristics
of slave MySQL server</span></b></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-indent: -.25in;">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Those users
who can easily afford downtime and have slave replication then the offline
backup method is best for them. Database is created with the help of data dump
option that helps in several other processes. It can be regarded as an
expensive exercise but in the end all the efforts will be worth it. The size of
files will also get large when an additional SQL syntax is added. But this is
not a matter of concern as it does not harm the system or functioning of other
programs.<span style="mso-spacerun: yes;"> </span>It is important to know all of
the steps that are required to set up a Salve <b><a href="http://whatismysqlrf.blogspot.com/">MySQL server</a></b> , as<span style="mso-spacerun: yes;"> </span>a single command that is entered wrong will
disrupt the process of data migration.<span style="mso-spacerun: yes;"> </span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/09800365369089065223noreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-91533264263956788012013-09-09T09:50:00.000-07:002013-11-14T22:35:25.391-08:00Installing MySQL with Apache 2.x<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Installing MySQL with Apache 2.x</span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b style="mso-bidi-font-weight: normal;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbM0R_2guN7G0dibQzf2ydeEWmS-Qkmm-52Q3GTJd9ECn6iKg2RQgUf8nDu5plCdisyq-W0U54R00geCd6GAex970xnJAoJY4aNVobf-UziI5h2Vpc3x2ApDDoETIyOOjZpZ9BXTdjhDO0/s1600/pamp00.jpg" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbM0R_2guN7G0dibQzf2ydeEWmS-Qkmm-52Q3GTJd9ECn6iKg2RQgUf8nDu5plCdisyq-W0U54R00geCd6GAex970xnJAoJY4aNVobf-UziI5h2Vpc3x2ApDDoETIyOOjZpZ9BXTdjhDO0/s1600/pamp00.jpg" /></a></b></div>
<br />
<div class="MsoNormal">
<br />
<span style="font-size: 12.0pt; line-height: 115%;">For the sake
of local development and testing, Apache and MySQL are installed on the
computer windows in order to serve for various purposes. </span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Installing the latest apache series:</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">For
the installation of the latest Apache available few simple steps are followed.</span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">While
going to the official website of Apache one can search for the best available
version of Apache 2.x. One will encounter with the win file containing the
setup of Apache version. The version has to be further downloaded on the
computer. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Run
the file from the desired destination and keep on moving next until it asks
about the server information.</span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">In
server information, local host information has to be given while one can give
any email address when required for admin email. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Change
the name of the destination folder and keep on moving until the installation is
done.</span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">As
soon as the installation is complete, the file will start running on the
screen. A dos window might also open on the computer until the Apache is running
on the computer. </span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">The
next step is the creation of index.hmtl file that can be made with simple steps
and has to be saved in Apache folder. Once the file is saved open it for
display if the apache is running the step is successful otherwise repeat the
process.</span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Installing MySQL</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Go
to the official page of installing MySQL and scroll down to find the concerned
link. From link find the desired file and download it to the computer. </span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Unzip
the file to some folder and run the necessary setup from given destination.</span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">Once
the installation is complete, one has to create the username and password for
further proceedings.</span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-size: 12.0pt; line-height: 115%;">The
username and password can be modified with php later for further editing.</span><br />
</div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">MySQL and Apache:</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Apache helps
in running the various modules of the MySQL and if Apache fails to work with
the specific version that could result in using the previous MySQL libraries.
Recompiling of all modules using MySQL will be a better solution to the
problem. For the effective use of <a href="http://whatismysqlrf.blogspot.com/2013/09/importexport-mysql.html"><b>MySQL files</b></a> with apache one needs to
understand the importance of availing the options for authentication to apache.
There are many online packages available that provide the source that will be
helpful in upgrading the version of the program and further helps in verifying
the problems. These packages vary with the system it is designed for; from
Linux to the MAC system. The basic programs work for the installation of
various programs that requires the selected versions of MySQL and apache.
Failure in the coordination of the two files will result in the failure of the
installation. The settings stand for the security as well as requirements for
the concerned activity for the web server.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">In short
MySQL ad apache works in coordination with their related versions and provides
the database that has to be run in order to perform the specific function on
the computer. These stand for the efficient components on the web server.</span></div>
</div>
Anonymoushttp://www.blogger.com/profile/09800365369089065223noreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-21753943815449149142013-09-09T09:45:00.001-07:002013-11-14T22:36:31.141-08:00Import/Export MySQL<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Import/Export MySQL</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip0vEFUSQhB_HWOTMC8GfH41Wh7xpu9-MsRw7pnCIv6IPwIUv2brzEzp2b7oU2Mz8Iu-FHQ92xMskx_x_YlpBbuo2NNQOuEZmVB_TOCFoaq7iAITFauOlpBQoCDCcLY07H4wIIJBv1Qqwy/s1600/mysql-export-import.jpg" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEip0vEFUSQhB_HWOTMC8GfH41Wh7xpu9-MsRw7pnCIv6IPwIUv2brzEzp2b7oU2Mz8Iu-FHQ92xMskx_x_YlpBbuo2NNQOuEZmVB_TOCFoaq7iAITFauOlpBQoCDCcLY07H4wIIJBv1Qqwy/s1600/mysql-export-import.jpg" /></a><span style="font-size: 12.0pt; line-height: 115%;">Generally
speaking importing and exporting data in the MySQL is not a difficult task and
there are three different ways specified for the efficient working. The first
method is to perform it through graphical means with the help of<span style="mso-spacerun: yes;"> </span><a href="http://whatismysqlrf.blogspot.com/2013/09/what-is-phpmyadmin.html"><b>phpMyAdmin</b></a> while the method is not highly
recommended in case of uploading heavy files on system. The next method is the
utilization of the SSH tunnel in which a third party is used to execute the
importing function for the system. The last method is to make use of the
command line client for MySQL through the SSH connection.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">As there are
different ways used to develop the backup or restoring for the MySQL yet there
are some limitations in each method. The best way recommended is to perform the
task locally which helps in dumping of data on the disk in a much faster speed.
By simply using the dumping procedure as well as utilities one can perform the
task in much better time and error free method. </span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Import data of MySQL</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">One of the
widely used methods for restoring or importing data on the server is to start
creating with the username for MySQL. Once the account information is made that
includes a database, password and username, one is ready for the further
proceedings.</span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Upload
the dump file of the SQL to the account from the database. Majority files can
be recognized with .sql extensions.</span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">The
file will contain the necessary statements and the tables on which the action
of reinserting will be performed. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">After
uploading of the file, a SSH account is required and a special command is run
to make it function. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Replace
the mysqluser with the username created by you while the statement of mysqldb
will be substituted with the database of the sql created. While the last
statement of dbfile.sql will be replaced with the name of the respective sql
dump file location. </span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo2; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">A
password will be needed for the necessary action and once it matches with the
system, it will immediately load the data. Any error in the dump file path will
result in failure in uploading of the file.</span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo2; text-indent: -.25in;">
<br /></div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><span style="font-size: 12.0pt; line-height: 115%;">Export data for MySQL</span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Exporting
the data is convenient when compared to the steps followed for importing. Yet
the first step for both the tasks remains the same as one need to create the
SSH account.</span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Once
the SSH account is generated we will take the same example of the previous
statement. The command that has been used to initiate the process earlier. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">The
next step is to provide the username and password to the system that will
further helps in replacing the required statement. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">As
soon as the password matches with the system, there will be a file created that
contains the data on the home directory. Further FTP can be sued in order to
download the given file. </span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="font-family: "Calibri","sans-serif"; font-size: 12.0pt; line-height: 115%; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">If
the file is not to be used again after downloading, it is highly recommended to
delete it on order to not to be used for the server in future. </span></div>
</div>
Anonymoushttp://www.blogger.com/profile/09800365369089065223noreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-29633194515111789192013-09-09T03:30:00.000-07:002013-11-14T22:39:08.582-08:00What is MySQL?<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="line-height: 18px;"><b>What is MySQL?</b></span></div>
<div class="MsoNormal">
<span style="line-height: 18px;"><b><br /></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyp1gp7cjizxR30ADlxFLt62bIQSndohsnB-sR86C_flXBxy9v8XGj_vqa7bYyJDWqkb1aZ-MjbxmfbUe-Axc5l42QODjHwHT2wixCjLik2ITp0jmJx8dNJD_dmN1K5zZYrSAtGvF2udAF/s1600/database_mysql.png" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgyp1gp7cjizxR30ADlxFLt62bIQSndohsnB-sR86C_flXBxy9v8XGj_vqa7bYyJDWqkb1aZ-MjbxmfbUe-Axc5l42QODjHwHT2wixCjLik2ITp0jmJx8dNJD_dmN1K5zZYrSAtGvF2udAF/s320/database_mysql.png" width="320" /></a></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;">MySQL is the
best source to provide database system working as a server and further provide
access to other databases. SQL is the abbreviation of Structured Query
Language. In simple words, MySQL helps in creating a structural database on the
web for sake of either storing data or an access to automotive procedures. </span><span style="font-size: 12pt; line-height: 115%;">With the help of such system one can create a
number of magnificent projects on the web. MySQL is also one of the open
sources that are free to use as it is licensed with general public license GPL.
The system is supported by the web host and is further associated with the
Linux servers.</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">How it is used?</span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">MySQL is one
of the widely used choices for creating the database on the web. Some of the
renowned sites have used it as the database management system that includes
<a href="http://www.youtube.com/">YouTube</a>, <a href="https://twitter.com/">twitter</a> and <a href="http://www.facebook.com/">Facebook</a>. The choice of the system works as a database to
be used in web applications and is considered one of the major components of
LAMP. MySQL is although a bit complex in use but easy to be built and can be
manually installed. After special customizations it is installed from binary
package. Once the system is installed after simple steps, system often require
configuration to adjust further settings related to security. </span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">In what way it is better than other
system?</span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The system
provides the multiple storage engines in which one can manually select the
efficient storage for the web use. The system provides many features storage
engines that each carries its own features. While creating the table on the web
one use the complicated statements of MySQL for the efficient working. Once the
tables are created the major part of the project is done, as the speed of the
system as well as reliability is much standardized when compared to other
systems. The system works best when a webpage is receiving a record number of
hits each day.</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The tables
of the system provide the real characters of the data type that provide
convenience in use. When used LongText data type, one can use billions of text
characters, while the Longblob data type provides the functional advantage of
holding many characters at the same time. The feature of Bigint data type
provides the ultimate storage of countless digits used by the multi user. These
features are considered to be the major reason behind the use of the system by
many renowned websites that receives a record number hits by the user each day.
</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<br />
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">As <a href="http://whatismysqlrf.blogspot.com/2013/09/what-is-mysql.html"><b>MySQL</b></a> is
free to use being licensed with GPL, the support for the use of the system can be
obtained from the manual available on the official website while further
support is also available on the wide level at many forums and IRC channels.
More advanced support is provided by ORACLE on paid services. Many versions of
the system are released and there are further advanced system ready to be
released due to the wide use of the system by many experts.</span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-9245246037768256742013-09-09T01:13:00.000-07:002013-09-09T01:17:43.687-07:00Most Common Shell Commands<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Most
Common Shell Commands</span></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcPvDh9fIRxTON_1qhvIoy2wpYvfcWnAqLPGMHRDuD5e71-5kdQq27s6sWwyuaCowvfooE8_ejCMoP0gZ00ELnDcLvtezpCDa-y-SEgoy2TyMKJBWkFXTchyBgG1peio3ySFcevX2PitHo/s1600/mysql-logo.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjcPvDh9fIRxTON_1qhvIoy2wpYvfcWnAqLPGMHRDuD5e71-5kdQq27s6sWwyuaCowvfooE8_ejCMoP0gZ00ELnDcLvtezpCDa-y-SEgoy2TyMKJBWkFXTchyBgG1peio3ySFcevX2PitHo/s320/mysql-logo.jpg" width="320" /></a></span></b></div>
<b><span style="font-family: inherit;"><o:p></o:p></span></b><br />
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Here we are going to discuss a few common shell commands that are being
used by the programmers to enable different functions. Beginners are confused
about the set of commands that can be used and the command box through which
they can execute their commands. All of the shell commands use s sensible and a
logical pattern to be executed. All of the shell commands are very short and
only include three or four letters. Shell commands that are used frequently
have been shortened to ease their usage criteria. Now we will describe a few
simple shell commands that will get you going. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Man command<o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Also known as manual command, it is used to help users with different
problems that can be faced while using Linux operating system. It is a built in
command and needs not to be modified. The man commands pages are not the
standalone guidelines for the beginners but can be used as a reference to mix
the reference material which you learned somewhere else. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Info command <o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Info command is a very useful command, which is also used as a reference
source for gaining help in different matters of Linux operating system. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">1.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Troubleshooting suggestions and GNU information can
be gained with the help of info command. It is somewhat different from man
command as in info command you can make use of the hyperlinks for easy and
secure browsing. <o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">2.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">You can access the required material easily as
there are several shortcuts available for scrolling through different pages. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-left: .25in;">
<br /></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Date command <o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">By looking at the name of this command you will get an idea about the
working of this command. When you enter this command on your system you will
come to know about the current date and time on your system. If you use cal command along with date
command it will show the calendar. You can look into the calendar of the
current month or choose a special date where the calendar can take you to. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Is command <o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Is command is a basic command that will display the different contents
which are present in a directory that you have chosen already. It means that
you will be able to see all of the files which are present in a specific
directory with the help of this simple command. This command has different
switches that can be used to modify its functionality and behavior. You can use
different commands with the basic Is command to get more detail and description
of the content which is present in the directory, or even a specific directory
for which you are looking. Hidden files in any directory can also be viewed if
you use another command with the basic Is command. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="font-size: 12pt; line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Cat command <o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-family: inherit;"><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">Cat command can be used for viewing all of the text which is present in
any simple file. This simple command comes handy if you are dealing with basic
text files and want to see the text which is present in these files. <br />
<!--[if !supportLineBreakNewLine]--><br />
<!--[endif]--><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><span style="font-family: inherit;">All of these commands are quite simple and can be placed to execute
different actions according to your requirements. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-30264849054038454722013-09-09T01:12:00.000-07:002013-09-09T01:12:00.463-07:00Overview of phpMyAdmin<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<b><span style="font-family: inherit;">Overview of phpMyAdmin</span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyE28TVoUcbApASbaQCrFZ1qhshfbZPXpoEK-UqTWdke_3OitX0D8rvk4bjK310hYpKI4Rk7dpWTwQQFdTPM-23AKbyXFxXTdhlJrP5S9pbifqGeb6R5kBf0FZVoBNJUt3oCHtAEAw6jsp/s1600/database_mysql.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyE28TVoUcbApASbaQCrFZ1qhshfbZPXpoEK-UqTWdke_3OitX0D8rvk4bjK310hYpKI4Rk7dpWTwQQFdTPM-23AKbyXFxXTdhlJrP5S9pbifqGeb6R5kBf0FZVoBNJUt3oCHtAEAw6jsp/s320/database_mysql.png" width="320" /></a></span></b></div>
<b><span style="font-family: inherit;"><o:p></o:p></span></b><br />
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: inherit;">PhpmyAdmin
can be described as the most popular application, which is being used for the
MySQL database management. Basically it is a free management tool that has been
developed in PHP and it is a very useful tool. As with the help of this
application you can easily export, import, delete, drop, alter or create a
MySQL database table. Not only this, but you can also run various MySQL
queries, check tables, optimize, repair, execute different database commands
and even change collation. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="line-height: 18.0pt; margin-bottom: 12.0pt; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">·<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->The different unique features of
PhpMyAdmin are:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">1.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->It supports a user friendly interface
for different web based applications <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">2.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->As told above it works as a support for
many MySQL functions which include dropping, creating, browsing, copying and
altering different databases, views, indexes, tables and fields, executing
MySQL queries, managing the stored functions and procedures. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">3.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Importing data from the SQL and CSV
files <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">4.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Exporting data to different formats
including the XML, SQL, PDF, CSV, IEC/ISO 26300 – LATEX, Spreadsheet and Open
Document Text and MS Word, MS Excel<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">5.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Searching globally in any database or a
possible subset of it <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="line-height: 18.0pt; margin-bottom: 12.0pt; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">6.<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Several more features<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; margin-left: .25in; margin-right: 0in; margin-top: 0in; text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoListParagraph" style="line-height: 18.0pt; margin-bottom: 12.0pt; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">·<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Requirement of PhpMyAdmin<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: inherit;">There
are several blogs, making use of the export and import tools in the WordPress
to handle different requirements of their websites. In case of an emergency and
to repair your blog you might need the WP-DB-Backup tool. But for the backup of
your data you will require the phpMyAdmin. Importance of phpMyAdmin can be
judged from that factor that it helps in handling the MySQL server, as all of
the programs are basically series of different MySQL and databases which manage
them. We can describe SQL as the main language that is being inside different
databases. So the important fact over here is that phpMyAdmin allows handling
different databases in a very easy manner. phpMyAdmin is basically a PHP script
that allows users to interact directly with their MySQL database. Raw data stored in MySQL database can be
accessed through the phpMyAdmin facility easily. <o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 18.0pt; margin-bottom: 12.0pt; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">·<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Location of phpMyAdmin <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: inherit;">To
locate your phpMyAdmin, you need to login to the back office or the cPanel.
After you login you will see different boxes where similar programs are being
grouped together. You have to select the box which shows databases and there
you will be able to see the phpMyAdmin. Host control panels like Plesk and
cPanel might have the phpMyAdmin installed earlier, so there is not much work
left to do. Basically it is linked with the database page and to make sure, it
is properly linked or not, you can ask your host for the availability. <o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 18.0pt; margin-bottom: 12.0pt; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;">·<span style="font-size: 7pt; line-height: normal;">
</span><!--[endif]-->Location of database<o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: inherit;">After
accessing you can click on Databases which is located under the localhost or
the MySQL. If you have several databases you will see a list of different
databases. It depends on you, which one you actually need and then you can
click on it. <o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 18.0pt; margin-bottom: 12.0pt; text-align: justify; text-justify: inter-ideograph;">
<span style="font-family: inherit;">You
must keep in mind that phpMyAdmin allows direct interaction with the different
databases, so it means any changes you are going to make will take an immediate
effect. You cannot modify the changes once they are made in the database, so
always work with caution while using both of the elements together. </span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-77053115995685325162013-09-09T01:10:00.002-07:002013-09-09T01:10:46.692-07:00Setting up Master MySQL Server<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<b><span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">Setting up Master MySQL Server</span></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><span style="font-family: inherit;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSEw3x86RFlHTN-DOIOGrPwh_qErkgY418rru6-tgUjexc5NZi-6wEB7wSIp-STLyo8sanInkkwdsEiedFyI60geYJ_W9CLfWy1xMKfGGhSsGp_QvI7MsbRzPBIFZBvBZt9FX07o2vYray/s1600/mysql-logo.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="133" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSEw3x86RFlHTN-DOIOGrPwh_qErkgY418rru6-tgUjexc5NZi-6wEB7wSIp-STLyo8sanInkkwdsEiedFyI60geYJ_W9CLfWy1xMKfGGhSsGp_QvI7MsbRzPBIFZBvBZt9FX07o2vYray/s320/mysql-logo.jpg" width="320" /></a></span></b></div>
<b><span style="font-family: inherit;"><o:p></o:p></span></b><br />
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<b><span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></b></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">Setting up a master MySQL server is
an easy process. But for the beginners this process might get tricky as they do
not know how to place different commands. Apart from knowing the exact and
accurate commands required for executing different actions they also need to be
typed correctly, as any wrong command will not let a required action to take
place. It will actually prevent MySQL from carrying out the action further in
case a wrong command has been detected. So it is important to learn and enter
the exact commands for this purpose. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">1.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">To initiate the
process first of all you need to install MySQL on the Windows Dedicated server<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">2.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">After installing
MySQL you can start the program and enter the required commands<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">3.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">You will start
MySQL with the help of Windows Command Line<o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">4.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">To make this process
successful you need to know the following steps <o:p></o:p></span></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">Note: the steps that we are going to
discuss over here can be used easily on any version of Windows, as there are no
special instructions or guidelines that require MySQL to become operational on
Windows. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo3; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%; mso-bidi-font-size: 12.0pt;">Getting started <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">First of all open the windows command
box which is also called as the DOS Windows. After you have opened the console
window you can start MySQLD server with the help of special commands. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">The exact path of the MySQLD server
will actually depend on the server of Windows and on the path where MySQL has
been installed. You can also stop the functioning of MySQL sever by entering a
simple command. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">1.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">It is important to
note that if there is a password required then you need to bring the p(password)
option on the mysqladmin, which will allow your access to the root use account.
<o:p></o:p></span></span></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">With the help of simple commands
MySQL administrative utility will come into action and inform the mysqladmin
server, to establish a link with the main server and as a result it is ordered
to shut down or discontinue its activity. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;"><br /></span></span></div>
<div class="MsoListParagraph" style="mso-list: l2 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">2.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%;">It is important to
note that, the users accessing the MySQL grant system are basically independent
and free from the influence of any other users that login Windows for different
purposes. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="margin-left: .25in; text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo3; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: inherit;"><span style="line-height: 115%;">·<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="line-height: 115%; mso-bidi-font-size: 12.0pt;">MySQL web server<o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">In case you are facing difficulties
in initiating the MySQL server then you need to have a look at the error log,
which will tell you about the different errors that are stopping the action.
You will also know if any action has been dropped by the server due to certain
limitations and this will eventually help you out in determining the actual
problem. All of the errors are recorded in the system files and you can easily
access them at any time. <o:p></o:p></span></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-family: inherit;">There is another process for
initiating MySQL server with the help of mysqld console. By using this command
you will be able to successfully run the program and start the server. By
entering this command your screen will display some useful information, which
will serve as a guideline to prevent further errors from taking place. <o:p></o:p></span></span></div>
<div style="text-align: left;">
</div>
<div class="MsoNormal" style="text-align: left;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-40823681751988460512013-09-09T01:08:00.001-07:002013-09-09T01:08:54.710-07:00Simple MySQL commands<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Simple MySQL commands</span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIFuaDSpiC-eTDTiVGCRTpzaxwbLF-CHdORnMOgBipvCR9x0aUjWac9xIznc53JwdbyK_yaTNWpJDN1lok0PAJ4V6pusdEx3CzLo6JVl__ZrAh38sJzQbCUpssyUhJ9OdCu-VWXtpbsVqC/s1600/ado-net.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIFuaDSpiC-eTDTiVGCRTpzaxwbLF-CHdORnMOgBipvCR9x0aUjWac9xIznc53JwdbyK_yaTNWpJDN1lok0PAJ4V6pusdEx3CzLo6JVl__ZrAh38sJzQbCUpssyUhJ9OdCu-VWXtpbsVqC/s320/ado-net.png" width="222" /></a></b></div>
<b><o:p></o:p></b><br />
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">MySQL is a
database system used by many sites in order to maintain a functional database
for web use. The system is easy to install and further used by doing simple
configuration to the system. Below are
some of the simple commands to be used in MySQL that further provides easy
functioning in the system.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The commands
used on MySQL helps in the direct interaction with the database on the server.
Such commands are most of the time useful in sudden requirements of the
application in order to create a database or the tables related to it. By
loading the sql script one is ready to create the given requirements. For
accessing any command line one has to execute the command by entering the
password.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Some simple commands in MySQL<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l4 level1 lfo5; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;">For
creating the users of the table simple commands are useful.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l4 level1 lfo5; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;">In
case of user nickname are required only with their concerned favorite number,
some easy to use commands can do the desired task.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l2 level1 lfo4; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;">For
the nicknames availed if provided with pair of socks that are less than 10 and
if the favorite number specified is more than 100 then the command will specify
the detail in it.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l3 level1 lfo3; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;">For
inserting the row of data into the system table, an easy to use command of
MySQL will provide the best solution.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l1 level1 lfo2; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;">For
if the row of the data has the password missing the command is somewhat same as
the one recommended for creating the password for the user table.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Common statements to be used:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">For more
complex type of commands there are different statements and clauses are used
that helps in generating the commands. Some of the mostly used statements and
clauses are <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">ALTER DATABASE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">ALTER VIEW<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">ANALYZE TABLE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">CACHE INDEX<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">CHECK TABLE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">COMMIT <o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">CREATE INDEX<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">CREATE DATABASE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">CREATE VIEW<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">DELETE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">DROP DATABASE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">DROP INDEX<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">DROP USER<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">EXPLAIN<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">GRANT<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">INSERT<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">KILL<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">LOAD DATA INFILE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">LOCK TABLES<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">RENAME TABLES<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">RESET MASTER<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">RESTORE TABLE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">SET PASWORD<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">SHOW COLUMNS<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-size: 12.0pt;">SHOW CREATE TABLE<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">An example of complete MySQL command:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Apart from
these famous statements there is still much to learn regarding the string
functions of the system as well as functional aspect of date and time. To
explain more about some simple commands let us take an example of a complete
set of command performing the desired function. <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%;"><b>Replacing
the statements</b><o:p></o:p></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The action
of replacing the item is performed in a row. The action of replacement is more
dependent on the id as in order to REPLACE effectively one has to add the
column of PRIMARY. Once the primary column has been set as id the system will
be familiar as to which row the necessary action has to be performed. Consequently if the id is not specified
system will have no information of which row one has intended to bring changes.
<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">In the
statements where id is not specified to the system it will act more like an
INSERT action. In simple words if the primary row is specified the changes will
be made only in concerned row.<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-69744985381822502172013-09-09T01:06:00.001-07:002013-09-09T01:06:49.853-07:00What is Shell Scripting?<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">What is Shell Scripting?</span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<b><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrbiLnku8BeRfxBxyvsoQqp-c7hw-Wz4xFa3VGelHhDRwd_VqY8rrXd6QEuIxOUtTFcowVTfGWw_s-Xaml5cwJTOVbO3e0rqDV0OrefG0k2QMhXH85FD6GP9uRXbtgVHUdFwxCvh1b9L_/s1600/SS.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="290" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGrbiLnku8BeRfxBxyvsoQqp-c7hw-Wz4xFa3VGelHhDRwd_VqY8rrXd6QEuIxOUtTFcowVTfGWw_s-Xaml5cwJTOVbO3e0rqDV0OrefG0k2QMhXH85FD6GP9uRXbtgVHUdFwxCvh1b9L_/s320/SS.jpg" width="320" /></a></b></div>
<b><o:p></o:p></b><br />
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<b><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></b></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">For those
who do not have a programming background must be unaware of the basics of
different operating systems and scripting. Shell scripting can be confusing for
the beginners but with the passage of time when you start learning different
things of this language, it will become clearer to you. You might find it
interesting to learn and apply later once you are aware of the actual
functioning of this script. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Basic intro <o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Shell
script can be described as a text file, which contains string of different commands
that have been placed in a particular sequence. Once the script is allowed to
run all of the commands are executed which are present in that file. Shell,
basically refers to a special command line interface which is used for
communicating with Linux kernel. Nowadays different shells are being used and
the most common shells are csh also known as the C Shell, ksh also known as the
Korn Shell, sh which is also known as Bourne Shell and Bourne Again bash or
shell. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">You will
experience different scenarios while making a script using a shell. The
different cases can be:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">1.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Supporting and existing script while you are
looking forward to make few amendments <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;">2.<span style="font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Automating systems setup procedure while you are
installing oracle. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">If you
pass through any of the above stated conditions you will need to use a special
script that will help in determining the actual state of the different
requirements of operating system. You have to keep in mind that these
requirements must be met before you plan to install the software. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Linux <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Bash can
be described as the most common shell that is being used under Linux. The other
name given to this shell is Bourne Again Shell, which is very first name,
awarded to this shell. In fact there are several other shells available for
using with Linux and are easily compatible with this operating system. But most
of the experts recommend using this shell, as it will help in increasing the
chances of your operating systems compatibility with other similar operating
systems. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">UNIX <o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">While you
are using UNIX, it will allow to string different commands together and then
execute them as a set of UNIX commands even when the set of commands which
needs to be executed has not been completed. The process of executing a script
is made a lot faster by this process. Shell scripting done under UNIX makes it
quite easy for the programmers to understand your code. These types of scripts
can be shared easily at any corner of the world on the systems that have UNIX f<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<!--[if !supportLists]--><span style="font-family: Symbol; font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;">·<span style="font-family: 'Times New Roman'; font-size: 7pt; line-height: normal;">
</span></span><!--[endif]--><span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Script for windows <o:p></o:p></span></div>
<div class="MsoListParagraph" style="margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<span style="font-size: 12.0pt; line-height: 115%; mso-bidi-font-family: Arial;">Windows
also allows its users to develop certain scripts and then use them for
generating and controlling different types of programs. In Windows shell
scripting is basically done to generate the logon scripts. These scripts then
are used for configuring the different settings of the Windows that a user will
prefer after logging in. it is a unique feature that enables programs to use
shell scripting in Windows also. <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<div class="MsoNormal" style="text-align: justify; text-justify: inter-ideograph;">
<br /></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6985742584673200791.post-85932094291713868972013-09-09T00:56:00.000-07:002013-09-09T00:56:05.471-07:00What is phpMyAdmin?<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">What is phpMyAdmin?<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjDz1QCPkVYoN6jWzPehC4T9Ble3E0BsVcf3gUGb6H7hyphenhyphenEUdGMkYTsdpPUbjJSj4HwdPIVx01y2DkfKT8Ss0-RbVMk_z1wfS2rx4Y3l9umIlOdNePsr6KiVoFMDX1g7nyCkyskvBW8R2x3/s1600/PMA.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjDz1QCPkVYoN6jWzPehC4T9Ble3E0BsVcf3gUGb6H7hyphenhyphenEUdGMkYTsdpPUbjJSj4HwdPIVx01y2DkfKT8Ss0-RbVMk_z1wfS2rx4Y3l9umIlOdNePsr6KiVoFMDX1g7nyCkyskvBW8R2x3/s320/PMA.jpg" width="320" /></a></div>
<div class="MsoNormal">
<span style="font-size: 12pt; line-height: 115%;">phpMyAdmin
is a script made in PHP that is basically used for providing the interaction of
the user with the MySQL databases. Wordpress actively works in order to store
the data in MySQL database and within the wordpress site the information is
generated by the interaction of the database. The tool can be used for various
activities that could include creation, modification of databases, execution of
SQL statements and management of users and their permissions. The tool was
first released in 1998 and since then has introduced many updated compatible
versions.</span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Important features of the phpMyAdmin:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The program
actively works for the MySQL while its features deliver the best services. Web
interface is the main feature of the program while it is directly involved in
working of managing the MySQL database. The program also helps in importing the
data from SQL as well as CSV. Another exciting feature of the program is that
it can export data in variety of formats. The program administers on multiple
servers and further creates complex queries by suing the QBE. The set of
function in the program also provide efficient services in transforming the
stored data in various other formats. The program also works for the creation
of graphics for the database layout.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Uses of phpMyAdmin:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">The handy
program is performing various important functions that have the major benefits
for the user in various ways. The program performs commendable operations
related to maintenance of tables, editing required and back up information. The
program deals with the various functions related to the handling of MySQL
database that could involve deleting, creating modifying and editing. <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;">Access to the program:<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span style="font-size: 12.0pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Some of the
hosting control panels have php program already installed in it and one has to
do zero effort in order to take access to it. The link to the program is
normally available at the database page and can be asked from the host site to
give the access. While the manual download of the program is also available
that can be installed from the project page of phpMyAdmin. One of the important
considerations for the user is the careful handling of the program, as it
provides the direct access of handling the database. Any misuse or mishandling
will lead to trouble as the program doesn’t provide any undelete or undo
options. It is convenient to exercise with caution in order to deal with
database. <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><br /></span></div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;">Summarizing
the concept of phpMyAdmin, the browser based application is designed to provide
the maximum help in managing MySQL database. Apart from using the traditional
method of command prompt the program is designed to deliver the services by
using the browser. The program itself is free of cost but there could be some
charges that one has to pay for MySQL database. Data can also be imported in
the program with few simple steps. The data of MySQL cannot be directly deleted
with the help of program but the program instead helps in making modification
and deleting in tables.</span></div>
</div>
Unknownnoreply@blogger.com0