Month: March 2014

USING SSH MYSQL DUMP and backup databases. OR Downloading MySQL dump from command line


USING SSH MYSQL DUMP and backup databases. OR Downloading MySQL dump from command line.

You can accomplish this using the mysqldump command-line function.

If it’s an entire DB, then:

If it’s all DBs, then:

If it’s specific tables within a DB, then:

You can even go as far as auto-compressing the output using gzip (if your DB is very big):

If you want to do this remotely and you have the access to the server in question, then the following would work (presuming the MySQL server is on port 3306):

View original post

How to Install Mtop (MySQL Database Server Monitoring)


mtop (MySQL top) is an open source real time MYSQL Server monitoring program written in Perl language that shows queries which are taking longer time to process and kills those longer queries after certain number of specified time. Mtop program enable us to monitor and identify performance and related issues of MySQL Server from the command line interface similar to Linux Top Command.

Mtop MySQL Monitoring

Mtop includes zooming feature that display query optimizer information of a running queries and killing queries, it also shows statistics of server, configuration information and some useful tuning tips to optimize and improve MySQL performance.

Please check some of the following features offered by Mtop program.

  1. Display real time MySQL server queries.
  2. Provides MySQL configuration information.
  3. Zooming feature to display process query.
  4. Provides query Optimizer information for a query and ‘killing’ queries.
  5. Provides MySQL tuning tips.
  6. Ability to save output in a .mtoprc

View original post 680 more words

OSX How to Reset forgotten password

Cristina Llamas

  1. we need to stop the mysql server
  2. sudo /usr/local/mysql/bin/mysqld_safe –skip-grant-tables
  3. from a different bash tab /usr/local/mysql/bin/mysql mysql
  4. Once we login in mysql we have to type ‘UPDATE user SET Password=PASSWORD(‘yourpass’) WHERE Host=’localhost’ AND User=’root’;’ 

View original post

MySQL create read-only user


mysql -u root -p

CREATE USER user_name@’localhost’;

SET PASSWORD FOR user_name = PASSWORD (‘password‘);

GRANT SELECT ON database_name.table_name TO user_name;


Show user list:

select User,Hostname,Password from mysql.user;

View original post

What to Look for in Load Test Reporting: Six Tips for Getting the Data you Need

Load Impact Blog

Looking at graphs and test reports can be a befuddling and daunting task – Where should I begin? What should I be looking out for? How is this data useful or meaningful? Hence, here are some tips to steer you in the right direction when it comes to load testing result management.

For example, the graph (above) shows how the load times (blue) increase [1] as the service reaches its maximum bandwidth (red) limit [2], and subsequently how the load time increases even more as bandwidth drops [3]. The latter phenomenon occurs due to 100% CPU usage on the app servers.

When analyzing a load test report, here are the types of data to look for:

  • What’s the user scenario design like? How much time should be allocated within the user scenario? Are they geographically spread?

  • Test configuration settings: is it ramp-up only or are there different steps in the…

View original post 606 more words

Installing MySQL Utilities

Persistent Storage Solutions

MySQL utilities are set of scripts provided for DBAs for general database administration. These are basically command line utilities which can be used to perform various tasks.

Following is the listing of MySQL utility version 1.3 that I installed in my environment

advait.desktop$ ls -lL /usr/local/bin/mysql* -rwxr-xr-x 1 root root 10546 Mar 26 00:34 /usr/local/bin/mysqlauditadmin -rwxr-xr-x 1 root root 13443 Mar 26 00:34 /usr/local/bin/mysqlauditgrep -rwxr-xr-x 1 root root 10142 Mar 26 00:34 /usr/local/bin/mysqldbcompare -rwxr-xr-x 1 root root 13509 Mar 26 00:34 /usr/local/bin/mysqldbcopy -rwxr-xr-x 1 root root 14781 Mar 26 00:34 /usr/local/bin/mysqldbexport -rwxr-xr-x 1 root root 12719 Mar 26 00:34 /usr/local/bin/mysqldbimport -rwxr-xr-x 1 root root 9551 Mar 26 00:34 /usr/local/bin/mysqldiff -rwxr-xr-x 1 root root 6339 Mar 26 00:34 /usr/local/bin/mysqldiskusage -rwxr-xr-x 1 root root 13554 Mar 26 00:34 /usr/local/bin/mysqlfailover -rwxr-xr-x 1 root root 16487 Mar 26 00:34 /usr/local/bin/mysqlfrm -rwxr-xr-x 1 root root 5218 Mar 26 00:34 /usr/local/bin/mysqlindexcheck -rwxr-xr-x 1 root root 4717…

View original post 719 more words

Populate your PhoneGap App with Data from an External Server DB

iPhone Dev Log

With this article, we’ll pull data from a server and show it in the app. We’ll create a database table on a server, load it with data, then set up the scripts to make it all work. You’ll need a MySQL server and the ability to upload and change files on it.

My development environment:

Mac OS X 10.9.1 on latest Mac Mini
Cordova CLI 3.4.0
For Android 4.3, 4.4 v19
Testing in device: Android-19, Nexus 7 with 4.3
No Jquery or other JS or CSS packages used

View original post 2,239 more words