New answers tagged

0

Long story short, if you've lost the Transaction logs then you've lost any data that was in those logs which had not yet been fully committed to the database. If you are 100% sure that you have fully recovered all your logs then you may have some options but that seems unlikely. The log files growing is a symptom of the failure of backups. I don't think ...


0

Deleting transaction logs on their own shouldn't result in a loss of data, as they are logs of what has happened. Therefore the loss of data was caused by something else. However deleting transaction logs is not something that you should do. It can cause problems for Exchange. You obviously haven't had a successful backup for some time, which is why the ...


1

If you get an error from zcat, in which the error message contains the file name with an extra suffix .Z, then try using gzcat instead, as described at http://stackoverflow.com/questions/296717/zcat-wont-unzip-files-properly


0

Have a look at this site https://mathiasbynens.be/notes/mysql-utf8mb4 Although Jim's answer should also work.


3

This should work: [mysqld] character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci init-connect='SET NAMES utf8mb4' May be you need to define these options as well: [client] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4 Hope it helps. Cheers Update: Changed to utf8mb4


2

Typically if a MyISAM table has free space in the middle of the datafile after DELETE operations, it will insert the rows in that free space. However, due the way MyISAM implements concurrency, it depends on the workload what happens. From MySQL manual For a table with a hole, new rows are inserted at the end of the table if it is in use by another ...


0

According to your requirement, Let's start by making a new user called "chaminda" within the MySQL shell: CREATE USER 'chaminda'@'%' IDENTIFIED BY 'password'; The first thing to do is to provide the user with necessary permission and here I have given all permission to the particular user. GRANT ALL PRIVILEGES ON * . * TO 'chaminda'@'%'; Reload all ...



Top 50 recent answers are included