Can not import table to MySQL database on linux

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Moderators, Developers

Post Reply
Author
Message
cebrayiltagiyev
Posts: 2
Joined: Mon May 13, 2019 1:31 pm

Can not import table to MySQL database on linux

#1 Post by cebrayiltagiyev » Sat May 18, 2019 3:10 pm

When I want to import mysql_test_data_timezone.sql to MySQL database on Linux CentOS

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 ;

this directory have to exist or I have to created it myself?.

netniV
Cacti Guru User
Posts: 2868
Joined: Sun Aug 27, 2017 12:05 am

Re: Can not import table to MySQL database on linux

#2 Post by netniV » Sun May 19, 2019 1:54 am

If you installed by one of the packages, that is where mysql_test_data_timezone.sql would normally be on centos pr debian. For others, or manual installs, you would need to use the find command to locate it

User avatar
camerabob
Cacti User
Posts: 290
Joined: Fri Feb 10, 2017 2:45 pm
Location: Long Island, New York, USA
Contact:

Re: Can not import table to MySQL database on linux

#3 Post by camerabob » Mon May 20, 2019 7:37 am

disregard
See the Cacti 1.x templates I use at: http://www.camerabob.com/cacti

Live: Cacti 1.2.3 @ CentOS 7-6.1810.2.el7 & PHP 5.4.16-46.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

Test: Cacti 1.2.6-1.el7 @ CentOS 7-7.1908.0.el7 & PHP 5.4.16-46.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4

Post Reply