Dev {Tricks}

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

by

MySQL: Error Code: 1118

  • #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Change limit for “Mysql Row size too large”
  • Row size too large 8126 Changing some columns
  • 1118 Row size too large

The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Solution
  • Login to phpMyAdmin with root previllege
  • Go to Variables
  • Then edit Innodb Strict Mode as follows 
    innodb_strict_mode = 0

 

by

How To Create a New User and Grant Permissions in MySQL

Access MariaDB Server

mysql -u root -p

Create new database

CREATE DATABASE bdhostidb;

Check whether the database created

SHOW DATABASES;




GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;

by

Import export database | Linux

Import database

mysql -u DB_USERNAME -p DB_NAME < /PATH/OF/DB/softsql.sql

Export database

mysqldump -u DB_USERNAME -p DB_NAME > /PATH/TO/DB/softsql.sql

Dump error

  • Error Access denied need PROCESS privilege [MySQL]
  • mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

Solusion

Add ‘–no-tablespaces‘ option to the command as shown below:

mysqldump -u DB_USERNAME -p DB_NAME --no-tablespaces > /PATH/TO/DB/softsql.sql

 

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.