How to find the MAC (Physical) Address in Windows 8/8.1

How to find the MAC (Physical) Address in Windows 8/8.1

MAC address of a particular adapter can be found using the Command Prompt. Refer to the steps below to find out the MAC address of your network adapter using Command Prompt.

  1. Click or tap on Start and type cmd.
  2. Press enter on your keyboard or else tap or click on Command Prompt in the find window at the left.
  3. Type ipconfig /all in the Command Prompt window and press Enter.
  4. Once the command is completed, scroll to the Network Adapter for which the MAC address is needed.
  5. MAC Address

  6. Mark the address written against the Physical Address field and copy it for further use (where needed).
  7. [/ol]

How to copy a database in phpMyAdmin

How to copy a database in phpMyAdmin

This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin.

Begin by accessing phpMyAdmin

  1. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).
  2. Once inside the database, select the Operations tab.
  3. Scroll down to the section where it says “Copy database to:”
  4. Type in the name of the new database.
  5. Select “structure and data” to copy everything.  Alternately, you can select “Structure only” if you want the columns but not the data.
  6. Check the box “CREATE DATABASE before copying” to create a new database.
  7. Check the box “Add AUTO_INCREMENT value.”
  8. Click on the Go button to proceed.

If you click on the home icon, you will notice your new database listed in the left column.  If you go inside, you will see the database is a copy of the previous database

Restoring The Database via SSH/Telnet

Restoring The Database via SSH/Telnet

In order to restore your database via SSH or Telnet you will require 2 things:

  1. SSH or Telnet access to your site. You will need to check with your hosting company to see if this is available.
  2. An SSH/Telnet Client, such as PuTTy.

Note:

If your database backup resides on your home computer, you will first have to upload it via FTP to your website

Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS. For most hosting companies, this will bring you into the FTP root folder.

You can either change directoties to wherever the backup is located and type in the following:

mysql -u dbusername -p databasename < backupname.sql

Or if you do not want to change directories and you know the path to where the backup is located, type in the following:

mysql -u dbusername -p databasename < /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysql -h servername -u dbusername -p databasename < backupname.sql

Or:

mysql -h servername -u dbusername -p databasename < /path/to/backupname.sql