Tiny Core Extensions > TCE Q&A Forum
How to start MySQL in TCL?
Adam:
Hi all,
I've just installed mariadb.tcz & mariadb-client.tcz. However, I'm not sure to start the service on TCL.
--- Quote ---tc@box:~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory")
tc@box:~$
--- End quote ---
According to the info, I should be able to start the service by "sudo /usr/local/mysql/bin/mysqld_safe &"
--- Quote ---tc@box:~$ tce
tce-ab - Tiny Core Extension: Application Browser
S)earch P)rovides K)eywords or Q)uit:
Enter starting chars of desired extension, e.g. abi: maria
Title: mariadb.tcz
Description: An enhanced, drop-in replacement for MySQL
Version: 10.0.17
Author: MariaDB Foundation
Original-site: https://mariadb.org
Copying-policy: GPL V2, LGPL v2.1
Size: 33.3M
Extension_by: bmarkus
Tags: LIBRARY CLI SERVER SQL MYSQL MARIADB
Comments: Binaries only
----
Start server with command
'sudo /usr/local/mysql/bin/mysqld_safe &'
Database is /usr/local/mysql/data
Backup or use persistent storage
----
Compiled for Core 6.0
Change-log: 2014/11/27 First version, to 10.0.15
Current: 2015/04/06 Updated to 10.0.17
~
tc@box:~$ mysql -V
mysql Ver 15.1 Distrib 10.0.17-MariaDB, for Linux (i686) using readline 5.1
tc@box:~$
tc@box:~$ df -h | grep -iE 'sql|maria'
/dev/loop9 3.6M 3.6M 0 100% /tmp/tcloop/postgresql-9.5.1
/dev/loop14 1.8M 1.8M 0 100% /tmp/tcloop/mariadb-client
tc@box:~$
--- End quote ---
However, the command not found and there is no such directory "usr/local/mysql/" in my TCL. Please advise.
--- Quote ---tc@box:~$ sudo /usr/local/mysql/bin/mysqld_safe &
tc@box:~$ sudo: /usr/local/mysql/bin/mysqld_safe: command not found
[1]+ Done(1) sudo /usr/local/mysql/bin/mysqld_safe
tc@box:~$ cd /usr/local/
tc@box:/usr/local$ l
total 0
drwxr-xr-x 2 root root 1.7K Feb 20 2010 bin/
drwxr-xr-x 6 root root 180 Feb 21 2010 etc/
drwxr-xr-x 6 root root 1.6K Oct 2 2015 lib/
drwxr-xr-x 2 root root 100 Apr 10 2016 libexec/
drwxr-xr-x 2 root root 60 Apr 10 2016 sbin/
drwxr-xr-x 11 root root 240 Oct 2 2015 share/
drwxrwxr-x 2 root staff 360 Feb 20 2010 tce.installed/
drwxr-xr-x 3 root root 60 Apr 4 16:03 var/
tc@box:/usr/local$
--- End quote ---
gerald_clark:
You forgot to load mariadb.tcz.
Adam:
--- Quote from: gerald_clark on April 04, 2017, 09:46:05 AM ---You forgot to load mariadb.tcz.
--- End quote ---
Already installed
--- Quote ---tc@box:/mnt/sda1/tce/optional$ ls -lh | grep maria
-rw-rw-r-- 1 tc staff 1.8M Apr 4 16:00 mariadb-client.tcz
-rw-rw-r-- 1 tc staff 34 Apr 4 15:58 mariadb-client.tcz.dep
-rw-rw-r-- 1 tc staff 53 Apr 4 16:00 mariadb-client.tcz.md5.txt
-rw-rw-r-- 1 tc staff 7.7M Apr 4 15:50 mariadb.tcz
-rw-rw-r-- 1 tc staff 49 Apr 4 15:48 mariadb.tcz.dep
-rw-rw-r-- 1 tc staff 46 Apr 4 15:48 mariadb.tcz.md5.txt
tc@box:/mnt/sda1/tce/optional$
--- End quote ---
gerald_clark:
That just shows you download it.
Run "tce-load -i mariadb".
Rich:
Hi Adam
--- Quote from: Adam on April 04, 2017, 10:02:26 AM ---
--- Quote from: gerald_clark on April 04, 2017, 09:46:05 AM ---You forgot to load mariadb.tcz.
--- End quote ---
Already installed
--- Quote ---tc@box:/mnt/sda1/tce/optional$ ls -lh | grep maria
-rw-rw-r-- 1 tc staff 1.8M Apr 4 16:00 mariadb-client.tcz
-rw-rw-r-- 1 tc staff 34 Apr 4 15:58 mariadb-client.tcz.dep
-rw-rw-r-- 1 tc staff 53 Apr 4 16:00 mariadb-client.tcz.md5.txt
-rw-rw-r-- 1 tc staff 7.7M Apr 4 15:50 mariadb.tcz
-rw-rw-r-- 1 tc staff 49 Apr 4 15:48 mariadb.tcz.dep
-rw-rw-r-- 1 tc staff 46 Apr 4 15:48 mariadb.tcz.md5.txt
tc@box:/mnt/sda1/tce/optional$
--- End quote ---
--- End quote ---
No, that just means they are on your machine.
You showed this:
--- Code: ---tc@box:~$ df -h | grep -iE 'sql|maria'
/dev/loop9 3.6M 3.6M 0 100% /tmp/tcloop/postgresql-9.5.1
/dev/loop14 1.8M 1.8M 0 100% /tmp/tcloop/mariadb-client
tc@box:~$
--- End code ---
mariadb-client.tcz is loaded, mariadb.tcz is not loaded.
Navigation
[0] Message Index
[#] Next page
Go to full version