Tag : server
|Restore MySQL database in WampServer||TheJasonParker||MySQL||wampserver||
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||server||
AddHandler application/x-httpd-php .php .htm ... worked for me
|April 9, 2011|
|Kill Connections to SQL Server||tclancy||SQL||sqlserver||April 6, 2011|
|como identificar que viene de server.transfer||dactivo||C#||servertransfer||March 30, 2011|
|SQL Server Data Retrieval Made Easy||Shadar||VB.NET||Server Data Retrieval Made Easy||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||Start Server Single-User Mode||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||sqlserver||March 12, 2011|
|Check if a HTTP server is active||Gerson Amorim||C#||Check HTTP server active||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||Monitoring Free Space Microsoft Server||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||mysql server sql xml||
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||Zend-Frameworkserverxmlrpctest||
Van Matthew in the community
|February 17, 2011|
|Specify order of rows returned in MS SQL Server||dotNetkow||SQL||server||
Similar to "FINDINSET" from MySQL.
|February 16, 2011|
|How to calculate grand totals with SQL Server||Pragnesh Patel||SQL||calculate grand totals with Server||How to calculate grand totals with SQL Server||February 15, 2011|
|SQL Server 2008 Truncate Transaction Log||scholli||SQL||server||February 10, 2011|
|HTTPS httplib Client Connection with Certificate Validation||Marcelo Fernández||python||certificate client client_server httplib https networking ssl validation||
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|