Fetch Softworks

Database Files (12 posts)

• Started 8 years ago by Jimmy
• Latest reply 8 years 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 8 years 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 8 years ago #

• Jimmy Member

  Hi,

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

  Jim

  Posted 8 years 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 8 years 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 8 years 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 8 years 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 8 years ago #

• Jim Matthews Administrator

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

  Jim Matthews
  Fetch Softworks

  Posted 8 years 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 8 years 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 8 years 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 8 years 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 8 years ago #