I have a database named credifree. I did it with mysql's create
command. Yet, I can find no files on my linux box except for a\
directory and a gif file that have the name credifree. Why? What's
the name mysql might have made a database file under? Where is
it stored? Just curious.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx
mlh@appserver mlh $ mysql / -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use credifree
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------------+
| Tables_in_credi free |
+------------------------+
| paylog |
| secure_pdf |
| systemlog |
| tbiccreceiptsef x |
| tbiccreceiptsex p |
| tbiccreceiptstu |
| tbladdrchangese fx |
| tbladdrchangese xp |
| tbladdrchangest u |
| tbladdressesequ ifax |
| tbladdressesexp erian |
| tbladdressestra nsunion |
| tblaftermath |
| tblbureaus |
| tblcfclientchan ges |
| tblcfnegchanges |
| tblcr_types |
| tblcredifreecli ents |
| tblcredifreeneg s |
| tblcreditreport s |
| tblhits |
| tblinboundtypes |
| tblinstructions |
| tblmemberlogins |
| tblmerchandise |
| tbloutboundtype s |
| tblprefixes |
| tblreasons |
| tblremoved |
| tblsales |
| tblsleepers |
| tblsuffixes |
+------------------------+
32 rows in set (0.00 sec)
mysql> select * from tblhits;
+------------+----------+
| DateHit | HitValue |
+------------+----------+
| 0000-00-00 | 79417 |
| 2004-09-30 | 76 |
| 2004-10-01 | 16 |
| 2004-10-04 | 11 |
| 2004-10-06 | 24 |
| 2004-10-07 | 20 |
| 2004-10-08 | 37 |
| 2004-10-10 | 9 |
| 2004-10-11 | 4 |
| 2004-10-12 | 19 |
| 2004-10-13 | 13 |
| 2004-10-14 | 7 |
| 2004-10-15 | 8 |
| 2004-10-16 | 30 |
| 2004-10-17 | 31 |
| 2004-10-18 | 26 |
| 2004-10-19 | 3 |
| 2004-10-21 | 9 |
| 2004-10-22 | 10 |
| 2004-10-23 | 5 |
| 2004-10-24 | 7 |
| 2004-10-25 | 21 |
| 2004-10-26 | 12 |
| 2004-10-27 | 4 |
| 2004-10-28 | 4 |
| 2004-10-29 | 7 |
| 2004-10-30 | 4 |
| 2004-10-31 | 20 |
| 2004-11-01 | 11 |
| 2004-11-02 | 4 |
| 2004-11-03 | 4 |
| 2004-11-04 | 7 |
| 2004-11-07 | 1 |
| 2004-11-08 | 18 |
| 2004-11-09 | 11 |
| 2004-11-10 | 38 |
| 2004-11-11 | 41 |
| 2004-11-13 | 1 |
| 2004-11-15 | 18 |
| 2004-11-16 | 11 |
| 2004-11-17 | 9 |
| 2004-11-18 | 7 |
+------------+----------+
42 rows in set (0.00 sec)
mysql> exit
Bye
mlh@appserver mlh $ find / -name '*credifree*' 2>/dev/null
/home/mlh/public_html/credifree
/home/mlh/public_html/credifree/images/credifree.gif
mlh@appserver mlh $ exit 10 8972
MLH wrote: I have a database named credifree. I did it with mysql's create command. Yet, I can find no files on my linux box except for a\ directory and a gif file that have the name credifree. Why? What's the name mysql might have made a database file under? Where is it stored? Just curious.
[snip]
From the mysql command prompt enter "show variables" and look for one
named "datadir". That will tell you where the data is stored.
The reason that "find" would not find the files for you is because the
directory where the data is stored is only readable by the user and
group that mysql runs as; because your normal login would not have
these rights you cannot see inside that directory to find files unless
you are that user, or the root user.
In the data directory there is a directory for each database. Depending
on the database format there will be several files for each table named
after the table name. For MyISAM type tables there will be three files
for each table ending with .myi .myd and .frm If you want to know what
each of these files are for then read the mysql manual.
As I have posted in reply to one of your other messages, if you are
wanting to do database backups you should use the mysqldump command and
not try to back these files up.
--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
Thank-you, Chris. You helped eliminate some of the mystery for me.
I really do have a bad case of tunnel vision. I know so little about
the ins & outs of linux #AND# mysql. I intend to follow your advice
regarding backup needs and use the dump facility to do so.
Thx again!
BTW, I'm not too good with newsgroups either and I might have
reposted this same Q again. I'll probably get burned for it, but it
was an honest mistake. Tsk. Tsk. Tsk. I'm learning every day.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xx
On Wed, 30 Mar 2005 10:33:23 +1200, Chris Hope
<bl*******@elec trictoolbox.com > wrote: MLH wrote:
I have a database named credifree. I did it with mysql's create command. Yet, I can find no files on my linux box except for a\ directory and a gif file that have the name credifree. Why? What's the name mysql might have made a database file under? Where is it stored? Just curious.
[snip]
From the mysql command prompt enter "show variables" and look for one named "datadir". That will tell you where the data is stored.
The reason that "find" would not find the files for you is because the directory where the data is stored is only readable by the user and group that mysql runs as; because your normal login would not have these rights you cannot see inside that directory to find files unless you are that user, or the root user.
In the data directory there is a directory for each database. Depending on the database format there will be several files for each table named after the table name. For MyISAM type tables there will be three files for each table ending with .myi .myd and .frm If you want to know what each of these files are for then read the mysql manual.
As I have posted in reply to one of your other messages, if you are wanting to do database backups you should use the mysqldump command and not try to back these files up.
[snip]
The output I get appears to be several screens full. I tried piping it
to more and then to less. I found out real quick that those utilities
are useless in mysql. But there must be a way to capture and
scroll through the full text of the output from 'show variables'
(passes off the screen so quickly I have no idea just how much
there really is)
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxx From the mysql command prompt enter "show variables" and look for one named "datadir". That will tell you where the data is stored.
The reason that "find" would not find the files for you is because the directory where the data is stored is only readable by the user and group that mysql runs as; because your normal login would not have these rights you cannot see inside that directory to find files unless you are that user, or the root user.
In the data directory there is a directory for each database. Depending on the database format there will be several files for each table named after the table name. For MyISAM type tables there will be three files for each table ending with .myi .myd and .frm If you want to know what each of these files are for then read the mysql manual.
As I have posted in reply to one of your other messages, if you are wanting to do database backups you should use the mysqldump command and not try to back these files up.
MLH wrote: [snip] The output I get appears to be several screens full. I tried piping it to more and then to less. I found out real quick that those utilities are useless in mysql. But there must be a way to capture and scroll through the full text of the output from 'show variables' (passes off the screen so quickly I have no idea just how much there really is)
[snip]
run MySQL in a terminal window with a scrollbar. You will then
be able to scroll though the 179 lines of output generated by
"show variables"
jerry gitomer wrote: MLH wrote: [snip] The output I get appears to be several screens full. I tried piping it to more and then to less. I found out real quick that those utilities are useless in mysql. But there must be a way to capture and scroll through the full text of the output from 'show variables' (passes off the screen so quickly I have no idea just how much there really is)
[snip]
run MySQL in a terminal window with a scrollbar. You will then be able to scroll though the 179 lines of output generated by "show variables"
The other thing you can usually do if you're at a physical console is to
use shift+page up and page down to go through the last few screens of
data.
--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
MLH wrote: [snip] The output I get appears to be several screens full.
mysql> show variables like 'datadir';
Regards,
Bill K.
Bill Karwin wrote: MLH wrote: [snip] The output I get appears to be several screens full.
mysql> show variables like 'datadir';
That's weird - I could have sworn I tried that earlier on today when I
wrote my reply to the OP and it didn't work. When I tried now it did.
Guess I must have typed it in wrong... :)
--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
Wildcards do not seem to be supported...
mysql> show variables like 'd*'
does not work. How could one
query the vars beginning with 'd'?
On Wed, 30 Mar 2005 22:00:22 -0800, Bill Karwin <bi**@karwin.co m>
wrote: MLH wrote: [snip] The output I get appears to be several screens full.
mysql> show variables like 'datadir';
Regards, Bill K.
On 05/04/2005, Archie Ball wrote: Wildcards do not seem to be supported... mysql> show variables like 'd*' does not work. How could one query the vars beginning with 'd'?
You have to use an SQL wildcard:
mysql> SHOW VARIABLES LIKE 'd%';
--
felix This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin Lucas-Smith |
last post by:
Can anyone point me to a regular expression in PHP which could be used to
check that a proposed (My)SQL database/table/column name is valid, i.e.
shouldn't result in an SQL error when created?
The user of my (hopefully to be opensourced) program has the ability to
create database/table/column names on the fly.
I'm aware of obvious characters such as ., , things like >, etc.,
which won't work, but haven't been able to source a...
|
by: Simon |
last post by:
Hi,
I am having a little problem with my PHP - MySQl code, I have two tables
(shown below) and I am trying populate a template page with data from both.
<disclaimer>Now I would like to say my skills, especially with MySQL are
rudimentary</disclaimer> However my code (link below) fails, the nested
database call does not return any data and this has me stumped. Any help
will be much appreciated.
Many thanks in advance
|
by: Bob Bedford |
last post by:
Where to find a comprehensive document on how take datas from XML and put
them in a Mysql Database.
I've many sites sending us XML files. We have to parse datas and save those
datas on Mysql.
The problem is that we have many different file format (each company sends
us it's own XML structure).
How to provide a simple way to get those datas in Mysql, without having to
create a new PHP script for every new site's XML ?
|
by: MLH |
last post by:
A programmer developed an AMP (Apache/MySQL/PHP) application
for me. When he was done, he sent me the PHP files and the MySQL
dump file. Now, when I connect to the application on my LAN using
http://192.168.1.106/~mlh/credifree/index.php the AMP app still
thinks the data resides somewhere else. It runs fine - as long as I
leave my LAN's external internet connection up. But if I unplug my
LAN from the world, my app locks up.
Before I...
|
by: Victor Spång Arthursson |
last post by:
Well, bought a new disk to my Powerbook yesterday and reinstalled Mac
OS X. I'm in the middle of restoring everything now, and need to know
where the database files where located. I thougt /usr/local/pgsql/data
would be the appropriate place, but can't find anything there that
makes sense…
Regards,
Victor
| |
by: mm |
last post by:
I have several korn shell scripts I use with a MySQL database on the
same server (Solaris). I am moving to a Linux environment where the
MySQL database is on another server. I would like to convert the
database connection code to connect to the database on another Linux
server. I see alot of information on Perl DBI CLI and PHP DBI CLI but
cannot find any examples of Korn Shell connecting to a database on
another server.
Is there...
|
by: Israel |
last post by:
I'll preface this by saying that my preference is to dump a database to
SQL and transfer that file around but this is not the situation that
I'm in and I'll probably be in this situation in future..
I have all of the files from under C:\Program Files\MySQL\MySQL Server
4.1\data that were copied from another machine while mysqld-nt.exe was
still running. I thought that maybe I could copy these files over to
my machine, after first...
|
by: lord.zoltar |
last post by:
Hi,
I'm wondering how I deploy a database with an application.
I know that I can require SQLServer Express to be installed, using the
ClickOnce deployment system, but I also need to know how I can include
the database files and have them installed into SQLServer Express as a
part of the installation process.
I'm running VBExpress, SQLServer Express (but I also have access to SQL
Server 2000, full version).
thanks.
|
by: Atli |
last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t.
In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in your database. This is generally considered to be the easiest and fastest way to store files.
...
|
by: coolsti |
last post by:
I have the task to set up an application at work,using MS Access as a front end to a MySQL database. This will be done using an appropriate ODBC driver, and linking the MySQL database to Access.
My question is whether it is possible to set something up so that when linking to the MySQL database, the user name which is used for the MySQL connection is taken as the user's Windows ID. If so, then I can set up users and access grants in MySQL...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |