Archivio tag: mysql

Bookmarks for 12 apr 2013 from 14:46 to 21:36

These are my links for 12 apr 2013 from 14:46 to 21:36:

  • carloslima/dhsnapshot · GitHub – This script was created out of the need to have snapshots-like backups using the DreamHost Backup service, which provides 50GB of space for personal backups but gives very limited access to it's servers. Basically, you have no SSH access, only RSync and SFTP. It can be used to backup any machine: your computer, a server or even a Dreamhost-hosted website. You just need to configure it with the path to backup, your dreamhost backup account and the private key used for authentication and it will create daily backups and keep the last 7 days, 4 weeks and 6 months.
  • palexander/dreamback · GitHub – Dreamback is the easiest way to automate your backups on dreamhost. Dreamhost does not guarantee their backups of your users (though they've saved me with backups before), so it's best to run backups yourself. This is beta quality software. Please report issues if you have them. Using Dreamback is easy: 1) Create a user on dreamhost to manage your backups 2) Log in with your new user 3) gem install dreamback 4) dreamback 5) Answer the questions to setup your automated backup
  • View all MySQL Variables for Pasting into my.cnf – This is really useful for me because I work with dozens of different database servers. The first thing I do is run this command and paste it into the servers /etc/my.cnf file. That way I will always know the original value and it just makes life much easier.
  • How Permissions Work – Permissions are a key component of the Windows Server 2003 security architecture that you can use to manage the process of authorizing users, groups, and computers to access objects on a network.

Bookmarks for 2 nov 2012 from 15:23 to 18:09

These are my links for 2 nov 2012 from 15:23 to 18:09:

  • USEFUL ONE-LINE SCRIPTS FOR SED – (Unix stream editor) Dec. 29, 2005
    Compiled by Eric Pement – pemente[at]northpark[dot]edu version 5.5
  • IBM devscan tool – United States – The devscan tool is a supplemental tool used by AIX support personnel to gather debugging data for Storage Area Networks. The package download includes a manual page that is also available on this site at the Usage tab.
  • mysqlreport :: Make easy-to-read MySQL status reports – mysqlreport makes a friendly report of important MySQL status values. mysqlreport transforms the values from SHOW STATUS into an easy-to-read report that provides an in-depth understanding of how well MySQL is running. mysqlreport is a better alternative (and practically the only alternative) to manually interpreting SHOW STATUS.
  • Percona Online Tools – Welcome to Percona's suite of productivity tools for MySQL database administrators and developers. One free account lets you access all of the tools below, and keeps you updated when new tools or enhancements are available. Registration is required.

    Optimize your MySQL Server:
    Leverage our expertise to create a good starting configuration for a MySQL server.
    This tool will walk you through all of the steps necessary to create a ready to use MySQL configuration file in about 5 minutes.

    Analyze an SQL Query:
    Find out when your SQL is potentially buggy, hard for MySQL to optimize, or confusing.
    This tool will analyze your SQL code and warn you when it detects problems that we've encountered while optimizing thousands of queries in real applications.

Bookmarks for 2 nov 2012 from 11:31 to 12:17

These are my links for 2 nov 2012 from 11:31 to 12:17:

Bookmarks for 10 ott 2012 from 00:36 to 00:57

These are my links for 10 ott 2012 from 00:36 to 00:57:

  • miracle2k/emma · GitHub – Emma is a graphical toolkit for MySQL database developers and administrators. It provides dialogs to create or modify MySQL databases, tables, and associated indexes. The results of an executed query are displayed in a resultset where the record data can be edited by the user, if the SQL statemant allows for it. The SQL editor and resultset view are grouped in tabs. Results can be exported to CSV files. Multiple simultaneous opened MySQL connections are possible. Emma is the successor of yamysqlfront.
  • The NanoURL Project | Free Communications software downloads at SourceForge.net – The nanoURL project is essentially a script similar to the one used at tinyurl.com, which takes long URLs and turns them into shorter and more easily-remembered URLs. Web administration interface and installer included!
  • RT: Request Tracker – Best Practical – RT is a battle-tested issue tracking system which thousands of organizations use for bug tracking, help desk ticketing, customer service, workflow processes, change management, network operations, youth counselling and even more. Organizations around the world have been running smoothly thanks to RT for over 10 years.

    RT 4.0 is a major update. It's chock full of new features, enhancements and bug fixes. Don't miss our What's New in 4 series.

    There's no need to wait for a quote or for a sales person to send you a demo. The full, enterprise-ready version of RT is always available at absolutely no cost under an open source license. That means it's yours to use and customize however you'd like. We built RT from the ground up to be easy to adapt to your organization and your needs.

  • Zentyal Linux small business server | Free System Administration software downloads at SourceForge.net – Zentyal is an open source alternative to Windows Small Business Server
  • Resara Server | Free Communications software downloads at SourceForge.net – An easy-to-use, AD compatible Linux domain controller and file server