I have a server with some stuff hosted out of xampp. I noticed the tgz backups of this are way larger than we thought, and we've noticed it's all in the mysql folder, but it looks like most of the database files haven't been modified this decade. So we wanted to back up then delete the databases to free up the space, then we'd have the backup in case we found they were needed later.
Doing some google'ing on how to backup mysql dbs in xampp, it said to go to the main xampp page, then log into phpMyAdmin, then that makes backups a snap. Only problem is, with any account I try, i keep getting this error:
Code:
Cannot login to MySQL server
How do I figure out why?
If I do a ps aux |grep mysql, I get the following output:
Code:
root 6462 0.0 0.0 2860 944 ? S 05:20 0:00 /bin/sh /opt/lampp/bin/mysqld_safe --datadir=/opt/lampp/var/mysql --pid-file=/opt/lampp/var/mysql/my-server-name.pid
nobody 6496 0.0 0.2 26172 5156 ? Sl 05:20 0:00 /opt/lampp/sbin/mysqld --basedir=/opt/lampp --datadir=/opt/lampp/var/mysql --user=nobody --pid-file=/opt/lampp/var/mysql/my-server-name.pid --skip-locking --port=3306 --socket=/opt/lampp/var/mysql/mysql.sock
root 17665 0.0 0.0 4300 644 pts/0 S+ 16:49 0:00 grep mysql