Blog

Database

Database (6)

Children categories

I am trying to backup mysql using the command

mysqldump -u root -p  database_name > backup.sql

but it is throwing an error:

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

Also, i wanted to make a backup my database with all tables saperately sotored as a file. How can i do it?

 

Solution:

use --no-tablespaces

Thursday, 14 February 2019 21:40

Unknown collation: ‘utf8mb4_unicode_520_ci'

Written by

The following error is found when trying to migrate the MySQL database from one server to another: 

Unknown collation: ‘utf8mb4_unicode_520_ci’

-----------------------------

User can solve this by finding

ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

in the .sql file, and swapping it with

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;