Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Senior Member rolling's Avatar
    Join Date
    May 2004
    Different day, different place


    Quote Originally Posted by erb5
    What/where is the "data directory" exactly? And is starting mysqld with the --log-slow-queries[=file_name] command necessary if I've modified the my.cnf file and restarted mysqld?).
    1. 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

      We create a my.cnf in /var/lib/mysql/roottext if we do not specify /path/to/mysql/datadir/
    2. When you restarted mysqld or restarted your VPS, MySQL reloaded using the new configuration in my.cnf, so you've fulfilled that criteria

    I have jotted down some of my meddlings at
    Click here for a full list of formatting codes for this forum

  2. #12
    Junior Member
    Join Date
    May 2007


    Thank you!

Similar Threads

  1. Unable to uninstall MySQL 3.23 nor upgrade to MySQL 5
    By lifelinesfoundation in forum PHP / MySQL
    Replies: 1
    Last Post: 07-02-2007, 07:18 AM
  2. MySQL query browser?
    By distortedimage in forum PHP / MySQL
    Replies: 1
    Last Post: 11-08-2006, 05:14 PM
  3. connecting to mysql using mysqlcc
    By pinhead in forum PHP / MySQL
    Replies: 4
    Last Post: 03-11-2005, 09:23 PM
  4. Cache size in MySQL 4.1.x
    By Corrado Fiore in forum PHP / MySQL
    Replies: 0
    Last Post: 02-02-2005, 04:00 AM
  5. Replies: 0
    Last Post: 12-18-2004, 09:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts