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/.
After executing:
mysql>CREATE DATABASE roottext;
mysql>USE roottext;
mysql>CREATE TABLE hack (conf VARCHAR(80));
mysql>SELECT * INTO OUTFILE '/path/to/mysql/datadir/my.cnf' FROM hack
mysql>QUIT
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
Results 11 to 12 of 12
Thread: MySQL slow query log
-
05-23-2007, 02:31 AM #11
Richard
I have jotted down some of my meddlings at http://www.rollingr.net/wordpress
Click here for a full list of formatting codes for this forum
-
05-23-2007, 10:03 AM #12Junior Member
- Join Date
- May 2007
- Posts
- 7
Thank you!
Similar Threads
-
Unable to uninstall MySQL 3.23 nor upgrade to MySQL 5
By lifelinesfoundation in forum PHP / MySQLReplies: 1Last Post: 07-02-2007, 07:18 AM -
MySQL query browser?
By distortedimage in forum PHP / MySQLReplies: 1Last Post: 11-08-2006, 05:14 PM -
connecting to mysql using mysqlcc
By pinhead in forum PHP / MySQLReplies: 4Last Post: 03-11-2005, 09:23 PM -
Cache size in MySQL 4.1.x
By Corrado Fiore in forum PHP / MySQLReplies: 0Last Post: 02-02-2005, 04:00 AM -
Mysql 4.0.20 + php 5.0.2 installed on a VPS and working
By ssever in forum PHP / MySQLReplies: 0Last Post: 12-18-2004, 09:34 AM
Reply With Quote