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 202.54.1.10 databasename < data.sql
OR use hostname such as mysql.cyberciti.biz
$ mysql -u username -p -h mysql.cyberciti.biz 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 202.54.1.10 < data.sql

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

$ mysql -u username -p < data.sql

Advertisements

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
</Directory>

*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
</Directory>

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 127.0.0.1
</Directory>

Restart your Apache server after making these changes.

Forbidden ( WAMP and Windows 8 )

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

wamp