Can not import table to MySQL database on linuxhow to run mysql v5.5 on redhat linuxNeed help configuring Apache, MySQL, PHP on Centos LinuxHosting Cacti install from NginXIssues importing large mysql databasecan't change NIS account password from Centos-7 client “NIS server Centos-6”MySQL Server fail to restart after trying to import database from command lineImport outdated MySQL dump using consolecsv import mysql nullAfter restarting the server Mysql does not start workingMySQL database import silently failing?
How to make thick Asian sauces?
I wrote a scene that the majority of my readers loved. How do I get back to that place while writing my new book?
Chopin: marche funèbre bar 15 impossible place
When writing an error prompt, should we end the sentence with a exclamation mark or a dot?
Did Darth Vader wear the same suit for 20+ years?
What does War Machine's "Canopy! Canopy!" line mean in "Avengers: Endgame"?
How to decline physical affection from a child whose parents are pressuring them?
Diet Coke or water?
Why do guitarists wave their guitars?
Why is the relationship between frequency and pitch exponential?
Incremental Ranges!
PhD student with mental health issues and bad performance
What is the right way to float a home lab?
Is there any rule preventing me from starting multiple bardic performances in a single round?
Who operates delivery flights for commercial airlines?
What are the words for people who cause trouble believing they know better?
Explain Ant-Man's "not it" scene from Avengers: Endgame
Building a road to escape Earth's gravity by making a pyramid on Antartica
Comma Code - Ch. 4 Automate the Boring Stuff
What are they doing to this poor rocket?
What happened to all the nuclear material being smuggled after the fall of the USSR?
Shrink exponential fraction argument
Pronoun introduced before its antecedent
What do we gain with higher order logics?
Can not import table to MySQL database on linux
how to run mysql v5.5 on redhat linuxNeed help configuring Apache, MySQL, PHP on Centos LinuxHosting Cacti install from NginXIssues importing large mysql databasecan't change NIS account password from Centos-7 client “NIS server Centos-6”MySQL Server fail to restart after trying to import database from command lineImport outdated MySQL dump using consolecsv import mysql nullAfter restarting the server Mysql does not start workingMySQL database import silently failing?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error.
My command is
mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql
I get error
No such a file or directory ;
Does this directory have to exist or do I have to create it myself?
linux centos mysql mariadb cacti
edited May 19 at 11:05
RalfFriedl
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
add a comment |
I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error.
My command is
mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql
I get error
No such a file or directory ;
Does this directory have to exist or do I have to create it myself?
linux centos mysql mariadb cacti
edited May 19 at 11:05
RalfFriedl
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
Is there some reason there is a.at the end of the filename? The command should bemysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.
– Nasir Riley
May 18 at 21:47
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54
add a comment |
I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error.
My command is
mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql
I get error
No such a file or directory ;
Does this directory have to exist or do I have to create it myself?
linux centos mysql mariadb cacti
edited May 19 at 11:05
RalfFriedl
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
I am trying to install cacti. When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS, I get an error.
My command is
mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql
I get error
No such a file or directory ;
Does this directory have to exist or do I have to create it myself?
linux centos mysql mariadb cacti
linux centos mysql mariadb cacti
edited May 19 at 11:05
RalfFriedl
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
edited May 19 at 11:05
RalfFriedl
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
edited May 19 at 11:05
RalfFriedl
2,5053714
edited May 19 at 11:05
RalfFriedl
2,5053714
edited May 19 at 11:05
RalfFriedl
2,5053714
2,5053714
asked May 18 at 20:35
CebrayilCebrayil
6
asked May 18 at 20:35
CebrayilCebrayil
6
asked May 18 at 20:35
CebrayilCebrayil
6
6
Is there some reason there is a.at the end of the filename? The command should bemysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.
– Nasir Riley
May 18 at 21:47
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54
add a comment |
Is there some reason there is a.at the end of the filename? The command should bemysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.
– Nasir Riley
May 18 at 21:47
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54
Is there some reason there is a
. at the end of the filename? The command should be mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.– Nasir Riley
May 18 at 21:47
Is there some reason there is a
. at the end of the filename? The command should be mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.– Nasir Riley
May 18 at 21:47
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54
add a comment |
2 Answers
2
active
oldest
votes
Later versions of CentOS install mariadb-server in preference to mysql server. You can list the files installed by mariadb-server using the rpm utility
rpm -ql mariadb-server
you can then examine the output to see if the file you are looking for is installed (hint: it is, under a different path).
If you do not know which package (if any) provides a particular file you can use yum to search for it e.g.
yum provides /usr/share/mysql/mysql_test_data_timezone.sql
or to search more generally
yum provides */mysql_test_data_timezone.sql
answered May 19 at 12:58
IainIain
106k14166259
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
add a comment |
Yes, directory /usr/share/mysql should exist with file mysql_test_data_timezone.sql in it. It should have come with with your mysql-server/mariadb-server installation. So I guess your installation is somehow screwed.
answered May 18 at 21:07
FreddyFreddy
1,188110
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f967912%2fcan-not-import-table-to-mysql-database-on-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Later versions of CentOS install mariadb-server in preference to mysql server. You can list the files installed by mariadb-server using the rpm utility
rpm -ql mariadb-server
you can then examine the output to see if the file you are looking for is installed (hint: it is, under a different path).
If you do not know which package (if any) provides a particular file you can use yum to search for it e.g.
yum provides /usr/share/mysql/mysql_test_data_timezone.sql
or to search more generally
yum provides */mysql_test_data_timezone.sql
answered May 19 at 12:58
IainIain
106k14166259
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
add a comment |
Later versions of CentOS install mariadb-server in preference to mysql server. You can list the files installed by mariadb-server using the rpm utility
rpm -ql mariadb-server
you can then examine the output to see if the file you are looking for is installed (hint: it is, under a different path).
If you do not know which package (if any) provides a particular file you can use yum to search for it e.g.
yum provides /usr/share/mysql/mysql_test_data_timezone.sql
or to search more generally
yum provides */mysql_test_data_timezone.sql
answered May 19 at 12:58
IainIain
106k14166259
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
add a comment |
Later versions of CentOS install mariadb-server in preference to mysql server. You can list the files installed by mariadb-server using the rpm utility
rpm -ql mariadb-server
you can then examine the output to see if the file you are looking for is installed (hint: it is, under a different path).
If you do not know which package (if any) provides a particular file you can use yum to search for it e.g.
yum provides /usr/share/mysql/mysql_test_data_timezone.sql
or to search more generally
yum provides */mysql_test_data_timezone.sql
answered May 19 at 12:58
IainIain
106k14166259
Later versions of CentOS install mariadb-server in preference to mysql server. You can list the files installed by mariadb-server using the rpm utility
rpm -ql mariadb-server
you can then examine the output to see if the file you are looking for is installed (hint: it is, under a different path).
If you do not know which package (if any) provides a particular file you can use yum to search for it e.g.
yum provides /usr/share/mysql/mysql_test_data_timezone.sql
or to search more generally
yum provides */mysql_test_data_timezone.sql
answered May 19 at 12:58
IainIain
106k14166259
edited May 23 at 21:45
answered May 19 at 12:58
IainIain
106k14166259
answered May 19 at 12:58
IainIain
106k14166259
answered May 19 at 12:58
IainIain
106k14166259
106k14166259
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
add a comment |
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
Thank you a lot) I provide particular file as you say and works
– Cebrayil
May 19 at 14:30
add a comment |
Yes, directory /usr/share/mysql should exist with file mysql_test_data_timezone.sql in it. It should have come with with your mysql-server/mariadb-server installation. So I guess your installation is somehow screwed.
answered May 18 at 21:07
FreddyFreddy
1,188110
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
add a comment |
Yes, directory /usr/share/mysql should exist with file mysql_test_data_timezone.sql in it. It should have come with with your mysql-server/mariadb-server installation. So I guess your installation is somehow screwed.
answered May 18 at 21:07
FreddyFreddy
1,188110
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
add a comment |
Yes, directory /usr/share/mysql should exist with file mysql_test_data_timezone.sql in it. It should have come with with your mysql-server/mariadb-server installation. So I guess your installation is somehow screwed.
answered May 18 at 21:07
FreddyFreddy
1,188110
Yes, directory /usr/share/mysql should exist with file mysql_test_data_timezone.sql in it. It should have come with with your mysql-server/mariadb-server installation. So I guess your installation is somehow screwed.
answered May 18 at 21:07
FreddyFreddy
1,188110
answered May 18 at 21:07
FreddyFreddy
1,188110
answered May 18 at 21:07
FreddyFreddy
1,188110
answered May 18 at 21:07
FreddyFreddy
1,188110
1,188110
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
add a comment |
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
Now I tried to downloaded mysql again.when I write "yum install mysql mysql-server" .I shows me "mariadb already installed " but It have to show mysql not mariadb .Am I right?
– Cebrayil
May 19 at 5:08
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
This depends on what you need. As I said, it can be mariadb or mysql, so (re)installing mariadb-server would also be okay.
– Freddy
May 19 at 9:38
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f967912%2fcan-not-import-table-to-mysql-database-on-linux%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Is there some reason there is a
.at the end of the filename? The command should bemysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql.– Nasir Riley
May 18 at 21:47
No .İ did not write '.' .When I ask question ,I added it by mistake .
– Cebrayil
May 19 at 4:54