Archive for the Database Category

How to cut down SBS monitoring memory usage on SBS 2003.

This may be due to a firewall issue – in particular Allow inbound SQL Server Browser UDP 1434
See further info on opening relevant firewall ports here:
http://technet.microsoft.com/en-us/library/ms175043.asp
Regards,
Brendan

On a windows server the MySQL executables folder by default will be installed in a folder like
C:\Program Files\MySQL\MySQL Server 5.1\bin
Executables in this folder will be
myisamchk.exe
myisamlog.exe
myisampack.exe
myisam_ftdump.exe
mysql.exe
mysqladmin.exe
mysqlbinlog.exe
mysqlcheck.exe
mysqld-debug.exe
mysqld.exe
mysqldump.exe
mysqlimport.exe
MySQLInstanceConfig.exe
mysqlmanager.exe
mysqlshow.exe
mysqltest.exe
mysql_client_test.exe
mysql_upgrade.exe
my_print_defaults.exe
perror.exe
replace.exe
resolveip.exe
Use this to create a database:
# mysqladmin create <db-name>
Assign privledges:

# mysql -u root -p
# mysql> use mysql;
# mysql> grant all privileges on <db-name>.* to <db-user>@webserver.com
-> identified by [...]

This error is associated with the VIA protocol. To disable it

Start->All Programs -> Microsoft Sql server 2005 -> Configuration Tools -> SQL Server Configuration Manager.
In the SQL SERVER configuration Manager Window, click the plus (+) sign against SQL SERVER 2005 Network Configuration.
Highlight ‘Protocols for MS SQL SERVER’. In the right pane you’d find VIA in [...]

A pre-note on installing WordPress: Read the official installation instructions first! By following the “5 minute install” instructions verbatim, I’ve never had a problem! Problems only happen when you don’t follow the instructions!
http://codex.wordpress.org/Installing_WordPress
Symptom: You’re installing Wordpress and you’re getting database connection errors even though you have the settings correct.
Fix: It’s possible that you have the [...]

The Express version of MS SQL 2005 does not include functionality to perform a scheduled backup. To get around this, use the “Script to File” option and then run it from the command line using a batch file and Windows Scheduled Tasks function.
1. Open up SQL Server Management Studio Express
2. Drill down to your database [...]