Your best friend for file transfer.

Fetch application logoFetch

Database Files (12 posts)

  • Started 1 year ago by Jimmy
  • Latest reply 1 year ago from Jim Matthews
  • Jimmy Member

    Hi,

    I have a website that uses mysql databases. The databases are located in a folder located by a terminal program at:

    /var/db/mysql

    mysql is a folder (it is not the mysql program). In the terminal program there are 6 items in the /db folder including the mysql folder. When I look with Fetch, there are only 5 items - the mysql folder is missing.

    Is there something I need to do the see this folder? Inside the folder are the actual databases that I use on the website. I am trying to move them to a new server.

    Thanks for your help.

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    If you choose Refresh from the View menu in Fetch do you still not see the mysql folder listed?

    Thanks,

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

  • Jimmy Member

    Hi,

    Choosing Refresh doesn't help. I just see 5 of the 6 folders.

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    Hi,

    Could you choose Refresh and then choose "Fetch Transcript" from the Window menu, and post the contents here (or at http://fetchsoftworks.com/fetch/feedback if you'd rather not post them publicly)?

    Thanks,

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

  • Jimmy Member

    Hi,

    Here is the Transcript:
    ==============================
    ASV
    227 Entering Passive Mode (161,58,49,242,228,136).
    Making data connection to 161.58.49.242 port 58504
    LIST -al
    150 Opening ASCII mode data connection for file list
    drwxr-xr-x 22 root wheel 512 Mar 25 05:02 .
    drwxr-xr-x 22 root wheel 512 Mar 25 05:02 ..
    -rw-r--r-- 1 root wheel 703 Dec 5 2002 .cshrc
    drwxr-xr-x 4 root wheel 512 Nov 1 2006 .migrate
    -rw-r--r-- 1 root wheel 210 Dec 5 2002 .profile
    -r--r--r-- 1 root wheel 4735 Oct 9 2002 COPYRIGHT
    drwxr-xr-x 14 root wheel 512 Mar 25 04:59 backup
    drwxr-xr-x 4 root wheel 1024 May 5 2008 bin
    drwxr-xr-x 3 root wheel 512 Oct 30 2006 compat
    dr-xr-xr-x 4 root wheel 512 Jan 1 1970 dev
    drwxr-xr-x 14 root wheel 1536 Mar 25 05:48 etc
    drwxr-xr-x 3 root wheel 512 Mar 25 05:01 ftp
    drwxr-xr-x 17 root wheel 512 Jul 28 2015 home
    drwxr-xr-x 2 jimbojim2 webadmin 1024 Dec 11 2008 mysqlDump
    drwxr-xr-x 4 nobody nobody 1536 Feb 11 2011 ports
    drwxr-xr-x 4 root wheel 512 Jan 20 2012 root
    drwxr-xr-x 2 root wheel 512 May 5 2008 sbin
    drwxr-xr-x 14 root wheel 512 Jun 23 2011 skel
    drwxr-xr-x 3 root wheel 512 Feb 6 2006 src
    drwxrwxrwt 5 root wheel 375808 Mar 25 19:42 tmp
    drwxr-xr-x 15 root wheel 512 Sep 27 2007 usr
    drwxr-xr-x 19 root wheel 512 Nov 18 2006 var
    lrwxr-xr-x 1 root wheel 16 Nov 7 2002 www -> usr/local/apache
    226 Transfer complete
    CWD var
    250 CWD command successful
    PWD
    257 "/var" is the current directory
    PASV
    227 Entering Passive Mode (161,58,49,242,208,140).
    Making data connection to 161.58.49.242 port 53388
    LIST -al
    150 Opening ASCII mode data connection for file list
    drwxr-xr-x 19 root wheel 512 Nov 18 2006 .
    drwxr-xr-x 22 root wheel 512 Mar 25 05:02 ..
    drwxr-xr-x 4 root wheel 512 Mar 17 2003 at
    drwxr-x--- 2 root wheel 2560 Jul 29 2015 backups
    drwxr-x--- 3 root wheel 512 Nov 18 2006 cron
    drwxr-xr-x 6 root wheel 512 Jan 8 2010 db
    drwxr-xr-x 2 root wheel 512 May 28 2003 distfiles
    dr-xr-xr-x 2 root wheel 512 Oct 31 2006 empty
    drwxrwxr-x 5 root games 512 Oct 9 2002 games
    drwxr-xr-x 3 root wheel 512 Mar 11 2003 lib
    drwxr-xr-x 3 root wheel 1536 Mar 25 19:00 log
    drwxrwxr-x 2 root mail 512 Mar 25 19:43 mail
    drwxr-xr-x 2 daemon wheel 512 Oct 31 2006 msgs
    drwxr-xr-x 2 root wheel 512 Oct 9 2002 preserve
    drwxr-xr-x 8 root wheel 512 Mar 25 19:44 run
    drwxr-xr-x 9 root wheel 512 Jun 30 2010 spool
    drwxrwxrwt 3 root wheel 512 Mar 25 19:43 tmp
    drwxr-xr-x 2 root wheel 512 Oct 10 2002 yp
    226 Transfer complete
    CWD db
    250 CWD command successful
    PWD
    257 "/var/db" is the current directory
    PASV
    227 Entering Passive Mode (161,58,49,242,207,30).
    Making data connection to 161.58.49.242 port 53022
    LIST -al
    150 Opening ASCII mode data connection for file list
    drwxr-xr-x 6 root wheel 512 Jan 8 2010 .
    drwxr-xr-x 19 root wheel 512 Nov 18 2006 ..
    drwxr-xr-x 2 clamav clamav 512 Aug 25 2009 clamav
    -r--r--r-- 1 nobody wheel 2096104 Mar 19 04:16 locate.database
    drwxr-xr-x 183 root wheel 5632 Jan 13 2011 pkg
    -rw-r--r-- 1 root wheel 9 Oct 9 2002 port.mkversion
    drwxr-xr-x 3 root wheel 512 Jan 8 2010 spamassassin
    226 Transfer complete
    PWD
    257 "/var/db" is the current directory
    PWD
    257 "/var/db" is the current directory
    PWD
    257 "/var/db" is the current directory
    ===================================

    Thanks,

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    Hi,

    That's interesting -- there definitely isn't an mysql folder in /var/db. Is it possible that the database server and the web server are different computers?

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

  • Jimmy Member

    I don't think so. They are both located on the same server.

    Here is the listing from the terminal program:

    /var/db> ls
    clamav mysql port.mkversion
    locate.database pkg spamassassin

    Regards,

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    How strange. What do you see if you type ls -l in the terminal connection?

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

  • Jimmy Member

    Hi,

    /var/db> ls -l
    total 2063
    drwxr-xr-x 2 clamav clamav 512 Aug 25 2009 clamav
    -r--r--r-- 1 nobody wheel 2096104 Mar 19 04:16 locate.database
    drwx------ 10 mysql mysql 3584 Mar 17 23:54 mysql
    drwxr-xr-x 183 root wheel 5632 Jan 13 2011 pkg
    -rw-r--r-- 1 root wheel 9 Oct 9 2002 port.mkversion
    drwxr-xr-x 3 root wheel 512 Jan 8 2010 spam assassin

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    Thanks. The obvious difference between the mysql folder and the other items in /var/db is that only the mysql account has permission to read, write or search the mysql folder. Since you probably aren't FTP'd in under the mysql account, that might explain why it isn't shown to you. From FTP you don't have permission to see anything in the mysql folder.

    I would look into using the mysqldump command to export your database, and then import them on the other computer.

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

  • Jimmy Member

    Hi again and thanks for your responses.

    That's exactly what I did. I used mysqldump. But I was surprised to see that the FTP client didn't recognize the folder.

    Is there a way to login as root in Fetch?

    Jim

    Posted 1 year ago #

  • Jim Matthews Administrator

    You could try to login as root with Fetch, but a sensible system administrator would not allow it, due to the security risks involved.

    Jim Matthews
    Fetch Softworks

    Posted 1 year ago #

Reply

  • Or nickname, if you prefer.
  • This will be kept confidential.
  • This is to ensure that you’re a person, not a spambot.