#1
  1. No Profile Picture
    chinnavi
    Guest
    Devshed Newbie (0 - 499 posts)

    I just want to transfer my database into another machine...
    i have RH 6.1 and
    --------
    $mysql --version
    mysql Ver 9.36 Distrib 3.22.27, for pc-linux-gnu (i686)
    ----------

    what do i do ?
    where my database resides?

    ------------------
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    Hi!

    To query your database directory:

    mysql> show variables;
    +----------------------------+---------------------------+
    | Variable_name | Value |
    +----------------------------+---------------------------+
    | back_log | 5 |
    | connect_timeout | 5 |
    | basedir | / |
    | datadir | /var/lib/mysql/ |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |

    Bye, Peter

Similar Threads

  1. Update SQL database with entries from MS Access
    By Misha G in forum MS SQL Development
    Replies: 3
    Last Post: April 3rd, 2007, 05:54 AM
  2. creating a new database
    By aspuser25 in forum ASP Programming
    Replies: 3
    Last Post: September 9th, 2003, 11:50 AM
  3. Wap database access
    By Efti in forum Mobile Programming
    Replies: 0
    Last Post: August 21st, 2003, 10:50 AM
  4. SQLException: Unknown database 'mysq'
    By BasilMahdi in forum MySQL Help
    Replies: 4
    Last Post: August 12th, 2003, 04:43 AM
  5. Validating form info before inserting it into database
    By Templhaven in forum PHP Development
    Replies: 3
    Last Post: April 24th, 2003, 11:27 PM

IMN logo majestic logo threadwatch logo seochat tools logo