• Sunny
  • 3258 Views
  • 0 Comment
  • No tags

Supportlobby share some tips which we are using while dealing with mysql databases. ‘-e’ is the switch which enables command line mode for ‘mysql’ client which is installed default on every Linux distros. Some examples: 1. For listing all mysql users on the server. mysql mysql -e "SELECT User FROM user" 2. Show values assisned to each mysql variable mysql -e "SHOW VARIABLES" 3. For list mysql engine details mysql -e "SHOW ENGINES" 4. Dropping a database mysql -e "DROP…

READ MORE
  • Sunny
  • 705 Views
  • 0 Comment
  • No tags

Before starting to upgrade mysql in your server, first make full mysql backup(including system tables)  to safe location. This action will prevent data losing in case if something goes wrong. The following link will help how to take backup, http://docs.cloudlinux.com/index.html?backing_up_mysql.html Then you can update mysql/governor in the following way: # yum update governor-mysql --enablerepo=cloudlinux-updates-testing # /usr/share/lve/dbgovernor/db-select-mysql --mysql-version=mysql55 # /usr/share/lve/dbgovernor/db-select-mysql --install-now Once the installation completed, don't forgot to recompile php on the server. MYSQL_VERSION can be one of the following: auto…

READ MORE
  • Ann George
  • 693 Views
  • 0 Comment
  • No tags

It so happens that you are not able to login to the Enterprise Manager from a remote location due to lost sa password. You can reset the sa password as the windows administrator using the following steps 1. Login to the MSSQL server as admiinistrator 2. Find the Osql.exe path 3. Run the command prompt as administrator and cd to the determined path 4. Execute the command osql -E -Q "EXEC sp_password @new='new_pass', @loginame = 'sa'"

READ MORE
  • Ann George
  • 710 Views
  • 0 Comment
  • No tags

MyISAM is the default storage engine for MySQL database, but it is very common that we usually find that a MyISAM table gets corrupted very easily. When a table is created under MySQL, it creates three different files: *.frm file to store table format *.MYD (MyData) file to store the data, and *.MYI (MyIndex) to store the index. Suppose, we receive an error that the database is corrupted, then the corrupted table can be repaired using myisamchk as explained below.…

READ MORE
OUR SERVICES
OUR TECHNOLOGIES