Score:1

MySQL error while create databaseon mariadb

sy flag

Trying new adventures, been set up cacti on my VirtualBox Machine, sticking to vary instructions, exploring my problem I stuck in, but can't go further.

I'm doing alright till I'm creating database on mariadb:

sudo mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql

Then error appears everytime:

ERROR 1062 (23000) at line 18: Duplicate entry 'MET' for key 'PRIMARY'

Values ubuntu complaining for in 18th string in my file are:

INSERT INTO time_zone_name (Name, Time_Zone_id) Values ('MET', 1), ('UTC', 2), ('Universal', 2), ('Europe/Moscow', 3) etc

What am I doing wrong?

Ubuntu 22.04.1 LTS

mysql Ver 15.1 Distrib 10.6.11-MariaDB, for debian-linux-gnu (x86_64) using Editline wrapper

Didn't find VMBox version

docdroid.net/jP70dUw/install-cacti-step-by-step-txt

doing all according this link –

codlord avatar
ru flag
The script is trying to insert data into the `time_zone_name` table and almost certainly the table already contains data. Do a `select * from time_zone_name` and see. Also, you don't need to post multiple comments on your own post unless replying to comments. Just edit your original post.
Claude Monet avatar
sy flag
@codlord do you mean I should manually set it? script you gave, where I'm writing it down to?
codlord avatar
ru flag
Connect to your database `sudo mysql -u root -p mysql` and then issue select statements such as `select * from time_zone_name;` If the tables already have the same data in as the script `/usr/share/mysql/mysql_test_data_timezone.sql` then there is no need to run the script.
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.