04-05-2014
Using symbolic link for database MySQL in CentOS, not update sizing
I have no idea what I should set the topic here =='
This is my story, please you there kindly help me I'm quite newbie for this.
==================================
My host server is CentOS, I spared 9.9GB for /var path that used by MySQL
and...It's full because of heavy load traffic, then I couldn't access the database anymore.
I solved this problem by moving my database out to another directory that have more space such as /usr/ and create a symbolic link. After that, I can access my database again so, I deleted some data and wanna move it back but... I check sizing with du -sh and nothing change. It's still 6.3 GB even it's shown 3.2GB in phpMyAdmin page.
Is there something wrong? or I did anything incorrect?
Please suggest to me
Thank you in advance
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
question abt symbolic link ...
i'm doing the following ...
ln -s x.sh ./scripts/y.sh
and
cat ./scripts/y.sh
it is giving following error
cat: cannot open y.sh
Any reason u an think of ?
But it is working fine when i goto scripts directory and cretae the symbolic link.
... (1 Reply)
Discussion started by: bhargav
1 Replies
2. UNIX for Dummies Questions & Answers
hello folks
how y'all doin
well i have some questions about symbolic link and hard link
hope some one answer me
i open terminal and join as root
and i wrote ln -s blah blah
then i wrote ls
i see red file called blah blah
but didn't understand what is this can some one explain and... (2 Replies)
Discussion started by: detective linux
2 Replies
3. Shell Programming and Scripting
Hi,
i am trying to create sym links on sles 11 , but it seems i am doing something wrong.
oracle@tests:/u01/app/oracle/oradata/ACIS> pwd
/u01/app/oracle/oradata/ACIS
oracle@tests:/u01/app/oracle/oradata/ACIS> ln -s /db/ACIS/dbase/dbf/ /u01/app/oracle/oradata/ACIS/... (2 Replies)
Discussion started by: tonijel
2 Replies
4. Shell Programming and Scripting
Hello All,
This may be a silly question to some but I am really stuck.
Is there a way to reverse the following;
sudo rm /bin/sh
sudo ln -s /bin/bash /bin/sh
It was part of a driver compile/installation procedure by Digi for Ubuntu stating that dash isn't supported and a symbolic link... (2 Replies)
Discussion started by: LAVco
2 Replies
5. Shell Programming and Scripting
CAN I download an html file via wget and pass it to mysql and update a database field? (8 Replies)
Discussion started by: mapasainfo
8 Replies
6. Shell Programming and Scripting
Hi all,
Can anyone please confirm if the command below is the only way that I can get what the symbolic link is set to?
mnlxd110(oracle)/db/posd2/dba$: ls -l | grep "^l"
lrwxrwxrwx 1 oracle dba 28 Aug 9 2011 bdump -> diag/rdbms/posp1/posp1/trace
mnlxd110(oracle)/db/posd2/dba$:... (7 Replies)
Discussion started by: newbie_01
7 Replies
7. UNIX for Dummies Questions & Answers
Hi everybody,
I read about treads realted to this issue but they did not resovle issue given below.
Please help me resolve issue given below
I have html file under /srv/www/htdocs/actual_folder
ls actual_folder/
test.html
and following link works... (0 Replies)
Discussion started by: newbielgn
0 Replies
8. UNIX for Dummies Questions & Answers
Hi, trying to understand more about symblic link, when I compiled a program called "match" in one folder ~/downloadsoftware/I want this program to be accessible like a system command by putting a symbolic link in /usr/bin/ Not by setting the $PATH method in .bashrc at this time.
What I did is:... (4 Replies)
Discussion started by: yifangt
4 Replies
9. Red Hat
this is my current code,
# ln -s /lib64/
# ls -lrth
total 80K
-rw-r--r--. 1 root root 12K Jul 6 2012 post-install
-rw-r--r--. 1 root root 552 Jul 6 2012 post-install.log
-rw-------. 1 root root 1.5K Aug 21 2012 anaconda-ks.cfg
drwxr-xr-x. 2 root root 4.0K Aug 21 2012 Videos... (3 Replies)
Discussion started by: jediwannabe
3 Replies
10. UNIX for Advanced & Expert Users
Any help appreciated just logging in to this server which is a front end for Rocks Cluster 6.1.1. Getting the below errors:
ldconfig
ldconfig: /usr/lib/libX11.so.6 is not a symbolic link
ldconfig: /usr/lib/libjpeg.so.62 is not a symbolic link
ldconfig: /usr/lib/libpng12.so.0 is not a symbolic... (3 Replies)
Discussion started by: RobbieTheK
3 Replies
LEARN ABOUT DEBIAN
grass-mesql
grass-mesql(1grass) Grass User's Manual grass-mesql(1grass)
NAME
grass-mesql - MySQL embedded driver
MySQL embedded driver MySQL embedded driver in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
embedded database without necessity to run MySQL server.
Driver and database name
GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL embedded driver the
parameter 'driver' should be set to value 'mesql'. The parameter 'database' is a full path to the directory where database tables are
stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it is
possible to use 3 variables:
$GISDBASE - path to current GISBASE
$LOCATION_NAME - name of current location
$MAPSET - name of current mapset
Examples of connection parameters:
db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
db.connect driver=mesql database=/home/user1/db
Data types, indexes
For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver
Database type
Because database closing was found very slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
server option).
Note
The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second table. This
can be fixed in future.
SEE ALSO
db.connect, SQL support in GRASS GIS
Credits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.
AUTHOR
Radim Blazek
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-mesql(1grass)