Import database to mysql throught console in windows

In this example, import ‘data.sql’ file into ‘blog’ database using vivek as username:
$ mysql -u vivek -p -h localhost blog < data.sql

If you have a dedicated database server, replace localhost hostname with with actual server name or IP address as follows:
$ mysql -u username -p -h databasename < data.sql
OR use hostname such as
$ mysql -u username -p -h database-name < data.sql

If you do not know the database name or database name is included in sql dump you can try out something as follows:
$ mysql -u username -p -h < data.sql

you may remove the host and add the database and table like the following

$ mysql -u username -p < data.sql


How to make wamp online across network ?

Today i wanted to make my localhost shared across network so any one can see any edit at my websites

  1. you have to know your ipaddress .. in windows ( as you using wamp ) you run cmd and run ipconfig /all
  2. take your ip4 and this is your ipaddress for your localhost
  3. put WAMP on online mode ( left click on wamp and then press put online )
  4. try this in the browser
  5. it will give you that permssion denied on other computers
  6. you have to edit your http.conf file ( apache )
  7. Edit the following
  8. # AllowOverride controls what directives may be placed in .htaccess files.
    # It can be "All", "None", or any combination of the keywords:
    # Options FileInfo AuthConfig Limit
    AllowOverride All
    # Controls who can get stuff from this server.
    # Online --> Require all granted ( you change that to all guranted )
  9. Then try your ip address on other network computers

WAMP error: Forbidden You don’t have permission to access /phpmyadmin/ on this server

If you’re using WAMP with Apache 2.4.2, you need to use Require all instead of Allow and remove Order Deny,Allow:

<Directory "f:/Projects/myproject/www/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
    Require all granted

*as stated in this blog post


another answer :

Change the file content of c:\wamp\alias\phpmyadmin.conf to the following.

<Directory "c:/wamp/apps/phpmyadmin3.4.5/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
        Allow from all

Here my WAMP installation is in the c:\wamp folder. Change it according to your installation.

Previously, it was like this:

<Directory "c:/wamp/apps/phpmyadmin3.4.5/">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
    Deny from all
    Allow from

Restart your Apache server after making these changes.

Forbidden ( WAMP and Windows 8 )

المشكلة دى فى وندوز 8 الجديد … عشان تحل المشكلة دى لازم تحط ال wamp على put online  ( كليك يمين على التاسك بار ) … فهى مش ححتحل الا بالموضوع دا