Dev {Tricks}

You are here: Home / Archives for Server and Hosting / MySQL

by

How to reboot vps automatically?

To reboot VPS 5 minutes after midnight everyday:

Login via SSH and run the following:

echo shutdown -r now > /root/shutdown.sh;chmod +x /root/shutdown.sh

Then run crontab -e and enter this line:

5 0 * * * /root/shutdown.sh

Then save and exit.

by

Solved: Can’t save module, exceeds limits | Joomla

  • Save failed with the following error the content exceeds allowed limits
  • Can’t save module, exceeds limits

Solution

The error message is triggered by the size limit of the text that can be stored into the column ‘content’ in the modules table. The text limit is 65535 in the MySQL database.

  • Login to your hosting panel (For example cPanel, Plesk, DirectAdmin, CWP etc.)
  • Now open your database in phpMyAdmin
  • Check the definition of the column ‘content’ and it should be ‘text’ and we have to make it ‘mediumtext’.

That’s all!

If not solved, please change Default editor to TinyMCE.

by

Update a column value, replacing part of a string

  • How to Replace Part of a String in MySQL
  • Replace part of string in mysql table column
  • Find and Replace text in the entire table
  • MySQL REPLACE String Function: Find & Replace Text

Replace the bold text as per your table name, field/column name, strings and conditions.

UPDATE table_name
SET field_name = REPLACE(field_name, 'string_to_find', 'string_to_replace')
WHERE conditions;

Example,
Table name: publication_settings
Field/column name: setting_value
String to change: Copyright © to ©

where conditions
Field/column name: setting_name
Field string/value: abstract

UPDATE publication_settings
SET setting_value = REPLACE(setting_value, 'Copyright ©', '©')
WHERE setting_name LIKE ('abstract');

 

by

MySQL database table “in use” problem

  • MySQL table collation suddenly changed to “in use”
  • Unable to login, registration, reset password

Backup database.

Error occurs when you set the connection collation to anything other then the current server collation.

So

  • Repair database (repairing database will fix the “in use” issue)
  • Then change the collation to same everywhere.
  • You may also check the collation in the config file.

That’s all!