New answers tagged mysql
0
It appears as though the user executing mysqldump or the user you are logged in as, does not have permissions to write the backup to the directory.
I would also change the command being used to:
mysqldump -u root -p www_example_com > /var/www/www-example-com/share/www-example-com_"`date +"%d-%m-%Y"`".sql
Reference: https://...
0
Did you try check permissions for all directory in "/var/www/www-example-com/share" path?
Also, you could try using sudo (if you can)
0
Your mail server only has one name and your TLS certificate only needs to have that name. The domains you accept mail for are irrelevant. There is no need to attempt to do this at all.
1
Yes, just make 'user'@'%', except that it doesn't match 'localhost', so still have to make that one explicitly.
0
This is how you could do it:
LOAD XML
INFILE '/tmp/test.xml'
INTO TABLE test
ROWS IDENTIFIED BY '<item>'
(Column1, @Column2, @Column3, @Column4)
set Column2 = str_to_date(@Column2,'%e/%c/%Y %l:%i:%S %p') ,
Column3 = str_to_date(@Column3,'%e/%c/%Y %l:%i:%S %p') ,
Column4 = str_to_date(@Column4,'%e/%c/%Y')
;
You may need ...
0
I have found the answer. I had set skip-grant-tables in my.cnf while trying to perform some user management work which had caused this. Phew. The panic, the sanity. I hope this helps someone.
1
The following log line :
2 not fully installed or removed. suggests that apt-get is trying to complete an earlier failed package installation (mysql-server-5.7) before proceeding with the new installation request (tree), which is why you see mysql-server mentioned in that output.
I would suggest identifying if mysql server is already running via ps -ef | ...
1
I am assuming that you are taking backups with mysqldump.
To start a replication process, the slave node needs two things:
A copy of recent database from the master
Coordinates in the master binary log corresponding to the state in the copy
You can add --master-data argument to your mysqldump command to include setting of coordinates in the backup.
After ...
0
(dba.stackexchange.com is probably a better place to ask.)
Some things to try:
Can you move the do_db filtering to the Primary as "binlog_do_db"? If so, this will also improve performance since the Replica won't be pulling the stuff, then tossing it.
Move the replicate_do_db into the Replicate_Wild_Do_Table list. (When mixing the various ...
0
"By default, granting a role to an account or naming it in the mandatory_roles system variable value does not automatically cause the role to become active within account sessions."
"To specify which roles should become active each time a user connects to the server and authenticates, use SET DEFAULT ROLE. To set the default to all assigned ...
0
Yes, simply run the command:
sudo apt install mysql-server
to install MySQL 8. It is fairly straightforward, works in almost exactly the same way, and has the same packages available. If you’re concerned about manageability, use phpMyAdmin to manage it and control access using .htaccess files.
Here is a great step-by-step on now to install MySQL 8 on Ubuntu ...
0
Your command:
GRANT SELECT, SHOW VIEW ON ‘my_database’.* TO 'myrole'@'%';
Is only allowing access to the database “my_database” and not all databases. You would need to replace the database name with an asterisk to allow the role to Select and Show View on all databases, and enclose them with single quotes.
0
I edit the variable at /etc/mysql/mariadb.conf.d/50-server.cnf
under [server]
[server]
innodb_file_format=barracuda
innodb_file_per_table=ON
3
All of those should be after this tag:
[mysqld]
The tag [mysql] refers to the commandline tool, not the server.
0
I believe I've reconstituted the data as best I could, as follows.
Add a column token2 BINARY(5) NOT NULL to table bayes_token
UPDATE bayes_token SET token2 = CONVERT(token USING latin1);
Create a new table bayes_token2 using the modern schema
INSERT INTO bayes_token2 SELECT '1' AS id, token2 AS token, SUM(spam_count) AS spam_count, SUM(ham_count) AS ...
0
This is still some guesswork since you don't just provide all relevant information.
You need to know the certification chain of the certificate of your MySQL server. You can check it using the openssl command, for example like this:
openssl s_client -showcerts -connect host:port
Ideally you should add the certificate of your SubCA to the general CA ...
0
It could be related to this. Maybe the solution is posted here 7.1
Quote:
"The Google Cloud SQL API must be enabled in your GCP project. To do that, go to the API library page of the Google Cloud Console, search for "Cloud SQL API", click the first result and enable the API. "
google-cloud-platform
0
Did you use MySQL transaction, AUTO_INCREMENT, and InnoDB/XtraDB?
Did your Node.js MySQL driver uses implicit transaction?
If so, you probably got hit by InnoDB AUTO_INCREMENT sequence gap. You can see the docs here, but in short,
In all lock modes (innodb_autoinc_lock_mode = 0, 1, and 2), if a transaction that generated auto-increment values rolls back, ...
0
It sounds like the text could be different encodings. You can't put different encodings into a single column unless you first convert to, say, utf8mb4. But, if you don't know what the encoding is, that is is not practical.
If your goal is simply to pass the bytes along, I would use VARBINARY(..) or BLOB so that you don't stumble over charset issues.
In ...
0
In addittion to pierlo https://serverfault.com/a/919403/586669
From within MySQL Workbench there is an option to set the path of the mysqldump executable.
(Edit - Preferences - Administration)
So you can create a .cmd (on Windows) or a .sh file (on Linux or mac) as follows:
mysqldump_nostatistics.cmd:
@ECHO OFF
"C:\Program Files\MySQL\MySQL Workbench ...
0
Your error is in the log that you posted:
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2020-08-03T11:17:14.960692Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
Ensure the directory /...
0
The way I did this is to run a Fargate task.
Create a Docker container with a shell script containing the pipe statement:
aws s3 cp $DATA_LOCATION - | mysql --host=$MYSQL_HOST --user=$MYSQL_USER --password=$MYSQL_PASS --database=$database
Upload that somewhere AWS can access (eg ECR).
Then create a cluster (if you haven't already got one lying around) and a ...
1
You somehow installed a package named mysql80-community-release intended for RHEL/CentOS 8, but your system is CentOS 7. This package provides the repositories to download MySQL, but it provides packages for RHEL/CentOS 8. This won't work on your system.
You need to remove this package and replace it with its equivalent for CentOS 7, i.e. with yum remove ...
0
SHOW FULL PROCESSLIST; might be more useful if the process is still running. The complete query would be listed.
0
MySQL and MariaDB optionally create a "slowlog" file or table.
Setup:
⚈ Set long_query_time = 1 -- Preferrable in my.cnf We may change that threshold up or down later, but this is a reasonable start.
⚈ Set up the slowlog to be captured to FILE.
⚈ Turn on (the details of this vary with the Version)
⚈ Wait at least 24 hours.
Writing slow_log to ...
1
Never assume something is always recoverable and consistent!
Crash recovering an file system doesn't necessarily mean your files are intact. A (hopefully small) amount of uncommitted file system writes may be lost. Worst case, the metadata becomes inconsistent, and a fsck gets the file system back but may lose files. This also applies to your database logs, ...
0
To solve your issue you should follow steps below:
Be sure that your instance has a static external IP or change it to static. By default VM instances has ephemeral external IP which could be changed and cause an issue with connection to the database. To do it follow the documentation Reserving a new static external IP address and Changing or assigning an ...
0
After thorough investigation it seems the problem boils down to MySQL/MariaDB not supporting Host SNI. So it's not possible to utilise TCP routing in Traefik or other ingress controllers.
0
Since we also had trouble with the FLUSH TABLES WITH READ LOCK for innoDB several years back, and we did also not want to rely on innoDBs ability to recover from non-consistent data-files, we did the following:
Use a 2nd mariadb/mysql Database machine configured as a secondary (formerly known a "slave").
Whenever you want to make a zfs snapshot we ...
0
The timeout is probably cause because you're missing "Inbound rule" port for RDS database in your vpc. So when you try to connect manually from the new EC2 to your RDS DB, what happends, timeout?
Check your configuration and compare it with the details in AWS documentation
0
yum remove mysql*
find / -name mysql
rm -rf (all folders listed in find)
0
I implemented this myself for my MariaDB installations some time back, and before I trusted anyone else to do it correctly. These are the steps I performed:
# mysql_secure_installation
- name: Update MariaDB root password
mysql_user: name=root host={{item}} password={{mysql_root_password}}
with_items:
- 127.0.0.1
- ::1
- localhost
- name: ...
0
For idempotency reasons it is a good practice to implement the hardening steps done by mysql_secure_installation with dedicated Ansible tasks rather than executing mysql_secure_installation via Ansible directly.
mysql_secure_installation does the following:
set the root password
remove anonymous users
remove root remote access
remove the test database
...
3
Seems it's known bug and the reason why it happened because you haven't stopped database before the upgrade and some query was running.
You can find more details on Percona article
Try to use command line utility mytop to see what's going on. But you've mentioned you can't reach the database, try under root user. If it's possible make a backup of the ...
3
Your server is running MS SQL, and you are trying to connect to it using MySQL client.
MySQL and MS SQL are different products, and you cannot use tools designed for MySQL to access MS SQL server.
You need to use MS SQL client to access your MS SQL server.
2
96K tables !! That can lead to all sorts of problems.
query_cache_size = 512M -- Having the QC that large hurts performance. Don't go over 50M.
If you have 62GB of RAM and are using both MyISAM and InnoDB, I would recommend:
innodb_buffer_pool_size = 16G -- (also noticing that you have only 11G of data)
key_buffer_size = 8G -- This only for MyISAM ...
1
The "right" way to update everything is from dependencies to the top, so the order should be :
HTTP/2 and Apache, upgrading Apache will allow you to use HTTP/2, PHP have (almost) nothing to do with it.
MySQL
PHP to 7.3
(optional) PHP to 7.4 AFTER PHP 7.3
Apache
Upgrading Apache will be the easiest part because there is not much dependencies ...
0
2020-07-15T21:33:55.734143Z 0 [Note] InnoDB: Initializing buffer pool, total size = 384M, instances = 1, chunk size = 128M
2020-07-15T21:33:55.748097Z 0 [ERROR] InnoDB: mmap(137428992 bytes) failed; errno 12
2020-07-15T21:33:55.751593Z 0 [ERROR] InnoDB: Cannot allocate memory for the buffer pool
How much RAM do you have? Either it is very tiny, or you have ...
0
If you downloaded from MYSQL Installer, search for it & open. It can install, repair, uninstall in one shot for connectors, server etc.
It may even work if you installed individually I think.
The name is something like these when you download
mysql-8.0.15.0_Win32-64.msi
mysql-8.0.15-winx64.msi
0
The issue seems like MYSQL is not getting enough memory to add to the buffer pool size. Setting up parameter need to be done with precaution if the values are too high you might have an issue with server hogging. InnoDB buffer pool size should be set to 50% of the available RAM in a low connection environment and 30% in a high connection environment. You can ...
0
You may want to try MySQL Workbench which is free and quite useful for tasks like this.
1
MySQL client infers the protocol from the provided host.
For a given connection, if the transport protocol is not specified explicitly, it is determined implicitly. For example, connections to localhost result in a socket file connection on Unix and Unix-like systems, and a TCP/IP connection to 127.0.0.1 otherwise.
Source: MySQL Docs
To avoid that you can ...
1
My steps on Windows 10:
Copy C:\ProgramData\MySQL\MySQL Server 8.0\my.ini to C:\ProgramData\MySQL\MySQL Server 8.0\my1.ini
Open my1.ini and modify:
port=3307(under Client and Server Section)
datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data1
report_port=3307
Copy C:\ProgramData\MySQL\MySQL Server 8.0\Data to C:\ProgramData\MySQL\MySQL Server 8.0\Data1
...
0
Export the public part of the certificate, import it as trusted certificate to the target machine. Done.
Top 50 recent answers are included
