General :: Redirect Some Databases To Another Directory?
Jun 22, 2011My /var/database/ directory is filled..!
Is there any way to redirect some databases to another directory .
My /var/database/ directory is filled..!
Is there any way to redirect some databases to another directory .
On one of my servers (Centos 5.5), I have been hosting articularly complex CRM application for one of my clients. Recently they have asked about configuring SSL connections to the CRM. Problem is, SSL is already configured for their main domain but not the sub-domain where the CRM application is accessed. Rather than purchasing another SSL certificate for their sub-domain (and probably another IP address),ld it be possible to setup a redirection from the subdomain to a sub-directory in the SSL directory using mod_rewrite. I have searched online and through the other posts on LinuxQuestions but nothing I have tried works.For example:[URl]
View 2 Replies View Relatedjust wondering, if i type in a url like this:
how can i get it to direct to:
I have a website example.com, serving pages on port 80. I want the url example.com/redmine to be rewritten to port 3000, where my redmine server is running, without actually changing the URL. So the user typing in example.com/redmine/test would serve up example.com:3000/test, without the user actually connecting through the port. I know this can work through CPanel, but I don't know exactly how it was implemented. I'm looked at how mod_proxy, mod_proxy_html, and mod_rewrite,
View 4 Replies View RelatedI just found that PMON and SMON are running (i.e., showing in the output of ps -ef | grep -i [o]ra)but when I check MMAN (used for internal database tasks), nothing comes up:
Code:
ps -ef | grep -i [m]man
Is that okay or could there be some problem?
So, what are the essential processes of an Oracle Databse that we must check for their status to make sure that the Oracle Databse is up and running fine? What steps do you usually take to validate an Oracle Databse on a Unix / Linux (Production) Server (specifically immediately after a CR has been worked upon)?
I have some big sqlite3 databases in ~/.mozilla/firefox/profilename Notably places.sqlite (12 MB) and urlclassifier3.sqlite (33 MB). Is it possible to truncate them and wipe out the oldest records in them? Of course I could just wipe them completely, but that's not my goal - I just want to minimize the size of those files while keeping the newest records.
View 2 Replies View RelatedStarting mysqld daemon with databases from /var/lib/mysqli m installed mysql-5.0.77-4.el5_5.4
[root@serv ~]# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[root@serv ~]# /etc/init.d/mysqld stop
[code]....
Relational databases usually have their data over in /var/lib/something. Users are in /home (with data in /var/www). How can I apply a single total disk space quota across all of these independent software systems (file systems, RDBMS, etc.)?
P.S. There's a bet going on around me as to just how awesome SU is. Let's see what you've got.
I am trying to grep multiple numbers from file, grep does have the -f option for that.
Code: grep -f <`seq 500 520` /etc/passwd I know this could be done with
Code: for i in `seq 500 520`; do grep "$i" /etc/passwd; done But my question is fare more behind this example. It is possible to redirect one command output which will be treat as a content of file for another command ?
I use a version of Ubuntu Desktop Edition 9.04 and installed various server software useful for my needs.
New issue. How do I get MySQL databases working on this system, and how do I get myPhpAdmin to help manipulate said databases onto the system?
I've got several servers running RedHat4 ES, alongside several Windows 2003 servers with MS SQL on them.
Is there a MS SQL Client for Linux so I can connect to the SQL Server databases?
I'ev got Oracle running as well, and I can back these up from my linux boxes easily as there is a Linux ORacle client. I'd like to do the same with MS SQL, so I have one central location doing my database backups .
I need to move mysql databases from my hard drive which is currently in external box. I can't boot the drive since the laptop is down. Nothing of the distribution on the drive is missing. I just need to know which files/folders copy to my new computer to have all databases running. Old computer ran on Dreamlinux (Debian-based). I'm currently running Ubuntu 9.10.
View 5 Replies View RelatedI have installed mysql ,php ,apache,phpmyadmin i have create a forum on mysite check it on[URL]..Now i have create a database with name login and then i create a table with name loginn ..After that in loginn table i create colums with name username (data type=varchar),and password(data type=int);i want when someone entered username and password in my sql ,it goes to database and userconnect to next page as we generally do in orkut or other social sites;I dont know how to connect with php with mysql and how to do it whole
View 3 Replies View RelatedIs there any program to create databases graphically? Something like Glom maybe?
View 3 Replies View RelatedQuick searches did not bring forth any standard solution.
I have installed Ubuntu Server 10 (x64) using LVM with two disks (this is a Virtual Machine on VMWare ESXi4)
During install I selected only disk 1, and LVM guided Installation Added LAMP and SSH
Server gives only a text mode configuration, great if you are a linux guru, but I am not so it took a bit to find a stripped down GUI. None could be found but I did the following:
apt-get install xorg gdm gnome-core (minimal Gnome install)
apt-get install gnome-system-tools (users and *****s, time)
apt-get install gnome-network-admin (network config)
apt-get install update-notifier (updates)
[Code].....
I have created a similar system with Ubuntu, now I wish to move the var/www directory to sda1, and the databases from MySQL.
Trying to set up a backup for mySQL databases in CRON.
I've entered the following line in /etc/crontab:
Code:
7 13 * * * root mysqldump -u root -pMYPASSWORD --all-databases | gzip > /home/myuser/mysql_backups/database_`date '+%Y-%m-%d'`.sql.gz
grep CRON /var/log/syslog shows:
[Code].....
If I run the command outside of CRON, it creates the backups no problem, but CRON is not doing anything.
I have a laptop and a desktop PC, both running Ubuntu 10.04 and both are configured the same way. I am using Unison-gtk to sync the data between both computers... This works for everything... except for my mysql databases. Any way to simply sync my mysql databases on both computers. Right now I need to do this table-per-table... and it is quite long to proceed like this. What I need is a script or a program (open and preferably free) that would just compare both databases (all the tables) and sync them either by updating existing tables or by creating them. This should work both ways... obviously. I could write a script for this, but I am sure there already is something for this out there.
View 9 Replies View RelatedI have a system with opensuse 11.0 and mysql
After changing the administrator password only information_schema and test databases are shown in GUI tools (webmin or mysql administrator GUI tool). After the error I restored the password to the old used
if I use mysql in terminal, and use show databases; I can see the 7 databases that I have.
I aslo cannot access to any field using GUI tools (cannot acces to database permissions, or MySQL Server Configuration, host permissions or MySQL system variables). The error is:
DBI connect failed : Access denied for user ''@'localhost' to database 'mysql'
Do you know how to restore the view/access to databases?
I was wondering if there is any linux command to list all the databases on the system. I have PostgreSQL databases on my system. I can list them through the psql console, but I cannot do that in a shell script. Hence the need for a linux command.
View 2 Replies View RelatedI know that set -x can be used for debugging a shell script.But I want to redirect the output of set -x to a text file.eg: Say test.sh is my script,
View 3 Replies View RelatedHow do I restore MySQL Databases from an old hdd with Ubuntu on it which won't boot? Information below is not necessary just explaining how I ended up in this situation. Today the harddrive crashed on one of my development servers and I have no recent backup of the MySQL databases on the server.
The stuff on the server weren't horrible important but it would still be nice if I were able to recover some of the files. This is the thing, I don't think the harddrive is entirely dead because it comes to a screen saying harddrive error something enter to continue then it says GRUB in the upper left corner before the computer crashes/reboots.
So I installed Ubuntu server on a new HDD and now I want to attempt to recover the databases from the old HDD by mounting it in Ubuntu but before trying I would like to know who one does that. As I've understood it's a bit more complicated then one might thing because MySQL uses binaries and not plain-files.
I've been running Kubuntu (up to 10.10 now) and also OpenSuSE. I have a Palm Pilot that I want to synchronize to the KDE databases for kontact, kaddressbook, korganizer, etc. Until my upgrade to KDE 4.5.4 I was able to use kpilot, but kpilot is no longer being maintained and has been dropped altogether from KDE 4.5.4. So I've been stranded. It seems that both kpilot and jpilot are quite ancient, not having been materially updated for ten years.
One suggestion I've heard is to replace my Palm with an iPhone, but that's not a path I want to take. The iPhone has capabilities (telephony for one) that I don't need but would be paying dearly for. Not only is the iPhone far more expensive than the Palm; it entails that horrendous and extortionate two-year contract with AT&T.
How I can sync my Palm to the KDE databases? One possibility is some combination of akonadi and OpenSync, but there doesn't seem to be support for that yet, let alone a clear explanation as to how to get that combination to work.
How to redirect output from dd command to /dev/null ?
View 2 Replies View RelatedI have sshed into a linux box and I'm using dvtm and bash (although I have also tried this with Gnu screen and bash). I have two terminals, current /dev/pts/29 and /dev/pts/130. I want to redirect the input from one to the other.And then when I type in /dev/pts/29 the characters I type should show up in /dev/pts/130. However what ends up happening is that every other character I type gets redirected.
View 2 Replies View RelatedI have a linux test machine which I would like to run a copy of a production webserver. This is a legacy application which does not use a property file for its server name. Throughout the application, the server name is hardcoded (example: open connection to myServer.myCompany.com).
Is there any linux trick which I can use to redirect all requests for a certain host back to localhost? I know in Windows that I can add an entry to the hosts file and have it redirect back to localhost. How do I do this in linux?
I had just set up nginx on my server. I have PHP and everything working okay. Except when I try the URL
http://xxx.xxx.xxx.xxx/123
I get redirected to
http://_/123
but when I try the url
http://xxx.xxx.xxx.xxx/123/
It works just as I want it to. How can I get nginx to treat the slashless url decently?
My poblem: At work I have a proxy with some closed ports. I need to connect to an Oracle DB on some DB_IP at port 1521. DB_IP is a public IP. What I Have: At home, I have a Linux machine and a Linksys WRT54G Router. What I need: How can I do to communicate a PC at work with DB_IP:1521?
View 1 Replies View RelatedAlthough this is a basic stuff, but still i wonder.
Consider these two examples. code...
I wonder, why doesn't redirection work in first case? when to use redirect and when to use pipes? I have been Linux for a long time, but still this basic stuff baffles me.
I have a crontab that wgets a PHP page every five minutes (just to run some the PHP code), and I want to send the output to /dev/null. I couldn't find it in the wget manual.
I'm looking for something like:
wget -o stout http://whatever.com/page.php > /dev/null
is there any built-in option in squid to redirect a website URL to another URL?
View 2 Replies View Related