Tag : server

Title User Language Tags Description Date
Restore MySQL database in WampServer TheJasonParker MySQL

Go to the Windows command line by going to Start -> Run and typing in cmd.

You need to change directory to the MySQL bin directory. On my version, the directory is c:\wamp\bin\mysql\mysql4.1.22\bin.

Therefore, the command to change to this directory is: cd wamp\bin\mysql\mysql4.1.22\bin

Put the MySQL dump (SQL file) into the above directory

Create the new database in phpmyAdmin (or on the command line)

The actual restore command is slightly different to normal (see below).

#

Note that is says mysql.exe rather than the normal mysql. When it asks you for a password, just hit enter. There is no password associated with the database that you created (unless you prefer to have one. But as it is local, there is no need).

 April 19, 2011
Get PHP to parse on local server stephcode PHP

AddHandler application/x-httpd-php .php .htm ... worked for me

 April 9, 2011
Kill Connections to SQL Server tclancy SQL April 6, 2011
como identificar que viene de server.transfer dactivo C# March 30, 2011
SQL Server Data Retrieval Made Easy Shadar VB.NET A data retrieval module for SQL Server. All you have to do is pass in SQL String or Stored Procedure Name, Command Type, and parameters (if any) March 29, 2011
Start SQL Server in Single-User Mode Frank Blau SQL This is usefull to repair a corrupt master-db. You must start a Database with the following Code from Query Analyzer and then do DBCC CHECKDB or DBCC CHECKTABLE with a valid REPAIT Option. March 21, 2011
SQL Server SP/FN Set Options michanne SQL March 12, 2011
Check if a HTTP server is active Gerson Amorim C# This function just opens a socket and try to connect to a remote endepoint on port 80. If that connection is open, the function returns true otherwise returns false. March 11, 2011
Monitoring Free Space on Microsoft SQL Server Gerson Amorim SQL Database administrators need to take up the stewardship of the server; any issues and be prepared to burn the midnight oil. A job goes down or a database fails to respond or the server fails to start, DBAs are always on the hot seat. Today, we will be dis March 10, 2011
A MSSQL XML importer for MySQL Albert Perrien II python

This is a simple function that takes records exported to XML from SQL Server or Access and imports them into MySQL.

March 9, 2011
Zend Framework test xmlRpc server Roen PHP

Van Matthew in the community

 February 17, 2011
Specify order of rows returned in MS SQL Server dotNetkow SQL

Similar to "FINDINSET" from MySQL.

 February 16, 2011
How to calculate grand totals with SQL Server Pragnesh Patel SQL How to calculate grand totals with SQL Server February 15, 2011
SQL Server 2008 Truncate Transaction Log scholli SQL February 10, 2011
HTTPS httplib Client Connection with Certificate Validation Marcelo Fernández python

Despite httplib.HTTPSConnection lets the programmer specify the client's pair of certificates, it doesn't force the underlying SSL library to check the server certificate against the client keys (from the client point of view).

This class allows to force this check, to ensure the python client is connecting to the right server.

 January 18, 2011