Posts Tagged ‘structure’

How to backup and restore your MySQL database or table structure to in Linux

Whenever there is a database involved, an important task that should never be neglected is backing it up. In the case of MySQL on a Linux machine, backing up consists of executing a single command.
Backing up a MySQL database can be done with one simple command:

mysqldump -h <host> -u <user> -p<password> <db_name> > backup.sql

For example if you want to backup a local database called db1 using the user user1 with password pass1 you should write:

mysqldump -h localhost -u user1 -ppass1 db1 > backup.sql

The backup.sql file contains an SQL query for creating the exact same database. Restoring such a dump-file is just a matter of one command too:

mysql -h <host> -u <user> -p<password> <db_name> < backup.sql

Following the naming from our previous example will result in the following command to restore the database:

mysql -h localhost -u user1 -ppass1 db1 < backup.sql

In the perfect environment the backup should be created by a cronjob or anacronjob.
Another useful thing that one may want to backup is the table structure. For tables whose structure is relatively often changed this can prove to be very helpful. It is done by using one simple modification of the command for backing up an entire database:

mysqldump -d -h <host> -u <user> -p<password> <db_name> > backup.sql

Did you notice the difference? It is the -d option, which specifies that data should not be dumped. Using our previous examples this will be transform to:

mysqldump -d -h localhost -u user1 -ppass1 db1 > backup.sql
VN:F [1.9.18_1163]
Rating: 6.3/10 (3 votes cast)

14 advises for how to design your website’s navigation

One of the most important things to keep in mind when designing a website is navigation. You don’t like getting lost in a city you don’t know, do you? Well, neither do your users. You won’t tolerate travelling for two hours just to buy a cup of coffee, will you? Well, neither will your users. In this short article we will provide you with a few guidelines to follow when designing your site.

1. Each page should show the basic structure of your site.

2. Make each action sequence clear and structured. Remember, users don’t know what your website’s back-end is. What you may find to be logical on a technical level may be irrational on a logical level.

3. Keep each screen as clean as possible. Align page elements horizontally or vertically.

4. Be consistent with the placing of important items. Highlighting critical information is a must.

5. Keep your site’s structure as broad and as shallow as possible.

6. Carefully choose your header and bottom of the page. Make sure the user doesn’t get confused that he has reached the top/bottom of the page when he hasn’t.

7. No horizontal scrolling.

8. Links should be self-explanatory.

9. Avoid elements that look clickable, but are not.

10. Make sure that category labels are distinguished from ordinary ones. They should be self-explanatory. Never forget that page titles should be descriptive.

11. Navigation labels should be consistent with page titles/headings. Tooltips are your friends.

12. Heading should be descriptive and consistent throughout the site. This helps users familiarize the site structure.

13. Order items in the lists by importance. Users scan content top-bottom.

14. List ordering should be consistent between pages.

Follow these guidelines and your website’s navigation will be user friendly and intuitive.

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)

Creating A CSS Layout In Dreamweaver from PSD

In this tutorial we will go through the steps of creating a CSS website starting from a layout received from the designer. We will explain how to understand the page structure and how to use the Flexi CSS Layouts to create the CSS layout without coding. Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (10 votes cast)

Simple File or Image Uploads Using PHP HTML

Today we are going to learn how to upload a file or image using PHP and a web form. No knowledge of PHP is needed or HTML as the full file structure is included Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)

How To Install PHP-Nuke CMS

In next tutorial I will show you how to install PHPNuke CMS .

PHP-Nuke is a CMS (content management system) specially designed to be used in Intranets and Internet. The Administrator has total control of his web site, registered users, and he will have in the hand a powerful assembly of tools to maintain an active and 100% interactive web site using databases.

Firs of all you need AppServ Software packet with Apache, PHP and MySQL .

Next you have to install AppServ. You will don\”t have a problem if you read and fill correctly all notes along with installation. Apache web server have to be installed automatically. For MySQL you have to set username and password. PHP will be installed. automatically. With this, installation was finished. Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 9.0/10 (2 votes cast)

Show folder tree under DOS

This tutorial will show you how to show folder tree under DOS.

To do this go to directory from which level you want to show the folder structure and type: Read the rest of this entry »

VN:F [1.9.18_1163]
Rating: 0.0/10 (0 votes cast)