Hi All,
Thanks for the replies, but in trying to fix things I managed to scramble 2
installs on 2 different drives (OUCH), and grub. The older install Mageia 2 I
reinstalled on a clean ptn, the other I reinstalled without reformatting hoping
to only update/correct what was damaged. Mostly that worked!
The good part is that I have separate ptns for Documents, Photos, Sundries, and
mail folders so basically all that was lost in each case was system only
(WHEW!)
Now to get back to the php mysql problem...............
Barry
--------------------------------------------------------
On 30/05/15 15:57, [email protected] wrote:
Distro is Mageia2 and 4.
Its the "datadir" that defines the location of the database
not "basedir" also is '/home/barry/.local/share/akonadi/db_data/mysql'
a soft link to your datadir?
my.cnf basic options are
user=mysql
basedir=/usr
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
port=3306
pid-file=/var/run/mysqld/mysqld.pid
log-error=/var/log/mysqld.log
There should be error messages not machine code in the
log it might help to drop the use of ./bin/mysql_install_db --general-log
option and let it log to mysqld.log not just for error messages it should log
it is "ready for connections".
Distros vary with log location /var/log, /var/log/mysql or /var/lib/mysql
but the my.cnf should define it.
When you run mysql_install_db it should output any perm errors.
Other tests
ps -ef | grep mysql (check server is running)
netstat -lnp | grep 3306 (check open ports)
mysqladmin -u root -p status (info uptime and open tables)
---
keith.
On 29/05/15 21:32, Barry wrote:
Hi all could someone please elucidate for me on what is happening when I try to
set up mysql.
As root I cd to /usr, then run ./bin/mysql_install_db --general-log. this
returns 'Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...' but
nothing turns up there!
After many days trying, and searching I found the files in
'/home/barry/.local/share/akonadi/db_data/mysql' although in my.cfg the server
base directory is set to /usr
This has occurred on both the mageia2 and mageia4 distros. The 3 general-log
files are of no use they only contain machine code. As it appears I may have
tried this last year I tried renaming the mysql db and rerunning the cmd but no
joy.
Can someone help please.
TIA
Barry _______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
_______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
_______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
