Archive for August 2012

How to import large sql files into mysql using phpmyadmin wamp server

When you try to import sql file to wamp server usually it cann't upload more than  2,048KiB size and gives error message like

There is another way to upload large size of sql file to wamp server

step 1

Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here:

C:\wamp\apps\phpmyadmin3.4.5\config.inc.php

Note:  phymyadmin3.4.5 folder name is different in different version of wamp

step 2:

Find the line with $cfg['UploadDir'] on it and update it to:

$cfg['UploadDir'] = 'upload';


step 3:
Create a directory called ‘upload’ within the phpmyadmin directory.
   
C:\wamp\apps\phpmyadmin3.2.0.1\upload\


step 4:

copy and paste the  large sql file into upload directory which you want importing to phymyadmin

step 5:

select sql file from drop down list from phymyadmin to import



48 Comments

How to Disable Internet Search on Terminal Server in windows 2003

A Windows Terminal Server is a Windows 2003 server system that uses the Terminal Services application to allow remote users to connect to the machine. Internet Search is a feature of Windows Server that allows the system to automatically search for solutions to problems over the Internet. This can include driver updates, error messages and unknown file extensions. Blocking this behavior will increase your system's security by preventing users from locating untrusted or untested solutions as suggested steps to their problems. Internet Search is disabled with a group policy object.

Step 1

Log in to the Terminal Server as an administrative user.

Step 2

Open the Start menu, click "Run" and then type "gpedit.msc" (without quotes) and then press "Enter."

Step 3

Expand "Local Computer Policy" on the left by clicking the "+" symbol.

Step 4

Expand "Computer Configuration" on the left of the screen, then click "User Configuration" which opens below it.

Step 5

Double-click "Integrated Internet Search," then click "Disable." Click "OK" to save your changes.

Step 6

Click "OK" twice to save your settings.

References

"Windows Admin Scripting Little Black Book;" Jesse M. Torres; 2008

    1 Comment