Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19

Warning: Function ereg() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 4

Warning: Function split() is deprecated in ..../includes/class_postbit.php(345) : eval()'d code on line 19
moving database from its default directory where mysql puts on new databases
Results 1 to 3 of 3

Thread: moving database from its default directory where mysql puts on new databases

  1. #1

    moving database from its default directory where mysql puts on new databases

    I am thinking of moving my database from its default directory where mysql puts on new databases. I am currently running OpenNA 1.0 and my database server may soon be out of disk space. I know I can do this thru my.cnf. Are there anything to consider execept changing the ff:

    datadir=/var/lib/mysql

    How about the basedir should I change it too to the desired location?

    Hope you can help me.

    Thanks and more power.

  2. #2
    Senior Member
    Join Date
    Apr 2002
    Posts
    417

    Re:moving database from its default directory where mysql puts on new databases

    Is your db server in production? Why don't you just try editing the my.cnf, don't move the data, and see what happens. I would assume that mysql would complain that the mysql db's (users, hosts, etc) can't be found. Then copy over the mysql db's and restart mysql. if all you accounts are still there then that's good. Then try moving over all other db's. Make sure to look at your logs.




  3. #3

    Re:moving database from its default directory where mysql puts on new databases


Similar Threads

  1. need help configuring Openldap with mysql database
    By ryswick in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 12-08-2010, 09:15 PM
  2. Accessing MySQL databases using C++ code
    By tech291083 in forum Redhat / Fedora
    Replies: 3
    Last Post: 06-20-2007, 05:38 PM
  3. MySQL database user creation help needed
    By Compunuts in forum Linux - Software, Applications & Programming
    Replies: 2
    Last Post: 05-24-2006, 06:48 AM
  4. MySQL database creation error
    By Compunuts in forum Linux - Hardware, Networking & Security
    Replies: 6
    Last Post: 10-24-2003, 06:09 AM
  5. Iptables logging to MySql database
    By xkill in forum Linux - Software, Applications & Programming
    Replies: 1
    Last Post: 02-11-2002, 07:45 PM

Bookmarks

Posting Permissions

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